EXCEL MODULE 1 SAM TRAINING WITH ALL
CORRECT & VERIFIED ANSWERS
Center the contents of cell C3 horizontally Correct answer-Select cell C3. In the alignment group in
the home tab, click the center button.
Hide grid lines in the current worksheet Correct answer-Click the view tab. In the show group, click
the grid lines check box.
Use the Tell Me box to change the FILL COLOR of cells in range B4:D4 to BLACK, TEXT 1 (theme colors,
top row, second option). Correct answer-Click and drag to select range B4:D4. To the right of the
last tab on the ribbon, click the Tell Me box and type Fill Color in the box. In the Tell Me list, point to
the Fill Color arrow. In the Theme Colors Section, click the Black, Text 1 option, the second option in
the top row.
Select cell D22 Correct answer-Literally just click on it
In cell J5, enter the value 77112 as text using the keyboard or keypad. Correct answer-Select cell
J5. Type 77112 in the cell, then press enter.
Enter the number 491 in cell D6 Correct answer-Click cell D6. Type 491, then click enter.
In cell B16, create a formula using the SUM function to total the values in the range B4:B15.
Correct answer-Select cell B16. In the Editing Group, click the AutoSum button. Press enter.
Use the fill handle to copy the formula in cell B7 to cells C7 and D7. Correct answer-Click cell B7.
Position the mouse pointer over the lower right corner of cell B7 until the fill handle appears,
denoted by a plus sign made of thick black lines. Press and hold the left mouse button while you drag
the mouse right, to include cells C7 and D7.
Copy the formula in cell B7 into cell C7 Correct answer-Click cell B7. In the Clipboard Group on the
Home Tab, click the copy button. Click cell C7. In the Clioboard Group on the Home tab, click the
Paste button.
Cut and paste the contents of cell I5 into cell C11. Correct answer-Click cell I5. In the Clipboard
Group, click the Cut button. Click cell C11. In the Clipboard Group, click the Paste button.
In cell B18, create a formula using the AVERAGE function to calculate the average of the values in the
range B5:B16. Correct answer-Select cell B18. Type =AV in cell B18. In the Formula AutoComplete
list, double click AVERAGE. Position the mouse pointer over cell B5. Press and hold the left mouse
button as you drag the pointer downward until it's over cell B16, and then release the mouse button.
Type ) in cell B18 to complete the formula. Press enter.
Without using parentheses, enter a formula in cell G4 that determines the Projected 2021 Salary, less
Healthcare, for the employee by adding the value in cell C4 to the product of cell C4 multiplied by
cell E4, and then subtracting the value in cell F4. Correct answer-Select cell G4. Type = (equal sign)
in cell G4 to start the formula. Click cell C4. Type + (plus) in cell G4. Click cell C4. Type * in cell G4.
Click cell E4. Type - (minus) in cell G4. Click cell F4. On the formula bar, click the Enter button.
In cell D19, create a formula using the MAX function to calculate the maximum value in the range
D4:D17. Correct answer-Click cell D19. On the formula bar, click the Insert Function (fx) button.
CORRECT & VERIFIED ANSWERS
Center the contents of cell C3 horizontally Correct answer-Select cell C3. In the alignment group in
the home tab, click the center button.
Hide grid lines in the current worksheet Correct answer-Click the view tab. In the show group, click
the grid lines check box.
Use the Tell Me box to change the FILL COLOR of cells in range B4:D4 to BLACK, TEXT 1 (theme colors,
top row, second option). Correct answer-Click and drag to select range B4:D4. To the right of the
last tab on the ribbon, click the Tell Me box and type Fill Color in the box. In the Tell Me list, point to
the Fill Color arrow. In the Theme Colors Section, click the Black, Text 1 option, the second option in
the top row.
Select cell D22 Correct answer-Literally just click on it
In cell J5, enter the value 77112 as text using the keyboard or keypad. Correct answer-Select cell
J5. Type 77112 in the cell, then press enter.
Enter the number 491 in cell D6 Correct answer-Click cell D6. Type 491, then click enter.
In cell B16, create a formula using the SUM function to total the values in the range B4:B15.
Correct answer-Select cell B16. In the Editing Group, click the AutoSum button. Press enter.
Use the fill handle to copy the formula in cell B7 to cells C7 and D7. Correct answer-Click cell B7.
Position the mouse pointer over the lower right corner of cell B7 until the fill handle appears,
denoted by a plus sign made of thick black lines. Press and hold the left mouse button while you drag
the mouse right, to include cells C7 and D7.
Copy the formula in cell B7 into cell C7 Correct answer-Click cell B7. In the Clipboard Group on the
Home Tab, click the copy button. Click cell C7. In the Clioboard Group on the Home tab, click the
Paste button.
Cut and paste the contents of cell I5 into cell C11. Correct answer-Click cell I5. In the Clipboard
Group, click the Cut button. Click cell C11. In the Clipboard Group, click the Paste button.
In cell B18, create a formula using the AVERAGE function to calculate the average of the values in the
range B5:B16. Correct answer-Select cell B18. Type =AV in cell B18. In the Formula AutoComplete
list, double click AVERAGE. Position the mouse pointer over cell B5. Press and hold the left mouse
button as you drag the pointer downward until it's over cell B16, and then release the mouse button.
Type ) in cell B18 to complete the formula. Press enter.
Without using parentheses, enter a formula in cell G4 that determines the Projected 2021 Salary, less
Healthcare, for the employee by adding the value in cell C4 to the product of cell C4 multiplied by
cell E4, and then subtracting the value in cell F4. Correct answer-Select cell G4. Type = (equal sign)
in cell G4 to start the formula. Click cell C4. Type + (plus) in cell G4. Click cell C4. Type * in cell G4.
Click cell E4. Type - (minus) in cell G4. Click cell F4. On the formula bar, click the Enter button.
In cell D19, create a formula using the MAX function to calculate the maximum value in the range
D4:D17. Correct answer-Click cell D19. On the formula bar, click the Insert Function (fx) button.
