Managing Data Cells and Ranges Flashcards
6 cards from real Microsoft Excel practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 Managing Data Cells and Ranges flashcards as text
What does Paste Special > 'Values' do?
Answer: Pastes only calculated results, removing formulas and formatting
Paste Values strips formulas and formatting, leaving only the result.
How do you name a range of cells?
Answer: Select range, type name in Name Box, press Enter
Select cells, click the Name Box (left of formula bar), type the name, press Enter.
What is the difference between deleting contents and deleting cells?
Answer: Contents clears values but keeps cells; deleting cells removes them and shifts neighbors
Delete key clears values; Right-click > Delete removes the cell and shifts adjacent cells.
What does Flash Fill do?
Answer: Detects patterns in your data entry and fills remaining cells
Flash Fill recognizes patterns from examples you type and auto-fills the rest.
How do you use Go To Special to select specific cell types?
Answer: Ctrl+G then 'Special' to select by type (formulas, blanks, constants)
Press Ctrl+G, click Special, then choose criteria like formulas, blanks, or constants.
What does Text to Columns do?
Answer: Splits one column into multiple based on delimiter or fixed width
Text to Columns splits text using delimiters or fixed character positions.