When you start typing the same text which was previously used Excel automatically shows it. this feature is called
AutoComplete
Name a new feature that has been updated with Tables concept from 2013 Version
Slicer
What does that symbol represent in Excel
Auto Fill/ Fill Pointer
In Excel, Columns are labelled as ___
AA AB or Alphabets
Which type of Reffernce is this $A$1
Absolute reference
Which Function will you use to enter current date
=today()
Protection and the Protect Sheet options can be selected from?
Review
A work sheet range is
Group of Cells
Shortcut key to insert current time
Ctrl+: and function is =now()
What is the shortcut key to Flash fill
Ctrl+E
A formula always start with
=
What is the short cut key to highlight the entire column?
Ctrl+Space Bar
What is the other name for FILE
Backstage View
What function displays row data in a column or column data in a row?
Transpose
Tabs that appear only when an object is selected are called__________
Contextual Tab
A worksheet can have a maximum of ________Number of rows in 2013 version
1048576
________is the feature that contains commonly-used Excel commands.
Quick Access toolbar
What term describes explanatory text attached to a cell?
Comment
What is the Shortcut key of getting Keyboard shortcuts of Ribbon & its Tabs
Alt
Which functionin Excel tells how many numeric entries are there ?
Count
What type of error/mistake is ##### or why this appears
When the width of the cell is smaller than the text/Value entered in the cell
Excel is a ___________
Spreadsheet
The __________Box appears to the left of the Formula Bar
Name Box
What is the File Extension of Excel
.xlsx
Which view allows you to insert Headers & Footers
Page Layout
To Lock the rows or columns in a sheet which will be appearing even when you scroll vertically or horizontally is
Freeze Panes
What percentage of Zoom option is valid
10%-400%