I85PREP
⌘ K
Computer Specialist in Spreadsheet Level 2 study materials
Computer Specialist in Spreadsheet Level 2 study resources

Computer Specialist in Spreadsheet Level 2 practice questions

One question at a time. Build your Computer Specialist in Spreadsheet Level 2 understanding.

First 50 of 200 questions. Each one lists the choices, the correct answer, and an explanation. The checker at the top of this page saves progress in this browser when it is available.

Continue in the practice tool above to load more questions, 50 at a time.

Question 1Spreadsheet Fundamentals and Interface

A user types 007 into a cell that is formatted as General before any entry is made. What does the cell display after the entry is confirmed?

  1. 007
  2. ###
  3. 7 Correct answer.
  4. 0.007

Explanation

In the General format, leading zeros have no numeric meaning, so the stored value 7 is displayed without them. To keep the zeros visible, the cell must be formatted as Text or given a custom number format such as 000 before or after entry.

Question 2Spreadsheet Fundamentals and Interface

Which key combination moves the active cell to the last used cell in the same row, in the direction of the arrow key pressed, when the row contains contiguous data?

  1. Ctrl + arrow key Correct answer.
  2. Shift + arrow key
  3. Tab
  4. Alt + arrow key

Explanation

Ctrl combined with an arrow key jumps to the edge of the current data block, stopping at the last non-empty cell before a blank. Without Ctrl, a plain arrow key moves only one cell at a time.

Question 3Spreadsheet Fundamentals and Interface

A worksheet contains the value 5 in A1 and 10 in A2. The formula =A1+A2 is entered in A3, and later A1 is changed to 20. What appears in A3?

  1. 30 Correct answer.
  2. 25
  3. The cell stays blank until recalculated manually
  4. 15

Explanation

A formula that references cells recalculates automatically when a precedent cell changes, so A3 shows 20 plus 10. The original result of 15 is replaced without any user action.

Question 4Spreadsheet Fundamentals and Interface

What is the default file extension of a standard macro-free spreadsheet workbook saved by a modern spreadsheet application?

  1. .txt
  2. .xlsx Correct answer.
  3. .csv
  4. .pdf

Explanation

The .xlsx extension identifies the default XML-based workbook format that preserves formulas, formats, and multiple sheets. Formats such as .csv and .txt store only plain values and lose formatting and formulas.

Question 5Spreadsheet Fundamentals and Interface

Which element of the spreadsheet window shows the address of the currently selected cell, such as B7?

  1. The status bar
  2. The formula bar
  3. The Name Box Correct answer.
  4. The sheet tab

Explanation

The Name Box sits to the left of the formula bar and displays the reference of the active cell or selected range. It can also be used to type a reference and jump directly to that cell.

Question 6Spreadsheet Fundamentals and Interface

A cell contains the text value 42 entered as text. Which alignment does the spreadsheet apply by default?

  1. Left-aligned Correct answer.
  2. Centered
  3. Justified
  4. Right-aligned

Explanation

Text entries align to the left of the cell by default, while numeric values align to the right. This default alignment is a quick visual cue for distinguishing text from numbers.

Question 7Spreadsheet Fundamentals and Interface

A user needs to enter the same heading into cells A1 through A10. Which approach fills the range in one action?

  1. Select A1:A10, type the heading, and press Ctrl + Enter Correct answer.
  2. Type the heading in A1, then press Enter ten times
  3. Type the heading in A1 and press Ctrl + C
  4. Select A1:A10 and press Ctrl + D without any prior entry

Explanation

When a range is selected and text is typed, pressing Ctrl + Enter commits the entry to every cell in the selection at once. This avoids repeated typing or copying steps.

Question 8Spreadsheet Fundamentals and Interface

A cell displays ##### across its width. What is the most likely cause?

  1. The cell contains an invalid data type
  2. The workbook is protected
  3. The formula contains a circular reference
  4. The column is too narrow to display the formatted numeric result Correct answer.

Explanation

When a column is too narrow for a numeric or date result, the spreadsheet shows hash marks instead of truncating the value. Widening the column or reducing the font size reveals the number.

Question 9Spreadsheet Fundamentals and Interface

What distinguishes the formula =A1 from the formula =$A$1 when the formula is copied to another location?

  1. The first returns text; the second returns a number
  2. The first is absolute; the second is relative
  3. The first adjusts its reference when copied; the second keeps column A and row 1 fixed Correct answer.
  4. Both behave identically in every copy operation

