Advanced Excel and Google Sheets Questions

Covers advanced spreadsheet skills used for data analysis, reporting, and ad hoc business intelligence work in both Microsoft Excel and Google Sheets. Core capabilities include lookup and reference functions such as VLOOKUP and INDEX MATCH, aggregation and conditional functions such as SUMIF and AVERAGEIF, logical functions such as IF, array formulas, and nested formulas. Candidates should be comfortable building and manipulating pivot tables to summarize data, using conditional formatting and data validation to ensure data quality, and structuring worksheets with named ranges and proper use of absolute versus relative cell references. The topic also includes creating dynamic formulas and simple dashboards for visualization, charting best practices, data cleaning techniques, and performance considerations for large worksheets. At an advanced level, familiarity with automation and workflow improvements such as macros or scripts, query and transform capabilities, and how spreadsheets integrate or compare with business intelligence tools is expected.