Excel & Spreadsheet Analytics — Section Test

Question 11 point

Which concept is most appropriate for this situation: You need to apply the idea taught in “Workbook Worksheet and Table Anatomy” and explain how its input is transformed into a valid output.

Spreadsheet Mini Project Sales Performance WorkbookWorkbook Worksheet and Table AnatomyDate and Time Analysis in ExcelText Cleaning with Trim Clean Textsplit and Substitute

Question 21 point

Which concept is most appropriate for this situation: Your program must choose different actions depending on whether a logical condition is true.

Pivottables for Grouped AnalysisSpreadsheet Mini Project Sales Performance WorkbookConditional Aggregation with SUMIFS COUNTIFS and AVERAGEIFSSpreadsheet Error Handling and Auditing

Question 31 point

Which concept is most appropriate for this situation: You need to represent, inspect or transform textual values rather than numeric quantities.

Lookup Analysis with XLOOKUPExcel Tables and Structured ReferencesPivottables for Grouped AnalysisText Cleaning with Trim Clean Textsplit and Substitute

Question 41 point

Which concept is most appropriate for this situation: You need to reshape or summarise long records into a matrix-like report by categories.

Pivottables for Grouped AnalysisCharts in Excel Choose Label and AuditLookup Analysis with XLOOKUPWorkbook Worksheet and Table Anatomy

Question 51 point

Which concept is most appropriate for this situation: You need to apply the idea taught in “Spreadsheet Mini Project Sales Performance Workbook” and explain how its input is transformed into a valid output.

Spreadsheet Mini Project Sales Performance WorkbookPivottables for Grouped AnalysisINDEX and MATCH for Flexible LookupsCharts in Excel Choose Label and Audit