BSAB1C FQuiz2

What does the SUMIF function do in Excel?

• Counts non-empty cells based on a condition

• Sums cells based on a condition

• Finds the average of cells based on a condition

• Converts numbers to Roman numerals

Which function would you use to count cells that contain text or numbers?

• COUNT

• COUNTA

• COUNTBLANK

• ROMAN

What is the result of the formula =COUNT(A1:A5) if the range contains the values: 10, "Apple", 20, 30, and an empty cell?

• 5

• 4

• 3

• 2

Which function would you use to convert the text "excel" to "EXCEL"?

• LOWER

• PROPER

• UPPER

• COUNT

What does the COUNTIF function require as its main parameters?

• A range and a condition

• A range and a sum range

• A string and a format

• A number and a conversion type

If you want to convert the number 44 into a Roman numeral, which formula would you use?

• =ROMAN(44)

• =UPPER(44)

• =COUNT(44)

• =PROPER(44)

What is the output of =LOWER("HELLO WORLD")?

• Hello world

• hello world

• HELLO WORLD

• Hello World

Which function will return the number of blank cells in the range A1?

• COUNT

• COUNTA

• COUNTBLANK

• COUNTIF

What is the output of the function =PROPER("excel functions")?

• EXCEL FUNCTIONS

• excel functions

• Excel Functions

• Excel functions

What is the main purpose of conditional formatting in Excel?

• To sort data

• To filter data

• To visualize data and make worksheets easier to understand

• To calculate totals