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
... [Show More] 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 displays the number 10, type 5. Click format. Click the fill tab. In the background colors section, click the blue, accent 5 option. Click ok. Click ok.
Apply the Berlin theme to the current workbook. - CORRECT ANSWER Click the page layout ribbon. Click the themes button. Click the Berlin option.
change the fill color of cell d9 to blue, accent 1, lighter 60% (theme colors section, row 3, column 5). - CORRECT ANSWER Select D9. In the Font group, click the fill color arrow. Choose the color needed.
apply thick outside borders to the range A8:D8. - CORRECT ANSWER Select A8-D8. In the Font group click the borders arrow. Click the thick outside borders option. Click cell D10.
Add an outline border with a blue accent five line color to sell D19 then select A3. - CORRECT ANSWER Select D19. In the font group on the home tab click on the borders arrow. Click more borders. In the line section click the color arrow. Click blue accent 5. In the presets section of the dialog box, click the outline button. Click ok. Click A3.
Apply the 03/14/12 Date number format to cell D4. - CORRECT ANSWER Select D4. In the number group on the ribbon click the dialog box launcher. In the type list, click 03/14/12 to select a new date number format. Click ok.
For values in the range B3:B12, adjust the number of decimal places so that two decimal places are displayed. - CORRECT ANSWER Select cells B3:B12. In the number group click the increase decimal button. Click it again.
Apply the percent Number Format, with no decimal places, to the range C4:C15. - CORRECT ANSWER Select C4:C15. In the number group click the percent style button.
Edit the conditional formatting rule for range for range B5:B16 to highlight cells whose value is less than $25,000. Use the same cell formatting as in the original rule - CORRECT ANSWER Select B5:B16. In the styles group click the conditional formatting button. Click manage rules. Click edit rule. In the edit formatting dialog box under format only cells with click the greater than arrow. Click less than. Click ok. Click ok.
Clear the conditional formatting rule from the range B4:B15. - CORRECT ANSWER Select B4:B15. I am at the styles group click the conditional formatting button. Click clear rules. Click clear rules from selected cells.
Hide column F. - CORRECT ANSWER 1. Click the column heading for column F
2. In the Cells group, click the Format button
3. Point to Hide and Unhide
4. Click Hide Columns
Change the height of row 2 to approximately 27 points. - CORRECT ANSWER Click cell A2. Click 2 and drag down to 27 points.
Check spelling in the entire worksheet, accepting the suggested correction. - CORRECT ANSWER Click the review tab. Click the spelling button. Click change. Click yes. Click ok.
Print 3 copies of the Sales Forecast Worksheet. - CORRECT ANSWER Click the file tab. Click print. Click the copies text box and type 3. Click the print button.
Change the worksheet margins to the narrow margin style. - CORRECT ANSWER Click the page layout tab. Click the margins button. Click narrow.
Add the text Confidential to the center header section, and then click cell A4 to deselect the header. - CORRECT ANSWER Click the view tab. Click the page layout button. Click the center section of the header placeholder, which contains the text "Add header". Type Confidential in the center header. In the worksheet, click cell A4.
Highlight cells in the range B4:B15 whose value is less than $50000 using Yellow Fill with Dark Yellow Text. - CORRECT ANSWER Select B4:B15. Click Conditional Formatting button. Point to Highlight Cells Rules. Click Less Than. Type 50000. Click the format cells arrow. Click the yellow fill with dark yellow text option. Click ok. [Show Less]