excel

Ace your homework & exams now with Quizwiz!

select all box

a box in the upper left corner of the worksheet grid that selects all the cells in a worksheet

line chart

a chart that displays trends over time

freeze panes

a command that enables you to select one or more rows or columns and lock them in place

quick analysis tool

a feature that displays in the lower right corner of a selected range with which you can analyze your data by using excel tools such as charts, color-coding, and formulas

range finder

a feature that outlines cells in color to indicate which cells are used in a formula

conditional format

a format that changes the appearance of a cell based on a condition

if function

a function that uses a logical test to check whether a condition is met, and then returns one value if true and another value if false

logical functions

a group of functions that test for specific conditions, and which typically use conditional tests to determine whether specified conditions are true or false

row

a horizontal group of cells in a worksheet

SUM function

a predefined formula that adds all the numbers in a selected range

function

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

table

a series of rows and columns that contains related data and that is managed independently from other data

data bar

a shaded bar that provides a visual cue about the value of a cell relative to other cells

countif function

a statistical function that counts the number of cells within a range that meet the given condition and which has two arguments - the range of cells to check and the criteria

point

a value that originates in a worksheet cell and that is represented in a chart by a data marker

column

a vertical group of cells in a worksheet

summary sheet

a worksheet where totals from other worksheets are displayed and summarized

formula bar

an element in the excel window that displays the value or formula contained in the active cell

name box

an element of the excel window that displays the name of the selected cell, table, chart, or object

formula

an equation that performs mathematical calculations on values in a worksheet

average function

an excel feature that adds a group of values and then divides the result by the number of values in the group

autofit

an excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column

workbook

an excel file that contains one or more worksheets

max function

an excel function that determines the largest value in a range

min function

an excel function that determines the smallest value in a range

median function

an excel function that finds the middle value that has as many values above it in the group as are below it

value

another name for a constant value

spreadsheet

another name for a worksheet

cell address

another name for cell reference

logical test

any value or expression that can be evaluated as being true or false

cell content

anything typed into a cell

criteria

conditions that you specify in a logical function

statistical functions

excel functions , such as average, that are useful to analyze a group of measurements

constant value

numbers, text, dates, or times of day that you type into a cell

data series

related data points represented by data markers

comparison operator

symbols that evaluate each value to determine if it is the same (=), greater than (>), less than (<), or in between a range of values as specified by the criteria

data

text or numbers in a cell

paste

the action of placing cell contents that have been copied or moved to the clipboard into another location

explode

the action of pulling out a pie slice from a pie chart for emphasis

category axis

the area along the bottom of a chart that identifies the categories of data

plot area

the area bounded by the axes of a chart, including all the data series

underlying value

the data that displays in the formula bar

general format

the default format that excel applies to numbers

print titles

the excel command that enables you to specify rows and columns to repeat on each printed page

flash fill

the excel command that recognizes a pattern in your data and then automatically fills in the values when you enter examples of the desired output

auto fill

the excel feature that generates and extends values into adjacent cells based on the values of selected cells

now function

the function that retrieves and then displays the date and time from your computer

chart

the graphic representation of data in a worksheet

cell

the intersection of a column and a row

sheet tabs

the labels along the lower border of the excel window that identify each worksheet

sorting

the process of arranging data in a specific order based on the value in each field

filtering

the process of displaying only a portion of the data based on matching a specific value to show only the data that meets the criteria that you specify

navigate

the process of moving within a worksheet or workbook

fill handle

the small black square in the lower right corner of a selected cell

operators

the symbols with which you can specify the type of calculation you want to perform in an excel formula

volatile

the term used to describe an excel function that is subject to change each time the workbook is opened

absolute

the type of cell referee that refers to cells by their fixed position in a worksheet

major unit

the value in a chart's value axis that determines the spacing between tick marks and between gridlines in the plot area

arguments

the value that an excel function uses to perform calculations or operations

detail sheets

the worksheets that contain the details of the information summarized on a summary sheet

sparklines

tiny charts embedded in a cell that gives a visual trend summary alongside your data


Related study sets

Prioritizing Client Care: Leadership, Delegation, and Emergency Response Planning

View Set

Math Review (Treatment Planning)

View Set

Economics Test- Chapter 3 sections 4-9

View Set