PrepAway - Latest Free Exam Questions & Answers

which of the following steps can you accomplish your task?

You are creating a worksheet on Excel 2010. You want to select entire worksheet (including the
blank cells). Through which of the following steps can you accomplish your task?
Each correct answer represents a complete solution. Choose two.

PrepAway - Latest Free Exam Questions & Answers

A.
Press Ctrl+A twice

B.
Click the Select Entire region button

C.
Press Ctrl+A

D.
Click the Select All button

Explanation:
According to the question, you are required to select entire worksheet including the blank cells. In
order to accomplish the task, you can take either of these two steps:
Press Ctrl+A twice.
Click the Select All button.

Microsoft Excel provides various ways to select cells or ranges based on a user’s requirement. The
following table describes the action to be taken for different requirements of selection:

To cancel a selection of cells, click any cell on the worksheet.
Answer C is incorrect. Pressing Ctrl+A will select the current region.
Answer B is incorrect. No such button is available in Excel 2010.


Leave a Reply