Trust your Instinct | Baamboozle - Baamboozle | The Most Fun Classroom Games!

0%

0 0 0

In sorting your data in Excel, is it possible to sort it by more than one column?

YES, by adding a level (sorting level)

There are 4 advanced filtering tools, give at least two.

SEARCH, DATE, NUMBER, AND TEXT FILTERING

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

It allows you to illustrate your workbook's data graphically which makes it easy to visualize comparisons.

CHART

This command allows you to create groups and use common functions like SUM, COUNT, and AVERAGE to help summarize your data.

SUBTOTAL

It is a predefined formula that performs calculations using specific values in a particular order.

FUNCTION

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

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 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.

How to apply conditional formatting rule on your worksheet?

SELECT THE CELLS, HOME TAB CLICK CONDITIONAL FORMATTING COMMAND THEN APPLY THE DESIRED RULES.

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.

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

From the function =SUM(A1:A10), what part of the function inside the parenthesis?

ARGUMENT