Computer Specialist in Spreadsheet Level 2 cheat sheet

The Name Box (left of the formula bar) displays the active cell reference and accepts typed references or range names to jump or select.

The formula bar shows the stored content of the active cell; editing there vs. in-cell is equivalent, but the formula bar reveals full text hidden by column width.

Ctrl+End moves to the last used cell; Ctrl+Home returns to A1; Ctrl+Arrow jumps to the edge of the current data block.

Status bar can show Average, Count, Numerical Count, Min, Max, and Sum of the current selection; right-click the status bar to toggle these.

Sheet tabs sit at the bottom; Ctrl+Page Down / Ctrl+Page Up cycle sheets, and right-clicking a tab opens Rename, Move, Copy, Protect, and Tab Color.

Ribbon tabs are contextual: Table Tools, Chart Tools, and PivotTable Tools appear only when the relevant object is selected.

Alt key activates KeyTips, letting commands be run from the keyboard (e.g., Alt, H, O, I for column width).

The Quick Access Toolbar is customizable via File > Options or right-clicking any command; it persists across workbooks.

Insert Worksheet: Shift+F11 (or the plus button beside the tabs); delete via right-click > Delete, which cannot be undone after save.

Move or Copy dialog: check 'Create a copy' to duplicate a sheet; leaving it unchecked moves the sheet, and the To book list allows cross-workbook moves.

Grouped sheets (Ctrl+click or Shift+click tabs) receive identical edits and formatting; ungroup by right-clicking > Ungroup Sheets before editing further.

Freeze Panes splits at the active cell: rows above and columns left of the selection stay visible; Unfreeze Panes restores normal scrolling.

Split (View tab) creates independently scrollable panes in the same window without locking rows; it is display-only and not saved as a print setting.

Hide a sheet with right-click > Hide; unhide requires right-click > Unhide and selecting from the list - a hidden sheet cannot be unhidden by keyboard alone.

Protect Workbook (Review tab) restricts structural changes such as adding, deleting, renaming, or moving sheets; Protect Sheet restricts cell editing instead.

Workbook themes, cell styles, and custom number formats are stored in the workbook; copying sheets to another workbook may remap theme colors.

Enter completes entry and moves down; Tab completes and moves right; Shift+Enter and Shift+Tab reverse direction; Ctrl+Enter fills the whole selected range with the entry.

F2 enters edit mode in place; Esc cancels the edit and restores the prior value; Enter commits.

AutoFill handle (bottom-right corner) extends series; dragging with right mouse button offers Copy Cells, Fill Series, Fill Formatting Only, Fill Without Formatting.

Custom lists (File > Options > Advanced > Edit Custom Lists) drive AutoFill order for text such as weekdays or department names.

Flash Fill (Ctrl+E) infers a pattern from one or two typed examples and fills the column; it is static text, not a formula.

Paste Special options include Values, Formulas, Formats, Column Widths, Transpose, and Operation (Add/Subtract/Multiply/Divide) applied to the clipboard data.

