NEW
Font size
WorksheetsAdvance MS Excel Tips and Tricks
Total questions: 10
Worksheet time: 2mins
Which of the following is NOT part of a function
Equal Sign
Function Name
Arguments
Cell Reference
Which of the following returns one value if the condition is TRUE, or another value if the condition is FALSE
IF function
IFS function
COUNT function
COUNTA function
Which of the following Counts the number of cells that are not empty in a range
IF function
IFS function
COUNT function
COUNTA function
Which of the following Sums the values in a range that meets the criteria that you specify
SUM function
SUMIF function
SUMIFS function
SUMMATION
Which Short-cut button Shows the Number Format
Ctrl + 1
Ctrl + ;
Alt + Enter
Ctrl + Shift + ;
Which Short-cut button Adds the current date into a cell
Ctrl + 1
Ctrl + ;
Alt + Enter
Ctrl + Shift + ;
Which Short-cut button is for AutoSum
Ctrl + 1
Alt + =
Alt + Enter
Ctrl + Shift + ;
Which Short-cut button Duplicate a sheet
Double click fill handle
Ctrl hold + click
Ctrl + Spacebar
Shift + Spacebar
Which Short-cut button Selects entire column
Double click fill handle
Ctrl hold + click
Ctrl + Spacebar
Shift + Spacebar
Which Short-cut button Hides an entire column
Ctrl + 0
Ctrl + 9
Ctrl + - (Minus)
Alt + ;
