
Bengkel Google Spreadsheet
Authored by PPD LIMBANG-CM30 KPM
Computers
12th Grade
Used 2+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
45 sec • 2 pts
What color should be used to highlight absent students in the attendance checklist?
Green
Red
Blue
Yellow
2.
MULTIPLE CHOICE QUESTION
45 sec • 2 pts
Which formula is used to calculate the total number of absences for each student?
=SUMIF()
=VLOOKUP()
=COUNTIF()
=AVERAGE()
3.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
What should be added to the bottom of the attendance data to calculate total class absences?
A new column
A new chart
A new row
A new sheet
4.
MULTIPLE CHOICE QUESTION
1 min • 3 pts
What is the function of $ sign in Spreadsheet?
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
What formula calculates the average number of absences per student?
=COUNTIF()
=AVERAGE()
=SUM()
=VLOOKUP()
6.
MULTIPLE CHOICE QUESTION
1 min • 3 pts
What is the purpose of the Data Validation feature in the attendance checklist?
To calculate totals
To create dropdown
To create charts
To format cells
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
In the invoice sheet, which function is used to retrieve the unit price of an item?
AVERAGE
COUNTIF
VLOOKUP
SUMIF
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
15 questions
Virtual Private Server
Quiz
•
12th Grade
10 questions
Python with DataScience
Quiz
•
7th Grade - University
17 questions
Security and Ethics
Quiz
•
9th - 12th Grade
10 questions
IT Quiz
Quiz
•
11th - 12th Grade
20 questions
Design your website
Quiz
•
7th - 12th Grade
13 questions
INTERNET CONNECTION
Quiz
•
12th Grade
11 questions
Unit 2, 1.3 Types of information access and storage devices
Quiz
•
12th Grade
15 questions
Problem Solving : Design Solution
Quiz
•
12th Grade
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
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade