Practicing Success

Target Exam

CUET

Subject

Accountancy

Chapter

Spreadsheet

Question:

Steps to print non contiguous ranges in MS-Excel are:-

A. Click the office Button and select print
B. Select the first range to be printed
C. In print what section, select selection
D. Press [ctrl] + select second range to be printed and more, if required
E. Click print

Choose the correct answer from the options given below:

Options:

B → D → A → C → E

A → B → D → C → E

B → D → C → A → E

A → B → C → D → E

Correct Answer:

B → D → A → C → E

Explanation:

The correct answer is Option (1) - B → D → A → C → E.

To select Print Multiple Ranges Excel facilitates to print non-contiguous ranges. Selected ranges will print on separate pages.
1. Select the first range to be printed.
2. Press [Ctrl] + select the second range to be printed .
3. For each additional range to be printed, repeat step 2.
4. In the top left corner of the Excel window, click the Office Button – select Print OR Press [Ctrl] + [P]. The Print dialog box appears.
5. In the Print what section, select Selection. Selection.
6. Click Print. The specified range of cells is printed.