Creating Charts
|
Creation and formatting of charts:
1) Class presentation on chart creation 2) Support Link: Click Here 3) Spreadsheet Practice Task: Create the appropraite chart on each worksheet |
| ||
Filtering
|
Filtering:
1) Class presentation on filtering 2) Download the Filtering Spreadsheet file: 3) Complete the tasks below on the filtering Spreadsheet: |
| ||
Instructions:
* Some of these tasks will require a screen grab /print screen (press the print screen button) and paste this into a Word document that you will need to save and send to Leap on completion.
1) Highlight table data >> Insert Table-Take a screen grab
2) Filter the first column "Types of Transactions" into "Check"-Take a screen grab
3) Reset/Clear the filter for "Types of Transactions"
4) Select the "Balance" column and filter the value to: between 500-1500 -Take a screen grab
5) Reset/Clear the filter for "Balance" column
6) Select the "Withdrawal" column and filter the green colour-Take a screen grab
7) Reset/Clear the filter for "Withdrawal" column
8) Type the word Total Balances into cell reference K3 and in cell reference K4 type Minimum
9) Calculate the Total Balances in cell reference L3-Take a screen grab
10) Use the Minimum function to calculate the minimum balance in the "Balances" column. Place the function and answer in cell reference L4 -Take a screen grab
* Some of these tasks will require a screen grab /print screen (press the print screen button) and paste this into a Word document that you will need to save and send to Leap on completion.
1) Highlight table data >> Insert Table-Take a screen grab
2) Filter the first column "Types of Transactions" into "Check"-Take a screen grab
3) Reset/Clear the filter for "Types of Transactions"
4) Select the "Balance" column and filter the value to: between 500-1500 -Take a screen grab
5) Reset/Clear the filter for "Balance" column
6) Select the "Withdrawal" column and filter the green colour-Take a screen grab
7) Reset/Clear the filter for "Withdrawal" column
8) Type the word Total Balances into cell reference K3 and in cell reference K4 type Minimum
9) Calculate the Total Balances in cell reference L3-Take a screen grab
10) Use the Minimum function to calculate the minimum balance in the "Balances" column. Place the function and answer in cell reference L4 -Take a screen grab