How to create a chart
- Select the data that will be used for the chart (it is a good idea to include column headings)
- Click on the inside tab, tarts group in click on the type of chart you want
- Click on the type of variation you want and the chart you selected will be inserted
How to edit a chart
- Select the chart and the icons will appear at the top right side of the chart
- Click on the chart elements icon
- Half of the mouse over the element that you wish to add or change and then click on the arrow on the right
- Choose the relevant option
How to change the appearance of a chart
- Click on the chart Styles icon (the paint brush). Options for changing the style and the color of the chart will appear
- Click on your choice
To insert a worksheet
Click on the plus sign next to the sheet
How do you rename a worksheet
Right click on the tab and choose rename
How do you delete a worksheet
Right click on the tab and choose delete
What does the function sum do and what is the formula for it
Sum adds the values of all cells in the range
The formula is =SUM(A2: A10)
What does the MIN function do and what is the formula for it
Compares the values in the range and gives you the smallest/lowest
=MIN(A1:A15)
What does the MAX function do and what is the formula for it
Compare the values in the Range and Returns the maximum/highest/largest value
=MAX(B2: B10)
What does the AVERAGE function do and what is the formula for it
Ads together the values of all the cells in the Range and divided by the number of cells in the range that have a value
The formula is =average(D3: D25)
What does the Count function do and what is the formula for it
Count the number of cells in a range that contain numeric values and the formula is =COUNT(A2: A20)
What does the COUNTA function do and what is the formula for it
Count the number of cells in the Range that contain anything and the formula is =COUNTA(C5: C10)
What does the COUNTBLANK function do and what is the formula for it
Comes the number of cells in a range that do not contain anything and the formula is =(B15:B20)
What does the ROUND function do and what is the formula for it
Around the value in a cell to a specified number of decimal places and the formula is =ROUND(A6,1)
What does the COUNTIF function do and what is the formula for it
Count the number of cells in a range that meet a certain condition and the formula is =COUNTIF(C5:C20,”M”)
Ways to troubleshoot formulas and functions
Always read the questions carefully
try to decide whether a formula or function is required
try to break big problems into smaller problems
Read the tool tip that appears under a cell when you start typing a function
How to set or clear a print area
- Select the range of cells that you want to set up as the print area
- Click on the page layout tab, page setup group, print area, set printer area.
