INFS Midterm

In Excel, a number can contain the characters ______

All of the above

A thin red border indicates the active cell


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)


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


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


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


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


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


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


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


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


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


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


Clicking the ___ box completes an entry


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


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


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


A cell is referred to by its cell ____


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


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


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


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


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


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


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


Which of the following calculations multiplies 23 by 0.01


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


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


The Insert Options button lists formatting options


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


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


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


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


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


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


The arithmetic opertaor ^ directs Excel to perform the division operation


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


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


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


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


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


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


A worksheet header is the same as a worksheet title


A paste option can allow the copying of the format only


The <> comparision means greater than


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


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


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


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


Which comparision operator means "not equal to"?


To Name a cell use the ___


Which of the following formulas contains and absolute cell reference


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


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)


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 ____?


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


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

Thursday, Saturday, Monday