Microsoft Excel Managing Data Cells and Ranges Questions and Answers

Question 1

A user wants to copy a range of cells containing formulas (A1:A10) to a new location (B1:B10), but needs to paste only the calculated values, not the formulas themselves.
Which Paste Special option should be used?

Accepted Answer

Values

Answer

Formulas

Answer

Formats

Answer

Transpose

Question 2

You are working with a large dataset and want to quickly select all the blank cells within a specified range to either delete them or fill them with specific data. Which feature would be most efficient for this task?

Accepted Answer

Go To Special

Answer

Find and Replace

Answer

Conditional Formatting

Answer

Flash Fill

Question 3

A user has a table of sales data where the months are listed in Row 1 (B1:M1) and product names are in Column A (A2:A20). For a new report, the user needs to switch the orientation so that the months are in Column A and the product names are in Row 1. What is the most direct way to accomplish this?

Accepted Answer

Use the Transpose option in Paste Special

Answer

Use the CONCATENATE function

Answer

Manually re-type the data

Answer

Use the Cut and Paste commands

Question 4

Which of the following is an invalid character for use within a named range in Excel?

Accepted Answer

Space ( )

Answer

Underscore (_)

Answer

Period (.)

Answer

Backslash (\)

Question 5

You frequently need to enter a specific, non-sequential list of department names into various worksheets (e.g., 'Sales', 'Marketing', 'HR', 'IT', 'Finance'). To save time and ensure consistency, you want to be able to type the first department name and use the Fill Handle to automatically populate the rest. What Excel feature should you use to set this up?

Accepted Answer

Custom List

Answer

Data Validation List

Answer

Conditional Formatting

Answer

Named Range

Question 6

A financial analyst needs to apply the specific formatting (cell color, font style, and number format) from a summary cell (A1) to a range of other cells (D1:D10) without overwriting the existing data or formulas in the destination cells. Which of the following is the most appropriate method?

Accepted Answer

Format Painter

Answer

Copy and Paste

Answer

Find and Replace with Formatting

Answer

Flash Fill

A user wants to copy a range of cells containing formulas (A1:A10) to a new location (B1:B10), but needs to paste only the calculated values, not the formulas themselves.Which Paste Special option should be used?

A user wants to copy a range of cells containing formulas (A1:A10) to a new location (B1:B10), but needs to paste only the calculated values, not the formulas themselves.
Which Paste Special option should be used?