MOS Excel Objectives 1 and 2

What procedure should be used to change the document title?

• Backstage View>Info>Title

• Backstage View>Options>Title

• Backstage View>Title>Modify

• Backstage View>Info>Subject

Paste Special can not be used to paste only the formatting to a range of cells.

• True

• False

What is the procedure being demonstrated?

• Insert>Line Chart

• Insert>Line Graph

• Insert>Data Graph

• Insert>Sparkline

What tool in Excel allows you to make changes to data before loading it into Excel?

• Data Import Loader

• Power Query Editor

• Data Editor

• Data Transform Editor

It is good to use the Accessibility Checker to confirm your data formatting is comparable to older versions of Excel.

• True

• False

The GoTo Special feature can be used to search for (multiple answers):

• Blanks

• Sparklines

• Column/Row Differences

• Conditional Formatting

• Formulas

Thalia would like to print only a range of cells from the worksheet. What tool should she use to do this?

• set print area

• print preview

• print range

• print cells

What two ways can you name a range of cells?

• enter the name in the name box

• use the right-click menu

• using the format button

• using the name manager tool

Names can be used in formulas in place of cell references.

• True

• False

Jamir is using the format painter to copy the formatting to a range of cells, what must he do before selecting the format painter button?

• select the range of cells to apply the formatting

• clear the clipboard

• select the cell to copy the formatting from

• select control + C