Subdomain 3.1 Create and format tables
3.1.1 Create Excel tables from cell ranges
Directions:
1.) Download the file (above).
2.) Select range A4:K9.
3.) Go to Home tab and Styles group.
4.) Click "Format As Table"
5.) Choose a style and press OK.
To Get Credit: Show me your table.
1.) Download the file (above).
2.) Select range A4:K9.
3.) Go to Home tab and Styles group.
4.) Click "Format As Table"
5.) Choose a style and press OK.
To Get Credit: Show me your table.
3.1.2 Apply table styles
Directions:
1.) Download the file (above).
2.) Click anywhere within the table.
3.) Go to the table tools design tab (this will only be shown when you click inside the table)
4.) Set the table to "Brown, Table Style Dark 3"
To Get Credit: Show me the table with "Brown, Table Style Dark 3".
1.) Download the file (above).
2.) Click anywhere within the table.
3.) Go to the table tools design tab (this will only be shown when you click inside the table)
4.) Set the table to "Brown, Table Style Dark 3"
To Get Credit: Show me the table with "Brown, Table Style Dark 3".
3.1.3 Convert tables to cell ranges
Directions:
1.) Download the file (above).
2.) Click on the table.
3.) Go to "Design" tab.
4.) In the "Tools" group click "Convert To Range"
To Get Credit: Show me the converted range.
1.) Download the file (above).
2.) Click on the table.
3.) Go to "Design" tab.
4.) In the "Tools" group click "Convert To Range"
To Get Credit: Show me the converted range.
Subdomain 3.2 Modify tables
3.2.1 Add or remove table rows and columns
Directions:
1.) Download the file (above).
2.) Click on the table and go to the design tab.
3.) Right click to open the menu to add/remove a row or column.
To Get Credit: Demonstrate the process of how to create a row and column and delete a row and column.
1.) Download the file (above).
2.) Click on the table and go to the design tab.
3.) Right click to open the menu to add/remove a row or column.
To Get Credit: Demonstrate the process of how to create a row and column and delete a row and column.
3.2.2 Configure table style options
Directions:
1.) Download the file (above).
2.) Click on table and go to Design tab.
3.) Remove banded rows and header rows.
4.) Remove duplicates.
To Get Credit: Show me a table without banded rows, without a header row and with no duplicates.
1.) Download the file (above).
2.) Click on table and go to Design tab.
3.) Remove banded rows and header rows.
4.) Remove duplicates.
To Get Credit: Show me a table without banded rows, without a header row and with no duplicates.
3.2.3 Insert and configure total rows
Directions:
1.) Download the file (above).
2.) Click on table and go to design tab.
3.) Click total row
4.) Follow the directions under the table on the worksheet.
To Get Credit: Show me a table with a total row (following the directions listed on the worksheet).
1.) Download the file (above).
2.) Click on table and go to design tab.
3.) Click total row
4.) Follow the directions under the table on the worksheet.
To Get Credit: Show me a table with a total row (following the directions listed on the worksheet).
Subdomain 3.3 Filter and sort table data
3.3.1 Filter records
Directions:
1.) Download the file (above).
2.) Turn cell range in to a table. (You should know how to do this from previous tasks.)
3.) On tab A (bottom of document) filter the table to remove the letters, B, O, R, I, N and G.(Yeah that spells BORING HA!!!!)
4.) On tab B sort column B to go from the lowest value to the highest value.
To Get Credit: Filter BORING from tab A, sort from lowest value to highest value on tab B.
1.) Download the file (above).
2.) Turn cell range in to a table. (You should know how to do this from previous tasks.)
3.) On tab A (bottom of document) filter the table to remove the letters, B, O, R, I, N and G.(Yeah that spells BORING HA!!!!)
4.) On tab B sort column B to go from the lowest value to the highest value.
To Get Credit: Filter BORING from tab A, sort from lowest value to highest value on tab B.
3.3.2 Sort data by multiple columns
Directions:
1.) Download the file (above).
2.) Go to Home tab.
3.) Go to Editing group.
4.) Click the "Sort and Filter" drop down.
5.) Select "Custom Sort"
6.) Sort alphabetically by Last Name and then School and then Graduation Year.
To Get Credit: Show me your table sorted alphabetically by last name and then school.
1.) Download the file (above).
2.) Go to Home tab.
3.) Go to Editing group.
4.) Click the "Sort and Filter" drop down.
5.) Select "Custom Sort"
6.) Sort alphabetically by Last Name and then School and then Graduation Year.
To Get Credit: Show me your table sorted alphabetically by last name and then school.