excel test 3

Question 1

average function

Answer 1

returns the average of values in the range

Question 2

median function

Answer 2

returns the middle value in the range

Question 3

mode.sngl

Answer 3

returns the single value that is repeated most often in the range

Question 4

round up function

Answer 4

rounds a value to the next highest digit

Question 5

autofill

Answer 5

used to enter formulas or data patterns into a selected range based on the content of the starting cells in the range

Question 6

constant

Answer 6

a value/term in an equation whose values don’t change

Question 7

fill handle

Answer 7

appears as a black square/box in the lower-right corner of the cell

Question 8

Nest

Answer 8

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

Question 9

NOW function

Answer 9

automatically updated whenever you add a new calculation to the workbook or reopen the workbook

Question 10

TODAY function

Answer 10

the date displayed is automatically updated whenever you enter a new formula or reopen the workbook

Question 11

WORKDAY function

Answer 11

function to display the date of a working day/weekday that is a specified number of workdays/weekdays past a start date

Question 12

Error value

Answer 12

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

Question 13

Mixed cell reference

Answer 13

a cell reference that has both absolute and relative components in the reference

Question 14

Absolute cell reference

Answer 14

a cell reference that does not change when the formula containing that reference is moved to a new location

Question 15

Relative cell reference

Answer 15

a cell reference that changes when the formula containing that reference is moved to a new location

Question 16

VLOOKUP function

Answer 16

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)

Question 17

IF Function

Answer 17

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

Question 18

lookup function

Answer 18

retrieves a value matching a specified condition from a table of data

Question 19

lookup table

Answer 19

the table storing the data you want to be retrieved with a lookup function

Question 20

lookup value

Answer 20

the values that are being looked up/the category you want to find in lookup table

Question 21

Return values

Answer 21

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

Question 22

Exact match lookup

Answer 22

the lookup value must exactly match one of the values from the table’s first column or row/in the lookup table

Question 23

Approximate match lookup

Answer 23

used when the lookup value falls within a range of values in the first column or row/lookup table

Question 24

trial and error

Answer 24

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

Question 25

goal seek

Answer 25

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

Question 26

Types of patterns AutoFill

Answer 26

Numbers (1,2,3) and dates/times (Jan, Feb, Mar)

Question 27

List two Date and Time functions

Answer 27

Date(year,month,day) and Day(serial_number)

Question 28

List two common error values

Answer 28

#DIV/0! (Divided by zero) and #NAME? – excel doesn’t recognize text/misspell

Question 29

List two logical comparison operators

Answer 29

=, >

Question 30

List two Function Library categories

Answer 30

Compatibility – functions from excel 2010 or earlier, still supported to provide backward compatibility Cube – receives data from multidimensional databases involving online analytical processing (OLAP)

Question 31

argument

Answer 31

the numbers, text, or cell references used by the function to return a value

Question 32

compare values

Answer 32

the categories in a lookup table that are used for matching to a specified lookup value

Question 33

comparison operator

Answer 33

a symbol that indicates the relationship between two values

Question 34

COUNT function

Answer 34

the excel function that tallies how many cells in specified range contain numbers or dates

Question 35

COUNTA function

Answer 35

function that tallies how many cells in specified range contain any entries (numbers, dates, or text)

Question 36

horizontal lookup table

Answer 36

a lookup table in which the compare values are location in the first row

Question 37

logical function

Answer 37

a function that returns a different value depending on whether the given condition is true or false

Question 38

MAX function

Answer 38

a function that returns the maximum value in a range

Question 39

MIN function

Answer 39

a function that returns the minimum value in the range

Question 40

optional argument

Answer 40

an argument that is not required for the function to return a value

Question 41

required argument

Answer 41

an argument that is needed for the function to return a value

Question 42

significant digits

Answer 42

the number of digits that should be displayed for a calculation; they indicate the accuracy of the measured and calculated results

Question 43

vertical lookup table

Answer 43

a table used to retrieve data based on matching the category values found in the first column of the table

Question 43

what-if analysis

Answer 43

a way to explore the impact that changing input values has on calculated value in a workbook