KAKU YAINI MS EXCEL QUIZ 2

Sum, average, count, and maximum value are examples of what?

Which symbol is used to start a formula?

• +

• =

• /

• -

Which of the following formulas show the correct use of the SUM function?

• =SUM(H3...H10)

• =SUM(H3,H10)

• =SUM(H3;H10)

• =SUM(H3:H10)

Luna is calculating the total cost of her groceries. If she types =2*(6-4) in her spreadsheet, what will be the display value?

• 2

• 4

• 6

• 8

Avery is trying to calculate the total score of her assignments using a formula. What is the Sum formula?

• =Sum+( )

• =(Sum... )

• =(Sum)

• =Sum( )

Emma is trying to calculate the total score of her recent tests. She wants to find the function that lets her add up a range of cells or values.

• average

• sum

• count

• counta

The function COUNTA is used for counting cells that contain

• numbers and logical values only

• text, numbers, logical values and error values only

• 
  text, numbers and logical values only

• text, numbers, logical values, error values, and empty text (" ")

The function COUNT is specific for counting _________________

• texts

• cells

• numbers

• tables

The ______________ function is used to determine how many pupils were able to get a passing score in a test.

• countif

• count

• counta

• countblank

Emma is trying to calculate the difference between her scores in two subjects using Microsoft Excel. Which formula should she use to get the difference of selected cells?

• 
  =B2-B2

• 
  =B2-C2

• 
  -(B2:B2)

• -(B2-B2)