USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
He should open a new workbook, line his two windows up side-by-side, and create a Western worksheet from scratch, using the Eastern worksheet as a guide.
|
|
|
He should add a new worksheet to the current workbook, view both worksheets side-by-side, and create the Western worksheet from scratch, using the Eastern worksheet as a guide.
|
|
|
He should create a copy of the Eastern worksheet, rename the copy Western, and then enter the figures as appropriate.
|
|
|
He should rename the Eastern worksheet to Western, and then enter the figures as appropriate.
|
Detailed explanation-1: -His worksheet is beautifully formatted and contains accurate formulas. Now he needs to create a worksheet just like it for the Western region. How should Sam proceed? He should create a copy of the Eastern worksheet, rename the copy Western, and then enter the figures as appropriate.
Detailed explanation-2: -How many new worksheets can you add to an Excel workbook? Excel does not limit the number of new worksheets that can be added to a workbook. 10.
Detailed explanation-3: -Expert-Verified Answer Option a-Currency is the number format used to apply to the cell showing the total sales for the month. Explanation: Numbers must be formatted as currency in order to be displayed as monetary values.
Detailed explanation-4: -To change the color of a sheet tab, right-click the tab, point to Tab Color and pick a color that you want. Tip: Click away from the formatted tab to see the new tab color. If you want to remove the color, right-click the tab, point to Tab Color, and pick No Color.
Detailed explanation-5: -Select the cell that contains the formula you want to copy. Hover your cursor around the black square in the lower right corner of the cell until your cursor turns into a plus sign. Click and hold the left mouse button while dragging the handle to include all cellswhere you would like the formula copied.