What function would you use to find the average of a range of cells?

ICT Mid-semester Exam

Quiz
•
Computers
•
7th Grade
•
Hard
Mohammad Anwar
Used 1+ times
FREE Resource
64 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
=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.
Create a free account and access millions of resources
Similar Resources on Wayground
65 questions
All About ICT

Quiz
•
3rd Grade - University
65 questions
Review Materi PAS 1 TIK Gr6

Quiz
•
6th Grade - University
66 questions
Grade7 All

Quiz
•
7th Grade - University
60 questions
LATIHAN SOAL INFORMATIKA PSAT 2023/2024 INFORMATIKA KELAS 7

Quiz
•
7th Grade
60 questions
ข้อสอบปลายภาค 1/2566 วิชาคอมพิวเตอร์และสารสนเทศเพื่องานอาชีพ

Quiz
•
6th - 8th Grade
65 questions
ข้อสอบการใช้เทคโนโลยีดิจิทัล

Quiz
•
7th Grade
65 questions
วิชาโปรแกรมตารางคำนวณ

Quiz
•
7th Grade
61 questions
Msw1

Quiz
•
3rd Grade - University
Popular Resources on Wayground
25 questions
Equations of Circles

Quiz
•
10th - 11th Grade
30 questions
Week 5 Memory Builder 1 (Multiplication and Division Facts)

Quiz
•
9th Grade
33 questions
Unit 3 Summative - Summer School: Immune System

Quiz
•
10th Grade
10 questions
Writing and Identifying Ratios Practice

Quiz
•
5th - 6th Grade
36 questions
Prime and Composite Numbers

Quiz
•
5th Grade
14 questions
Exterior and Interior angles of Polygons

Quiz
•
8th Grade
37 questions
Camp Re-cap Week 1 (no regression)

Quiz
•
9th - 12th Grade
46 questions
Biology Semester 1 Review

Quiz
•
10th Grade