D388 Fundamentals of Spreadsheets and Data Presentations - Set 3 - Part 3

Correct Answer: The Rows area

Fields placed in the Rows area become the row labels running down the left side of the PivotTable. Fields in the Columns area spread across the top, the Values area holds the aggregated numbers, and the Filters area creates a report-level filter above the table. Rearranging fields among these areas reshapes the summary.

Correct Answer: Click Refresh, because PivotTables do not update automatically

Unlike ordinary formulas, a PivotTable caches its source data and does not automatically reflect edits to the source. After changing values in the source range, you must click Refresh (PivotTable Analyze tab or right-click menu) to recalculate. If rows were added outside the original range, you may also need to update the data source range.

Correct Answer: To provide clickable buttons that visually filter the PivotTable

A Slicer is a visual filtering tool that displays large buttons for each item in a field. Clicking a button filters the PivotTable (or PivotChart) to that selection, and the slicer clearly shows which filters are active. Slicers are more intuitive than the standard filter drop-downs and can control multiple PivotTables at once.

Correct Answer: Is linked to a PivotTable and updates interactively as the PivotTable is filtered or pivoted

A PivotChart is built on the same data cache as a PivotTable and stays synchronized with it. Filtering, expanding, or rearranging fields in the PivotTable (or via the PivotChart's own field buttons and slicers) instantly changes the chart. A standard chart, by contrast, plots a fixed range and offers no built-in aggregation or pivoting.

Correct Answer: Data Bars

Data Bars fill each cell with a horizontal bar whose length is proportional to the cell's value compared to the rest of the selected range, giving an in-cell bar-chart effect. Color Scales shade cells across a gradient, and Icon Sets place symbols like arrows or traffic lights. Sparklines are a separate mini-chart feature, not a conditional format.

Correct Answer: Highlight Cells Rules (Greater Than)

The Highlight Cells Rules submenu includes a Greater Than option where you enter a threshold (500) and choose a format. Excel then formats every qualifying cell. Color Scales, Data Bars, and Icon Sets visualize relative magnitude across the whole range rather than testing a single greater-than condition.

Correct Answer: The dollar sign before D locks the column so every cell in the row evaluates column D, while the row number stays relative

To format a whole row from a single column's value, you write a formula with a mixed reference such as =$D2="Closed". Anchoring the column with $ ensures every cell in the applied range checks column D, while leaving the row number relative lets the rule move down row by row so each row is evaluated against its own D cell.

Correct Answer: What data users are allowed to enter into a cell

Data Validation restricts the type or range of values that can be typed into a cell, such as whole numbers within a range, dates, a text length limit, or a value from a defined list. It can display input messages and error alerts to guide users, helping keep entered data consistent and reducing input mistakes.

Correct Answer: List

Selecting List in the Data Validation Allow box lets you specify the allowed entries, either typed directly (separated by commas) or referenced from a range of cells. Excel then adds a drop-down arrow to the cell so users select from those items only, preventing free-form and inconsistent entries.

Correct Answer: Stop prevents invalid entry, Warning lets the user choose to continue, and Information just notifies while still allowing the entry

The three alert styles differ in strictness. Stop rejects invalid data outright, forcing a retry or cancel. Warning displays a caution message but offers Yes/No to keep the entry. Information simply shows a note and allows the value to be entered after the user clicks OK. This lets designers choose how rigidly to enforce a rule.