Excel Module 2 SAM Training Exam 23 Questions with
Verified Answers
Wrap the text in cell A6 so that all the text is visible in the cell. - CORRECT
ANSWER Click cell A6. In the Alignment group, click the wrao text button.
Use Flash Fill to fill range E4:E15 after typing "[email protected]" in cell E4
and "Sal" in cell E5 - CORRECT ANSWER Click cell E4. Type
"[email protected]" in cell E4, and press Enter. Type "Sal" in cell E5, and
press enter.
Enter a formula using arithmetic operators and parentheses in cell B14 that adds
the monthly expenses in cells B9, B10, and B11, and then multiplies that result by
12. - CORRECT ANSWER Select cell B14. Type "=(" in cell B14. Click cell B9. Type +
in b14. Click b10. Type + in cell b14. Click b11. Type ) in b14. Type *12 in b14. On
the formula bar, click the enter button.
In cell B19, create a formula by entering cell references that subtracts can B6 from
B5, and then subtracts cell B18. - CORRECT ANSWER Click cell b19. Type = to begin
formula. Click b5. Type - in b19. Click b6. Type - in b19. Click b18. Press enter.
In cell D19, create a formula using the COUNT function to count the number of
values in the range d5:d18. - CORRECT ANSWER Select d19. Type =COUNT(. Select
d5-d18. Type ). Press enter.
In cell F19, Create a formula using the COUNTA function that counts the number
of cells that are not empty in the range F5:F18. - CORRECT ANSWER Click cell f19.
Click the formulas tab. Click the more functions button. Point to statistical. Click
COUNTA. Type f5:f18 in the Value1 box. Click Ok.
For range B4:B15, create a New conditional formatting rule that formats the top
five values in the range with a Blue, Accent 5 cell background color. - CORRECT
ANSWER Click and drag to select cells B4:B15. In the styles group, click the
conditional formatting button. Click new rule. In the select rule type section, click
format only top or bottom ranked values. Select the value box, which currently
