MOS Practice Exam 2023 On the Cash worksheet, in cell B20, enter a formula using the SUM function to add the values in cells B9 through B19. Answer- In the editing group, click the autosum button. Press enter.On the Cash worksheet, in cell B22, enter a formula using relative cell addresses that finds the difference between total income in cell B6 and total expenses in cell B20. Answer- =B6-B20 On the Cash worksheet, apply the Percent Style to cell E5, displaying 0 digits to the right of the decimal point. Answer- In the number group, click the percent style button.On the Cash worksheet, copy and paste the formula from cell C4 to cell C5.Answer- In the clipboard group on the home tab, click the copy button. In the clipboard group on the home tab, click the paste button.On the Cash worksheet, change the value in cell B4 to 1000. Answer- Just type it in Change the order of the Tuition and Cash worksheets so that the Tuition sheet is first. Answer- drag them Find all occurrences of "Profit" and replace it with "Earnings". Answer- In the editing group, click the find & select button. On the find & select menu, click replace. Type Profit in the find what box and type earnings in the replace with box. Click find next.Click replace. Click replace all. Click ok. Click close.Rename Sheet1 to Budget Answer- In the cells group on the home tab, click the format button. Click rename sheet. Press enter to rename.Insert a new, blank column F. The Projection column and Growth Assumptions data will move one column to the right. Answer- Click the column F column heading.Right-click the selection. On the shortcut menu, click insert.Create a custom header with the text Little Turtle Jewelry in the left section and the current date code using Header & Footer Elements in the right section. Answer- Click the view tab on the ribbon. In the workbook views group, click the page layout button. To add current date, click design and press current date.Use the Format Painter to apply the styles from cell B29 to cells C29 and D29.Answer- Click cell B29. In the clipboard group, click the format painter button. Click and drag cells C29 and D29.Apply scaling options to fit the sheet to one page, but do not print the page. Answer- Click the page layout tab on the ribbon. In the scale to fit group, click the scale box, type 70, and then press enter.
- / 1