Excel Chapter 3

what auto fill option is the same as the fill series option?

cell references in a formula are called_________

A ___________ chart provides a simple way to show trends and variations in a range of data within a single cell

the copy button copies the contents and format of the source area to the office ____ a temporary storage area in the computer's memory

charts can either be embedded in a worksheet or placed in a separate _______

__________ tect often provides a strong visual appeal

you can press the ________ keys to open the format cells dialog box

the path to the format painter button is _________

_________ refers to cells not wide enough to display the entire entry

using the mouse to move or copy cells is called

if you enter 90 in the degrees box in the ________ area of the format cells dialog box, the text will appear vertically and read from bottom to top in the cell

to open the format cells dialog box with the alignment sheet active, click the alignment settings ________

if formulas located in other cells reference cells in a deleted row or column, excel does not adjust these cell references but instead displays the ____ error message

when working with a large worksheet, you can split the window into _______ panes

________ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific oal for another cell

error messages begin with the _____ symbol

which comparison operator means not equal to?

the _____ function is useful when you want to affign a value to a cell based on a logical test

which of the following is not a valid format symbol?

_________ the format painter button and then drag through the nonadjacent ranges to paint the formats to the ranges

you use the _____ sheet in the format cells dialog box to position data in a cell by centering it for example

which of the following is an extension of the fill pattern sunday tuesday?

a ____ IF function is one in which the action to be taken for the true or false includes yet another IF function

which of the following patterns extends the fill series to 525 475 425

the increase indent button indents the contents of a cell to the right by ______ spaces

when assigned to a cell, the _____ function returns a number that corresponds to the system date and time beginning with december 31, 1899

which of the following is the path to the zoom button?

when you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values

whats the cell content that extends qrt3 qrt4 qrt1 by dragging the fill handle

the ______ auto fill option that fills the destination area using the format of the source area, no content is filled

which of the following formulas contains an absolute cell reference?

you should use a ____ chart to compare values side by side, broken down by category

a cell reference with only one dollar sign before either the column or the row is called an absolute reference

in the content of copying a range of cells to a nonadjacent location, an alternative to clicking the paste button is to press the _____ key

excel includes four types of sparkline charts, line, column, win/loss, and stock

when you magnify a worksheet, excel enlarges the view of the characters on the screen and displays more rows and columns

a data stamp shows the date a worksheet, report or other document was created or the time period it represents

you can nest IF functions at deep as you want, but after you get beyond a nest of three IF functions the logic becomes difficult to follow

the path to the logical button is formulas tab, function library group

a relative cell reference instructs excel to adjust the cell reference as it copies it to the destination area

you can select nonadjacent ranges using the shift key

a nested IF function is one in which the action to be taken for the true or false case includes yet another IF function

the underline format underlines the entire cell not just the characters in the cell

the <= comparison operator means less than or equal to

the linked pictures option in the paste options gallery copies an image of the source area as a picture so that a change to the cells in the source area updates the picture in the destination area

the range of entries that identifies the major groups for a clustered column chart we called the category names

the increase indent button indents the contents of a cell to the right by three spaces each time you click it

excel allows you to rotate text in a cell counterclockwise by entering a number between -1 degrees and -90 degrees