DA03 Advanced Formula

Used to summarize, sort, reorganize, group, count, total or average data stored in a table. It allows us to transform columns into rows and rows into columns.

• Slicer

• Conditional Formatting

• Pivot Table

• Data Validation

_______ provides buttons that you can click to filter tables or PivotTables. In addition to quick filtering, slicers also indicate the current filtering state, which makes it easy to understand what exactly is currently displayed.

• Sort

• Slicer

• Text to Column

• Conditional Formatting

How many total Quantity (Qty) for Branch A with Health & beauty category?

• 22

• 34

• 29

• 15

Error that comes up when Google Sheet found there is a division with 0

• #DIV/0!

• #REF!

• #VALUE!

• #N/A

John has 100,000 rows of data. What kind of feature he can use to make the line of each row easily read on his monitor?

• Data Validation

• Conditional Formatting

• Pivot Table

• Alternating Colors

Protect Sheet is useful for

• Preventing other people / unauthorized account to make a change

• Summarize the table only for the metric you want to see

• Easily reading each row if we have too many data

• Maintaining the data formatting and quality control

If John doesn't want to see any error on a cell, he can use ______ formula.

• SUMIFS

• IF

• IFERROR

• IFS

IMPORTRANGE is used to

• Pulling the data from another spreadsheet to a sheet.

• Downloading data to your computer

• Importing data from Google Docs file.

• Summarizing the table to be presented in a deck

This VLOOKUP formula will generate an error message

• True - because it needs 3 or 4 arguments for this formula.

• False - The result can be found. 1 is the result.