1
Excel Certification Exam
Excel Certification Exam Questions
with Correct Verified Answers Latest
Update (2024/2025) Guaranteed Pass
1. Import files - ANS ✅data>get external data
Specify delimitation, column formats
2. Comments - ANS ✅Review > new comment
3. Wrap text - ANS ✅home > wrap text
4. Centre across selection - ANS ✅home > alignment > alignment setting
(arrow in BR)> Horizontal alignment
5. Insert a column in between each column - ANS ✅use CTRL when
selecting the columns
6. Manually adjust column and row height - ANS ✅home > format >
column width
7. Export a worksheet to pdf - ANS ✅file > export >pdf
8. Inspect a w/s for personal info - ANS ✅file > check for issues >
inspect> inspect> remove all doc prop and personal info
Excel Certification Exam
, 2
Excel Certification Exam
9. Inspect a w/s for accessibility, compatibility - ANS ✅file > check for
issues > check compatibility or accessibility
10.Adjust page breaks - ANS ✅view > page break preview> drag around
11.Specify print titles - ANS ✅page layout > print titles > select rows and
columns to have print on each page
12.Change page margins and scaling - ANS ✅file > print
13.Outline data - ANS ✅data > group >auto outline (has to already have
subtotals)
14.Format cell borders - ANS ✅home > font > square
15.Format painter - ANS ✅select cells > clipboard > format painter
DC to do sets of cells
Esc to stop
16.Insert image - ANS ✅easier fit: format, arrange and align, snap to grid
17.Sum using destination cells - ANS ✅click where you want it to go >
auto sum
18.Sum using source cells - ANS ✅select the cells you want it to use > auto
sum
19.Apply table style to cell range - ANS ✅home> format as table
Excel Certification Exam
Excel Certification Exam
Excel Certification Exam Questions
with Correct Verified Answers Latest
Update (2024/2025) Guaranteed Pass
1. Import files - ANS ✅data>get external data
Specify delimitation, column formats
2. Comments - ANS ✅Review > new comment
3. Wrap text - ANS ✅home > wrap text
4. Centre across selection - ANS ✅home > alignment > alignment setting
(arrow in BR)> Horizontal alignment
5. Insert a column in between each column - ANS ✅use CTRL when
selecting the columns
6. Manually adjust column and row height - ANS ✅home > format >
column width
7. Export a worksheet to pdf - ANS ✅file > export >pdf
8. Inspect a w/s for personal info - ANS ✅file > check for issues >
inspect> inspect> remove all doc prop and personal info
Excel Certification Exam
, 2
Excel Certification Exam
9. Inspect a w/s for accessibility, compatibility - ANS ✅file > check for
issues > check compatibility or accessibility
10.Adjust page breaks - ANS ✅view > page break preview> drag around
11.Specify print titles - ANS ✅page layout > print titles > select rows and
columns to have print on each page
12.Change page margins and scaling - ANS ✅file > print
13.Outline data - ANS ✅data > group >auto outline (has to already have
subtotals)
14.Format cell borders - ANS ✅home > font > square
15.Format painter - ANS ✅select cells > clipboard > format painter
DC to do sets of cells
Esc to stop
16.Insert image - ANS ✅easier fit: format, arrange and align, snap to grid
17.Sum using destination cells - ANS ✅click where you want it to go >
auto sum
18.Sum using source cells - ANS ✅select the cells you want it to use > auto
sum
19.Apply table style to cell range - ANS ✅home> format as table
Excel Certification Exam
