Vocabulary for Microsoft Excel means understanding the words behind worksheets, formulas, tables, PivotTables and errors. The seven essentials are cell, range, relative reference, absolute reference, formula, function and PivotTable. Start with these before learning specialised tools.
The most important distinction is value versus formula. A cell can display 250, but it might contain the number 250 or a formula such as =B2*C2. Changing referenced cells can change a formula’s result. Another crucial difference is relative reference versus absolute reference: A2 can adjust when copied; $A$2 stays anchored. Excel’s official formula guide documents these rules.
Quick answer: Use =SUM(B2:B10) to add a range, =AVERAGE(B2:B10) for a mean and =IF(C2>=70,"Pass","Review") for a conditional result. Make a clean Excel table for records. Use filters to view subsets without deleting other rows, and a PivotTable to summarise groups. Check source data, formula errors and supported Excel versions before drawing conclusions.
- Understanding a grid: identify workbook, worksheet, cell, row, column and range.
- Writing formulas: separate operators, functions, arguments and references.
- Analysing records: use structured tables, filters and PivotTables.
- Exploring patterns: select an appropriate chart and read its axes.
- Fixing errors: distinguish #N/A, #REF!, #VALUE!, #DIV/0! and #SPILL!.
- Protecting important work: audit formulas and maintain a recoverable version.
This is a practical glossary for people working with spreadsheet language in offices, businesses and everyday life. It is not an Excel file or a paid training course. For the wider understanding of words in context, visit eduKateSG Vocabulary Articles & Knowledge.
How to read a spreadsheet in one minute
Imagine a worksheet showing item names in column A, quantities in column B and unit prices in column C. Column D contains a line-total formula: =B2*C2. When you copy the formula down to row 3, its relative references usually become =B3*C3. This is deliberate: each row uses its own quantity and price.
Now imagine every line also needs the same tax rate stored in cell F1. The formula can use $F$1 as an absolute reference, keeping the rate cell fixed as it is copied. Without that distinction, a copied calculation might silently use the wrong cell.
A clean spreadsheet should also make clear what one row means. If each row is an order, then order date, item, status and amount are fields. Such data can be filtered or summarised. Mixing notes, headings and multiple unrelated tables in the same records makes later analysis harder.
Excel workbook, cells and reference vocabulary
These 34 terms belong to one spreadsheet task. Each meaning comes with an example you can test or recognise in Excel.
Excel workbook
The complete spreadsheet file containing one or more worksheets and their related data. In use: “Save the workbook before closing Excel.”
Worksheet
One tabbed grid inside a workbook. In use: “Put the monthly sales on a separate worksheet.”
Sheet tab
The label used to select and organise worksheets. In use: “Rename the sheet tab to October.”
Cell
An individual intersection of a row and column. In use: “Enter the price in cell B2.”
Active cell
The currently selected cell that receives input or editing. In use: “Check the active cell before typing the formula.”
Row
A horizontal sequence of cells identified by numbers in A1 reference style. In use: “Each row represents one order.”
Column
A vertical sequence of cells identified by letters in A1 reference style. In use: “Column C contains delivery dates.”
Cell address
A coordinate such as B2 naming a cell in a worksheet. In use: “B2 is the cell address for the unit price.”
Cell reference
A formula expression pointing to another cell’s value or location. In use: “Use a cell reference rather than repeating the price as a constant.”
Range
A group of cells identified by its boundary addresses, such as A2:A20. In use: “Sum the values in range A2:A20.”
Contiguous range
An uninterrupted rectangular selection of cells. In use: “Select a contiguous range for the new table.”
Noncontiguous range
Several selections of cells that do not form one continuous rectangle. In use: “The selected areas form a noncontiguous range.”
Relative reference
A reference such as A2 that typically changes when the formula is copied to another position. In use: “Copying =A2 down a row can change the reference to A3.”
Absolute reference
A reference such as $A$2 whose row and column stay fixed when copied. In use: “Use $F$1 for the same tax-rate cell in every row.”
Mixed reference
A reference that locks either the row or column but not both, such as $A2 or A$2. In use: “Use A$1 when the header row must stay fixed.”
Formula bar
The editing area displaying a selected cell’s formula or content. In use: “Read the full formula in the formula bar.”
Name box
An interface field that displays or selects cell addresses and defined names. In use: “Type A100 into the Name box to jump to that cell.”
Named range
A meaningful name assigned to a cell or range for formula use. In use: “Use TaxRate instead of a hard-to-read absolute address.”
Cell format
The presentation applied to a value, such as currency, date or percentage. In use: “Formatting a number as a percentage does not change the underlying fraction.”
Number format
Rules controlling how a numeric value is displayed. In use: “Use currency number format for the invoice total.”
Text value
Characters treated as text, even when they resemble a number. In use: “A product code with leading zeros should often remain text.”
Numeric value
A quantity Excel can use directly in numerical operations under suitable conditions. In use: “The sales total is stored as a numeric value.”
Date serial
Excel’s internal numeric representation of many dates, subject to workbook date-system settings. In use: “A date can appear as a number when its cell format changes.”
Time value
A fraction of a day or time-related serial under Excel’s date-time system. In use: “Half a day is stored as 0.5 in common time calculations.”
Blank cell
A cell with no entered content, which differs from a formula returning an empty-looking string. In use: “Check whether the cell is truly blank.”
Hidden row
A row temporarily not displayed because it was hidden manually or by another feature. In use: “A hidden row still exists in the dataset.”
Hidden column
A column not currently shown but still present in the worksheet. In use: “Unhide the cost column before reviewing calculations.”
Freeze Panes
A feature keeping selected rows or columns visible while scrolling. In use: “Freeze Panes so the header stays in view.”
Split panes
A feature dividing the worksheet window into separately scrollable areas. In use: “Split panes to compare distant portions of the sheet.”
Fill handle
A drag control used to copy patterns, values or formulas into nearby cells. In use: “Use the fill handle to extend the monthly sequence.”
AutoFill
A feature extending data patterns or copied formulas into cells. In use: “AutoFill the formula down the expense column.”
Flash Fill
A feature identifying examples of text patterns and generating corresponding entries where available. In use: “Flash Fill can extract first names, but check unusual cases.”
Data validation
Rules limiting or guiding what may be entered into selected cells. In use: “Use data validation to restrict status to approved categories.”
Drop-down list
A set of selectable values offered in a cell under appropriate settings. In use: “Choose Pending or Complete from the drop-down list.”
Excel formulas and functions
These 39 terms belong to one spreadsheet task. Each meaning comes with an example you can test or recognise in Excel.
Formula
An expression beginning with an equals sign that calculates or retrieves a result. In use: “Enter =B2*C2 to calculate a line total.”
Function
A built-in operation used within formulas, such as SUM or IF. In use: “The SUM function adds numbers.”
Argument
An input passed to a function inside its parentheses. In use: “The range B2:B10 is an argument to SUM.”
Operator
A symbol describing an action such as addition, comparison or multiplication. In use: “The * operator multiplies two values.”
Constant
A directly entered value such as 10 or a quoted word, not a cell reference. In use: “Replace a changing tax constant with a referenced cell.”
SUM
A function adding numeric values in supplied arguments. In use: “=SUM(B2:B10) totals the nine cells.”
AVERAGE
A function calculating the arithmetic mean of eligible numeric values. In use: “=AVERAGE(C2:C8) gives the average score.”
COUNT
A function counting cells containing numbers in the specified inputs. In use: “COUNT does not count every nonempty text cell.”
COUNTA
A function counting nonempty cells under its rules. In use: “Use COUNTA to estimate how many entries exist.”
COUNTIF
A function counting cells meeting one criterion. In use: “=COUNTIF(B2:B20,"Paid") counts the matching text entries.”
COUNTIFS
A function counting entries satisfying multiple corresponding criteria. In use: “Use COUNTIFS when both status and region must match.”
SUMIF
A function adding values for entries satisfying one criterion. In use: “SUMIF can total sales for one product.”
SUMIFS
A function adding values for entries meeting several criteria. In use: “SUMIFS can total paid invoices from one month.”
IF
A function returning alternative results based on a logical test. In use: “=IF(B2>=70,"Pass","Review") tests a score.”
IFS
A function checking multiple conditions in sequence where supported. In use: “IFS can assign grade categories using several tests.”
AND
A logical function returning TRUE only when all supplied conditions are true. In use: “Combine AND with IF to enforce two thresholds.”
OR
A logical function returning TRUE when at least one specified condition is true. In use: “OR can recognise two accepted status labels.”
NOT
A logical function reversing a TRUE or FALSE result. In use: “NOT can exclude a stated condition.”
IFERROR
A function supplying an alternative when an expression evaluates to an error. In use: “Use IFERROR carefully so errors are not silently concealed.”
VLOOKUP
A lookup function that searches the first column of a supplied table range and returns a value from a designated column. In use: “VLOOKUP has limitations when the return field is left of the lookup column.”
XLOOKUP
A lookup function designed to find a match in a lookup array and return a corresponding value from a return array. In use: “XLOOKUP searches for an item code and returns its description.”
INDEX
A function retrieving a value or reference by position within a supplied range or array. In use: “INDEX can return an item from the fifth row.”
MATCH
A function finding the relative position of a value within a lookup array. In use: “MATCH can locate a product’s position.”
FILTER
A dynamic-array function returning values satisfying included conditions in supported Excel versions. In use: “FILTER can display orders whose status is Open.”
SORT
A dynamic-array function sorting an array into an output range in supported versions. In use: “SORT can arrange names without reordering the source.”
UNIQUE
A dynamic-array function returning distinct values from an array in supported versions. In use: “UNIQUE can list the product categories.”
TEXT
A function converting a value to text with a specified numeric format. In use: “TEXT can display a date in a chosen wording.”
TEXTJOIN
A function combining text values with a chosen delimiter under applicable settings. In use: “TEXTJOIN can assemble labels without manual typing.”
LEFT
A function taking a specified number of characters from the beginning of text. In use: “LEFT can extract the prefix of a reference code.”
RIGHT
A function taking characters from the end of text. In use: “RIGHT can read a fixed-length suffix.”
MID
A function extracting characters from a given starting position inside text. In use: “MID can extract a segment of a coded string.”
TRIM
A function removing certain extra spaces from text, with limitations for some nonbreaking spaces. In use: “TRIM helps tidy data imported from forms.”
ROUND
A function rounding a numeric value to a selected number of digits. In use: “Use ROUND for a displayed figure, but keep raw data for analysis.”
TODAY
A function returning the current date according to the calculation environment. In use: “TODAY can help calculate due dates.”
NOW
A function returning the current date and time according to the calculation environment. In use: “NOW is volatile and may update on recalculation.”
Formula syntax
The required order and punctuation used by functions and operators. In use: “A missing parenthesis causes a formula-syntax error.”
Nested formula
A function or calculation placed inside another function. In use: “An IF formula may contain SUMIFS as an argument.”
Recalculation
The process of updating formula results when inputs or calculation conditions change. In use: “Check calculation settings if the totals are stale.”
Circular reference
A formula depending on itself directly or through other formulas, potentially producing calculation problems. In use: “An accidental circular reference can stop normal totals.”
Tables, PivotTables, charts and analysis terms
These 40 terms belong to one spreadsheet task. Each meaning comes with an example you can test or recognise in Excel.
Excel table
A structured range with headers and built-in features for sorting, filtering and references. In use: “Convert the sales dataset to an Excel table.”
Header row
The row identifying what each column represents. In use: “Give every header a clear unique field name.”
Record
One observation or item represented by a row in a well-structured dataset. In use: “Each record corresponds to one invoice.”
Field
An attribute of records represented by a column. In use: “The Region field contains geographic categories.”
Structured reference
A formula reference using table or column names rather than only grid addresses. In use: “A structured reference can point to the Sales column.”
Table name
The identifier assigned to an Excel table for formulas and management. In use: “Rename Table1 to Orders.”
Sort
Rearrange records by specified values or criteria. In use: “Sort orders by date while keeping the full rows together.”
Ascending
Ordering from smaller to larger or earlier to later, depending on data type. In use: “Sort the invoice dates ascending.”
Descending
Ordering from larger to smaller or later to earlier. In use: “Sort the revenue descending.”
Filter
Display records meeting chosen conditions while other records remain in the dataset. In use: “Filter to show unpaid invoices.”
AutoFilter
Excel’s built-in filter controls on a supported table or range. In use: “AutoFilter can show only one region.”
Slicer
A visual interactive filter for supported tables or PivotTables. In use: “Use a slicer to choose the quarter.”
PivotTable
A tool summarising and reorganising data by fields and aggregations. In use: “Create a PivotTable for sales by region.”
PivotTable field
A source dataset column used in a PivotTable’s layout and calculations. In use: “Place Product in Rows and Revenue in Values.”
Rows area
The area where PivotTable category labels are organised vertically. In use: “Put Department in the Rows area.”
Columns area
The area where PivotTable categories become columns. In use: “Put Month in the Columns area.”
Values area
The area holding summarised measures such as sums or counts. In use: “Put Sales Amount in Values.”
Filters area
The area holding report-level filtering fields in a PivotTable. In use: “Use the Filters area for country.”
Aggregation
Combining many values into a summary such as a sum, count or average. In use: “Aggregation should match the business question.”
Grand total
An overall total across the chosen data scope. In use: “Check that the grand total equals the source summary.”
Subtotal
An intermediate total for a category or group. In use: “Subtotals make department contributions visible.”
Refresh
Update a PivotTable or connected output with changed source data. In use: “Refresh the PivotTable after importing new records.”
Source data
The original table or range supplying the analysis. In use: “Verify source data before interpreting the chart.”
PivotChart
A chart linked to a PivotTable or its data structure. In use: “Use a PivotChart to visualise the region summary.”
Column chart
A graphic using vertical bars to compare amounts across categories. In use: “Use a column chart for monthly sales.”
Bar chart
A graphic using horizontal bars to compare categories. In use: “A bar chart suits long department names.”
Line chart
A chart connecting observations to show change along an ordered or continuous axis. In use: “A line chart helps show a time trend.”
Scatter plot
A chart displaying pairs of numeric values to study relationships. In use: “Use a scatter plot for price against demand.”
Legend
A chart key identifying series or visual categories. In use: “The legend should explain each line.”
Axis
A reference line and scale used to position chart values. In use: “Check whether the vertical axis starts at zero.”
Data label
A number or description printed directly on a chart mark. In use: “Add labels only when they make comparisons easier.”
Conditional formatting
Rules changing cell appearance based on values or conditions. In use: “Highlight overdue payments through conditional formatting.”
Duplicate values
Repeated entries under a defined comparison, which might be errors or legitimate records. In use: “Duplicate values require investigation before deletion.”
Remove Duplicates
A tool deleting rows identified as duplicates using selected columns. In use: “Copy the dataset before running Remove Duplicates.”
Data cleaning
Correcting formatting, missing entries, inconsistencies and other data-quality problems. In use: “Data cleaning should happen before statistical conclusions.”
Power Query
Excel’s data preparation and transformation tool for supported import workflows. In use: “Power Query can combine monthly CSV files.”
Data type
The kind of value stored or interpreted, such as number, text or date. In use: “Wrong data type can cause calculation errors.”
CSV
A text-based, comma-separated data interchange format with limitations compared with a full workbook. In use: “A CSV does not preserve Excel formatting or multiple worksheets.”
Import
Bring data from an external source into a workbook or query. In use: “Import the CSV and verify separators.”
Export
Save data or reports in another format for sharing or downstream use. In use: “Export a summary PDF for the client.”
Excel errors, auditing and safe use
These 35 terms belong to one spreadsheet task. Each meaning comes with an example you can test or recognise in Excel.
#N/A
An error value often indicating that a requested lookup match was not available. In use: “Check the lookup value when XLOOKUP returns #N/A.”
#VALUE!
An error indicating that a formula received a value or argument of an inappropriate type under its rules. In use: “A text value may cause #VALUE! in arithmetic.”
#REF!
An error indicating a reference is invalid, often following deletion or displacement of cells. In use: “Deleting a referenced column can cause #REF!.”
#DIV/0!
An error arising when a formula tries to divide by zero or an empty denominator. In use: “Check the divisor when #DIV/0! appears.”
#NAME?
An error indicating Excel does not recognise something in the formula, such as a misspelled function name. In use: “A typo in a function can trigger #NAME?.”
#NUM!
An error related to invalid numeric values or calculations under the function’s requirements. In use: “A function may return #NUM! for an invalid numeric domain.”
#SPILL!
An error when a dynamic-array result cannot occupy its intended output area. In use: “Clear obstructing cells when an array returns #SPILL!.”
Spill range
The cells filled by one dynamic-array formula’s output. In use: “A spilled result may grow or shrink when inputs change.”
Dynamic array
A formula result capable of producing multiple values across cells automatically. In use: “UNIQUE can return a dynamic array.”
Manual calculation
An Excel mode where formulas may not recalculate automatically until requested. In use: “Check manual calculation before trusting an old total.”
Automatic calculation
A mode where eligible changes trigger recalculation under Excel’s rules. In use: “Automatic calculation may refresh dependent totals.”
Formula auditing
Tools and habits for examining how a formula gets its result. In use: “Audit the calculation before publishing a budget.”
Trace precedents
An auditing action showing which cells feed a formula. In use: “Trace precedents to identify the wrong input.”
Trace dependents
An auditing action showing which other formulas rely on a selected cell. In use: “Trace dependents before changing a key assumption.”
Evaluate Formula
A tool displaying how a formula is processed step by step in supported desktop versions. In use: “Use Evaluate Formula to understand nested conditions.”
Protect worksheet
A feature limiting selected edits within a worksheet, not a substitute for strong file encryption. In use: “Sheet protection can reduce accidental changes.”
Protect workbook
A feature restricting certain workbook structure changes under supported settings. In use: “Workbook protection is not the same as controlling file access.”
Read-only
A mode or permission intended to prevent ordinary direct editing. In use: “Share a read-only copy when recipients only need a reference.”
External link
A reference connecting a workbook to outside data or another workbook. In use: “Review external links before distributing a model.”
Broken link
A reference that no longer resolves to the intended data source. In use: “A broken link can make an analysis stale.”
Data integrity
The accuracy, consistency and completeness of stored information. In use: “Data integrity matters more than a colourful dashboard.”
Validation rule
A condition limiting acceptable data entry. In use: “Use a validation rule for allowed status labels.”
Outlier
An observation unusually different from others under the analytical context. In use: “An outlier is not automatically an error.”
Missing value
A data item absent from a record or field. In use: “Missing values should not silently be treated as zero.”
Assumption
An input or condition accepted for a model without direct observation. In use: “Document the growth-rate assumption.”
Scenario
An alternative set of model inputs or conditions. In use: “Compare optimistic and conservative scenarios.”
Sensitivity analysis
Testing how a result changes when one or more assumptions vary. In use: “Sensitivity analysis can reveal a fragile forecast.”
Audit trail
A record of revisions, inputs or decisions needed to understand how a result arose. In use: “Keep an audit trail of material budget changes.”
Version history
A record of prior workbook versions where storage and account support allow it. In use: “Check version history after an accidental overwrite.”
Data privacy
Safe handling of personal or confidential information in the spreadsheet. In use: “Remove private identifiers before sharing the workbook.”
Macro
A recorded or programmed action sequence used to automate work in supported Excel environments. In use: “Only enable macros from trusted sources.”
VBA
Visual Basic for Applications, a programming language used in certain Excel desktop automation. In use: “A VBA macro can change data, so review it carefully.”
Data connection
A link through which a workbook retrieves information from another source. In use: “Refresh a data connection only after verifying its source.”
Checksum
A calculated value used in some workflows to detect changes to data or files, rather than proof of accuracy. In use: “A matching checksum does not prove the numbers are correct.”
Reproducibility
The ability for someone else to repeat analysis and obtain the same result under stated inputs. In use: “Record formulas and source data for reproducibility.”
Four real Excel tasks and the vocabulary that solves them
A copied formula changes the tax rate
The problem is almost certainly a reference choice, not that Excel has forgotten the rate. A reference like F1 is relative, so it may change when copied. A reference like $F$1 locks the row and column. A mixed reference can lock just one dimension. Use the form appropriate to the actual copying pattern.
A lookup returns #N/A even though the item exists
Check the exact lookup value, data types, extra spaces and whether the chosen lookup array really contains the item. Text “0012” and numeric 12 may not behave as the same identifier. XLOOKUP can be useful in supported Excel versions, but Microsoft’s documentation notes that it is not available in Excel 2016 or 2019. Do not publish a template that silently depends on a function its audience cannot use.
A PivotTable does not include the latest month’s sales
The question is whether the source table includes the new records and whether the PivotTable was refreshed. A PivotTable summary can reflect an earlier source snapshot. Inspect its source range, confirm data types and refresh the report. Then reconcile the new grand total to a trusted source total before communicating it.
A chart says sales doubled, but the bars look almost equal
Read the axis, labels, units and selected data range. An axis with a narrow nonzero starting point can exaggerate visual differences; an incorrect number format can hide units; and a chart might exclude hidden or filtered categories. A chart is a representation of data, not an independent guarantee that the underlying calculation is right.
Formula and function examples that readers can try
- SUM:
=SUM(B2:B10)adds eligible numbers in the range. - AVERAGE:
=AVERAGE(B2:B10)calculates the mean of eligible numeric values. - COUNT:
=COUNT(B2:B10)counts numeric cells rather than all nonempty cells. - COUNTA:
=COUNTA(A2:A10)counts cells considered nonempty. - COUNTIF:
=COUNTIF(D2:D20,"Paid")counts Paid entries. - SUMIFS:
=SUMIFS(C2:C20,D2:D20,"Paid")sums values where status is Paid. - IF:
=IF(B2>=70,"Pass","Review")returns one of two text results. - XLOOKUP:
=XLOOKUP(F2,A2:A20,C2:C20,"Not found")returns a corresponding value or a fallback in supported versions.
These examples assume corresponding data ranges and suitable cell types. Excel formula separators and locale settings can vary, so some installations use semicolons rather than commas in function arguments.
Excel terms commonly mistaken for one another
- Workbook versus worksheet: the full file can contain several sheet tabs.
- Formula versus function: a formula is the complete expression; a function is one built-in operation it may call.
- Relative versus absolute: copied references may move unless their row or column is anchored.
- COUNT versus COUNTA: counting numeric cells differs from counting nonempty cells.
- Filter versus delete: filtering hides nonmatching rows in the view without removing them.
- Sort versus PivotTable: ordering records differs from summarising them by categories.
- PivotTable refresh versus automatic source update: a changed source does not always mean the PivotTable is current.
- Number format versus data value: changing appearance may not change the stored number.
- CSV versus workbook: a CSV is a simple text-based table format, not a full Excel workbook.
- Sheet protection versus file security: preventing accidental edits is not the same as encrypting sensitive data.
A five-step spreadsheet quality audit
First, define the question. Is the purpose to total invoices, identify late orders or analyse monthly revenue? Choose formulas and summaries according to the decision rather than decorating the workbook first.
Second, check source data. Identify a consistent record for each row, clear headers, appropriate data types and missing values. Verify that identifiers with leading zeros have not been silently converted to numbers.
Third, inspect representative calculations. Check the formula bar, relative and absolute references, sample inputs and outputs. Use tracing tools or independent calculations where useful.
Fourth, verify summaries and visuals. Refresh relevant PivotTables or connections, inspect filters and reconcile totals. Check chart axes, legends, categories and units.
Fifth, preserve a usable version. Keep an appropriately secured working copy, document assumptions and remove sensitive identifiers before external sharing. Do not enable untrusted macros or connections.
Practice your Excel vocabulary
- Cell D3 contains =B3*C3: formula, with two relative references.
- $F$1 stays fixed when copied: absolute reference.
- One row represents one invoice: record.
- You need only unpaid orders visible: filter.
- You need revenue summed by region: PivotTable.
- Lookup cannot find a code: investigate #N/A.
- A referenced column was deleted: investigate #REF!.
- A formula divides by zero: #DIV/0!.
- An array cannot expand because nearby cells are occupied: #SPILL!.
- You need unique categories from a range: UNIQUE in a supported version.
Frequently asked questions
What is the difference between a formula and a function?
A formula is the complete calculation beginning with =. A function is a built-in calculation such as SUM that a formula can use.
What does $A$1 mean?
It is an absolute reference to cell A1. The dollar signs anchor the column and row when a formula is copied.
Is XLOOKUP available in every Excel version?
No. Microsoft’s current documentation states XLOOKUP is not available in Excel 2016 or 2019. Check your users’ supported versions.
What is a PivotTable?
A PivotTable summarises source data by selected categories and measures, such as revenue by region.
What does #N/A mean?
It often means that the requested match or value was not available to a function. Check the lookup inputs and source data.
Why is my formula showing as text?
Check whether the cell is formatted as Text, the formula has a leading apostrophe or the display is showing formulas rather than results.
What is the difference between sorting and filtering?
Sorting rearranges order; filtering controls which records are visible without normally deleting them.
Can Excel calculations be wrong even without errors?
Yes. A formula can refer to the wrong cells, use inappropriate assumptions or exclude relevant data while still returning a perfectly valid number.
Official Microsoft references and related learning
- Microsoft — overview of formulas in Excel
- Microsoft — cell references in formulas
- Microsoft — XLOOKUP function
- Microsoft — Excel help and learning
- Microsoft — PivotTable help topics
To understand shared access to spreadsheet files, read Vocabulary for Google Drive | File Sharing, Storage and Access Terms Explained. For broader terminology and learning, browse the eduKateSG Vocabulary Articles & Knowledge Hub.