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