excel test 3 Flashcards

1
Q

average function

A

returns the average of values in the range

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

median function

A

returns the middle value in the range

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

mode.sngl

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

round up function

A

rounds a value to the next highest digit

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

autofill

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

constant

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

fill handle

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Nest

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

NOW function

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

TODAY function

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

WORKDAY function

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Error value

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Mixed cell reference

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Absolute cell reference

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Relative cell reference

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

VLOOKUP function

A

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)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

IF Function

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

lookup function

A

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

19
Q

lookup table

A

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

20
Q

lookup value

A

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

21
Q

Return values

A

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

22
Q

Exact match lookup

A

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

23
Q

Approximate match lookup

A

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

24
Q

trial and error

A

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

25
Q

goal seek

A

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

26
Q

Types of patterns AutoFill

A

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

27
Q

List two Date and Time functions

A

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

28
Q

List two common error values

A

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

29
Q

List two logical comparison operators

A

=, >

30
Q

List two Function Library categories

A

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

31
Q

argument

A

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

32
Q

compare values

A

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

33
Q

comparison operator

A

a symbol that indicates the relationship between two values

34
Q

COUNT function

A

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

35
Q

COUNTA function

A

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

36
Q

horizontal lookup table

A

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

37
Q

logical function

A

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

38
Q

MAX function

A

a function that returns the maximum value in a range

39
Q

MIN function

A

a function that returns the minimum value in the range

40
Q

optional argument

A

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

41
Q

required argument

A

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

42
Q

significant digits

A

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

43
Q

vertical lookup table

A

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

43
Q

what-if analysis

A

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