Excel Chapter 2

To insert a new column between Last and Student ID#, you would select column B.

• True

• False

If you hide rows 3–5 in your worksheet, row 4 will not print.

• True

• False

To rename a worksheet, you can double-click the sheet tab and type the new name without pressing [Delete] or [Backspace].

• True

• False

When multiple sheets are selected, you can modify all of them simultaneously.

• True

• False

PEMDAS refers to the order of operations and stands for Parentheses, Equations, Division, Multiplication, Addition, Subtraction.

• True

• False

A formula always begins with the equals (=) sign in the cell.

• True

• False

Cell references in a formula can be typed, using upper- or lowercase letters, or selected with the mouse.

• True

• False

After sorting the Quiz 1 grades in column D from highest to lowest, what would be the correct order of the students?

• Sarah, Crystal, Austin, John, Jessica

• Jessica, John, Sarah, Austin, Crystal

• Sarah, John, Jessica, Austin, Crystal

• Sarah, John, Crystal, Jessica, Austin

What cell reference should you enter if you want to create a formula that refers to cell A3 on the Expenses worksheet?

• Expenses!A3

• Exp!A3

• ExpensesA3

• Expenses!A3!

Which image displays the correct sheet tabs after you have copied the Q1 Revenue sheet?

• 
• 
• 
•