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:
Answer & explanation
Correct answer: option 1
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.Following steps are undertaken for printing:
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.
Thus, B → D → A → C → E is the correct sequence of printing.