BYSEX21C02SA
To insert a new column between Last and Student ID#, you would select column B.
Correct!
Review the section “Insert and Delete Rows, Columns, and Cells."
If you hide rows 3–5 in your worksheet, row 4 will not print.
Correct!
Review the section “Hide and Unhide Rows and Columns."
To rename a worksheet, you can double-click the sheet tab and type the new name without pressing [Delete] or [Backspace].
Correct!
Review the section “Rename Worksheets."
When multiple sheets are selected, you can modify all of them simultaneously.
Correct!
Review the section “Edit Multiple Sheets at One Time."
PEMDAS refers to the order of operations and stands for Parentheses, Equations, Division, Multiplication, Addition, Subtraction.
Correct!
Review the section “Order of Operations."
A formula always begins with the equals (=) sign in the cell.
Correct!
Review the section “Creating Formulas."
Cell references in a formula can be typed, using upper- or lowercase letters, or selected with the mouse.
Correct!
Review the section “Cell References."
After sorting the Quiz 1 grades in column D from highest to lowest, what would be the correct order of the students?
Correct!
Review the section “Sort Data by Column."
What cell reference should you enter if you want to create a formula that refers to cell A3 on the Expenses worksheet?
Correct!
Review the section “Create Cell References to Other Worksheets."
Which image displays the correct sheet tabs after you have copied the Q1 Revenue sheet?
Correct!
Review "Create a Copy of a Worksheet."
Why is the order of operations important when creating formulas?
Correct!
Review the section “Order of Operations."
What mathematical operation does the asterisk (*) perform in Excel?
Correct!
Review the section “Mathematical Operators."