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. You will use which feature in excel, if you want to work with one record at a time ?

Auto Complete
Auto Filter
Sub Totals
Data Form

Answer: Option D

2. Which shortcut can be used to Switch between open workbooks ?

Ctrl + F2
Ctrl + F6
Ctrl + F8
Ctrl + F10

Answer: Option B

3. With which of the following all formulas in excel starts ?

/
*
$
=

Answer: Option D

4. Which of the following keyboard shortcut can be used for creating a chart from the selected cells ?

F11
F10
F4
F2

Answer: Option A

5. A value used in a formula that does not change is called a ?

Constant
Cell address
Varaible
Static

Answer: Option A

Read more from - MS Excel Questions Answers