EXCEL Flashcards
alignement
the position the data between the cell margins
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
cell
the intersection of a column or row
column width
the horizontal measurement of a column
fill color
the background color appearing behind data in a cell
fill handle
small green square in the lower-right corner of a selected cell or range of cells
formula
displays the content ( text, value, date, or formula) in the active cell
formula bar
displays the content ( text, value, date, or formula) in the active cell
input area
the background color appearing behind data in a cell
name box
identifies the address of the current cell
order of operations
rules that control the sequence in which Excel performs arithmetic operations
output area
a range of cells containing results based on manipulating the variables
range
a rectangular group of cells
row height
the vertical measurement of a row
sheet tab
displays the name of a worksheet within a workbook
text
includes letters, numbers symbols, and spaces
value
a number that represents a quantity or an amount
workbook
a file containing related worksheets
worksheet
a spreadsheet that contains formulas, functions, values, text, and visual aids
wrap text
formatting that enables a label to appear on multiple lines within the current cell
absolute cell reference
Indicates a cell’s specific location; the cell reference does not change when you copy the formula.
argument
an input, such as a cell reference or value, needed to complete a function
AVERAGE function
calculates the arithmetic mean, or average, of value in a range
COUNT function
tallies the number of cells in a range that contain values
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
c)
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
d)
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
d)
which of the following is NOT an alignment option?
a) increase indent
b) merge and center
c) fill color
d) wrap text
c)
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
b)
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
b)
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)
b)
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
b)
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
c)
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
d)
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
b)
