MOS EXAM EXCEL QUESTIONS AND
ANSWERS
Incorporate text file - Correct Answers -DATA, From TEXT, select file, LOAD TO,
existing or new file
Create new worksheet - Correct Answers -Plus button on bottom, rename, press enter
Create a copy of worksheet - Correct Answers -Press control key, drag over, and drop
Navigate through workbook - find the BLANK - Correct Answers -Name box, drop arrow,
find name
Navigate outside of workbook - create a hyperlink - Correct Answers -Click on data,
right click, click LINK, select link or type in address, click OK
Format worksheets and workbook - change color of worksheet - Correct Answers -Right
click on bottom tab, go to tab color
Change page setup - separate locations (move one thing on one page and one thing on
another page) - Correct Answers -Go to page layout view (right corner, small square
with inner square), page layout tab, insert page break
Customize options and views - Correct Answers -Hide or unhide
Shade every other row - Correct Answers -Banded rows
Insert total row - Correct Answers -DESIGN TABLE TOOLS, total row
Hide - Correct Answers -Click on worksheet, HOME, FORMAT, hide rows, columns,
sheets
Unhide - Correct Answers -Go to worksheet, HOME, FORMAT, unhide worksheets
document properties - Correct Answers -FILE, INFO, show al properties, type in
property
Show Formulas - Correct Answers -Go to FORMULAS TAB, SHOW FORMULAS
Configure for distribution - PRINTING only a certain part - Correct Answers -Highlight
area, FILE, PRINT, print selection
Remove personal information - Correct Answers -FILE, INFO, inspect document, select
all, REMOVE all personal info
ANSWERS
Incorporate text file - Correct Answers -DATA, From TEXT, select file, LOAD TO,
existing or new file
Create new worksheet - Correct Answers -Plus button on bottom, rename, press enter
Create a copy of worksheet - Correct Answers -Press control key, drag over, and drop
Navigate through workbook - find the BLANK - Correct Answers -Name box, drop arrow,
find name
Navigate outside of workbook - create a hyperlink - Correct Answers -Click on data,
right click, click LINK, select link or type in address, click OK
Format worksheets and workbook - change color of worksheet - Correct Answers -Right
click on bottom tab, go to tab color
Change page setup - separate locations (move one thing on one page and one thing on
another page) - Correct Answers -Go to page layout view (right corner, small square
with inner square), page layout tab, insert page break
Customize options and views - Correct Answers -Hide or unhide
Shade every other row - Correct Answers -Banded rows
Insert total row - Correct Answers -DESIGN TABLE TOOLS, total row
Hide - Correct Answers -Click on worksheet, HOME, FORMAT, hide rows, columns,
sheets
Unhide - Correct Answers -Go to worksheet, HOME, FORMAT, unhide worksheets
document properties - Correct Answers -FILE, INFO, show al properties, type in
property
Show Formulas - Correct Answers -Go to FORMULAS TAB, SHOW FORMULAS
Configure for distribution - PRINTING only a certain part - Correct Answers -Highlight
area, FILE, PRINT, print selection
Remove personal information - Correct Answers -FILE, INFO, inspect document, select
all, REMOVE all personal info