Text typed with a leading apostrophe is stored as text; a leading equals sign starts a formula; Ctrl+` toggles display of formulas vs. results.

Data Validation restricts entry by list, whole number, decimal, date, time, or custom formula, and supplies an input message and error alert.

All formulas begin with =; operators follow Excel precedence: reference operators (: space ,), negation, %, ^, * and /, + and -, then & and comparison operators.

Relative references (A1) shift when copied; absolute ($A$1) do not; mixed ($A1 or A$1) lock only the row or column.

VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) defaults to approximate match (TRUE); use FALSE or 0 for exact match.

IFERROR(value, value_if_error) traps errors such as #N/A, #DIV/0!, and #VALUE!; IFNA traps only #N/A.

COUNT counts numeric cells; COUNTA counts non-empty cells; COUNTBLANK counts empty ones; SUMIF/COUNTIF accept criteria such as ">100" or "East".

SUMIFS/COUNTIFS/AVERAGEIFS use AND logic across criteria ranges, which must be the same size as the sum range.

INDEX(array, row_num, [column_num]) returns a value by position and pairs with MATCH(lookup_value, lookup_array, 0) for left-looking lookups.

Common errors: #REF! (deleted reference), #DIV/0! (zero divisor), #NAME? (unrecognized name), #VALUE! (wrong argument type), ##### (column too narrow).

Number format codes use placeholders 0 (forced digit), # (optional digit), and ? (space-padded digit); sections are positive;negative;zero;text separated by semicolons.

Accounting format aligns currency symbols and shows a dash for zero; Currency places the symbol directly beside the number.

Conditional Formatting can highlight cells by rule, data bars, color scales, or icon sets; Manage Rules sets priority and Stop If True behavior.

Format Painter copies all formatting from a source cell; double-clicking the painter keeps it active for multiple pastes, Esc to exit.

Merge & Center combines cells, keeping only the upper-left value; Center Across Selection achieves visual centering without merging.

Page Setup: Orientation, Scaling (Adjust to n% or Fit to n pages wide by m tall), Margins, Header/Footer, and Print Titles for repeating rows or columns.

Print Area (Page Layout > Print Area > Set Print Area) limits what prints; Clear Print Area restores the full sheet.

Cell styles and themes cascade: changing the workbook theme alters theme fonts and colors used by built-in styles.

Chart types: column/bar compare categories, line shows trend over time, pie shows parts of one whole, scatter (XY) shows correlation between two numeric variables, and combo charts mix types with a secondary axis.

Select Data Source dialog controls series name, series values (Y), category labels (X), and the order of series; Switch Row/Column transposes the interpretation.

Chart elements include Chart Title, Axis Titles, Legend, Data Labels, Gridlines, and Trendline; add them via the plus button or Chart Elements menu.

Sparklines (Insert > Sparklines) place Line, Column, or Win/Loss mini-charts inside a single cell and reference a data range.

Recommended Charts and Quick Analysis (Ctrl+Q) propose chart types based on the selected data shape.

A chart placed on its own chart sheet is sized to the page; an embedded chart floats over cells and moves or sizes with cells depending on its property setting.

Pictures, shapes, SmartArt, and icons are inserted as objects; Wrap Text and Bring Forward/Send Backward control layering over cells.

Convert a range to a table with Ctrl+T; tables auto-expand, carry structured references such as Table1[Sales], and show filter buttons in headers.

Sort dialog allows up to 64 levels with per-level Order (A to Z, Z to A, Custom List) and Options for case sensitivity and left-to-right sort.

AutoFilter (Ctrl+Shift+L) filters by value, text contains, date period, color, or number condition; filters hide rows without deleting them.

Advanced Filter copies or filters in place using a criteria range; multiple criteria on one row are AND, criteria on separate rows are OR.

Remove Duplicates (Data tab) deletes rows with repeated values in selected columns and reports how many were removed; it is irreversible.

Subtotal (Data tab) inserts outline levels with SUM, COUNT, AVERAGE per group; it requires the data sorted by the grouping column first.

Text to Columns splits one column into several by Delimited (comma, tab, semicolon) or Fixed width, with per-column data format settings.

A PivotTable needs a clean source: one header row, no blank rows or columns, and consistent data types per column.

PivotTable areas are Filters, Columns, Rows, and Values; dragging a numeric field to Values defaults to Sum, while text defaults to Count.

Refresh (Alt+F5 or right-click > Refresh) re-reads the source; a new source range requires Change Data Source.

Show Values As options include % of Grand Total, % of Column Total, Running Total In, and Difference From.

Grouping dates in a PivotTable creates Years, Quarters, and Months levels; numeric grouping can build bins by interval.

Slicers are visual filters that connect to multiple PivotTables via Report Connections; Timelines filter date fields only.

GETPIVOTDATA retrieves a value from a PivotTable by field and item names; typing = and clicking a pivot cell inserts it automatically.

Goal Seek (Data > What-If Analysis) solves one input for a target formula result; Scenario Manager stores named sets of input values.

Ctrl+P opens Print with a live preview; settings include printer, copies, page range, one- or two-sided, collation, orientation, paper size, margins, and scaling.

Print Titles (Page Layout > Print Titles) repeats header rows at the top and columns at the left of every printed page.

Page Break Preview (View tab) allows dragging page breaks; Insert Page Break adds manual breaks, and Reset All Page Breaks clears them.

Share via OneDrive or SharePoint enables co-authoring; AutoSave requires the file to be stored in a cloud location.

Track Changes and comments: Review > New Comment (or Notes) attaches feedback to a cell; Show Comments toggles display.

Protect Sheet can allow specific actions (select locked cells, format columns) while blocking others; the password is optional but recommended.

Export options: Save As PDF/XPS, print to PDF, or publish specific sheets; Mark as Final sets the file to read-only and warns editors.

Compatibility Checker (File > Info > Check for Issues) lists features unsupported in older file formats such as .xls.

The Name Box (left of the formula bar) displays the active cell reference and accepts typed references or range names to jump or select.

The formula bar shows the stored content of the active cell; editing there vs. in-cell is equivalent, but the formula bar reveals full text hidden by column width.

Ctrl+End moves to the last used cell; Ctrl+Home returns to A1; Ctrl+Arrow jumps to the edge of the current data block.

Status bar can show Average, Count, Numerical Count, Min, Max, and Sum of the current selection; right-click the status bar to toggle these.

Sheet tabs sit at the bottom; Ctrl+Page Down / Ctrl+Page Up cycle sheets, and right-clicking a tab opens Rename, Move, Copy, Protect, and Tab Color.

Ribbon tabs are contextual: Table Tools, Chart Tools, and PivotTable Tools appear only when the relevant object is selected.

Alt key activates KeyTips, letting commands be run from the keyboard (e.g., Alt, H, O, I for column width).

The Quick Access Toolbar is customizable via File > Options or right-clicking any command; it persists across workbooks.

Insert Worksheet: Shift+F11 (or the plus button beside the tabs); delete via right-click > Delete, which cannot be undone after save.

Move or Copy dialog: check 'Create a copy' to duplicate a sheet; leaving it unchecked moves the sheet, and the To book list allows cross-workbook moves.

Grouped sheets (Ctrl+click or Shift+click tabs) receive identical edits and formatting; ungroup by right-clicking > Ungroup Sheets before editing further.

Freeze Panes splits at the active cell: rows above and columns left of the selection stay visible; Unfreeze Panes restores normal scrolling.

Split (View tab) creates independently scrollable panes in the same window without locking rows; it is display-only and not saved as a print setting.

Hide a sheet with right-click > Hide; unhide requires right-click > Unhide and selecting from the list - a hidden sheet cannot be unhidden by keyboard alone.

Protect Workbook (Review tab) restricts structural changes such as adding, deleting, renaming, or moving sheets; Protect Sheet restricts cell editing instead.

Workbook themes, cell styles, and custom number formats are stored in the workbook; copying sheets to another workbook may remap theme colors.

Enter completes entry and moves down; Tab completes and moves right; Shift+Enter and Shift+Tab reverse direction; Ctrl+Enter fills the whole selected range with the entry.

F2 enters edit mode in place; Esc cancels the edit and restores the prior value; Enter commits.

AutoFill handle (bottom-right corner) extends series; dragging with right mouse button offers Copy Cells, Fill Series, Fill Formatting Only, Fill Without Formatting.

Custom lists (File > Options > Advanced > Edit Custom Lists) drive AutoFill order for text such as weekdays or department names.

Flash Fill (Ctrl+E) infers a pattern from one or two typed examples and fills the column; it is static text, not a formula.

Paste Special options include Values, Formulas, Formats, Column Widths, Transpose, and Operation (Add/Subtract/Multiply/Divide) applied to the clipboard data.

Text typed with a leading apostrophe is stored as text; a leading equals sign starts a formula; Ctrl+` toggles display of formulas vs. results.

