Editing Content :: Admin Scraper

Chapter

Content type

Position

Value

Spreadsheet Advantages of Pivot Table (Report) A PivotTable report is an interactive way to quickly summarise large amounts of data. Use a PivotTable report to analyse numerical data in depth and to answer unanticipated questions about data. A PivotTable report designed for: E Querying large amounts of data in user-friendly ways. Sub totaling and aggregating numeric data, summarising data by categories and subcategories, and creating custom calculations and formulas. E Expanding and collapsing levels of data to focus on results, and providing from details to the summary of data for areas of interest. E Moving rows to column or columns to rows (or “pivoting”) to see different summaries of the source data. E Filtering, sorting, grouping, and conditionally formatting the most useful and the interesting subset of data to enable us to focus on the information that we want. E Presenting concise, attractive, and annotated online or printed reports. E The use of a PivotTable report is to analyse related totals, when we have a long list of figures to sum and to compare several facts about each figure. 2.6. COMMON ERRORS (MESSAGES) IN SPREADSHEET 4.1.1 M ARK COMMON FORMULA ERRORS 1. Click the Microsoft Office Button, click Excel Options, and then click the Formulas category. 2. In the Error Checking section, select the Enable background error checking check box. 3. To change the colour of the triangle that marks where an error occurs, in the Indicate errors using the colour box, select a new colour. 4. Select a cell with a triangle in the top-left corner of a cell. 5. Next to the cell, click the Error Checking button that appears, and then click the option that we want. The commands are different for each type of error, and the first entry describes the error. If we click Ignore Error, the error is marked to be ignored for each consecutive check. Figure 2.59 6. Repeat the two previous steps. • Correct an error value If a formula cannot properly evaluate a result, e Excel will display an error 73 value. Each error type has different causes, and different solutions. Some are discussed here to understand them properly before redo the operation Reprint 2026-27