MOS Practice Exam UPDATED ACTUAL Questions and CORRECT Answers

MOS Practice Exam UPDATED ACTUAL
Questions and CORRECT Answers
On the Cash worksheet, in cell B20, enter a formula using the SUM function to add the values in
cells B9 through B19. - CORRECT 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. - CORRECT
ANSWER - =B6-B20


On the Cash worksheet, apply the Percent Style to cell E5, displaying 0 digits to the right of the
decimal point. - CORRECT 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. - CORRECT
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. - CORRECT ANSWER - Just
type it in


Change the order of the Tuition and Cash worksheets so that the Tuition sheet is first. -
CORRECT ANSWER - drag them



Find all occurrences of "Profit" and replace it with "Earnings". - CORRECT 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 - CORRECT ANSWER - In the cells group on the home tab,
click the format button. Click rename sheet. Press enter to rename.