G1- L1 - Q1

What is the primary purpose of Excel?

• To create presentations and animations.

• To store, analyze, and visualize data effectively.

• To design websites and applications.

• To write code for software development.

You have a dataset with 1,000 rows. What is the quickest way to highlight all rows where the sales value is greater than $10,000?

• Use the MAX function to find the highest value.

• Apply a Filter to only show rows with values > $10,000.

• Use Conditional Formatting with a custom rule.

• Create a PivotTable and filter the data manually.

Which of the following statements about PivotTables is TRUE?

• PivotTables can be used to directly edit the original dataset.

• PivotTables require all data to be formatted as text.

• PivotTables summarize large datasets into dynamic, interactive tables.

• PivotTables automatically update when the source data changes.

How can you create a dynamic chart that updates automatically when new data is added?

• Use a predefined chart template in Excel.

• Manually update the chart range every time data changes.

• Use a named range or Excel Table as the data source.

• Apply Conditional Formatting to the data range.

Which of the following functions would you combine to dynamically calculate the total revenue of all sales greater than $500 in a dataset?

• SUM and IF

• SUMIF

• SUM and COUNTIF

• SUMPRODUCT