Keep the stored value, summary rule and view distinct.
Review numeric display, percentages, PivotTable sums, freezing panes, specified chart geometry and worksheet protection.
Your count is the number of matching keys among six selected questions in this edition. It is not an Excel level, job threshold, certificate or percentile. Every answer, explanation and complete guide is available at every count.
Six different controls with different effects
This section deliberately mixes display and summary questions so that you must name what each command changes. Number formatting changes the view of a stored number under the stated precision setting; a PivotTable applies a chosen summary calculation; freezing panes changes the scrolling view. The chart task specifies vertical bars rather than asking for an objectively best chart. Worksheet protection concerns editing restrictions and must not be mistaken for encryption or permission to open a file.
Compare the displayed number with the stored value
In an unscored example, a cell stores 8.764 and Set precision as displayed is off. Formatting it to two decimal places shows 8.76, while a calculation still uses 8.764. That differs from changing the value with a rounding formula. State whether you need a rounded output, a display convention or a changed source value. Never enable a workbook-wide precision option casually to make a display match; practise these distinctions in a disposable file.
Read percentages from an existing numeric value
For an already stored number 0.046, percentage formatting with one decimal place displays 4.6%. The stored fraction and the displayed percentage represent the same quantity. The condition already stored matters: typing a new number into a cell preformatted as Percentage can follow different input behaviour. In a fresh sheet, enter a fraction first, note the formula bar and then change only the format. Explain the relationship before choosing a decimal place for presentation.
Inspect both the field and aggregation
Suppose fictional rows are Pine/3, Pine/8 and Oak/6. A PivotTable with the category in Rows and Sum of the numeric quantity in Values returns Pine=11 and Oak=6. Count returns the number of records instead, Pine=2 and Oak=1. Both are coherent summaries, but only one answers a request for total quantity. Confirm the selected aggregation, source types and refresh state when using a real PivotTable; a familiar layout alone does not establish a correct total.
Use the requested view and geometry
In the Windows general Freeze Panes command, selecting C3 freezes the rows above and columns to its left: rows one and two, columns A and B. This is distinct from the separate top-row command. For chart vocabulary, a column chart has vertical bars and a bar chart has horizontal bars. Geometry identifies the requested type here; actual communication also depends on clear category labels, units, scale and context, none of which a four-option question can fully evaluate.
Treat worksheet protection as an editing control
Unlock intended input cells before protecting a sheet whose formulas should resist casual editing. Then verify on a disposable example that the intended input remains editable and locked formula cells are restricted under the chosen settings. Microsoft explicitly distinguishes worksheet protection from a security feature. It does not automatically encrypt the file, control every reader’s access or prove the correctness of inputs. Keep confidentiality and file access decisions in their appropriate security mechanisms rather than relying on a protected sheet.
Use the guide without adopting an ability label
Every count unlocks the same complete explanations and all four revision guides. These six knowledge selections do not demonstrate that you can design a dashboard, audit a report or protect an organisation’s data. There is no beginner, advanced or expert assignment and no Microsoft certification. After reviewing a missed distinction, make a fresh invented example and describe what changed and what stayed stored. Improved performance on the identical bank may reflect recall rather than transferable workbook skill.