Like this study set? Create a free account to save it.

Sign up for an account

Already have a Quizlet account? .

Create an account

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.


T/F: The cell in the worksheet in which you type data is called the open cell.

False; active cell

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


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.


T/F: The contents of the active cell always appear in the Formula Bar.


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


The name of each worksheet appears in the ______ at the bottom of the worksheet window.

Sheet tab

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


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


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 _____


Numbers that extend beyond a cell's width appears as _____ in the cell


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.


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

____ determines the best width for a column or height for a row.


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.


A group of selected cells is a(n) ______


A ___ is a prewritten formula that is built into Excel.


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


When Excel follows the order of operations, the formula, 8*3+2, equals


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 adjusted cell references in a copied and pasted formula are called ____ references


A ____ cell in Excell has a numberical value of zero


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.


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


The ___ function displays the highest value in a range


The ____ function determines the lowest number in a range


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

Range Finder

A ____ is a predefined set of colors, fonts, chart syles, cell styles, and fill effects.


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: The equal sign (=) precedes a formula.


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


T/F: The arithmetic operator, ^, directs Excel to perform the division operation.


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


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.


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


T/F: You can click the Format Cells Dialog Box Launcher to open the Format Cells dialog box.


T/F: You cannot format an entire column at once.


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


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.


T/F: Formatting that appears only when the value in a cell meets conditions that you specify is called conditional formatting.


Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions and try again


Reload the page to try again!


Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

Voice Recording