USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Copy the Summary worksheet from the Quarterly ____ Earnings ____ Overview.xlsx workbook, found in your Gmwtrix Templates folder, and place it as the last worksheet in the Quarterly ____ Earnings.xlsx workbook.
|
|
file, open, select Quarterly ____ Earnings ____ Overview.xlsx, home tab, cells group, format, move or copy worksheet, select move worksheet to end
|
|
|
insert tab, text button, object, create from file, Quarterly ____ Earnings ____ Overview.xlsx
|
|
|
insert tab, text button, object, create from file, Quarterly ____ Earnings ____ Overview.xlsx, move worksheet to the end
|
|
|
file, open, select Quarterly ____ Earnings ____ Overview.xlsx, home tab, cells group, format, move or copy worksheet
|
Explanation:
Detailed explanation-1: -On the Page Layout tab, in the Page Setup group, click Page Setup. Under Print Titles, click in Rows to repeat at top or Columns to repeat at left and select the column or row that contains the titles you want to repeat. Click OK.
Detailed explanation-2: -worksheet, change the Page Size to A4. 1. In the Marketing Budget Plan worksheet, in the Page Layout tab, locate the Page Setup group, click Size, and select A4.
Detailed explanation-3: -The quickest and easiest way to sum a range of cells is to use the Excel AutoSum button. It automatically enters an Excel SUM function in the selected cell.
There is 1 question to complete.