Excel Certification Exam with correct
answers 100% 2026
import files - Correct Answers data>get external data
specify delimitaton, column formats
Comments - Correct Answers Review > new comment
Wrap text - Correct Answers home > wrap text
center across selection - Correct Answers home > alignment > alignment setting (arrow in BR)>
Horizontal alignment
insert a column in between each column - Correct Answers use CTRL when selecting the
columns
manually adjust column and row height - Correct Answers home > format > column width
export a worksheet to pdf - Correct Answers file > export >pdf
inspect a w/s for personal info - Correct Answers file > check for issues > inspect> inspect>
remove all doc prop and personal info
inspect a w/s for accessibility, compatibility - Correct Answers file > check for issues > check
compatibility or accessibility
adjust page breaks - Correct Answers view > page break preview> drag around
, specify print titles - Correct Answers page layout > print titles > select rows and columns to have
print on each page
change page margins and scaling - Correct Answers file > print
outline data - Correct Answers data > group >auto outline (has to already have subtotals)
format cell borders - Correct Answers home > font > square
format painter - Correct Answers select cells > clipboard > format painter
DC to do sets of cells
esc to stop
insert image - Correct Answers easier fit: format, arrange and align, snap to grid
sum using destination cells - Correct Answers click where you want it to go > auto sum
sum using source cells - Correct Answers select the cells you want it to use > autosum
apply table style to cell range - Correct Answers home> format as table
turn table to cell range - Correct Answers design > convert to range
remove duplicates - Correct Answers select table > remove duplicates
sorting data - Correct Answers select column > sort
answers 100% 2026
import files - Correct Answers data>get external data
specify delimitaton, column formats
Comments - Correct Answers Review > new comment
Wrap text - Correct Answers home > wrap text
center across selection - Correct Answers home > alignment > alignment setting (arrow in BR)>
Horizontal alignment
insert a column in between each column - Correct Answers use CTRL when selecting the
columns
manually adjust column and row height - Correct Answers home > format > column width
export a worksheet to pdf - Correct Answers file > export >pdf
inspect a w/s for personal info - Correct Answers file > check for issues > inspect> inspect>
remove all doc prop and personal info
inspect a w/s for accessibility, compatibility - Correct Answers file > check for issues > check
compatibility or accessibility
adjust page breaks - Correct Answers view > page break preview> drag around
, specify print titles - Correct Answers page layout > print titles > select rows and columns to have
print on each page
change page margins and scaling - Correct Answers file > print
outline data - Correct Answers data > group >auto outline (has to already have subtotals)
format cell borders - Correct Answers home > font > square
format painter - Correct Answers select cells > clipboard > format painter
DC to do sets of cells
esc to stop
insert image - Correct Answers easier fit: format, arrange and align, snap to grid
sum using destination cells - Correct Answers click where you want it to go > auto sum
sum using source cells - Correct Answers select the cells you want it to use > autosum
apply table style to cell range - Correct Answers home> format as table
turn table to cell range - Correct Answers design > convert to range
remove duplicates - Correct Answers select table > remove duplicates
sorting data - Correct Answers select column > sort
