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?