Data Validation restricts entry by list, whole number, decimal, date, time, or custom formula, and supplies an input message and error alert.

All formulas begin with =; operators follow Excel precedence: reference operators (: space ,), negation, %, ^, * and /, + and -, then & and comparison operators.

Relative references (A1) shift when copied; absolute ($A$1) do not; mixed ($A1 or A$1) lock only the row or column.

VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) defaults to approximate match (TRUE); use FALSE or 0 for exact match.

IFERROR(value, value_if_error) traps errors such as #N/A, #DIV/0!, and #VALUE!; IFNA traps only #N/A.

COUNT counts numeric cells; COUNTA counts non-empty cells; COUNTBLANK counts empty ones; SUMIF/COUNTIF accept criteria such as ">100" or "East".

SUMIFS/COUNTIFS/AVERAGEIFS use AND logic across criteria ranges, which must be the same size as the sum range.

INDEX(array, row_num, [column_num]) returns a value by position and pairs with MATCH(lookup_value, lookup_array, 0) for left-looking lookups.

Common errors: #REF! (deleted reference), #DIV/0! (zero divisor), #NAME? (unrecognized name), #VALUE! (wrong argument type), ##### (column too narrow).

Number format codes use placeholders 0 (forced digit), # (optional digit), and ? (space-padded digit); sections are positive;negative;zero;text separated by semicolons.

