The practice files for these tasks are located in the MOSExcel2013\Objective1 practice file folder. Save the results of the tasks in the same folder. l Open the Excel_1-4a workbook, and complete the following tasks: m Hide the column containing the Inventory ID, and the row containing the data’s source notes. Then unhide the row but not the column. m Add the Calculator button (which is not available on any ribbon tab) to the Quick Access Toolbar, make it the leftmost button, and visually sepa- rate it from the other buttons. m Create a Quick Access Toolbar for only the current workbook that con- tains buttons for inserting pictures, charts, and tables. Then display the Quick Access Toolbar below the ribbon. m Reset the Quick Access Toolbar to its default content, and display it above the ribbon. l Open the Excel_1-4b workbook, and complete the following tasks: m On the Personal Monthly Budget worksheet, freeze rows 1 through 9 so that when you scroll the rest of the workbook, those rows are always vis- ible. Then unfreeze the panes. m Split the Personal Monthly Budget worksheet vertically so that you can display rows 1 through 9 in the top window and scroll the budget data in the bottom window. m Attach the keywords spending and saving to the workbook. m Display the Personal Monthly Budget worksheet in Page Layout view, and then zoom out so you can see the entire first page. m Select the Projected Monthly Income section of the worksheet, and zoom in to display only the selected cells. l In the Excel_1-4c workbook, hide the By Product-Customer Filtered worksheet.
44 Chapter 1 Create and manage workbooks and worksheets 1.5 Configure worksheets and workbooks to print or save Printing workbook content An Excel workbook can contain many separate worksheets of data. You can print part or all of an individual worksheet, a selected worksheet, or all the worksheets that contain content at one time. By default, Excel prints only the currently active worksheet or work- sheet group. If you want to print only part of a worksheet, you can do so from the Print page of the Backstage view or, if you will often print the same portion of a worksheet, you can define that portion as the print area. After defining the print area of a workbook, you can add selected ranges to it. A range that is contiguous to the original range becomes part of the original print area definition; a range that is noncontiguous or a different shape becomes a separate print area and is printed on a separate page. You can also remove ranges from the print area. If you don’t want to limit printing to the print area, you can permanently clear the print area or temporarily ignore it by selecting an option on the Print page of the Backstage view. If your worksheet content doesn’t fit naturally within the space allocated to it on the page, you can scale the content for the purpose of printing, instead of modifying the content to make it fit. You can scale the worksheet manually or allow Excel to scale it for you by specifying the number of pages you want the printed worksheet to be.
You've reached the end of your free preview.
Want to read all 168 pages?
- Spring '15
- Leo Nguyen