EXCEL CERTIFICATION QUESTIONS AND ANSWERS
SET A+
✔✔inspect a w/s for accessibility, compatibility - ✔✔file > check for issues > check
compatibility or accessibility
✔✔adjust page breaks - ✔✔view > page break preview> drag around
✔✔specify print titles - ✔✔page layout > print titles > select rows and columns to have
print on each page
✔✔change page margins and scaling - ✔✔file > print
✔✔outline data - ✔✔data > group >auto outline (has to already have subtotals)
✔✔format cell borders - ✔✔home > font > square
✔✔format painter - ✔✔select cells > clipboard > format painter
DC to do sets of cells
esc to stop
✔✔insert image - ✔✔easier fit: format, arrange and align, snap to grid
✔✔sum using destination cells - ✔✔click where you want it to go > auto sum
✔✔sum using source cells - ✔✔select the cells you want it to use > autosum
✔✔apply table style to cell range - ✔✔home> format as table
✔✔turn table to cell range - ✔✔design > convert to range
✔✔remove duplicates - ✔✔select table > remove duplicates
SET A+
✔✔inspect a w/s for accessibility, compatibility - ✔✔file > check for issues > check
compatibility or accessibility
✔✔adjust page breaks - ✔✔view > page break preview> drag around
✔✔specify print titles - ✔✔page layout > print titles > select rows and columns to have
print on each page
✔✔change page margins and scaling - ✔✔file > print
✔✔outline data - ✔✔data > group >auto outline (has to already have subtotals)
✔✔format cell borders - ✔✔home > font > square
✔✔format painter - ✔✔select cells > clipboard > format painter
DC to do sets of cells
esc to stop
✔✔insert image - ✔✔easier fit: format, arrange and align, snap to grid
✔✔sum using destination cells - ✔✔click where you want it to go > auto sum
✔✔sum using source cells - ✔✔select the cells you want it to use > autosum
✔✔apply table style to cell range - ✔✔home> format as table
✔✔turn table to cell range - ✔✔design > convert to range
✔✔remove duplicates - ✔✔select table > remove duplicates