Accounting format aligns currency symbols and shows a dash for zero; Currency places the symbol directly beside the number.

Conditional Formatting can highlight cells by rule, data bars, color scales, or icon sets; Manage Rules sets priority and Stop If True behavior.

Format Painter copies all formatting from a source cell; double-clicking the painter keeps it active for multiple pastes, Esc to exit.

Merge & Center combines cells, keeping only the upper-left value; Center Across Selection achieves visual centering without merging.

Page Setup: Orientation, Scaling (Adjust to n% or Fit to n pages wide by m tall), Margins, Header/Footer, and Print Titles for repeating rows or columns.

Print Area (Page Layout > Print Area > Set Print Area) limits what prints; Clear Print Area restores the full sheet.

Cell styles and themes cascade: changing the workbook theme alters theme fonts and colors used by built-in styles.

Chart types: column/bar compare categories, line shows trend over time, pie shows parts of one whole, scatter (XY) shows correlation between two numeric variables, and combo charts mix types with a secondary axis.

Select Data Source dialog controls series name, series values (Y), category labels (X), and the order of series; Switch Row/Column transposes the interpretation.

Chart elements include Chart Title, Axis Titles, Legend, Data Labels, Gridlines, and Trendline; add them via the plus button or Chart Elements menu.

Sparklines (Insert > Sparklines) place Line, Column, or Win/Loss mini-charts inside a single cell and reference a data range.

Recommended Charts and Quick Analysis (Ctrl+Q) propose chart types based on the selected data shape.

A chart placed on its own chart sheet is sized to the page; an embedded chart floats over cells and moves or sizes with cells depending on its property setting.

Pictures, shapes, SmartArt, and icons are inserted as objects; Wrap Text and Bring Forward/Send Backward control layering over cells.

Convert a range to a table with Ctrl+T; tables auto-expand, carry structured references such as Table1[Sales], and show filter buttons in headers.

Sort dialog allows up to 64 levels with per-level Order (A to Z, Z to A, Custom List) and Options for case sensitivity and left-to-right sort.

AutoFilter (Ctrl+Shift+L) filters by value, text contains, date period, color, or number condition; filters hide rows without deleting them.

Advanced Filter copies or filters in place using a criteria range; multiple criteria on one row are AND, criteria on separate rows are OR.

Remove Duplicates (Data tab) deletes rows with repeated values in selected columns and reports how many were removed; it is irreversible.

Subtotal (Data tab) inserts outline levels with SUM, COUNT, AVERAGE per group; it requires the data sorted by the grouping column first.

Text to Columns splits one column into several by Delimited (comma, tab, semicolon) or Fixed width, with per-column data format settings.

A PivotTable needs a clean source: one header row, no blank rows or columns, and consistent data types per column.

PivotTable areas are Filters, Columns, Rows, and Values; dragging a numeric field to Values defaults to Sum, while text defaults to Count.

Refresh (Alt+F5 or right-click > Refresh) re-reads the source; a new source range requires Change Data Source.

Show Values As options include % of Grand Total, % of Column Total, Running Total In, and Difference From.

Grouping dates in a PivotTable creates Years, Quarters, and Months levels; numeric grouping can build bins by interval.

Slicers are visual filters that connect to multiple PivotTables via Report Connections; Timelines filter date fields only.

GETPIVOTDATA retrieves a value from a PivotTable by field and item names; typing = and clicking a pivot cell inserts it automatically.

Goal Seek (Data > What-If Analysis) solves one input for a target formula result; Scenario Manager stores named sets of input values.

Ctrl+P opens Print with a live preview; settings include printer, copies, page range, one- or two-sided, collation, orientation, paper size, margins, and scaling.

Print Titles (Page Layout > Print Titles) repeats header rows at the top and columns at the left of every printed page.

Page Break Preview (View tab) allows dragging page breaks; Insert Page Break adds manual breaks, and Reset All Page Breaks clears them.

Share via OneDrive or SharePoint enables co-authoring; AutoSave requires the file to be stored in a cloud location.

Track Changes and comments: Review > New Comment (or Notes) attaches feedback to a cell; Show Comments toggles display.

Protect Sheet can allow specific actions (select locked cells, format columns) while blocking others; the password is optional but recommended.

Export options: Save As PDF/XPS, print to PDF, or publish specific sheets; Mark as Final sets the file to read-only and warns editors.

Compatibility Checker (File > Info > Check for Issues) lists features unsupported in older file formats such as .xls.

