EXCEL Flashcards by donya amini

alignement

the position the data between the cell margins

How well did you know this?

Not at all

Perfectly

auto fill

enables you to copy the contents of a cell or cell range or to continue a sequence by dragging the fill handle over an adjacent cell or range of cells

How well did you know this?

Not at all

Perfectly

cell

the intersection of a column or row

How well did you know this?

Not at all

Perfectly

column width

the horizontal measurement of a column

How well did you know this?

Not at all

Perfectly

fill color

the background color appearing behind data in a cell

How well did you know this?

Not at all

Perfectly

fill handle

small green square in the lower-right corner of a selected cell or range of cells

How well did you know this?

Not at all

Perfectly

formula

displays the content ( text, value, date, or formula) in the active cell

How well did you know this?

Not at all

Perfectly

formula bar

displays the content ( text, value, date, or formula) in the active cell

How well did you know this?

Not at all

Perfectly

input area

the background color appearing behind data in a cell

How well did you know this?

Not at all

Perfectly

name box

identifies the address of the current cell

How well did you know this?

Not at all

Perfectly

order of operations

rules that control the sequence in which Excel performs arithmetic operations

How well did you know this?

Not at all

Perfectly

output area

a range of cells containing results based on manipulating the variables

How well did you know this?

Not at all

Perfectly

range

a rectangular group of cells

How well did you know this?

Not at all

Perfectly

row height

the vertical measurement of a row

How well did you know this?

Not at all

Perfectly

sheet tab

displays the name of a worksheet within a workbook

How well did you know this?

Not at all

Perfectly

text

includes letters, numbers symbols, and spaces

How well did you know this?

Not at all

Perfectly

value

a number that represents a quantity or an amount

How well did you know this?

Not at all

Perfectly

workbook

a file containing related worksheets

How well did you know this?

Not at all

Perfectly

worksheet

a spreadsheet that contains formulas, functions, values, text, and visual aids

How well did you know this?

Not at all

Perfectly

wrap text

formatting that enables a label to appear on multiple lines within the current cell

How well did you know this?

Not at all

Perfectly

absolute cell reference

Indicates a cell’s specific location; the cell reference does not change when you copy the formula.

How well did you know this?

Not at all

Perfectly

argument

an input, such as a cell reference or value, needed to complete a function

How well did you know this?

Not at all

Perfectly

AVERAGE function

calculates the arithmetic mean, or average, of value in a range

How well did you know this?

Not at all

Perfectly

COUNT function

tallies the number of cells in a range that contain values

How well did you know this?

Not at all

Perfectly

IF function

evaluates a condition and returns one value if the condition is true and a different value if the condition is false

logical test

an expression that evaluates to true or false

lookup table

A range that contains data for the basis of the lookup and data to be retrieved

MAX function

identifies the highest value in range

MEDIAN function

identifies the midpoint value in a set of values

MIN function

displays the lowest value in a range

mixed cell reference

Contains both an absolute and a relative cell reference in a formula; the absolute part does not change but the relative part does when you copy the formula

NOW function

displays the current date and time

PMT function

calculates the periodic payment for a loan with a fixed interest rate and fixed term

relative cell reference

indicates a cell's location from the cell containing the formula; the cell reference changes when the formula is copied

SUM function

calculates the total of values contained in two or more cells

syntax

the set of rules for combining words into grammatically sensible sentences

TODAY function

displays the current date

VLOOKUP function

looks up a value in a vertical lookup table and returns a related result from the lookup table

axis title

a label that describes either the category axis or the value axis

bar chart

chart type that compares categories of data horizontally

category axis

the area along the bottom of a chart that identifies the categories of data; also referred to as the x-axis

chart area

contains the entire chart and all of its elements

chart title

a label that describes a chart

cluster column chart

chart type that shows the relationship between two variables

combo chart

Chart that contains two chart types, such as column and line, to depict two types of data, such as individual data points and percentages

data labels

labels that identify each value in the data series

data point

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

data series

a group of related information in a column or row of a worksheet that is plotted on a chart

gridline

the lines in a table that form the rows and columns

legend

the key to a chart that explains what each data series represents

line chart

a chart that uses points connected by a line to illustrate values in a worksheet

pie chart

chart that shows each data point in proportion to the whole data series

plot area

the area in the chart container that shows the data series compared to the chart's gridlines

sizing handle

A circle that enables you to adjust the height or width of a selected chart

sparklines

miniature graphs that summarize data; typically used to graphically describe trends in data

task pane

a window along the left side of the program window that contains options and commands

value axis

horizontal or vertical grouping of values from the worksheet

X Y (scatter) chart

shows the relationship between two variables

which step is NOT part of planning a worksheet design? a) decide what input values are needed b) state the purpose of the worksheet c) decide what outputs are needed to achieve the purpose d) enter labels, values and formulas

given the formula =B1*B2+B3/B4^2, what operation is calculated first? a) B1*B2 b) B2+B3 c) B3/B4 d) B4^2

how can you display formulas within the cells instead of the cell results? a) press Crtl+G b) press Crtl+ ' c) click cell reference on the home tab d) press Crtl+C

which of the following is NOT an alignment option? a) increase indent b) merge and center c) fill color d) wrap text

what is a fast way to apply several formats at one time? a) click each one individually b) apply a cell style c) use auto fill d) use copy and paste option

if cell E1 5 contains the formula =$C$5*J$15, what type of cell reference is the J$15 in the formula? a) relative reference b) absolute reference c) mixed reference d) syntax

what function would most efficiently accomplish the same thing as =(B5+C5+D5+E5+F5)/5? a) =SUM(B5:F5)/5 b) =AVERAGE(B5:F5) c) =MEDIAN(B5:F5) d) =COUNT(B5:F5)

When you start to type =AV, what feature displays a list of functions and defined names? a) function screentip b) formula autocomplete c) insert function dialog box d) function argument dialog box

which of the following functions should be used to insert the current date and time in a cell? a) TODAY() b) CURRENT() c) NOW() d) DATE

which of the following is not an argument of the IF function? a) value_if_true b) value_if_false c) logical_test d) lookup_value

which of the following is NOT true about the VLOOKUP function? a) the lookup table must be in ascending order b) the lookup table must be in descending order c) the default match type is approximate d) the match type must be false when completing an exact match