Unit 3 Presentations Flashcards

1
Q

what do lookup functions do?

A

looks up data using a cross-referencing method

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

what is a lookup value?

A

the known variable, what you are looking up

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

what is the return value?

A

the answer you are looking for

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

what is the lookup table?

A

where you go to find the information

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

what are the arguments of a lookup function?

A

=VLOOKUP(Lookup_Value, Table_Array, Column_Index_Number, Range_Lookup)

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

what is the Lookup_Value?

A

cell address for the known variable

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

what is the Table_array

A

all cell addresses from lookup table, except headings, make them absolute

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

what is the Column_Index_Number?

A

Number that represents which column we need fro the lookup table

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

what is the Range_lookup?

A

optional
true- if an approximate match is ok
false- if an exact match is required

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

what are the function arguments?

A

=IF(Logial_Test, Value_if_True, Value_if_False)

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

what is the logical test?

A

the criteria you want to test

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

how many parts are in the logical test of the if function?

A

3
cell address, comparison symbol, value

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

what is an if function?

A

decides between two possible answers, bases the decision on the criteria provided

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

what is the logical test of an if function?

A

the criteria you want to test
=IF(B5>8

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

what is the value if true part of an if function?

A

the value that you want returned if the result if the result of logical_test is TRUE
=IF(B5>8, 10

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

what is the value if false part of an if function?

A

the value you want returned if the result of the logical_test is false
=IF(B5>8,10,5)

17
Q

what are the arguments of the SUMIF function?

A

=SUMIF(range, criteria, SumRange)

18
Q

what is the SUMIF function?

A

adds up numbers in a range based on a specific condition or rule

19
Q

what is the range in a SUMIF function?

A

range of cells you want evaluated by criteria

20
Q

what is the criteria of the SUMIF function?

A

the rule or condition that entries in the range need to meet to be added up

21
Q

what is the SumRange of the SUMIF function?

A

what to add up, use if you want Excel to add up different cells than the ones selected for the range
ex. if you were looking for a certain name in the first range, you will need to select a second range that contains numbers to have some to add

22
Q

The IF function has 3 function arguments: =IF(Logical Test, Value if True, Value if False) The Logical Test argument always has 3 parts… what are they?

A. Cell Address Comparison Symbol Value
B. Comparison Symbol Value True/False
C. Cell Address Dash Number
D. None of these are true. The logical test does not have 3 parts.

A

cell address comparison symbol value

23
Q

Which function will return the current date and time?

=NOW()

=DAYS()

=TODAY()

=TIME()

24
Q

When would it be appropriate to use the FALSE entry for the Range Lookup Argument in a VLOOKUP?

When you need an exact match.

When you need an approximate match (within a range)

Always, this is the only option for the Range Lookup argument.

Never, Range Lookup up is not entered as True/False

A

when you need an exact match

25
The _________________ function is used to calculate the number of cells in a range that contain an input (word or number). =COUNT# =COUNTA =COUNTIF =COUNT
=COUNTA
26
This tool allows users to limit what may be entered as an input in a range of cells. Entry Formatting Data Validation Verification Conditional Limitation
Data Validation
27
what are the steps to data validation?
1. select the cell(s) that you want to apply it too 2. go to data tab and select data validation button 3. change what you allow ex.list 4. click on source and got to where your list is 5. highlight the desired cells
28
how to put a note on a cell?
right click on cell wall and find note button
29
what is macro?
takes multiple steps into one
30
how do you do macro?
1) insert tab, insert a shape or icon 2) view tab, macro drop down button, select record macro 3) go through entire process that should be executed 4) select macro drop down again, stop recording 5) right click on icon and select assign macro then select the macro recorded from the list and hit okay
31
how do you do sheet protection?
review tab allow edit ranges, new protect sheet
32
what is the COUNT function?
only count cells with a number
33
what is the COUNTA function?
counts all cells that contain an input
34
what is the COUNTIF function?
counts number of cells that match a certain criteria