Excel Lessons 1-5

• tab
• worksheet tab
• new worksheet

• Pages
• Page break preview
• Normal
• Page layout

• Zumba
• Zoom
• Zoom level
• Zoomer

• namer
• name box
• box
• text display

• row
• column
• active cell
• cell

Which of the following correctly describes the default selection for AutoSum?

• You must make the selection before clicking AutoSum
• By default, AUTOSUM totals all entries above the cell in which the formula is located, even if the cells contain text and numbers
• By default, AutoSum calculates the total from the adjacent cell through the first non numeric cell
• AutoSum doesn't have a default selection

You want to SUM multiple noncontinuous (not together) cell ranges that are named. Which of the following is best to use?

• AutoSum
• SUBTOTAL
• MAX
• MIN

The COUNT and MIN functions are examples of which category of functions?

• text
• statistical
• financial 
• logical

You want to calculate the number of non-blank cells in your worksheet. Which function do you use?

• SUM
• COUNT
• COUNTA
• MAX

You want to create a formula that calculates the number of years you have lived. You were born in 1991

• =YEAR(TODAY())-1991
• =YEAR(TODAY())+1991
• =YEAR(COUNT())-1991
• =YEAR(COUNT())+1991