thick
The active cell has a _______ border.
name box
The contents of an active cell are displayed in the ________.
cell
The intersection of a row and column is known as a ________.
range
A(n) _________ is a group of cells.
equals sign
An Excel formula always begins with a9n0 _______.
Ctrl+
From formula view, press _______ to switch the worksheet back to Normal view.
...
Put the following steps for selecting a nonadjacent range of cells in the proper order
1.Select an adjacent range of cells
column heading
AD is an example of a ______.
In _______ orientation, a page is taller than it is wide.
portrait
letters, numbers, and symbols
Text data is any combination of ________.
Excel performs exponentiation, then multiplication and division, then addition and subtraction.
According to the order of precedence in Excel:
parentheses
To change the order of operations, enclose a part of the formula in ______.
pixels
It is recommended to set your column widths based on the maximum number of characters you wish to display, rather than _______.
in a worksheet , in a chart sheet
A chart can be displayed _______.
spreadsheet
Excel is an electronic version of a(n) ________.
workbooks
Excel stores its documents as files called _______.
A6:A9;C6:C9
Which describes a nonadjacent range?
font styles
Italic, bold, bold italic, and underline as examples of _______.
custom
You can create a ________ color by specifying a mixture of red, blue, and green color values.
Format and content
The background does not affect any cell's ________.
General number format
By default, numbers appear in the _______ and generally display values exactly as you type them.
numbers
Because Excel stores dates and times as _______, you can apply different formats without affecting the date and time value.
Orientation
Options to rotate cells in Excel are available using the _______ button in the Alignment group on the Home tab.
to enhance readability, to the top, right or bottom of a cell, an specify the thickness
You can add a border in Excel _______.
turn it off
When using the Format Painter, double-click the Format Painter button to paste the same format multiple times and click the format painter again to _______.
the ability to sort data, transferring data to and from an external file, and filtering data to show only rows that match specified criteria
Apply a table style marks the range as a table, making available tools designed for analyzing tabular data, including _______.
printed page
In Page layout view, the worksheet is displayed as it will appear on the ______.
margin
A _______ is the space between the page content and the edges of the page.
Painter
One way to ensure that you are using consistent formats is to copy and paste your formats using the Format ________.
hide columns without information you need
To view certain column on a large database, a good option is to ________.
Print Area
Setting the ______ to A1:L10 will print only data in those cells.
manual page break
To avoid splitting a worksheet in awkward places you cna insert a(n) _____ to specify a specific breaking point
&[File]
The code ______ will display the filename of the current workbook.
Logical
The ______ category of excel functions returns (true-false) values.
nested
0
syntax
Every function has to follow ________.
<<
Which of the following is not a comparison operator?
The formula returns the text "RESTART
IN the following formula: =IF(A1="YES","DONE","RESTART") what happens if A1="NO"?
arguments
The numbers, text, or cell references used by the function to return a value are called _______.
total number of payment periods required to pay off the loan
PMT(rate, nper, pv, [fv=0] [type=0]
In the figure above, nper stands for the _______.
optional arguments
PMT(rate, nper, pv, [fv=0] [type=0]
In the figure above, fv and type are _______.
column width
If you were to see ##### in cell B10, the ______ is too small to view the entire value.
relative
One of the great advantages of ______ references is that you can quickly generate row and column totals without having to worry about revising the formulas as you copy them to new locations.
absolute
Use ______ references when you want different formulas to refer to the same cell.
cell references
in "SUM(number1[,number2,number3,...])", number 1, number 2, and number 3 may be numbers or _______.
The average of the values in the range A1:A100 is calculated.
In the formula =INT(AVERAGE(A1:A100)), which would occur first? _______
content and formats
The fill handle copies ________.
Feb, Mar, Apr
Using AutoFill what would be the extended series of the initial entry Jan? _______
mixed
$A3$B$2 is an example of ______ references. This type of reference is seldom used other than when creating table of calculated values such as a multiplication table in which the values of the formula or function can be found in the initial rows and column