Excel Certification Exam Questions and Answers 100% PASS

Excel Certification Exam Questions
and Answers 100% PASS

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




COPYRIGHT ©️ 2025 ALL RIGHTS RESERVED