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.
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.
