Excel Study Guide

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

Which button can you click to add up a series of numbers?

• The autosum button
• The Formula button
• The quicktotal button
• The total button

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

• MAX
• MIN
• LARGE
• SUM

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

• MAX
• MIN
• SMALL
• SUM

Which symbol must all formula begin with?

• =
• +
• (
• @

Columns go...

• Across
• Down

Rows go...

• Across
• Down

In a cell reference, for example A1, what does the letter refer to?

• The column
• The cell
• The row

In Excel rows are labeled by

• letters
• numbers
• rows and numbers

Where rows and columns meet are referred to as

• Blocks
• Cells
• Boxes