BSAB1C FQuiz2
Authored by Louella Gonzales
Information Technology (IT)
University
Used 1+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
24 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
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
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which function would you use to count cells that contain text or numbers?
COUNT
COUNTA
COUNTBLANK
ROMAN
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
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
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which function would you use to convert the text "excel" to "EXCEL"?
LOWER
PROPER
UPPER
COUNT
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
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
6.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
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)
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
What is the output of =LOWER("HELLO WORLD")?
Hello world
hello world
HELLO WORLD
Hello World
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
Already have an account?
