Advance MS Excel Tips and Tricks

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 + ;