Chapters 1-3 Tests

### T/F: Microsoft Office Excel 2010 is the presentation program in Microsoft Office 2010

False; PowerPoint

### T/F: The Excel program window has the same basic parts of all Office programs: the title bar, the Quick Access Toolbar, the Ribbon, Backstage View, and the status bar.

True

### T/F: The Save As command saves an existing workbook on a disk, using its current name and save location.

False

### T/F: If a cell is not wide enough to display all the cell's contents, extra text extends into the next cells if there is room.

True

### When Excel starts, the program window displays a blank workbook titled Book1, which includes ____ blank worksheets.

3

### ____ appear horizontally and are identified by numbers on the left side of the worksheet window.

Rows

### ____ of the worksheet appear vertically and are identified by letters at the top of the worksheet.

Columns

### The ____, or cell reference area located below the Ribbon, displays the cell reference of the active cell.

Name Box

### The range is identified by its range reference, which is the cell in its upper-left corner and the cell in its lower-right corner, separated by a _____

Colon

### If you want to see more cells in the work area, click the Zoom Out button or drag the Zoom slider to the ____ to decrease the zoom percentage.

Left

### If you try to close a workbook that contains changes that you haven't yet saved, . . .

a dialog box asks you whether or not you want to save the file

### You can also center cell contents across several columns. Select the cells, and then click the _____ button in the Alignment group on the Home tab of the ribbon.

Merge and Center

### As you format cells,___ shows the results of the different formatting options you can choose.

Live Preview

### A(n) _________ is an equation that calculates a new value from values currently in a worksheet.

Formula

### When more than on arithmetic operator is involved in a formula, Excel follows the same basic order of _____ that you use in algebra

operations

### Which of the following happens when you enter the formulater =G15 into a cell?

Excel assigns the value in cell G15 to the active cell

### The ___ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.

Average

### You should ____ a function name in the Formula AutoComplete list to select the function.

Double-click

### You can use the ____ to check which cells are referenced in the formula assigned to the active cell.

Range Finder

### The ____ displays the numbers with a fixed dollar sign to the left of the number, a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent.

Accounting Number Format

### T/F: An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

True

### T/F: The Sum button menu allows you to enter one of five often-used functions easily into a cell.

True

### T/F: The use of a fill color in a cell or range of cells sets off the cell or range from other portions of the worksheet and provides visual impact to draw the user's eye toward the cell or range.

True

### T/F: When you click the Decrease Font Size button, Excel assigns the next highest font size in the Font Size gallery.

False

### T/F: A floating dollar sign appearsimmediately to the left of the first digit in a dollar value with no spaces.

True

### T/F: The Percent Style button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign.

True