Title: Excel 2010 Review
Course: ITSC 1001.90008.C1Intro to PC > Section: Using the Computer

Q: A ____ chart is used to illustrate changes in data over time.
- book
- pie
- scatter
- line
A: line

Q: A formula in a cell that contains a reference back to itself is called a ____ reference.
- hidden
- loop
- nested
- circular
A: circular

Q: A formula using a(n) ____ reference instructs Excel to adjust the cell reference as it copies it to a destination area.
- adjustable cell
- absolute cell
- mixed cell
- relative cell
A: relative cell

Q: ____ allows you to create or modify a worksheet while viewing how it will look in printed format.
- Normal View
- Page Layout View
- Print Preview
- Review
A: Page Layout View

Q: A(n) ____ instructs the paste operation to keep the same cell reference as it copies a formula from one cell to another.
- absolute reference
- cell reference
- mixed reference
- constant reference
A: absolute reference

Q: A(n) ____ is a prewritten formula that is built into Excel.
- operation
- cell
- function
- argument
A: function

Q: A(n) ____ is a series of two or more adjacent cells in a column or row or rectangular group of cells.
- area
- range
- section
- list
A: range

Q: By default, Excel positions text in a cell ____.
- left-aligned
- right-aligned
- centered
- justified
A: left-aligned

Q: In a worksheet, Excel automatically ____ numeric data.
- centers
- left-aligns
- right-aligns
- none of the above
A: right-aligns

Q: The arithmetic operator for multiplication is ____.
- %
- *
- x
- ^
A: *

Q: The arithmetic operator for division is ____.
- \
- /
- %
- *
A: /

Q: The ____ on a Worksheet is one in which you can enter data.
- cell
- active cell
- home cell
- reference cell
A: active cell

Q: The range of cells receiving a copy is called the ____ area.
- source
- destination
- copy
- reference
A: destination

Q: To erase recent cell entries, use the ____ command on the Quick Access Toolbar.
- Undo
- Clear
- Backspace
- Erase
A: Undo

Q: To toggle between Insert mode and Overtype mode press the ____ key(s).
- Delete
- Insert
- Shift + Right arrow
- Shift + Left arrow
A: Insert

Q: Use the ____ function to determine the lowest number in a range.
- Range Finder
- SEARCH
- MIN
- FIND
A: MIN

Q: Using the ____ you can format a cell quickly by copying a cell's format to another cell or range of cells.
- Formatter
- Format Painter
- Copy
A: Format Painter

Q: Which of the following is an absolute cell reference?
- B20
- $B$20
- $B20
- B$20
A: $B$20