FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

What command do you use to increase or decrease the view of a selected cell or range of cells to fill the Excel Window area for better visibility?

A	Magnify Area
B	Enlarge Selected Area
C	Amplify Range
D	Zoom to Selection

Explanation:

Detailed explanation-1: -To AutoFit column width, select one, several or all columns on the sheet, go to the Home tab > Cells group, and click Format > AutoFit Column Width. To AutoFit row height, select the row(s) of interest, go to the Home tab > Cells group, and click Format > AutoFit Row Height.

Detailed explanation-2: -Select View > View Side by Side. If you scroll up or down, the other scrolls as well. If you want them to scroll separately, select Synchronous Scrolling to turn it off.

Detailed explanation-3: -Select the cell or range of cells. Select Copy or press Ctrl + C. Select Paste or press Ctrl + V.

Detailed explanation-4: -You can use the Fill command to fill a formula into an adjacent range of cells. Simply do the following: Select the cell with the formula and the adjacent cells you want to fill. Click Home > Fill, and choose either Down, Right, Up, or Left.

There is 1 question to complete.