Question Detail

When creating a vertical page break ?

The active cell must be in row 1
The active cell must be A1
The active cell must be in row 10
The active cell must be in column A

Answer: Option A

Similar Questions :

1. Where are the status indicators located ?

Horizontal Scroll
Vertical Scroll
Formula bar
Address bar

Answer: Option C

2. VLOOKUP function used to ?

Finds related records
Looks up text that contain "v"
Check if two cells are identical
None of above

Answer: Option A

3. Which of the following is not a valid Zoom percentage in Excel ?

10
100
300
500

Answer: Option D

4. How do you change column width to fit the contents ?

Single-click the boundary to the left to the column heading
Double click the boundary to the right of the column heading
Press Alt and single click anywhere in the column
All of above

Answer: Option B

5. Merge cells option can be applied from ?

Formatting toolbar
Format Cells dialog box Alignment Tab
Both of above
None of above

Answer: Option B

Read more from - MS Excel Questions Answers