Explanation

A reference without dollar signs is relative and shifts by the number of rows and columns the formula moves. Dollar signs before both the column letter and row number make the reference absolute so it does not shift.

Question 10Spreadsheet Fundamentals and Interface

Which reference style uses the notation R1C1 to identify a cell?

  1. A1 reference style
  2. Structured table reference
  3. Named range style
  4. R1C1 reference style Correct answer.

Explanation

In R1C1 style, rows and columns are both identified by number, so R1C1 means row 1, column 1. The more common A1 style uses a column letter followed by a row number.

Question 11Spreadsheet Fundamentals and Interface

A user wants the formula in B2 to always refer to the value in column A of the same row, even when the formula is copied to the right. Which reference should be used?

  1. A$2
  2. $A2 Correct answer.
  3. A2
  4. $A$2

Explanation

The dollar sign before the column letter locks column A, while the row number remains relative so it adjusts per row. Copying the formula across columns therefore keeps pointing to column A.

Question 12Spreadsheet Fundamentals and Interface

Which paste option transfers only the calculated result of a formula, removing the underlying formula?

  1. Paste Transpose
  2. Paste Formulas
  3. Paste Values Correct answer.
  4. Paste Formatting

Explanation

Paste Values inserts the displayed result as static content, so the destination no longer depends on the original formula. Paste Formulas instead keeps the formula and its references.

Question 13Spreadsheet Fundamentals and Interface

A user selects the range A1:D20 and applies a currency number format. What is the effect?

  1. Every cell in the range displays numbers with a currency symbol and two decimal places, while stored values stay unchanged Correct answer.
  2. Only cells that already contain currency values are affected
  3. The range is converted to a table with a totals row
  4. The values in the range are rounded and permanently replaced

Explanation

Number formats change only how a value is displayed, not the underlying stored number. Applying currency format to a range affects all cells in it, including empty ones, which inherit the format for future entries.

Question 14Spreadsheet Fundamentals and Interface

A cell shows the error value #DIV/0!. Which situation produces this error?

  1. A formula omits a required argument
  2. A formula refers to text where a number is required
  3. A formula uses a column letter that does not exist
  4. A formula divides by a cell that is empty or contains zero Correct answer.

Explanation

#DIV/0! occurs when the divisor evaluates to zero, including when the divisor cell is blank. Checking the divisor for zero or using IFERROR produces a cleaner result.

Question 15Spreadsheet Fundamentals and Interface

A user wants to display the weekday name for a date in A1. Which number format category should be used?

  1. Percentage format
  2. Scientific format
  3. Custom format with the dddd code Correct answer.
  4. Currency format

Explanation

Dates are stored as serial numbers, and custom format codes such as dddd render the full weekday name without changing the underlying value. The date remains usable in calculations.

Question 16Spreadsheet Fundamentals and Interface

How does the spreadsheet decide whether typed content such as 3/4 is stored as a date or as text?

  1. It prompts the user every time before deciding
  2. It interprets the entry according to the workbook's regional date settings and stores a matching serial date Correct answer.
  3. It always stores any entry containing a slash as text
  4. It converts the entry to a fraction such as 0.75 only

Explanation

The application parses typed entries using the locale's date pattern; 3/4 is recognized as March 4 and stored as a serial number with a date format. If the entry cannot be parsed as a date, it is stored as text.

Question 17Spreadsheet Fundamentals and Interface

A user freezes the top row and the first column of a worksheet. What happens when the user scrolls down and to the right?

  1. The frozen row and column become hidden
  2. The frozen areas move with the scroll and disappear
  3. The top row and first column remain visible as the rest of the sheet scrolls Correct answer.
  4. Only the top row stays visible; the column unfreezes automatically

Explanation

Freeze Panes locks the rows above and columns to the left of the active cell so they stay on screen during scrolling. This is useful for keeping headers visible in large tables.

Question 18Spreadsheet Fundamentals and Interface

A workbook contains three sheets: Summary, Q1, and Q2. A formula on Summary must total cell B10 from both Q1 and Q2. Which formula accomplishes this?

  1. =B10!Q1+B10!Q2
  2. =Q1!B10+Q2!B10 Correct answer.
  3. =SUM(B10:B10)
  4. =Q1.B10+Q2.B10