The Name Box (left of the formula bar) displays the active cell reference and accepts typed references or range names to jump or select.

The formula bar shows the stored content of the active cell; editing there vs. in-cell is equivalent, but the formula bar reveals full text hidden by column width.

Ctrl+End moves to the last used cell; Ctrl+Home returns to A1; Ctrl+Arrow jumps to the edge of the current data block.

Status bar can show Average, Count, Numerical Count, Min, Max, and Sum of the current selection; right-click the status bar to toggle these.

Sheet tabs sit at the bottom; Ctrl+Page Down / Ctrl+Page Up cycle sheets, and right-clicking a tab opens Rename, Move, Copy, Protect, and Tab Color.

Ribbon tabs are contextual: Table Tools, Chart Tools, and PivotTable Tools appear only when the relevant object is selected.

Alt key activates KeyTips, letting commands be run from the keyboard (e.g., Alt, H, O, I for column width).

The Quick Access Toolbar is customizable via File > Options or right-clicking any command; it persists across workbooks.

Insert Worksheet: Shift+F11 (or the plus button beside the tabs); delete via right-click > Delete, which cannot be undone after save.

Move or Copy dialog: check 'Create a copy' to duplicate a sheet; leaving it unchecked moves the sheet, and the To book list allows cross-workbook moves.

Grouped sheets (Ctrl+click or Shift+click tabs) receive identical edits and formatting; ungroup by right-clicking > Ungroup Sheets before editing further.

Freeze Panes splits at the active cell: rows above and columns left of the selection stay visible; Unfreeze Panes restores normal scrolling.

Split (View tab) creates independently scrollable panes in the same window without locking rows; it is display-only and not saved as a print setting.

Hide a sheet with right-click > Hide; unhide requires right-click > Unhide and selecting from the list - a hidden sheet cannot be unhidden by keyboard alone.

Protect Workbook (Review tab) restricts structural changes such as adding, deleting, renaming, or moving sheets; Protect Sheet restricts cell editing instead.

Workbook themes, cell styles, and custom number formats are stored in the workbook; copying sheets to another workbook may remap theme colors.

Enter completes entry and moves down; Tab completes and moves right; Shift+Enter and Shift+Tab reverse direction; Ctrl+Enter fills the whole selected range with the entry.

F2 enters edit mode in place; Esc cancels the edit and restores the prior value; Enter commits.

AutoFill handle (bottom-right corner) extends series; dragging with right mouse button offers Copy Cells, Fill Series, Fill Formatting Only, Fill Without Formatting.

Custom lists (File > Options > Advanced > Edit Custom Lists) drive AutoFill order for text such as weekdays or department names.

Flash Fill (Ctrl+E) infers a pattern from one or two typed examples and fills the column; it is static text, not a formula.

Paste Special options include Values, Formulas, Formats, Column Widths, Transpose, and Operation (Add/Subtract/Multiply/Divide) applied to the clipboard data.

