[07] Lesson 8 Exam

On the Format tab, in the Format Auditing group, clicking Show Formulas, will ____________ in the cell.

Question 1 options:

	a) print the formula
	b) display the formula
	c) print the result
	d) display the result

Save

Question 2 (5 points)

____________ is a feature that speeds your typing and lessens the likelihood of errors; if the first few characters you type in a cell match an existing entry in the column, Excel fills in the remaining characters for you.

Question 2 options:

	a) AutoFit
	b) AutoComplete
	c) AutoFill
	d) AutoCalculate

Save

Question 3 (5 points)

Data can be entered by selecting ___________ and then typing text or a number.

Question 3 options:

	a) a column
	b) a row
	c) a range of cells
	d) the typed data

Save

Question 4 (5 points)

In Excel, you can apply custom margins, center the spreadsheet on the page, and insert a Header or Footer using the same technique as ____________ before printing the spreadsheet.

Question 4 options:

	a) Access
	b) Word
	c) Quicken
	d) PowerPoint

Save

Question 5 (5 points)

In Excel, the __________command begins its checking process with the currently selected cell and moves to the right and down.

Question 5 options:

	a) Format
	b) Spelling
	c) Formula Review
	d) Review

Save

Question 6 (5 points)

The __________check box centers a worksheet horizontally on a page.

Question 6 options:

	a) Format
	b) Align
	c) Center on page
	d) AutoFit

Save

Question 7 (5 points)

The ____________ group can be used to align text vertically and horizontally in a cell.

Question 7 options:

	a) format
	b) alignment
	c) text effects
	d) page setup

Save

Question 8 (5 points)

Like the ___________ in Word, the Quick Analysis button displays a set of commands and formatting tools when you select a range of data.

Question 8 options:

	a) status bar
	b) calculate button
	c) mini toolbar
	d) stationary

Save

Question 9 (5 points)

You can change the worksheet orientation on the Page Layout tab or:

Question 9 options:

	a) on the Print tab
	b) in Backstage view.
	c) in Print Preview.
	d) in Settings.

Save

Question 10 (5 points)

Cells and the overall layout of the worksheet can be formatted, using various commands on all the following EXCEPT:

Question 10 options:

	a) the Ribbon.
	b) shortcut menus.
	c) Edit bar.
	d) keyboard shortcuts.

Save

Question 11 (5 points)

__________will adjust the width of a column to accommodate the content of the widest cell.

Question 11 options:

	a) Scaling
	b) AutoFit
	c) Merge & Fit
	d) Adjust

Save

Question 12 (5 points)

When the Header or Footer is a field, such as the file name, it displays with the ____________ symbol.

Question 12 options:

	a) #
	b) +
	c) ^
	d) &

Save

Question 13 (5 points)

Use the _______________command to display the contents of a cell on multiple lines.

Question 13 options:

	a) Text Effects
	b) Wrap Text
	c) AutoFit
	d) Align

Save

Question 14 (5 points)

Text that is too long to fit in a cell will overflow into the cell on the right (if it is empty). If the cell to the right contains data, the text is truncated in the spreadsheet, however the entire value displays in the:

Question 14 options:

	a) Formula Bar.
	b) Formula Review Bar.
	c) adjacent cell.
	d) cell reference.

Save

Question 15 (5 points)

__________are symbols that specify a type of calculation.

Question 15 options:

	a) Cell references
	b) Calculators
	c) Arithmetic captions
	d) Arithmetic operators

Save

Question 16 (5 points)

In the ______________ group, the Wrap Text command can display the contents of a cell on multiple lines.

Question 16 options:

	a) Alignment
	b) Text Effects
	c) Format
	d) Page Setup

Save

Question 17 (5 points)

When creating a formula, you must use a(n) ___________ so that if the value in the cell changes Excel automatically re-calculates the spreadsheet.

Question 17 options:

	a) arithmetic operator
	b) calculator
	c) cell reference
	d) AutoFit command

Save

Question 18 (5 points)

Using the Backstage View, properties and tags can be added or modified and Excel files can be saved as _____________ files.

Question 18 options:

	a) Quicken
	b) Word
	c) PDF
	d) Access

Save

Question 19 (5 points)

The left side of the Status Bar displays all the following EXCEPT:

Question 19 options:

	a) page number.
	b) the current cell mean.
	c) the current cell mode.
	d) worksheet information.

Save

Question 20 (5 points)

When constructing a formula, the referenced cells display bordered in the same color. This feature is known as the ___________ and provides a visual cue showing the cells included in the formula.

Question 20 options:

	a) formula identifier
	b) range finder
	c) calculated range
	d) detail view