Microsoft Excel Managing Data Cells and Ranges 2

Question 1

What does Paste Special > 'Values' do?

Accepted Answer

Pastes only calculated results, removing formulas and formatting

Answer

Paste Values strips formulas and formatting, leaving only the result.

Question 2

How do you name a range of cells?

Accepted Answer

Select range, type name in Name Box, press Enter

Answer

Select cells, click the Name Box (left of formula bar), type the name, press Enter.

Question 3

What is the difference between deleting contents and deleting cells?

Accepted Answer

Contents clears values but keeps cells; deleting cells removes them and shifts neighbors

Answer

Delete key clears values; Right-click > Delete removes the cell and shifts adjacent cells.

Question 4

What does Flash Fill do?

Accepted Answer

Detects patterns in your data entry and fills remaining cells

Answer

Flash Fill recognizes patterns from examples you type and auto-fills the rest.

Question 5

How do you use Go To Special to select specific cell types?

Accepted Answer

Ctrl+G then 'Special' to select by type (formulas, blanks, constants)

Answer

Press Ctrl+G, click Special, then choose criteria like formulas, blanks, or constants.

Excel Practice Test