Tutorials 1-3

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