Action #5: Next, select the sheet tab labeled “October” Highlight cell B6 (highlighted in yellow) Press the key (NOTE: YOU WILL NEED TO PRESS THE SHIFT KEY AT THE SAME “+” TIME AS PRESSING THE KEY) “+” Action #6: Next, select the sheet tab labeled “December” Highlight cell B6 (highlighted in yellow) Press the key to complete the equation “Enter” =SUM(January!B6+April!B6+October!B6+December!B6) Action #7: Copy the formula all the way down the column (Cells B6 B27) “Days Off” – Close the document without saving SECTION IV: COMPLETE! SECTION V: SECURITY PROTECT SHEET LESSON ITEM #14: Excel spreadsheets are commonly used in the business world to disclose everything from REASON: employee information to company financials. Protecting these important documents is crucial in today’s technology based environment. Action #1: Locate the button located in the tab “Protect Sheet” “Review” Action #2: Click on the button to view the menu options “Protect Sheet” Action #3:
Action #5: Next, select the sheet tab labeled “October” Highlight cell B6 (highlighted in yellow) Press the “+” key (NOTE: YOU WILL NEED TO PRESS THE SHIFT KEY AT THE SAME TIME AS PRESSING THE “+” KEY) Action #6: Next, select the sheet tab labeled “December” Highlight cell B6 (highlighted in yellow) Press the “Enter” key to complete the equation =SUM(January!B6+April!B6+October!B6+December!B6) Action #7: Copy the formula all the way down the “Days Off” column (Cells B6 – B27) Close the document without saving SECTION IV: COMPLETE! SECTION V: SECURITY LESSON ITEM #14: PROTECT SHEET REASON: Excel spreadsheets are commonly used in the business world to disclose everything from employee information to company financials. Protecting these important documents is crucial in today’s technology based environment. Action #1: Locate the “Protect Sheet” button located in the “Review” tab Action #2: Click on the “Protect Sheet” button to view the menu options Action #3:
WFC413-0414-Intermediate-Excel-2010-Workshop.docx