Excel Certification Exam UPDATED
ACTUAL Questions and CORRECT
Answers
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
sorting data - CORRECT ANSWER✔✔- select column > sort
custom list? sort> order> custom list
ACTUAL Questions and CORRECT
Answers
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
sorting data - CORRECT ANSWER✔✔- select column > sort
custom list? sort> order> custom list
