WorksheetsBasics of Excel Quiz
Total questions: 20
Worksheet time: 10mins
This is a_____________?
Column
Row
Cell
Range
This is a_____________?
Row
Column
Cell
Range
The area within the red box is called_______?
Fill Handle
Active Cell
Cell
Row
These are called___________?
Sheet Tabs
Spread sheets
Work books
Sheets Menu
An Excel file is called_____________?
Workbook
Worksheet
Spread sheets
Excel
A Cell is___________________?
Where a row and column intersect
Cell running vertically
Cell runnung horizontally
All of above
This is a ___________?
Group
Ribbon
Tab
None of above
This is the __________?
Title bar
Entry bar
Tab
None of above
Name the active cell______?
C5
B4
C6
D6
Ctrl + N is a shortcut for_________?
Creating a new Workbook
Saving a workbook
Insert a new worksheet
Opening an existing worksheet
Which short cut is used to close excel application?
Alt + F4
Alt + F5
Ctrl + F4
Alt + Q
Shortcut key for bringing a disappeared ribbon?
Ctrl + F1
Alt + F1
Ctrl + Alt + F1
Alt + F4
How many Rows and Columns are there in an excel?
1048576R and 16384C
16384R and 1048576C
Unlimited
One Lakh Row and Columns
What is the Key to activate ribbon?
Alt
Ctrl
Alt + R
Fn
Short Cut key to open an existing Excel file?
Ctrl + O
Ctrl + N
Windows + R
Alt + O
Every Formula in MS Excel must begin with _______?
An Equal Sign
An () sign
A Plus Sign
A > Sign
What are the shortcut keys for AutoSum?
Alt + =
Ctrl + =
Ctrl +S
Alt + A
What are the keyboard shortcut keys to edit formula in a cell?
F2
F1
Alt + F2
Ctrl + F2
What would be a correct formula for sum in excel?
=SUM(B3:B9)
=SUMB3+B9
SUM(B3:B9)
=ADD(B3:B9)
Microsoft Excel is what type of software?
Spreadsheet
Drawing
Word Processing
Presentation
