MOS Practice Exam 2025 complete questions and answers

=B6-B20 - correct answer- 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. In the editing group, click the autosum button. Press enter. - correct answer- On the Cash worksheet, in cell B20, enter a formula using the SUM function to add the values in cells B9 through B19. In the number group, click the percent style button. - correct answer- On the Cash worksheet, apply the Percent Style to cell E5, displaying 0 digits to the right of the decimal point. In the clipboard group on the home tab, click the copy button. In the clipboard group on the home tab, click the paste button. - correct answer- On the Cash worksheet, copy and paste the formula from cell C4 to cell C5. Just type it in - correct answer- On the Cash worksheet, change the value in cell B4 to 1000. drag them - correct answer- Change the order of the Tuition and Cash worksheets so that the Tuition sheet is first. 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. - correct answer- Find all occurrences of "Profit" and replace it with "Earnings". In the cells group on the home tab, click the format button. Click rename sheet. Press enter to rename. - correct answer- Rename Sheet1 to Budget Click the column F column heading. Right-click the selection. On the shortcut menu, click insert. - correct answer- Insert a new, blank column F. The Projection column and Growth Assumptions data will move one column to the right. 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. - correct answer- 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. Click cell B29. In the clipboard group, click the format painter button. Click and drag cells C29 and D29. - correct answer- Use the Format Painter to apply the styles from cell B29 to cells C29 and D29. Click the page layout tab on the ribbon. In the scale to fit group, click the scale box, type 70, and then press enter. - correct answer- Apply scaling options to fit the sheet to one page, but do not print the page. Click and drag to select range A3:L23. Click the insert tab on the ribbon. In the tables group, click the table button. Click ok. - correct answer- Create a table from the data in cells A3:L23. The first row contains table headers. Click cell A5. Click the table tools design tab. In the table styles group, click the more button. Apply style light 18. - corr