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

Pastes everything

Answer

Pastes only formatting

Answer

Pastes with conditional formatting

Question 2

How do you name a range of cells?

Accepted Answer

Select range, type name in Name Box, press Enter

Answer

Right-click > Name Range

Answer

Home tab Name button

Answer

Names assigned automatically

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

No difference

Answer

Deleting cells is permanent

Answer

Contents removes formatting

Question 4

What does Flash Fill do?

Accepted Answer

Detects patterns in your data entry and fills remaining cells

Answer

Fills with random data

Answer

Applies fill animation

Answer

Applies fill color quickly

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

View > Go To Special

Answer

Home > Select Special

Answer

Only available in VBA

Question 6

What does Text to Columns do?

Accepted Answer

Splits one column into multiple based on delimiter or fixed width

Answer

Converts column charts to text

Answer

Converts text numbers to numbers

Answer

Wraps text in cells