
DA03 Advanced Formula
Authored by Muhammad Fachrizal
Computers
10th - 12th Grade
Used 1+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
9 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
20 sec • 10 pts
Used to summarize, sort, reorganize, group, count, total or average data stored in a table. It allows us to transform columns into rows and rows into columns.
Slicer
Conditional Formatting
Pivot Table
Data Validation
2.
MULTIPLE CHOICE QUESTION
20 sec • 10 pts
_______ provides buttons that you can click to filter tables or PivotTables. In addition to quick filtering, slicers also indicate the current filtering state, which makes it easy to understand what exactly is currently displayed.
Sort
Slicer
Text to Column
Conditional Formatting
3.
MULTIPLE CHOICE QUESTION
30 sec • 20 pts
How many total Quantity (Qty) for Branch A with Health & beauty category?
22
34
29
15
4.
MULTIPLE CHOICE QUESTION
20 sec • 10 pts
Error that comes up when Google Sheet found there is a division with 0
#DIV/0!
#REF!
#VALUE!
#N/A
5.
MULTIPLE CHOICE QUESTION
20 sec • 10 pts
John has 100,000 rows of data. What kind of feature he can use to make the line of each row easily read on his monitor?
Data Validation
Conditional Formatting
Pivot Table
Alternating Colors
6.
MULTIPLE CHOICE QUESTION
30 sec • 10 pts
Protect Sheet is useful for
Preventing other people / unauthorized account to make a change
Summarize the table only for the metric you want to see
Easily reading each row if we have too many data
Maintaining the data formatting and quality control
7.
MULTIPLE CHOICE QUESTION
20 sec • 5 pts
If John doesn't want to see any error on a cell, he can use ______ formula.
SUMIFS
IF
IFERROR
IFS
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
10 questions
DATA STRUCTURES
Quiz
•
12th Grade
10 questions
Treasure Hunt
Quiz
•
12th Grade
10 questions
Testas: Saugesnis internetas
Quiz
•
11th Grade
10 questions
Penilaian Harian-1, Pemrograman Berorientasi Objek (PBO)
Quiz
•
12th Grade
10 questions
Asesmen Diagnostik Informatika XI
Quiz
•
10th Grade
9 questions
11 сыныпқа арналған тест тапсырмалары
Quiz
•
11th Grade
10 questions
Initial Assessment - Cybersecurity Awareness
Quiz
•
9th Grade - Professio...
10 questions
Greetings
Quiz
•
1st Grade - University
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