NEW
Font size
WorksheetsExcel Shortcuts and Functions Quiz
Total questions: 40
Worksheet time: 7mins
Which shortcut is used to create a new Excel file?
Ctrl + S
Ctrl + N
Ctrl + O
Ctrl + F4
What is the default alignment for text in Excel cells?
Center
Left
Right
Justify
Which shortcut will apply currency formatting to a selected cell?
Ctrl + Shift + 4
Ctrl + Shift + 3
Ctrl + 1
Ctrl + $
Which symbol is used to make a cell reference absolute in Excel?
@
#
$
&
What does the COUNT function do in Excel?
Counts all types of data
Counts only numbers
Counts blank cells
Counts formulas only
Shortcut to save a file in Excel is:
Ctrl + O
Ctrl + S
Ctrl + N
Ctrl + F4
What is the function of Ctrl + F6 in Excel?
Find text
Move to next worksheet
Move between open workbooks
Format cells
The SUM function is used to:
Calculate average
Add a range of numbers
Count empty cells
None of the above
Shortcut to perform a spell check is:
Ctrl + X
Ctrl + V
F7
Ctrl + Z
What does “Wrap Text” in cell formatting do?
Deletes the text
Merges cells
Displays text in multiple lines within a cell
Highlights text
Shortcut to apply bold formatting is:
Ctrl + U
Ctrl + I
Ctrl + B
Ctrl + Shift + B
What does the COUNTA function do?
Counts numbers
Counts only blank cells
Counts non-empty cells
Averages numeric data
Which key combination opens the Format Cells dialog box?
Ctrl + Shift + F
Ctrl + 1
Alt + Enter
Ctrl + P
Shortcut to insert current date in a cell:
Ctrl + Shift + :
Ctrl + ;
Alt + D
Ctrl + T
Which function returns the largest value in a range?
MAX
MIN
COUNT
AVERAGE
What does F2 do in Excel?
Opens new file
Formats cell
Edits the active cell
Saves the file
Shortcut to open the Print dialog box is:
Ctrl + O
Ctrl + S
Ctrl + P
Ctrl + Q
Which of the following is NOT a type of cell referencing?
Relative
Absolute
Mixed
Internal
Which Excel component shows the formula of a selected cell?
Name box
Status bar
Formula bar
Title bar
Shortcut to undo last action in Excel:
Ctrl + Z
Ctrl + Y
Ctrl + U
Ctrl + F
What does the AVERAGE function calculate?
Total
Highest value
Middle value
Mean of values
What is the benefit of using named ranges in Excel?
Increases file size
Makes formulas easier to understand
Automatically highlights cells
Changes formatting
Shortcut to apply percentage format:
Ctrl + Shift + 3
Ctrl + Shift + 4
Ctrl + Shift + 5
Ctrl + Shift + %
Which component allows quick access to frequently used commands?
Status Bar
Ribbon
Formula Bar
Quick Access Toolbar
Shortcut to move to the next worksheet:
Ctrl + Page Down
Ctrl + Tab
Alt + Page Up
Shift + Tab
What is the result of this formula: =10+5*2
30
20
25
15
Shortcut to insert new worksheet:
Ctrl + F11
Shift + F11
Ctrl + Shift + F11
Alt + F11
What is the use of Ctrl + Space in Excel?
Select row
Select cell
Select column
Select sheet
Which shortcut recalculates all formulas in the worksheet?
Ctrl + F
F9
Ctrl + Y
Ctrl + R
Which option correctly defines a mixed reference?
$A$1
A1
$A1 or A$1
A1:A10
Shortcut to select an entire row:
Ctrl + Space
Shift + Space
Ctrl + A
Alt + Space
Which shortcut inserts the current time?
Ctrl + ;
Ctrl + Shift + ;
Ctrl + T
Ctrl + :
What does Ctrl + F do?
Format
Find text
Freeze row
Insert function
Shortcut to apply outline borders:
Ctrl + Shift + 4
Ctrl + Shift + 7
Ctrl + 7
Alt + Shift + B
Shortcut to open “Save As” dialog:
Ctrl + S
Ctrl + Shift + S
F12
Alt + S
What is the MIN function used for?
Find average
Count numbers
Find smallest value
Return text value
Which of the following is an arithmetic operator in Excel?
=
+
&
:
Which part of Excel contains tabs like Home, Insert, Page Layout?
Status Bar
Formula Bar
Ribbon
Title Bar
Which format displays numbers with comma separators and two decimals?
General
Number
Text
Custom
Which referencing method updates automatically when copied to another cell?
Absolute
Mixed
Relative
Static
