Spreadsheet values, references, functions and visual output
Separate values, formulas and display
A cell can contain a value or a formula. In the canonical notation used here, a formula begins with an equals sign, although some products accept other input forms. Number formatting changes display rather than automatically changing the stored number. Formatting0.25 as a percentage shows25 percent; it does not make the stored value25. Text that resembles a number can behave differently in calculations, sorting or imports, and date interpretation depends on the application’s date system and locale.
Trace references before copying
A relative reference moves with the copied formula. A dollar sign fixes the following column or row in Excel-style A1 notation. If a formula atC2 is=A2*$B$1, copying it down toC5 produces=A5*$B$1. A mixed reference such as$A2 fixes the column but permits the row to move. Confirm that the copied relationship matches the business meaning instead of adding dollar signs everywhere. In automatic calculation mode, dependent formulas update after relevant changes; manual calculation needs an explicit recalculation workflow. An unintended circular dependency can be an error, while some applications support carefully configured iterative models.
Choose a function and inspect the data range
SUM adds numeric values in the supplied range; AVERAGE divides by the relevant numeric count under the product’s rules. COUNT and COUNTA differ in what they count. MIN and MAX identify extrema, and IF selects an outcome according to a condition. In=IF(D2>=50,"Pass","Fail"), a value of50 satisfies the comparison and returns Pass. These are exercise thresholds, not official examination passing scores. Understand the intended treatment of blanks, text, errors and missing observations before trusting an aggregate.
Keep the table and output meaningful
Sorting one column independently can detach labels from their associated data; select the actual table and verify the header/range. Filtering hides nonmatching rows rather than deleting them, and calculations over visible versus all rows require the appropriate function. Freeze panes helps on-screen navigation, while repeat-print-title settings control printed headings. Charts should use the correct source labels, values and series. A line chart can show an ordered time trend; an XYscatter chart can use numeric horizontal values, including numeric time. A pie chart describes shares of a meaningful whole. Inspect axes, units, missing data and any truncated scale. Before export or printing, check print area, page orientation, scaling and legibility. CSV generally exports tabular values under specified delimiter/encoding rules and does not preserve a complete multi-sheet formatted workbook.