DRILL

SUM, AVERAGE, MAX and MIN are preset formulas on the _______________ menu.

• filter
• functions
• border
• fill color

If I want to make a cell a particular color, which button would I click on?

• orange arrow
• red arrow
• blue arrow
• green arrow

Which is the correct formula to add cells A1 to A5?

• =SUM(A1+A5)
• =SUM(A1:A5)
• =A1+A2+A3
• =SUM(A1:A4)

Why would you want to freeze rows in your spreadsheet?

• To modify only the frozen rows

• To limit the data that can be entered in the frozen row

• To scroll through the spreadsheet while continuing to see the frozen rows

• To prevent the rows from being edited by collaborators

Which of the following features allows you to narrow down the data in your worksheet?

• Relative cell references

• Filters

• Merge Cells

• Sorting

According to the order of operations, which calculation comes first in the following formula?

=3^2/5+(12-3)

• 12-3

• 2/5

• 5+12

• 3^2

Which of these is NOT a reason to freeze a row or column?

• To keep others from being able to edit it

• To keep the row or column visible as you scroll through the data

• To exclude the row or column name when you sort the data

• To create a header row with column titles

Which cursor allows you to drag and fill a series?

• Skinny Plus Sign
• Fat Plus Sign
• Hand
• Arrow

Which formula gets the biggest value of a range of cells?

• MAX
• MIN
• LARGE
• SUM

How do you select an entire column?

• Select Edit > Select > Column from the menu
• Click the column heading letter
• Hold down the shift key as you click anywhere in the column.
• Hold down the Ctrl key as you click anywhere in the column