Action #2: Open the existing document file labeled located on the C: “Conditional Formatting Practice” drive in the folder labeled “Training Class Files – DO NOT REMOVE” Follow the instructions at the top of the document to complete the activity INSERTING A TABLE LESSON ITEM #3: REASON: Inserting a table gives you more options regarding formatting style, sorting and filtering options IMPORTANT NOTE: In order to view the table styles options menu, a table must first be established and selected Action #1: Open the existing document file labeled Table located on the C: drive in the folder “Team 1” labeled Class Files “Training – DO NOT REMOVE” Highlight Cell range B4 F26 – Action #2: From the the button labeled “Insert” tab, click “Table” Action #3: Note the different items listed in the ribbon including table style, total row and “Table Tools” banded rows SECTION I: COMPLETE! SECTION II: MANAGING INFORMATION SORTING DATA LESSON ITEM #4: Sorting data is a key skill required to effectively manage and group spreadsheet information REASON: into a format that is easier to understand Action #1: Open the existing document file labeled Table located on the C: drive in the folder “Team 2” labeled “Training Class Files – DO NOT REMOVE” Highlight Cell range A4 I26 – Action #2:
Action #2: Open the existing document file labeled “Conditional Formatting Practice” located on the C: drive in the folder labeled “Training Class Files – DO NOT REMOVE” Follow the instructions at the top of the document to complete the activity LESSON ITEM #3: INSERTING A TABLE REASON: Inserting a table gives you more options regarding formatting style, sorting and filtering options IMPORTANT NOTE: In order to view the table styles options menu, a table must first be established and selected Action #1: Open the existing document file labeled “Team Table 1” located on the C: drive in the folder labeled “Training Class Files – DO NOT REMOVE” Highlight Cell range B4 – F26 Action #2: From the “Insert” tab, click the button labeled “Table” Action #3: Note the different items listed in the “Table Tools” ribbon including table style, total row and banded rows SECTION I: COMPLETE! SECTION II: MANAGING INFORMATION LESSON ITEM #4: SORTING DATA REASON: Sorting data is a key skill required to effectively manage and group spreadsheet information into a format that is easier to understand Action #1: Open the existing document file labeled “Team Table 2” located on the C: drive in the folder labeled “Training Class Files – DO NOT REMOVE” Highlight Cell range A4 – I26 Action #2: