FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
To display more than one workbook on the screen at the same time, you would use the ____ command.
A
Arrange
B
Arrange All
C
Organize All
D
Organize
Explanation: 

Detailed explanation-1: -On the View tab, in the Window group, click Arrange All. Under Arrange, click the option that you want. If the sheets that you want to view are all located in the active workbook, select the Windows of active workbook check box.

Detailed explanation-2: -Right-click the Excel icon on the taskbar and pick Microsoft Excel 2010 or Microsoft Excel 2007. Then navigate to File> Open and browse for your second workbook. Press and hold the Shift key on your keyboard and click the Excel icon on the taskbar. Then open your second file from the new instance.

Detailed explanation-3: -In the ribbon, click View > Arrange All > Vertical > OK. The two workbooks will now appear in the same window, as shown below.

Detailed explanation-4: -Click the Insert Worksheet tab at the bottom of the screen. Press and hold the CTRL key, and then click Sheet1, Sheet2, and so on till you finish selecting all your worksheets.

There is 1 question to complete.
Previous
Next