Edit Game
Trust your Instinct
 Delete

Use commas to add multiple tags

 Private  Unlisted  Public



 Save

Delimiter between question and answer:

Tips:

  • No column headers.
  • Each line maps to a question.
  • If the delimiter is used in a question, the question should be surrounded by double quotes: "My, question","My, answer"
  • The first answer in the multiple choice question must be the correct answer.

 Import questions





 Save   15  Close
How to apply conditional formatting rule on your worksheet?
SELECT THE CELLS, HOME TAB CLICK CONDITIONAL FORMATTING COMMAND THEN APPLY THE DESIRED RULES.
It allows you to illustrate your workbook's data graphically which makes it easy to visualize comparisons.
CHART
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.
What Excel's tab will give you an access to apply subtotal on your worksheet?
Data
This command allows you to create groups and use common functions like SUM, COUNT, and AVERAGE to help summarize your data.
SUBTOTAL
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
There are 4 advanced filtering tools, give at least two.
SEARCH, DATE, NUMBER, AND TEXT FILTERING
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.
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.
In sorting your data in Excel, is it possible to sort it by more than one column?
YES, by adding a level (sorting level)
Sorting helps you reorganize the data of your worksheet. Give the 2 tabs where you will access to sort your data.
HOME and DATA
What tab will you navigate to freeze either rows or columns of your worksheet?
VIEW TAB
What tab will you click when you want to "insert a function"?
FORMULAS
From the function =SUM(A1:A10), what part of the function inside the parenthesis?
ARGUMENT
It is a predefined formula that performs calculations using specific values in a particular order.
FUNCTION
Your experience on this site will be improved by allowing cookies.