EXCEL CERTIFICATION EXAM
QUESTIONS AND VERIFIED
SOLUTIONS (2024/2025 UPDATE)
Import files
Data>get external data
specify delimitaton, column formats
Comments
Review > new comment
Wrap text
Home > wrap text
Center across selec?on
Home > alignment > alignment se@ng (arrow in br)> horizontal alignment
Insert a column in between each column
Use ctrl when selec?ng the columns
Manually adjust column and row height
Home > format > column width
Export a worksheet to pdf
File > export >pdf
Inspect a w/s for personal info
File > check for issues > inspect> inspect> remove all doc prop and personal
info
Inspect a w/s for accessibility, compa?bility
File > check for issues > check compa?bility or accessibility
Adjust page breaks
View > page break preview> drag around
, Specify print ?tles
Page layout > print ?tles > 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 des?na?on 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
Sor?ng data
Select column > sort
custom list? Sort> order> custom list
QUESTIONS AND VERIFIED
SOLUTIONS (2024/2025 UPDATE)
Import files
Data>get external data
specify delimitaton, column formats
Comments
Review > new comment
Wrap text
Home > wrap text
Center across selec?on
Home > alignment > alignment se@ng (arrow in br)> horizontal alignment
Insert a column in between each column
Use ctrl when selec?ng the columns
Manually adjust column and row height
Home > format > column width
Export a worksheet to pdf
File > export >pdf
Inspect a w/s for personal info
File > check for issues > inspect> inspect> remove all doc prop and personal
info
Inspect a w/s for accessibility, compa?bility
File > check for issues > check compa?bility or accessibility
Adjust page breaks
View > page break preview> drag around
, Specify print ?tles
Page layout > print ?tles > 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 des?na?on 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
Sor?ng data
Select column > sort
custom list? Sort> order> custom list