Explanation

A cross-sheet reference places the sheet name before an exclamation mark, followed by the cell address, as in Q1!B10. Adding the two references totals B10 from both sheets.

Question 19Spreadsheet Fundamentals and Interface

A user wants to restrict entries in a column so that only whole numbers from 1 to 100 can be entered. Which feature is designed for this?

  1. Subtotal
  2. Data Validation Correct answer.
  3. Conditional Formatting
  4. Freeze Panes

Explanation

Data Validation defines rules an entry must satisfy, such as a whole-number range, and can reject or warn about invalid input. Conditional Formatting only changes appearance and does not block entries.

Question 20Spreadsheet Fundamentals and Interface

A worksheet uses a custom cell style named Header for its column titles. A user edits the Header style to add bold and a fill color. What happens to cells already using the style?

  1. The style is converted into a table
  2. All cells using that style update to show the new formatting Correct answer.
  3. The cells keep the old formatting until the style is reapplied one by one
  4. Only the currently selected cell updates

Explanation

A named cell style centralizes formatting attributes, so editing the style definition propagates the change to every cell that uses it. This makes global formatting changes fast and consistent.

Question 21Workbook and Worksheet Management

In a spreadsheet workbook, which element is used to organize related worksheets into a single file?

  1. A cell comment
  2. A print area
  3. A single cell range
  4. The workbook file itself Correct answer.

Explanation

A workbook is the container file that holds one or more worksheets, so related sheets are grouped together by saving them in the same workbook. Cell ranges, comments, and print areas all live inside a worksheet and do not group sheets into a file.

Question 22Workbook and Worksheet Management

A user wants to add a brand-new blank worksheet to the current workbook. Which action accomplishes this directly?

  1. Clicking the Insert Worksheet (plus) tab control at the end of the sheet tabs Correct answer.
  2. Changing the zoom level of the active sheet
  3. Renaming an existing sheet tab
  4. Freezing the top row of the active sheet

Explanation

The Insert Worksheet control, usually shown as a plus icon beside the last sheet tab, adds a new blank worksheet to the workbook. Renaming, zooming, and freezing panes all modify existing sheets rather than creating a new one.

Question 23Workbook and Worksheet Management

Which character is not permitted in a worksheet tab name in most spreadsheet applications?

  1. An underscore
  2. A forward slash Correct answer.
  3. A hyphen
  4. A space

Explanation

Sheet names cannot contain certain reserved characters such as the forward slash, backslash, question mark, asterisk, brackets, or colon. Hyphens, spaces, and underscores are all accepted in tab names.

Question 24Workbook and Worksheet Management

A workbook contains six worksheets. Which command hides the active worksheet so it no longer appears among the visible tabs?

  1. Delete Sheet
  2. Move or Copy
  3. Protect Sheet
  4. Format > Hide Sheet (Hide command on the sheet tab menu) Correct answer.

Explanation

The Hide command on the sheet tab shortcut menu, or the equivalent Format menu option, removes a worksheet from view while keeping it in the workbook. Delete removes it permanently, Protect restricts editing, and Move or Copy relocates or duplicates it.

Question 25Workbook and Worksheet Management

A user needs a worksheet tab to be renamed to 'Q1 Sales'. What is the most direct way to do this?

  1. Insert a header in Page Layout view
  2. Press Ctrl+S and type the new name
  3. Change the workbook file name in the Save As dialog
  4. Double-click the sheet tab and type the new name Correct answer.

Explanation

Double-clicking a sheet tab enters edit mode on the tab label so the new name can be typed directly. Saving, renaming the file, and editing headers affect the file or printed output, not the sheet tab label.

Question 26Workbook and Worksheet Management

Which statement correctly describes the difference between a worksheet and a workbook?

  1. A workbook is a file that can contain many worksheets; a worksheet is a single grid of cells Correct answer.
  2. A workbook stores only charts, while a worksheet stores only formulas
  3. A worksheet is a file that contains many workbooks; a workbook is a single grid of cells
  4. A workbook and a worksheet are two names for the same grid of cells

Explanation

The workbook is the saved file, and each worksheet inside it is one grid of cells with its own tab. A workbook can therefore hold several worksheets, but a worksheet never contains workbooks.

