MOS EXAM EXCEL with correct answers
100% 2026
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
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
Autofill formula - Correct Answers Drag down, drop arrow, "fill without formatting" or "fill with
formatting only"
Merge Across - Correct Answers merges each row in the selected range across the columns in
the range
Multiple lines - Correct Answers Wrap text
Spark lines - Correct Answers INSERT, spark lines, line, column, or win/loss
Subtotals - Correct Answers Highlight range, DATA, sort, HIGHLIGHT, SUBTOTAL, (replace current
totals, page break between group, summary below data) (make sure it's the right function)
Create table - Correct Answers Highlight range, INSERT, TABLE
Convert to range - Correct Answers Table tools design, convert to range
100% 2026
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
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
Autofill formula - Correct Answers Drag down, drop arrow, "fill without formatting" or "fill with
formatting only"
Merge Across - Correct Answers merges each row in the selected range across the columns in
the range
Multiple lines - Correct Answers Wrap text
Spark lines - Correct Answers INSERT, spark lines, line, column, or win/loss
Subtotals - Correct Answers Highlight range, DATA, sort, HIGHLIGHT, SUBTOTAL, (replace current
totals, page break between group, summary below data) (make sure it's the right function)
Create table - Correct Answers Highlight range, INSERT, TABLE
Convert to range - Correct Answers Table tools design, convert to range
