Excel is an electronic version of a ___________.
Excel stores its documents as files called _________.
The contents of an active cell are displayed in the _______ ___.
A chart can be displayed in a _________ or a _____ _____.
worksheet, chart sheet
The name given to a workbook before you rename it is _____.
By default, an Excel workbook is made up of _____ worksheets.
You can have more than __ _______ cells in each worksheet.
"Address" is an example of a ______ _______.
The active cell has a _____ border.
Row headings identify each row using a different _______.
Each cell in a worksheet is identified by a cell _________ indicating its column and row location.
The intersection of a row and a column is known as a ___.
An Excel worksheet can have a maximum of ______ columns.
To make A1 the active cell, press _________.
When you insert a new row in worksheet the existing rows are shifted ____.
Any text entered into a cell that doesn't fit may appear ______ __ _________.
hidden or truncated
To change the font size one point at a time, in the Font group on the Home tab, click the ________ ____ ____ ______ or the ________ ____ ____ ______.
Increase Font Size button, Decrease Font Size button
By default each cell in a worksheet is ____ standard-sized characters.
____ ____ is any combination of letters, numbers, or symbols that form words and sentences.
You can remove data from a cell by using _____ ________ or using the ______ ___.
clear contents, delete key
____ theme colors are designated for text and background, ___ colors are used for accents and highlights, and ___ colors are used for hyperlinks.
Four, six, two
You can create a ______ color by specifying a mixture of red, blue, and green color values.
To add a ____ _____ to a sheet tab, click the Format button, point to Tab color, and then click a color.
Selecting the Font Color button arrow will display __ _____ ______, _ ________ _____ ___, and _ ______ ___ __________ ___ _____ ____.
10 theme colors, a standard color bar, a Screen Tip displaying the color name
When creating an Excel document, you should avoid using ___ ___ _____ text and background together, since this is the most common form of color blindness.
red and green
By default, values appear in the _______ ______ ______ and generally displaying numbers exactly as you type them.
General number format
The ________ category of Excel functions retrieves and analyzes data.
The _______ category of Excel functions returns (true-false) values.
_______ is a Statistical function.
___ is a Math & Trig function.
=MAX(A1:A100)/100 is an example of a ______ function.
There is not a function called ____.
After you describe a function in the Insert Function dialog box, click __.
You rename a worksheet from "sheet1" to a more descriptive name that describes its content or purpose. (T/F)
Every function has to follow ______.
____, ___, and _____ are date functions.
Year, Now, Today
The PMT function is a _________ function.
With ________ interest, the borrower always pays more money to the lender the following year.
The FV function stands for ______ _____.
You can rename worksheet1 to a more descriptive name that describes its contents or purpose. (T/F)
The ______, ______, ___ ______ Chart Tools contextual tabs appear on the ribbon when you select a chart.
Design, Layout, and Format
_ ___________ range is two or more distinct areas of a worksheet such as A6:A10 and E6:E10.
The ____ _____ dialog box provides options for moving charts between worksheets and Chart sheets.
Placing a chart in a _____ _____ displays only the chart and no worksheet cells.
The ____ buttons on the status bar change how the worksheet contents are displayed.
To move or resize an embedded chart, ______ ___ _____ ___ ____ ___ _________ ___ or ____ ___ ______ ______ __ ___ _________ ___.
select the chart and drag the selection box, drag the resize handle on the selection box
A nonadjacent group of cells is two or more distinct areas in a single rectangular block of cells. (T/F)
You already created a line chart, but now decide that you want to change this chart to a pie chart. To do this, you click ______ _____ ____ from the Type gorup in the Chart Tools Design tab.
Change Chart Type
________ is the type of operation designated in the formula "C9/B10".
To move the active cell up one row, press ___________.
An ________ reference remains fixed when the cell formula is copied to a new location, and has $ in front of the column letter and the row numbers (example: $D$5).
A _____ reference contains an absolute row or an absolute comlumn (example: $N20 or N$20).