Text typed with a leading apostrophe is stored as text; a leading equals sign starts a formula; Ctrl+` toggles display of formulas vs. results.

Data Validation restricts entry by list, whole number, decimal, date, time, or custom formula, and supplies an input message and error alert.

All formulas begin with =; operators follow Excel precedence: reference operators (: space ,), negation, %, ^, * and /, + and -, then & and comparison operators.

Relative references (A1) shift when copied; absolute ($A$1) do not; mixed ($A1 or A$1) lock only the row or column.

VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) defaults to approximate match (TRUE); use FALSE or 0 for exact match.

IFERROR(value, value_if_error) traps errors such as #N/A, #DIV/0!, and #VALUE!; IFNA traps only #N/A.

COUNT counts numeric cells; COUNTA counts non-empty cells; COUNTBLANK counts empty ones; SUMIF/COUNTIF accept criteria such as ">100" or "East".

SUMIFS/COUNTIFS/AVERAGEIFS use AND logic across criteria ranges, which must be the same size as the sum range.

INDEX(array, row_num, [column_num]) returns a value by position and pairs with MATCH(lookup_value, lookup_array, 0) for left-looking lookups.

Common errors: #REF! (deleted reference), #DIV/0! (zero divisor), #NAME? (unrecognized name), #VALUE! (wrong argument type), ##### (column too narrow).

Number format codes use placeholders 0 (forced digit), # (optional digit), and ? (space-padded digit); sections are positive;negative;zero;text separated by semicolons.

Accounting format aligns currency symbols and shows a dash for zero; Currency places the symbol directly beside the number.

Conditional Formatting can highlight cells by rule, data bars, color scales, or icon sets; Manage Rules sets priority and Stop If True behavior.

Format Painter copies all formatting from a source cell; double-clicking the painter keeps it active for multiple pastes, Esc to exit.

Merge & Center combines cells, keeping only the upper-left value; Center Across Selection achieves visual centering without merging.

Page Setup: Orientation, Scaling (Adjust to n% or Fit to n pages wide by m tall), Margins, Header/Footer, and Print Titles for repeating rows or columns.

Print Area (Page Layout > Print Area > Set Print Area) limits what prints; Clear Print Area restores the full sheet.

Cell styles and themes cascade: changing the workbook theme alters theme fonts and colors used by built-in styles.

Chart types: column/bar compare categories, line shows trend over time, pie shows parts of one whole, scatter (XY) shows correlation between two numeric variables, and combo charts mix types with a secondary axis.

Select Data Source dialog controls series name, series values (Y), category labels (X), and the order of series; Switch Row/Column transposes the interpretation.

Chart elements include Chart Title, Axis Titles, Legend, Data Labels, Gridlines, and Trendline; add them via the plus button or Chart Elements menu.

Sparklines (Insert > Sparklines) place Line, Column, or Win/Loss mini-charts inside a single cell and reference a data range.

Recommended Charts and Quick Analysis (Ctrl+Q) propose chart types based on the selected data shape.

A chart placed on its own chart sheet is sized to the page; an embedded chart floats over cells and moves or sizes with cells depending on its property setting.

Pictures, shapes, SmartArt, and icons are inserted as objects; Wrap Text and Bring Forward/Send Backward control layering over cells.

Convert a range to a table with Ctrl+T; tables auto-expand, carry structured references such as Table1[Sales], and show filter buttons in headers.

Sort dialog allows up to 64 levels with per-level Order (A to Z, Z to A, Custom List) and Options for case sensitivity and left-to-right sort.

AutoFilter (Ctrl+Shift+L) filters by value, text contains, date period, color, or number condition; filters hide rows without deleting them.

Advanced Filter copies or filters in place using a criteria range; multiple criteria on one row are AND, criteria on separate rows are OR.

Remove Duplicates (Data tab) deletes rows with repeated values in selected columns and reports how many were removed; it is irreversible.

Subtotal (Data tab) inserts outline levels with SUM, COUNT, AVERAGE per group; it requires the data sorted by the grouping column first.

Text to Columns splits one column into several by Delimited (comma, tab, semicolon) or Fixed width, with per-column data format settings.

A PivotTable needs a clean source: one header row, no blank rows or columns, and consistent data types per column.

PivotTable areas are Filters, Columns, Rows, and Values; dragging a numeric field to Values defaults to Sum, while text defaults to Count.

Refresh (Alt+F5 or right-click > Refresh) re-reads the source; a new source range requires Change Data Source.

Show Values As options include % of Grand Total, % of Column Total, Running Total In, and Difference From.

Grouping dates in a PivotTable creates Years, Quarters, and Months levels; numeric grouping can build bins by interval.

Slicers are visual filters that connect to multiple PivotTables via Report Connections; Timelines filter date fields only.

GETPIVOTDATA retrieves a value from a PivotTable by field and item names; typing = and clicking a pivot cell inserts it automatically.

Goal Seek (Data > What-If Analysis) solves one input for a target formula result; Scenario Manager stores named sets of input values.

Ctrl+P opens Print with a live preview; settings include printer, copies, page range, one- or two-sided, collation, orientation, paper size, margins, and scaling.

Print Titles (Page Layout > Print Titles) repeats header rows at the top and columns at the left of every printed page.

Page Break Preview (View tab) allows dragging page breaks; Insert Page Break adds manual breaks, and Reset All Page Breaks clears them.

Share via OneDrive or SharePoint enables co-authoring; AutoSave requires the file to be stored in a cloud location.

Track Changes and comments: Review > New Comment (or Notes) attaches feedback to a cell; Show Comments toggles display.

Protect Sheet can allow specific actions (select locked cells, format columns) while blocking others; the password is optional but recommended.

Export options: Save As PDF/XPS, print to PDF, or publish specific sheets; Mark as Final sets the file to read-only and warns editors.

Compatibility Checker (File > Info > Check for Issues) lists features unsupported in older file formats such as .xls.