Unit 2 Review Flashcards
what are the three spreadsheet components?
input
intermediate
output
font, number, alignment, border and fill are considered _____.
block properties
the file extension for Excel documents is ______.
.xlsx
what is an active cell?
a cell that is clicked on and selected
using a function inside another function is called ____.
nesting
An _____ cell address is used when you need to lock in a specific cell address when quick copy and pasting a formula
absolute
how do you write an absolute cell address?
$A$6, short cut is F4
what this an example of?
=B4+C4
=B5+C5
=B6+C6
using a relative cell references
what does #DIV/0! mean?
cannot divide by 0
what does #### mean?
cell not wide enough to show entire number
what does #VALUE! mean?
includes or references text
what does #SPILL! mean?
unspecific
ex. =SUM(A2:B6)/(G4:G7)
what is the addition function?
SUM
what is the mean of a set of numbers function?
AVERAGE
what is the multiplication function?
PRODUCT
what is the subtraction function?
there is no function so use =B5-B4
what is the division function?
QUOTIENT
what is the disadvantage of the division function?
rounds the answer down to the whole number
what is the function to round the solution of a problem up, away from zero?
ROUNDUP
what is an example of the round up function?
=ROUNDUP(B2/B3,0)
what part of the function is this in the =ROUNDUP(B2/B2,0)?
B2/B2
number
what part of the function is this in the =ROUNDUP(B2/B2,0)?
,0
number of digits
what is the function to find the lowest number?
MIN
what is the function to find the largest number?
MAX
what is an example of a function?
=SUM(B2:B5)
=SUM(B2,B3,B4,B5)
what is an example of a formula?
=B2+B3+B4+B5
write a nested function for this data to add A1 to A2 and then multip;y with A3
7632
6453
9831
=PRODUCT(SUM(A1:A2),A3)
write a multi-step formula for this data
7632
6453
9831
=(A1+A2)A3
=SUM(A1,A2)A3
=PRODUCT(A1+A2,A3)