Excel Functions test oct g10

Which function adds up all the numbers in a specified range?

• COUNT

• ADD

• SUM

• SUMIF

What does the COUNTA function do?

• Counts only text entries

• Counts empty cells

• Counts all non-empty cells

• Counts numerical values only

Which function is used to count the number of cells that meet a specific condition?

• COUNT

• COUNTIF

• SUMIF

• COUNTA

The formula =INT(4.7) will return:

• 5

• 4.5

• 4

• 0

What does the ROUND function do in Excel?

• Adds up numbers

• Rounds a number to a specified number of digits

• Counts the number of cells with numbers

• Finds the largest number

Which function checks a condition and returns one value if true, and another value if false?

• SUMIF

• COUNTIF

• IF

• COUNTA

What is the result of =ROUND(12.345, 1)?

• 12.3

• 12.34

• 12.4

• 13

The formula =SUMIF(A1:A10, ">5") will:

• Count the numbers greater than 5 in the range

• Add the numbers greater than 5 in the range

• Sum all numbers in the range

• Return 5 if there are numbers greater than 5

What is the purpose of the INT function?

• It calculates the sum of integers

• It rounds a number to the nearest whole number

• It returns the integer portion of a number

• It counts the integer values in a range

If cell A1 contains the value 10, what will =IF(A1>5, "Yes", "No") display?

• Yes

• No

• 10

• TRUE