excel

the chart type that displays the relationship of parts to a whole is:

A. a pie chart

A cell reference that refers to a cell by it fixed position in a worksheet and that does not change when the formula is copied.

A. absolute celll reference

The cell, surrounded by a blank border, ready to receive data or be affected by the next excel command.

A. active cell

grouped worksheets can be edited and formatted in this way.

A. all at the same time

a green triangle that indicates a possible error in a formula is called:

A. an error indicator

in an excel function, the values in parentheses used to perform calculations or operations

A. arguments

a temporary storage area fr text and graphics.

A. clipboard

these symbols are inserted into logical functions to determine whether a condition is true or false- (<) and (=), for example

A. comparison operators

this command only displays the row of table that meet specified criteria

A. filter

an excel window area that displays the value contained in the active cell

A. formula bar

when a formula contains operators with the same precedence level, the operators are evaluated in this order

A. left to right

the box that identifies the patterns or colors assigned to the data series in a chart is called:

A. legend

this type of test has an outcome of true or false

A. logical

deleting the content of a cell also deletes this

A. only the contents

the number that displays at the left of a row.

A. row heading

changes in a detail worksheet will automatically recalculate and display on this sheet

A. summary

this row displays as the last row in an excel table and provides summary statistics

A. total

this word describes a function that is updated each time the workbook is opened

A. volatile

automatically changing the column width to accommodate the longest column entry is called:

B autofit

the excel function hat adds group of values and then divides the result by the number of values in the group

B. AVERAGE

a prewritten excel formula

B. Function

the excel number format that applies a comma separator where appropriate, inserts a fixed dollar sign aligned at the left edge of the cell, applies two decimal places, and leaves a small amount of space at both the right and left edges of the cell to accommodate parenthesis for negative numbers.

B. accounting number format

the column letter and row number that identify a cell

B. cell address

The identification of a specific cell by its intersecting column letter and row number.

B. cell reference

a predesigned combination of chart elements is referred to as a:

B. chart layout

a chat type that is useful when you want to compare value across categories; categories are typically organized along the vertical axis, and the values along the horizontal axis.

B. clustered bar chart

this word describes a format, such as cell shading, that is applied to cells when a specified condition is true

B. conditional

the chart data points related to one another are known as a:

B. data series

this term refers to related data organized in rows an columns that is managed independently from other data in the worksheet

B. excel window

the small black square in the lower right corner of the active cell.

B. fill handle

an equation that performs mathematical calculations on number values

B. formula

In an excel workbook, you can do this

B. move worksheets

page headers and footer can be changed in this view

B. page layout view

in chart, the legend can be located here.

B. the top of the chart

this function checks whether criteria are met and returns a on value if true and another is false

C. IF

after sorting, filtering, and totaling an excel table, an excel table can be converted into this

C. Range

when grouping worksheets in a workbook, you can group this number of worksheets

C. any number

symbols that specify mathematical operations such as addition or subtraction

C. arithmetic operators

a column in an excel table that uses a single formula that adjusts for each row

C. calculated column

the chart axis that is usually the horizontal axis and contains categories

C. category axis

a worksheet that contains only a chart is referred to as a:

C. chart sheet

a chart type useful for illustrating comparisons among related numbers is called:

C. column charts

a worksheet that contains the detailed information of a workbook

C. detail sheet

a chart placed on a worksheet with the source data is:

C. embedded chart

this command ensures that the header rows and columns remain visible when a worksheet is scrolled

C. freeze panes

if a workbook contains grouped worksheets, this word will display on the title bar

C. group

Another name for a text value

C. label

a view that maximizes the number of cells visible on the screen

C. normal view

the excel feature that outlines all the cells referenced in a formal is the:

C. range finder

addition and this mathematical operator are considered to be the same precedence level

C. subtraction

when pasting a range of cells, this cell needs to be selected in the past area

C. top left cell

a graphic representation of data in a worksheet that shows comparisons, patterns, and trends

D. chart

conditions that you specify

D. criteria

a method of moving or copying the content of selected cells in which you point the selection and drag it to a new location

D. drag and drop

An excel window are that displays the address of a selected cell

D. name box

to pull out one or more slices of a 3-D pie chart to emphasize a specific slice or slices

E. explode

A prewritten formula that performs calculations by using specific values in a particular order or structure

E. function

data in a cell made up of numbers only

E. number value

the mathematical rules for performing calculations within a formula

E. operator presedence

the default format that excel applies to numbers- whatever you type in the cell will display, with the exception that traveling zeros to the right of a decimal point will no display.

F. general format

the type of function that tests for specific conditions and typically uses conditional tests to determine whether specified conditions are TRUE or FALSE.

F. logical functions

the target destination for data that has been cut or copied using the clipboard

F. paste area

Another name for a worksheet.

F. spreadsheet

a sequential number assigned to a date

G serial number

an excel function that determines the largest vale in a range of values

G. MAX

a specific way that excel displays numbers

G. number format

data in a cell made up of text only

G. text value

the labels along the lower border of the workbook window that identify each worksheet.

H. sheet tabs

a set of design elements that provides a unified look for colors, fonts, and graphics

H. theme

data in a cell- text or number.

H. value

an excel function that determines the smallest value in a selected range of values

H.MIN

the function that returns the serial number of the current date and time

I. NOW

a worksheet that displays and summarizes totals from other worksheets in a workbook

I. summary sheet

a command with which you can display text on multiple lines within a cell

I. text wrap

An excel file that contains one or more worksheets.

I. workbook

a type of of function that summarizes a group of measurements

J. statistical functions

buttons to the left of the sheet tabs used to display excel sheet tabs that are not in view

J. tab scrolling buttons

the chart axis that usually the vertical axis and contains data

J. value axis

The primary document that you use in excel to store and work data, and which is formatted as a pattern of uniformly spaced horizontal and vertical.

J. worksheet

the data displayed in a cell

c. displayed value