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
lookup function
retrieves a value matching a specified condition from a table of data
lookup table
the table storing the data you want to be retrieved with a lookup function
lookup value
the values that are being looked up/the category you want to find in lookup table
Return values
the data values you want to retrieve from a lookup table / the remaining rows or columns contain the data values retrieved by the lookups function
Exact match lookup
the lookup value must exactly match one of the values from the table’s first column or row/in the lookup table
Approximate match lookup
used when the lookup value falls within a range of values in the first column or row/lookup table
trial and error
a way to perform what-if analysis by changing one or more of the input values to see how they affect other cells in the workbook
goal seek
a feature that automates the trial-and-error process by allowing you to specify a value for the calculated item, which Excel uses to determine the input value needed to reach that goal /
reverses the trial-and-error process by specifying an output value and working backward to find the input value needed to reach that goal
Types of patterns AutoFill
Numbers (1,2,3) and dates/times (Jan, Feb, Mar)
List two Date and Time functions
Date(year,month,day) and Day(serial_number)
List two common error values
DIV/0! (Divided by zero) and #NAME? – excel doesn’t recognize text/misspell
List two logical comparison operators
=, >
List two Function Library categories
Compatibility – functions from excel 2010 or earlier, still supported to provide backward compatibility
Cube – receives data from multidimensional databases involving online analytical processing (OLAP)
argument
the numbers, text, or cell references used by the function to return a value
compare values
the categories in a lookup table that are used for matching to a specified lookup value
comparison operator
a symbol that indicates the relationship between two values
COUNT function
the excel function that tallies how many cells in specified range contain numbers or dates
COUNTA function
function that tallies how many cells in specified range contain any entries (numbers, dates, or text)
horizontal lookup table
a lookup table in which the compare values are location in the first row
logical function
a function that returns a different value depending on whether the given condition is true or false
MAX function
a function that returns the maximum value in a range
MIN function
a function that returns the minimum value in the range
optional argument
an argument that is not required for the function to return a value
required argument
an argument that is needed for the function to return a value
significant digits
the number of digits that should be displayed for a calculation; they indicate the accuracy of the measured and calculated results
vertical lookup table
a table used to retrieve data based on matching the category values found in the first column of the table
what-if analysis
a way to explore the impact that changing input values has on calculated value in a workbook