excel test 3 Flashcards
average function
returns the average of values in the range
median function
returns the middle value in the range
mode.sngl
returns the single value that is repeated most often in the range
round up function
rounds a value to the next highest digit
autofill
used to enter formulas or data patterns into a selected range based on the content of the starting cells in the range
constant
a value/term in an equation whose values don’t change
fill handle
appears as a black square/box in the lower-right corner of the cell
Nest
to place one thing inside another, such as a function inside another function. excel evaluates innermost first and then outward/inner acting as argument for next outer function
NOW function
automatically updated whenever you add a new calculation to the workbook or reopen the workbook
TODAY function
the date displayed is automatically updated whenever you enter a new formula or reopen the workbook
WORKDAY function
function to display the date of a working day/weekday that is a specified number of workdays/weekdays past a start date
Error value
when you make a mistake writing a formula, Excel returns an error value indicating that some part of a formula was entered incorrectly/message in cell
Mixed cell reference
a cell reference that has both absolute and relative components in the reference
Absolute cell reference
a cell reference that does not change when the formula containing that reference is moved to a new location
Relative cell reference
a cell reference that changes when the formula containing that reference is moved to a new location
VLOOKUP function
returns values from a vertical lookup table (by specifying the value to be matched, the location of the lookup table, and the column containing the return values)
IF Function
a logical function that tests a condition and then returns one value if the condition is true and another value if the condition is false