Excel Exam 62 Questions with Verified Answers
spreadsheet - CORRECT ANSWER an electronic file that contains a grid of columns and rows containing
... [Show More] related data
worksheet - CORRECT ANSWER s spreadsheet that contains formulas, functions, values, texts, and visual aids
workbook - CORRECT ANSWER a file containing related worksheets
input area - CORRECT ANSWER a range of cells containing values for vairables used in formulas
output - CORRECT ANSWER a range of cells containing results based on manipulating the variables
name box - CORRECT ANSWER identifies the address of the current cell
formula bar - CORRECT ANSWER displays the content (text, value, date, or formula) in the active cell
sheet tab - CORRECT ANSWER diplays the name of a worksheet within a work-book
cell - CORRECT ANSWER the interesection of a column letter and a row number
cell address - CORRECT ANSWER identifies a cell by a letter and a ro number
active cell - CORRECT ANSWER the current cell, indicated by a dark border
text - CORRECT ANSWER includes letters, numbers, symbols, and spaces
value - CORRECT ANSWER a number that represents a quantity or an account
formula - CORRECT ANSWER a combination of cell refrences, operators, values, and or functions used to perfom a calculation
range - CORRECT ANSWER a rectangular group of cells
nonadjacent range - CORRECT ANSWER contains multiple ranges of cells
semi-selection - CORRECT ANSWER the process of using the mouse pointer to select cells while building a formula
relative cell reference - CORRECT ANSWER indicates a cell's relative location from the cell containing the formula, the cell reference changes when the formula is copied
absolute cell reference - CORRECT ANSWER indicates a cell's specific location; the cell reference does not change when you copy the formula
mixed cell reference - CORRECT ANSWER 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
circular reference - CORRECT ANSWER occurs when a formula directly or indirectly refers to itself
syntax - CORRECT ANSWER a set of rules that govern the structure and components for properly entering a function
arguement - CORRECT ANSWER an input, such as a cell reference or value, needed to complete a function
function screentip - CORRECT ANSWER a small pop-up description that displays the arguements for a function as you enter it
counta function - CORRECT ANSWER tallies the number of cells in a range that are not empty
now function - CORRECT ANSWER displays current date and time
if function - CORRECT ANSWER evaluates a condition and returns one value if the condition is true and a different value if the conditon is false
logical test - CORRECT ANSWER an expression that evaluates to true or false
nested function - CORRECT ANSWER a function that contains another function embedded inside one or more of its arguements
vlookup function - CORRECT ANSWER looks up a value in a vertical lookup table and returns a related result from the lookup table
table array - CORRECT ANSWER a range containing a lookup value
pmt function - CORRECT ANSWER calculates the periodic payment for a loan with a fixed interest rate and fixed term
rate - CORRECT ANSWER the periodic interest rate, such as a monthly interest rate
nper - CORRECT ANSWER the number of total payment periods
pv - CORRECT ANSWER the present value of the loan
range name - CORRECT ANSWER a word or string of characters that represents one or more cells
column chart - CORRECT ANSWER displays data comparisons vertically in columns
chart area - CORRECT ANSWER contains the entire chart and all of its elements
plot area - CORRECT ANSWER contains a graphical representation of values in a data series
value axis - CORRECT ANSWER displays incremental values to identify the values of the data series
legend - CORRECT ANSWER a key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart
stacked column chart - CORRECT ANSWER places stacks of data in segments on top of each other in on column, with each category in the data series represented by a different color
bar chart - CORRECT ANSWER compares values across categories using horizontal bars
line chart - CORRECT ANSWER uses a line to connect data points in order to show trends over a period of time
sparkline - CORRECT ANSWER a miniature chart contained in a single cell
chart title - CORRECT ANSWER a label that describes the chart
axis title - CORRECT ANSWER a label that describes either the category axis or the value axis
data label - CORRECT ANSWER the value or name of a data point
trendline - CORRECT ANSWER a line used to depict trends and forecast future data
gridline - CORRECT ANSWER a horizontal or vertical line that extends from the horizontal or vertical axis through the plot area
freezing - CORRECT ANSWER keeps rows and or columns visible as you scroll through a worksheet
page break - CORRECT ANSWER indicates where data starts on a new printed page
print area - CORRECT ANSWER defines the range of data to print
field - CORRECT ANSWER indvidual piece of data such a last name
record - CORRECT ANSWER a complete set of data for an entity
table - CORRECT ANSWER an area in the worksheet that contains rows and columns of related data formatted to enable data management and analysis
sorting - CORRECT ANSWER arranges records in a table by the value in a field(s) within a table
filtering - CORRECT ANSWER the process of displaying only records that meet specific conditions
structured reference - CORRECT ANSWER a tag or use of a table element as a reference in a formula
total row - CORRECT ANSWER appears as the last row of a table to display summary statistics, such as a sum
conditonal formatting - CORRECT ANSWER highlights or emphasizes cells that meet certain conditons
data bar - CORRECT ANSWER a horizontal gradient or solid fill indicating the cell's relative value compared to other selected cells [Show Less]