EXCEL 2016

Which of the choices demonstrates the correct way to reference a range of values?

• A1-A5
• A1A5
• A1:A5
• A1,A5

CTRL + V is the shortcut combination of PASTE 

• True
• False

Every formula in Excel starts with a ...

• Numbers
• An equal sign
• A dash
• Letters

If you want to add the values that are in cells C1 and C2 (93 and 14), why would you use cell reference in the formula (=C1+C2) instead of just writing the formula like this:  =93+14?

• The formula is more professional looking.
• The formula will be more accurate.
• The formula result will automatically update when cell values change. 

If you press ____________, the cell accepts your typing as its contents, but the focus stays in the cell.  There may be more than one answer.

• ENTER
• CTRL + ENTER
• TAB
• DOWN ARROW

To select a column, the easiest method is to:

• Double-click any cell in the column.
• Drag from the top cell in the last cell in the column.
• Click the column heading.
• Click the column label.

Which formula below will add the value of B2 to the value of C3?

• =B2+C3
• =C3+B3
• =6+4
• =All of the above. 

An excel spreadsheet is primarily used for calculating which of the following options?

• Data
• Finances
• Numbers
• All of the above

A selection of multiple cells is called a?

• Group
• Range
• Reference
• Package

In which view can you see the header and footer areas of a worksheet?

• Normal View
• Page layout view
• Page break preview
• Header/footer