Question 27Workbook and Worksheet Management

A user wants to place a copy of the 'Budget' worksheet immediately after the 'Summary' worksheet in the same workbook. Which sequence achieves this?

  1. Right-click the Budget tab, choose Move or Copy, select Summary, tick Create a copy, then OK Correct answer.
  2. Use File > Save As and save with a new file name
  3. Select all cells on Budget and press Ctrl+C
  4. Right-click the Budget tab and choose Delete

Explanation

The Move or Copy dialog lets you choose a target position and, with Create a copy checked, inserts a duplicate sheet at that location while leaving the original intact. Deleting, copying cells, or saving under a new name do not create a duplicate sheet in the desired position.

Question 28Workbook and Worksheet Management

A workbook has sheets in the order Jan, Feb, Mar, Apr. A user drags the Apr tab to the left of the Jan tab. What is the resulting tab order?

  1. Jan, Apr, Feb, Mar
  2. Apr, Jan, Feb, Mar Correct answer.
  3. Apr, Feb, Mar, Jan
  4. Jan, Feb, Mar, Apr

Explanation

Dragging a sheet tab moves that sheet to the drop position and shifts the other sheets to fill the gap, so Apr lands first and the rest keep their relative order. The other sequences misplace Apr or reorder unrelated sheets.

Question 29Workbook and Worksheet Management

A user wants to select several non-adjacent worksheets at once, for example Sheet1 and Sheet3 but not Sheet2. How is this done?

  1. Right-click the Sheet1 tab and choose Protect Sheet
  2. Double-click the Sheet1 tab
  3. Click the Sheet1 tab, then hold Ctrl and click the Sheet3 tab Correct answer.
  4. Click the Sheet1 tab, then hold Shift and click the Sheet3 tab

Explanation

Holding Ctrl while clicking tabs adds individual sheets to the selection without including the sheets in between. Holding Shift selects a contiguous range, which would also include Sheet2.

Question 30Workbook and Worksheet Management

Several worksheets are grouped. A user types a value into cell A1 and presses Enter. What happens?

  1. The value is entered into A1 of the first worksheet only
  2. The value is entered into cell A1 of every grouped worksheet Correct answer.
  3. The entry is rejected until the group is ungrouped
  4. The value is entered only into the active worksheet

Explanation

When sheets are grouped, edits made on the active sheet are applied to the same cells on all sheets in the group. This is useful for identical formatting or headers but risky for data entry.

Question 31Workbook and Worksheet Management

What is the quickest way to ungroup a selection of multiple worksheets so only one sheet remains active?

  1. Use Format > Rename Sheet
  2. Close and reopen the workbook
  3. Right-click a tab and choose Ungroup Sheets, or click any unselected sheet tab Correct answer.
  4. Press Ctrl+Z to undo the grouping

Explanation

Ungrouping is done through the sheet tab shortcut menu or by clicking a tab that is not part of the group, which makes it the sole active sheet. Undo does not reliably reverse tab grouping, and reopening the file is unnecessary.

Question 32Workbook and Worksheet Management

A user wants to change the tab color of the 'Expenses' worksheet to red for visual identification. Where is this done?

  1. Data > Sort
  2. Page Layout > Themes
  3. Sheet tab shortcut menu > Tab Color Correct answer.
  4. Home > Font Color

Explanation

Tab Color is available on the sheet tab shortcut menu and colors the tab itself for visual grouping. Font Color changes text, Themes change overall styling, and Sort rearranges data.

Question 33Workbook and Worksheet Management

A user wants to display row and column headings on every printed page of a multi-page worksheet. Which setting should be used?

  1. Insert > Header & Footer
  2. Home > Wrap Text
  3. View > Freeze Panes
  4. Page Layout > Print Titles > Rows to repeat at top Correct answer.

Explanation

Print Titles lets you specify rows or columns that repeat on each printed page, which is the correct tool for repeating headings. Freeze Panes only affects on-screen scrolling, and Wrap Text affects cell display.

Question 34Workbook and Worksheet Management

A worksheet is set to print in landscape orientation with a print area of A1:H40. Which statement describes the effect of the print area setting?

  1. All cells with data are printed regardless of the print area
  2. Only cells A1:H40 are printed, even if other cells contain data Correct answer.
  3. The print area converts the range into a table
  4. The print area changes the sheet's row heights

