ICT Mid-semester Exam
Authored by Mohammad Anwar
Computers
7th Grade
Used 1+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
64 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function would you use to find the average of a range of cells?
=SUM()
=AVERAGE()
=COUNT()
=MAX()
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following formats can you apply to a cell in Excel?
Currency
Percentage
Date
All of the above
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the correct formula to calculate the total price if the unit price is in cell A1 and the quantity is in cell B1?
=A1 + B1
=A1 * B1
=A1 - B1
=A1 / B1
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which chart type would be best for showing the relationship between two variables?
Pie Chart
Line Chart
Bar Chart
Scatter Plot
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
To apply a filter on your data in Excel, you would go to which tab?
Home
Data
Insert
View
6.
OPEN ENDED QUESTION
3 mins • 1 pt
The formula to calculate the percentage increase is _________.
Evaluate responses using AI:
OFF
7.
FILL IN THE BLANK QUESTION
30 sec • 1 pt
To create a new worksheet in Excel, you click on the _________ icon.
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
60 questions
الصف الاول الاعدادي الترم الثاني الدرس الخامس
Quiz
•
7th Grade
62 questions
Adobe Photoshop - basico, medio e avançado
Quiz
•
1st Grade - University
60 questions
Doors
Quiz
•
1st Grade - Professio...
62 questions
ÔN TẬP Giữa Kỳ Môn Tin Học 8
Quiz
•
7th Grade - University
66 questions
ÔN SỬ 7_Bài 6_DNA_phong kiến
Quiz
•
7th Grade
60 questions
Soal Latihan PH
Quiz
•
7th Grade
61 questions
ICDL Module 1 - Computer & Online Essentials QRG 1
Quiz
•
7th Grade
60 questions
Quiz 2 Latihan Soal UAS Manajemen Keamanan Sistem Informasi
Quiz
•
1st Grade - 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
29 questions
Alg. 1 Section 5.1 Coordinate Plane
Quiz
•
9th Grade
22 questions
fractions
Quiz
•
3rd Grade
11 questions
FOREST Effective communication
Lesson
•
KG
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
