COMP1 Midterm Examination
Authored by Jonalyn Angeles
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
80 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
What symbol is used for inputting a formula in MS-Excel?
+ (plus sign)
= (equal sign)
– (dash sign)
; (semicolon)
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
What is the MS Excel 2019 formula that you want to get the sum of the numbers in the given range using cell reference for example from B1 to G10?
=SUM(B1:G10)
=SUM(B1G10)
=SUM(B1:G10)
=SUM(B1-G10)
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Using the data above, what is the correct formula to display the AVERAGE of Student 1234?
=AVE(B2:E4)
=AVERAGE(B2:E2)
=SUM(B2:E4)
=SUM(B2:B4)
4.
MULTIPLE CHOICE QUESTION
3 mins • 1 pt
What is the result if the given formula for F4 is =AVERAGE(B4:E4)?
A. 70
B. 80
C. 90
D. 95
5.
MULTIPLE CHOICE QUESTION
3 mins • 1 pt
Using the formula =AVERAGE(B2:E2), What is the result in cell F2?
A. 74.75
B. 75.00
C. 75.50
D. 75.75
6.
MULTIPLE CHOICE QUESTION
3 mins • 1 pt
Using the formula =AVERAGE(B3:E3), What is the result?
A. 85.00
B. 86.00
C. 88.25
D. 90.00
7.
MULTIPLE CHOICE QUESTION
3 mins • 1 pt
What will be the value of F1 using this formula =(A1-B1)*C1?
281
283
284
285
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 Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
