INFS Midterm

In Excel, a number can contain the characters ______

All of the above

A thin red border indicates the active cell

True

A (n) _____ window is an open window hidden from view but that can be displayed quickly by clicking the window's program button on task bar (dock)

Administered

Choose a type of chart that relays the message that you want to convey

True

If you inadvertently rename a file that is associated with certain programs, the programs may not be able to find the file and may not execute properly

True

A ___ is an icon on the desktop that provides a user with immediate access to a program or file

Shortcut

The AutoCorrect feature can automatically capitalize the first letter in the names of days

False

A(n) _____ chart is drawn on the same worksheet as the data

embedded

A ___ helps you manage multiple folders and files stored in various locations on a computer

Library

A(n) ___ on a menu performs a specific action, such as saving a file

Indicator

Excel can display characters in only three font colors: black, red, blue

True

Both the Cancel box and the Enter box appear on the formula bar when you begin typing in a cell

True

To enter data in a cell, you must first select or activate the ____

Cell

Clicking the ___ box completes an entry

Enter

To cancel an entire entry before entering it into a cell press the ___ key

ALT

To draw a chart, first select the data to be charted and then click the Chart tool tab

False

Combining two or more selected cells into one cell is called ____ cells

Merging

A cell is referred to by its cell ____

reference

When you click the Tab key to complete an entry in a cell, the active cell moves down to the next cell in the same column

False

In Microsoft Office applications, each ____ contains a collections of groups, each of which contains related commands

Tab

One method of changing the size of a window is to drag the window borders

True

Microsoft Office programs use ____ dialog boxes for performing actions such as opening and saving files

Common

The first step in creating an effective worksheet is to make sure you ____

Understand what is required

A ____ consists of a drive letter and colon, to identify the storage device, and one or more folder names

Path

Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTEr key

Left Parenthesis

A ____ is a pre-written formula that is built into excel

Function

Which of the following option buttons gives options for filling cells following a fill operation

Auto Fill Options

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

Accounting Style

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

Range Finder

Too obtain the formulas version of a worksheet use the ____ keys

CTRL + ACCENT MARK (COMMAND ACCENT MARK)

Which of the following calculations multiplies 23 by 0.01

0.23

You can clear cell contents and the formatting by clicking the Clear Contents on the Clear button menu

True

Point mode allows you to select cells for use in a formula by using the keyboard

False

The Insert Options button lists formatting options

False

You can click the ___ button to undo an automatic correction

Auto Fill Options

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

double-click

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

Average

Which of the following happens when you enter the formula =G15 into a cell

Excel assigns the value in cell G15 to the active cell

The equal sign (=) precedes a formula

True

Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric data

False

The ____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign

Formula

As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations

False

The arithmetic opertaor ^ directs Excel to perform the division operation

False

An asterisk (*) following a cell reference in a formula us the arithmetic operator that directs Excel to perform the division operation

False

To paste copied cell contents, you can press the ____ keys

CTRL + V (COMMAND V)

Which of the following is the path to the Copy and Paste buttons

(Home Tab- Clipboard Group)

All of the following are valid Excel arithmetic operators except____

^

You can use the arrow keys to complete an entry Keyboard mode

True

With Excel in Edit mode, you can edit cell content directly in the cell

True

A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area

True

The ___ function is useful when you want to assign a value based on a logical test

IF

A worksheet header is the same as a worksheet title

False

A paste option can allow the copying of the format only

True

The <> comparision means greater than

False

If the contents of cell A1 containing 410 and A2 containing 430 are copied using the fill handle, then the next three values of an extended series can be: 450, 470, 490

True

A(n) ___ IF function is one in which the action to be taken for the true or false case includes yet another IF function

Included

When you rest the mouse pointer over a chart item such as the legend, Excel displays a chart tip containing the name of an item

True

You can ensure correctness by in your formulas by using the ___

Range Finder

The copy button copies the contents and format of the source area to the office _____, a reserved place in the computers memory

...

Rotates text allows you to fit more text into a smaller column width

True

Which comparision operator means "not equal to"?

<=

To Name a cell use the ___

...

Which of the following formulas contains and absolute cell reference

389846216

When creating a formula in one worksheet, a cell in another can be referenced by _______

...

When you set up a worksheet, you should use cell references whenever possible, rather than ________ values

...

In a formula using _____ addressing, $B$4 instructs Excel to not adjust the cell reference as it copies it to the destination area

Absolute

Which of the following is not a valid format symbol?

;

The Syntax of the IF functions is IF(logical_test, value_if_false, value_if_true)

False

If you Copy and Paste cells A1 and B1 containing numbers 1 and 2, respectively, to cells C1 and D1, the values in C1 and D1 will be ____?

1,2

A (n) is _____ is a seperate sheet in a workbook that contains only a chart

Chart Sheet or Worksheet??

With a (n) mouse, you control the movement of the pointer on the screen and make selections from the screen

True

Which of the following is an extension of the fill pattern Sunday, Tuesday?

Thursday, Saturday, Monday