
Mastering Spreadsheet Functions Quiz

Quiz
•
Information Technology (IT)
•
9th Grade
•
Medium
S Uwadiae
Used 1+ times
FREE Resource
17 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
11
16
13
10
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function would you use to find the average of a range of cells in a spreadsheet?
SUM
AVERAGE
MEDIAN
MODE
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How would you apply conditional formatting to highlight cells greater than 100 in a spreadsheet?
Use the conditional formatting rule "Cell Value > 100"
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of the SUM function in spreadsheets?
To find the average of numbers
To add up a range of numbers
To count the number of cells
To find the maximum value
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is a basic formula to subtract 10 from 25 in a spreadsheet?
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Finds the minimum value in the range A1 to A10
Finds the maximum value in the range A1 to A10
Adds all the values in the range A1 to A10
Counts the number of cells in the range A1 to A10
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you format a cell to display numbers as currency in a spreadsheet?
Apply the currency format from the formatting menu
Type the currency symbol manually
Create a free account and access millions of resources
Similar Resources on Wayground
15 questions
Pre Test SUMIF, COUNTIF, IF

Quiz
•
9th Grade
15 questions
S3 Admin and IT Spreadsheets

Quiz
•
9th Grade
20 questions
KELAS 7 BAB 6 ANALISIS DATA C. Pengolahan Data Dasar

Quiz
•
7th Grade - University
15 questions
Spreadsheets Knowledge Check

Quiz
•
9th - 12th Grade
22 questions
MS Excel

Quiz
•
4th Grade - University
15 questions
Table,Image formatting

Quiz
•
5th Grade - University
20 questions
Mastering the SUMIF Function

Quiz
•
9th Grade
20 questions
BAB 6 ANALISIS DATA B. Perkakas Pengolah Lembar Kerja

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