Team 1
0
Team 2
0
Teams
Name
Score
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
Loading
×
banana
Go to last place!
Oops!
×
fairy
Take points!
5
10
15
20
25
×
fairy
Take points!
5
10
15
20
25
×
lifesaver
Give 25 points!
Oops!
10
×
There are 4 advanced filtering tools, give at least two.
SEARCH, DATE, NUMBER, AND TEXT FILTERING
Oops!
Check
Okay!
Check
15
×
This command allows you to create groups and use common functions like SUM, COUNT, and AVERAGE to help summarize your data.
SUBTOTAL
Oops!
Check
Okay!
Check
10
×
There are 2 ways on how to add rows/columns to your table in your worksheet. Give at least one.
Enter new content or Click and drag the bottom - right corner.
Oops!
Check
Okay!
Check
20
×
Excel allows you to apply Filter on your data. Will it also allow you to remove or clear the applied filter? How?
YES, BY CLICKING THE DROP-DOWN ARROW ON THE FILTER YOU WANT TO CLEAR THEN CHOOSE CLEAR FILTER.
Oops!
Check
Okay!
Check
10
×
From the function =SUM(A1:A10), what part of the function inside the parenthesis?
ARGUMENT
Oops!
Check
Okay!
Check
15
×
What tab will you navigate to freeze either rows or columns of your worksheet?
VIEW TAB
Oops!
Check
Okay!
Check
10
×
In sorting your data in Excel, is it possible to sort it by more than one column?
YES, by adding a level (sorting level)
Oops!
Check
Okay!
Check
15
×
What tab will you click when you want to "insert a function"?
FORMULAS
Oops!
Check
Okay!
Check
10
×
What Excel's tab will give you an access to apply subtotal on your worksheet?
Data
Oops!
Check
Okay!
Check
10
×
It allows you to illustrate your workbook's data graphically which makes it easy to visualize comparisons.
CHART
Oops!
Check
Okay!
Check
25
×
How to apply conditional formatting rule on your worksheet?
SELECT THE CELLS, HOME TAB CLICK CONDITIONAL FORMATTING COMMAND THEN APPLY THE DESIRED RULES.
Oops!
Check
Okay!
Check
25
×
Sorting helps you reorganize the data of your worksheet. Give the 2 tabs where you will access to sort your data.
HOME and DATA
Oops!
Check
Okay!
Check
×
boom
Lose 50 points!
Oops!
×
fairy
Take points!
5
10
15
20
25
×
rocket
Go to first place!
Okay!
×
baam
Lose 15 points!
Oops!
×
monster
Reset all scores!
Oops!
×
seesaw
Swap points!
Okay!
×
rocket
Go to first place!
Okay!
×
banana
Go to last place!
Oops!
10
×
It is a predefined formula that performs calculations using specific values in a particular order.
FUNCTION
Oops!
Check
Okay!
Check
×
Restart
Review
Join for Free
;
Your experience on this site will be improved by allowing cookies.
Allow cookies