Explanation

Defining a print area restricts printed output to that range, so data outside A1:H40 is excluded from printing while remaining in the sheet. It does not alter formatting or convert the range into a table.

Question 35Workbook and Worksheet Management

A user wants the first column and the top two rows to stay visible while scrolling through a large worksheet. Which action sets this up?

  1. Choose View > Page Break Preview
  2. Choose Home > Format > Column Width
  3. Select cell B3, then choose View > Freeze Panes Correct answer.
  4. Select cell A1, then choose View > Freeze Panes

Explanation

Freeze Panes freezes everything above and to the left of the selected cell. Selecting B3 freezes column A and rows 1-2, keeping them visible during scrolling.

Question 36Workbook and Worksheet Management

A user deletes a worksheet that is referenced by formulas on other sheets. What is the typical result?

  1. The deleted worksheet is automatically recreated
  2. The formulas return a #REF! error because the referenced sheet no longer exists Correct answer.
  3. The formulas recalculate using the next available sheet
  4. The formulas silently return zero

Explanation

When a sheet referenced by a formula is deleted, the reference becomes invalid and the formula returns a #REF! error. The application does not substitute another sheet, recreate the deleted one, or return zero.

Question 37Workbook and Worksheet Management

A user wants to protect the structure of a workbook so that worksheets cannot be inserted, deleted, renamed, or moved. Which command is appropriate?

  1. Review > Protect Workbook > Structure Correct answer.
  2. View > Arrange All
  3. Review > Protect Sheet
  4. File > Info > Inspect Workbook

Explanation

Protect Workbook with the Structure option prevents adding, deleting, renaming, moving, or hiding sheets. Protect Sheet restricts editing of cell contents on a single sheet, which is a different scope.

Question 38Workbook and Worksheet Management

A workbook contains a hidden worksheet named 'Data'. A user wants it visible again. What is required?

  1. Use File > Open to reopen the hidden sheet
  2. Right-click any visible sheet tab and choose Unhide, then select Data Correct answer.
  3. Change the sheet tab color to white
  4. Select all cells and press Ctrl+H

Explanation

The Unhide command on the sheet tab shortcut menu lists hidden sheets so one can be selected and made visible. Hidden sheets are not reopened as separate files, and tab color does not affect visibility.

Question 39Workbook and Worksheet Management

A user needs a summary sheet to display the same header block on every worksheet without retyping it. Which approach best supports consistent workbook management?

  1. Group the relevant worksheets and enter the header once so it applies to all grouped sheets Correct answer.
  2. Type the header separately on each sheet without grouping
  3. Move each worksheet into a separate workbook
  4. Delete the header cells on each sheet and re-enter them

Explanation

Grouping sheets and entering the header once applies the same content to the same cells on every grouped sheet, ensuring consistency and saving effort. Retyping separately risks inconsistency, and splitting into separate workbooks works against unified management.

Question 40Workbook and Worksheet Management

A user wants to compare two worksheets side by side within the same workbook on screen. Which feature is designed for this?

  1. Data > Consolidate
  2. View > New Window, then View > Arrange All Correct answer.
  3. Insert > PivotTable
  4. Review > Protect Sheet

Explanation

Opening a new window for the workbook and using Arrange All displays two views side by side, each able to show a different sheet. Protect Sheet, Consolidate, and PivotTable serve unrelated purposes.

Question 41Data Entry and Cell Editing

In a spreadsheet, which key combination commits the entry currently being typed in a cell and moves the selection down one cell?

  1. Shift+Enter
  2. Enter Correct answer.
  3. Tab
  4. Ctrl+Enter

Explanation

Pressing Enter confirms the edit and, by default, moves the active cell one row downward. Tab confirms the entry and moves one column to the right instead. Shift+Enter confirms but moves upward, and Ctrl+Enter fills the selected range with the entry.

Question 42Data Entry and Cell Editing

A user types 007 into a General-format cell. Which result appears, and why?

  1. 007 is kept because the cell is text by default
  2. 0.07 appears because the entry is read as a decimal
  3. 7 appears because General format treats the entry as a number Correct answer.
  4. 007 is kept because leading zeros are always preserved in cells

Explanation

Under General format the spreadsheet interprets a digit-only entry as a number, and numbers do not store leading zeros. To display 007 the cell must be formatted as Text before typing, or the entry must be prefixed with an apostrophe.

