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?
Similar Resources on Wayground
75 questions
Information Assurance & Security Practice Questions
Quiz
•
University
77 questions
CompTIA Security+ Certification Questions
Quiz
•
University
81 questions
TS410_2022 Practice Questions (2602112101) BINUS
Quiz
•
University
83 questions
Stepik2301 (1/3)
Quiz
•
University
81 questions
LTM ( Multicast, Exception, Thread )
Quiz
•
University
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
20 questions
Figurative Language Review
Quiz
•
6th Grade
Discover more resources for Information Technology (IT)
12 questions
IREAD Week 4 - Review
Quiz
•
3rd Grade - University
23 questions
Subject Verb Agreement
Quiz
•
9th Grade - University
7 questions
Force and Motion
Interactive video
•
4th Grade - University
7 questions
Renewable and Nonrenewable Resources
Interactive video
•
4th Grade - University
5 questions
Poetry Interpretation
Interactive video
•
4th Grade - University
19 questions
Black History Month Trivia
Quiz
•
6th Grade - Professio...
15 questions
Review1
Quiz
•
University
15 questions
Pre1
Quiz
•
University