BCIS - MS EXCEL (CH. 6)

Which function can be used to computer the total of values in a cell range?

• Average

• Add

• Sum

• Total

Which function can be used to find the smallest value in a range of cells?

• MAX

• MIN

• MINIMUM

• MAXIMUM

Which function can be used to find the largest value in a range of cells?

• MAX

• MAXIMUM

• MIN

• MINIMUM

Which function can be used to control the number of decimal places the value has?

• DECI

• FRACT

• PLACES

• ROUND

Which function can be used to determine the number of non-empty cells in a range?

• COUNT

• NUMBER

• CELLS

• VALUES

What function can be used to randomly provide a value?

• Random

• Generate

• Value

• Rand

What function can be used to determine payments in an installment loan?

• PYT

• PMT

• PAY

• INSTALL

Which function is used to determine an action based on a condition?

• IF

• COND

• PMT

• AVERAGE

What does the error code #### mean?

• Wrong data value

• Numbers needed

• Column width not wide enough for value

• Placeholders

What does the error code #DIV/0 mean?

• The formula is trying to divide by zero

• Number division or 0

• Value is not divisible