Question 43Data Entry and Cell Editing

Which action places the current cell's content on the clipboard and removes it from the cell in a single step?

  1. Ctrl+V
  2. Ctrl+X Correct answer.
  3. Ctrl+Z
  4. Ctrl+C

Explanation

Ctrl+X performs a cut, which copies the cell content to the clipboard and marks the source for removal once it is pasted. Ctrl+C copies without removing anything, and Ctrl+V pastes clipboard content into the target. Ctrl+Z reverses the last action rather than moving data.

Question 44Data Entry and Cell Editing

A column of 500 part numbers must all end with the suffix -A. Which approach edits all cells at once without retyping each value?

  1. Use Find and Replace with an empty Find field and -A as Replace
  2. Type the suffix in the first cell and use Fill Down on the whole column
  3. Select the range and apply the Text format to the column
  4. Select the range, type -A, and press Ctrl+Enter Correct answer.

Explanation

Typing a value and pressing Ctrl+Enter enters that value into every cell of the selected range in one operation. Fill Down would overwrite the existing part numbers rather than appending to them, and formatting does not change content.

Question 45Data Entry and Cell Editing

What does the apostrophe (') typed at the start of an entry such as '12345 do?

  1. It rounds the number to the nearest integer
  2. It stores the entry as text and is not displayed in the cell Correct answer.
  3. It inserts a visible apostrophe before the number
  4. It converts the entry into a formula

Explanation

A leading apostrophe is a text-alignment prefix: the spreadsheet treats the following characters as text and hides the apostrophe itself. This is the standard way to keep leading zeros or long numeric codes as literal text.

Question 46Data Entry and Cell Editing

A cell contains the text Sales Report. Which key deletes only the character immediately to the left of the insertion point while the cell is in edit mode?

  1. Delete
  2. Insert
  3. Backspace Correct answer.
  4. Esc

Explanation

In edit mode, Backspace removes the character to the left of the cursor, while Delete removes the character to the right. Esc cancels the whole edit and restores the previous cell content, and Insert toggles overwrite mode.

Question 47Data Entry and Cell Editing

A user needs the same header text in cells A1, B1 and C1. Which method enters it fastest while keeping the content identical?

  1. Type it in A1, select A1:C1, and use Fill Right Correct answer.
  2. Type it in A1 and drag the fill handle to C1
  3. Type it in A1, then copy A1 and paste into B1 and C1
  4. Type it separately in each of the three cells

Explanation

Selecting the source cell plus the targets and using Fill Right replicates the value across the selection in one command. Dragging the fill handle also works but is slower for a fixed three-cell range, and retyping risks inconsistency.

Question 48Data Entry and Cell Editing

After typing a long entry, a user presses Esc instead of Enter. What is the result?

  1. The entry is committed but the cell stays selected
  2. The entry is committed and the cursor moves down
  3. The entry is discarded and the cell keeps its previous content Correct answer.
  4. The entry is stored in the clipboard

Explanation

Esc cancels the current edit, so any characters typed since editing began are discarded and the cell reverts to its prior value. Enter, by contrast, commits the entry. Nothing is placed on the clipboard by cancelling.

Question 49Data Entry and Cell Editing

A user pastes a block of data into a sheet and finds every value placed in a single column instead of separate columns. Which paste option should be used to split the text at the delimiters?

  1. Paste Special with Formats only
  2. Paste Special with Transpose
  3. Text Import or the Text to Columns feature Correct answer.
  4. Paste Special with Values only

Explanation

When delimited text lands in one column, the Text Import dialog or Text to Columns parses it at the chosen delimiter and distributes the pieces across adjacent columns. Paste Special options control which attributes are pasted, not how a single string is split.

Question 50Data Entry and Cell Editing

Which statement about editing a cell that contains a formula is correct?

  1. Typing over the cell replaces the formula with the new content Correct answer.
  2. Clicking the cell and pressing F2 deletes the formula
  3. The formula can only be changed by deleting the row
  4. Formatting the cell as Text automatically converts the formula to a value

Explanation

Any direct entry typed into a cell replaces whatever was there, including a formula, unless the edit is cancelled. To modify rather than replace a formula, the user edits within the formula bar or in-cell edit mode. Formatting does not convert formulas into static values.