You have a dataset with customer reviews, and you want to calculate the average rating and the total number of reviews for each product. How would you use Excel functions to aggregate and summarize this data?

Spreadsheets - Aggregations

Aggregation functions

How do array formulas differ from regular formulas in Excel?

Spreadsheets - Array formulas

Array formulas

How is relative referencing different from absolute referencing?

Spreadsheets - Cell referencing

Cell referencing

What is a conditional aggregation in Excel, and why is it useful?

Spreadsheets - Conditional aggregation

Conditional Aggregations

You want to visually highlight all cells in a column where the profit is negative. How would you achieve this in Excel?

Spreadsheets - Conditional formatting

Conditional formatting

What is a PivotTable in Excel, and how is it created?

Spreadsheets - PivotTable

Pivot Tables

How does the DATE function differ from the TEXT function for dates?

Spreadsheets - DATE vs TEXT

Excel Date & Time Functions

How does a line chart differ from a bar chart in Excel?

Spreadsheets - Line chart vs Bar chart

Data Visualisation in Excel

What is error handling in Excel, and why is it important?

Spreadsheets - Error Handling

Error handling using IFERROR & IFNA

How is the Find function different from the Search function?

Spreadsheets - Find vs Search

Search and replace

What are missing values in Excel, and how can they be handled?

Spreadsheets - Missing values

Handling missing values - Excel

How does Index and Match differ from VLOOKUP?

Spreadsheets - Lookup functions

LOOKUP Functions

In a dataset, you have product names in one column and their corresponding prices in another. How would you use the INDEX and MATCH functions in Excel to look up the price for a specific product?

Spreadsheets - INDEX/MATCH

INDEX and MATCH

What are macros in Excel, and how are they used?

Spreadsheets - Macros

Macros (Excel)

You have a list of customer names, and you want to ensure that there are no duplicate entries. How would you remove duplicates in Excel?

Spreadsheets - Removing duplicates

Removing duplicates from data (Excel)

How does a report differ from a dashboard in Excel?

Spreadsheets - Report vs Dashboard

Reporting and Dashboarding

What are slicers, and how are they used for filtering information in Excel?

Spreadsheets - Slicers

Using slicers to filter information

How does VLOOKUP differ from HLOOKUP in Excel?

Spreadsheets - VLOOKUP vs HLOOKUP

What is WHATIF analysis in Excel, and how is it used?

Spreadsheets - WHATIF Analysis

WHATIF analysis

What is the XLOOKUP function in Excel, and how is it different?

Spreadsheets - XLOOKUP

Open Course

Tryouts | Practice for your next Tech Interview

Enhance your spreadsheet prowess with Newton School's dynamic Tryouts. Dive into subjective audio assignments designed to sharpen your spreadsheet skills effectively. Get interview-ready with real-time questions and automated assessments, empowering you to excel in spreadsheet-related roles.

Explore Newton School

Tryouts

Most Solved Questions