Get access to thousands of high quality educational resources

Explain some commonly used workbook management practices when working on MS Excel.

      

Explain some commonly used workbook management practices when working on MS Excel.

  

Answers

BONFACE
• To Insert a New Worksheet: Click the Insert Worksheet tab next to the sheet tabs at the bottom of the program screen. Or, press Shift + F11.
• To Delete a Worksheet: Select the sheet want to delete, click the Delete button in the Cells group on the Home tab, and select Delete Sheet. Or, right-click the sheet tab and select Delete from the contextual menu.
• To Rename a Worksheet: Double-click the sheet tab, enter a new name for the worksheet, and press Enter.
• To Change a Worksheet’s Tab Color: Right-click the sheet tab, select Tab Color, and choose the color you want to apply.
• To Move or Copy a Worksheet: Click and drag a tab to move a worksheet. Hold down the Ctrl key while clicking and dragging to copy the worksheet.
• To Split a Window: Drag either the vertical or horizontal split bar (located near the scroll bars) onto the worksheet.
•To Freeze Panes: Place the cell pointer where you want to freeze the window, click the View tab on the Ribbon, click the Freeze Panes button in the Window group, and select an option from the list.
• To Select a Print Area: Select the cell range you want to print, click the Page Layout tab on the Ribbon, click the Print Area button in the Page Setup group, and select Set Print Area.
• To Adjust Page Margins, Orientation, Size, and Breaks: Click the Page Layout tab on the Ribbon and use the commands in the Page Setup group, or click the Dialog Box Launcher in the Page Setup group to open the Page Setup dialog box.
• To Protect or Share a Workbook: Click the Review tab on the Ribbon and use the commands in the Changes group.
• To Recover AutoSaved Versions: Click the File tab on the Ribbon and select Info. Select an AutoSaved version from the Versions list. Or, click the Manage Versions button and select Recover Draft Versions.
Mwalimu Bonface answered the question on April 14, 2018 at 09:40

Next: State the basic keyboard shortcut keys used to format and edit a spreadsheet.
Previous: What are the qualities of good e-mail contact management software?

View More Computer Studies Questions and Answers | Return to Questions Index


Exams With Marking Schemes

Related Questions

© 2008-2024 by KenyaPlex.com. All Rights Reserved | Home | About Us | Contact Us | Copyright | Terms Of Use | Privacy Policy | Advertise