Unit 2 Review Flashcards

1
Q

what are the three spreadsheet components?

A

input
intermediate
output

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

font, number, alignment, border and fill are considered _____.

A

block properties

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

the file extension for Excel documents is ______.

A

.xlsx

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

what is an active cell?

A

a cell that is clicked on and selected

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

using a function inside another function is called ____.

A

nesting

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

An _____ cell address is used when you need to lock in a specific cell address when quick copy and pasting a formula

A

absolute

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

how do you write an absolute cell address?

A

$A$6, short cut is F4

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

what this an example of?
=B4+C4
=B5+C5
=B6+C6

A

using a relative cell references

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

what does #DIV/0! mean?

A

cannot divide by 0

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

what does #### mean?

A

cell not wide enough to show entire number

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

what does #VALUE! mean?

A

includes or references text

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

what does #SPILL! mean?

A

unspecific
ex. =SUM(A2:B6)/(G4:G7)

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

what is the addition function?

A

SUM

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

what is the mean of a set of numbers function?

A

AVERAGE

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

what is the multiplication function?

A

PRODUCT

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

what is the subtraction function?

A

there is no function so use =B5-B4

17
Q

what is the division function?

18
Q

what is the disadvantage of the division function?

A

rounds the answer down to the whole number

19
Q

what is the function to round the solution of a problem up, away from zero?

20
Q

what is an example of the round up function?

A

=ROUNDUP(B2/B3,0)

21
Q

what part of the function is this in the =ROUNDUP(B2/B2,0)?
B2/B2

22
Q

what part of the function is this in the =ROUNDUP(B2/B2,0)?
,0

A

number of digits

23
Q

what is the function to find the lowest number?

24
Q

what is the function to find the largest number?

25
Q

what is an example of a function?

A

=SUM(B2:B5)
=SUM(B2,B3,B4,B5)

26
Q

what is an example of a formula?

A

=B2+B3+B4+B5

27
Q

write a nested function for this data to add A1 to A2 and then multip;y with A3
7632
6453
9831

A

=PRODUCT(SUM(A1:A2),A3)

28
Q

write a multi-step formula for this data
7632
6453
9831

A

=(A1+A2)A3
=SUM(A1,A2)
A3
=PRODUCT(A1+A2,A3)