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
15
×
What tab will you navigate to freeze either rows or columns of your worksheet?
VIEW TAB
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
×
It allows you to illustrate your workbook's data graphically which makes it easy to visualize comparisons.
CHART
Oops!
Check
Okay!
Check
×
monster
Reset all scores!
Oops!
×
rocket
Go to first place!
Okay!
×
shark
Other team loses 15 points!
Okay!
×
banana
Go to last place!
Oops!
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
15
×
What tab will you click when you want to "insert a function"?
FORMULAS
Oops!
Check
Okay!
Check
×
seesaw
Swap points!
Oops!
×
magnet
Take 25 points!
Okay!
×
rocket
Go to first place!
Okay!
×
thief
Give points!
5
10
15
20
25
15
×
When grouping rows or columns on your worksheet, will it allow you to hide those sections? How?
YES, CLICK THE MINUS SIGN/HIDE DETAIL BUTTON
Oops!
Check
Okay!
Check
×
banana
Go to last place!
Oops!
×
gold
Win 50 points!
Okay!
×
fairy
Take points!
5
10
15
20
25
×
thief
Give points!
5
10
15
20
25
10
×
What Excel's tab will give you an access to apply subtotal on your worksheet?
Data
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
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
10
×
It is a predefined formula that performs calculations using specific values in a particular order.
FUNCTION
Oops!
Check
Okay!
Check
10
×
From the function =SUM(A1:A10), what part of the function inside the parenthesis?
ARGUMENT
Oops!
Check
Okay!
Check
10
×
There are 4 advanced filtering tools, give at least two.
SEARCH, DATE, NUMBER, AND TEXT FILTERING
Oops!
Check
Okay!
Check
25
×
What is the difference of Filtering data to Sorting data?
FILTERING NARROWS DOWN YOUR DATA ALLOWING YOU TO VIEW ONLY THE INFO. YOU NEED WHILE SORTING REORGANIZES YOUR DATA.
Oops!
Check
Okay!
Check
×
Restart
Review
Join for Free
;
Your experience on this site will be improved by allowing cookies.
Allow cookies
