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
60 questions
GCSE J277 - Variables, Operators and Constructs Mega Quiz

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

Quiz
•
7th Grade
60 questions
Computer Hardware and Software Test

Quiz
•
6th - 8th Grade
63 questions
Chủ đề 1: CĂN BẢN VỀ CÔNG NGHỆ (GS6 LV2_ 2024)_1

Quiz
•
7th Grade
61 questions
untitled

Quiz
•
7th - 9th Grade
60 questions
UNIT 4 TEST OS, Hardware and Software Systems

Quiz
•
5th - 9th Grade
68 questions
7 сынып информатика

Quiz
•
7th Grade
66 questions
Hardware and Coding

Quiz
•
5th - 7th Grade
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