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