Excel Certification Exam | Latest Exam
2026-2027 || 100% PASS
import files -ANSWER data>get external data
specify delimitaton, column formats
Comments -ANSWER Review > new comment
Wrap text -ANSWER home > wrap text
center across selection -ANSWER home > alignment > alignment setting (arrow in BR)>
Horizontal alignment
insert a column in between each column -ANSWER use CTRL when selecting the
columns
manually adjust column and row height -ANSWER home > format > column width
export a worksheet to pdf -ANSWER file > export >pdf
inspect a w/s for personal info -ANSWER file > check for issues > inspect> inspect>
remove all doc prop and personal info
inspect a w/s for accessibility, compatibility -ANSWER file > check for issues > check
compatibility or accessibility
adjust page breaks -ANSWER view > page break preview> drag around
specify print titles -ANSWER page layout > print titles > select rows and columns to have
print on each page
change page margins and scaling -ANSWER file > print
outline data -ANSWER data > group >auto outline (has to already have subtotals)
format cell borders -ANSWER home > font > square
format painter -ANSWER select cells > clipboard > format painter
DC to do sets of cells
esc to stop
insert image -ANSWER easier fit: format, arrange and align, snap to grid
sum using destination cells -ANSWER click where you want it to go > auto sum
, sum using source cells -ANSWER select the cells you want it to use > autosum
apply table style to cell range -ANSWER home> format as table
turn table to cell range -ANSWER design > convert to range
remove duplicates -ANSWER select table > remove duplicates
sorting data -ANSWER select column > sort
custom list? sort> order> custom list
insert subtotals -ANSWER MAKE SURE ITS NOT A TABLE
also that its properly sorted in the column you want subtotaled
put the column, the function, and subtotal appearance
count function -ANSWER how many cells have numbers in it?
COUNT(cell #, cell #...)
counta fxn -ANSWER how many cells have anything?
COUNTA(cell #, cell #...)
average function -ANSWER averages the cells
AVERAGE(cell #, cell #...)
mix / max functions -ANSWER returns min or max number of the cells
MIN(cell #, cell #...) or MAX(cell #, cell #...)
sum in a total table row and filter results -ANSWER design > total row
can change filter to change results
conditional formatting: highlighting -ANSWER home > conditional formatting > highlight
conditional formatting: icon sets -ANSWER conditional formatting > icon sets
relative cell referencing -ANSWER cell reference in formula that changes automatically
when formula moved
absolute cell referencing -ANSWER cell reference in formula that wont change when
moved to different lacation
ex. $A$4
mixed cell referencing -ANSWER either the row or the column is an absolute reference
Int function -ANSWER rounds number down to nearest integer
INT(cell #)
2026-2027 || 100% PASS
import files -ANSWER data>get external data
specify delimitaton, column formats
Comments -ANSWER Review > new comment
Wrap text -ANSWER home > wrap text
center across selection -ANSWER home > alignment > alignment setting (arrow in BR)>
Horizontal alignment
insert a column in between each column -ANSWER use CTRL when selecting the
columns
manually adjust column and row height -ANSWER home > format > column width
export a worksheet to pdf -ANSWER file > export >pdf
inspect a w/s for personal info -ANSWER file > check for issues > inspect> inspect>
remove all doc prop and personal info
inspect a w/s for accessibility, compatibility -ANSWER file > check for issues > check
compatibility or accessibility
adjust page breaks -ANSWER view > page break preview> drag around
specify print titles -ANSWER page layout > print titles > select rows and columns to have
print on each page
change page margins and scaling -ANSWER file > print
outline data -ANSWER data > group >auto outline (has to already have subtotals)
format cell borders -ANSWER home > font > square
format painter -ANSWER select cells > clipboard > format painter
DC to do sets of cells
esc to stop
insert image -ANSWER easier fit: format, arrange and align, snap to grid
sum using destination cells -ANSWER click where you want it to go > auto sum
, sum using source cells -ANSWER select the cells you want it to use > autosum
apply table style to cell range -ANSWER home> format as table
turn table to cell range -ANSWER design > convert to range
remove duplicates -ANSWER select table > remove duplicates
sorting data -ANSWER select column > sort
custom list? sort> order> custom list
insert subtotals -ANSWER MAKE SURE ITS NOT A TABLE
also that its properly sorted in the column you want subtotaled
put the column, the function, and subtotal appearance
count function -ANSWER how many cells have numbers in it?
COUNT(cell #, cell #...)
counta fxn -ANSWER how many cells have anything?
COUNTA(cell #, cell #...)
average function -ANSWER averages the cells
AVERAGE(cell #, cell #...)
mix / max functions -ANSWER returns min or max number of the cells
MIN(cell #, cell #...) or MAX(cell #, cell #...)
sum in a total table row and filter results -ANSWER design > total row
can change filter to change results
conditional formatting: highlighting -ANSWER home > conditional formatting > highlight
conditional formatting: icon sets -ANSWER conditional formatting > icon sets
relative cell referencing -ANSWER cell reference in formula that changes automatically
when formula moved
absolute cell referencing -ANSWER cell reference in formula that wont change when
moved to different lacation
ex. $A$4
mixed cell referencing -ANSWER either the row or the column is an absolute reference
Int function -ANSWER rounds number down to nearest integer
INT(cell #)
