Spreadsheets

Question 1

How to create a chart

Answer 1

1. Select the data that will be used for the chart (it is a good idea to include column headings)
2. Click on the inside tab, tarts group in click on the type of chart you want
3. Click on the type of variation you want and the chart you selected will be inserted

Question 2

How to edit a chart

Answer 2

1. Select the chart and the icons will appear at the top right side of the chart
2. Click on the chart elements icon
3. Half of the mouse over the element that you wish to add or change and then click on the arrow on the right
4. Choose the relevant option

Question 3

How to change the appearance of a chart

Answer 3

1. Click on the chart Styles icon (the paint brush). Options for changing the style and the color of the chart will appear
2. Click on your choice

Question 4

To insert a worksheet

Answer 4

Click on the plus sign next to the sheet

Question 5

How do you rename a worksheet

Answer 5

Right click on the tab and choose rename

Question 6

How do you delete a worksheet

Answer 6

Right click on the tab and choose delete

Question 7

What does the function sum do and what is the formula for it

Answer 7

Sum adds the values of all cells in the range
The formula is =SUM(A2: A10)

Question 8

What does the MIN function do and what is the formula for it

Answer 8

Compares the values in the range and gives you the smallest/lowest
=MIN(A1:A15)

Question 9

What does the MAX function do and what is the formula for it

Answer 9

Compare the values in the Range and Returns the maximum/highest/largest value

=MAX(B2: B10)

Question 10

What does the AVERAGE function do and what is the formula for it

Answer 10

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)

Question 11

What does the Count function do and what is the formula for it

Answer 11

Count the number of cells in a range that contain numeric values and the formula is =COUNT(A2: A20)

Question 12

What does the COUNTA function do and what is the formula for it

Answer 12

Count the number of cells in the Range that contain anything and the formula is =COUNTA(C5: C10)

Question 13

What does the COUNTBLANK function do and what is the formula for it

Answer 13

Comes the number of cells in a range that do not contain anything and the formula is =(B15:B20)

Question 14

What does the ROUND function do and what is the formula for it

Answer 14

Around the value in a cell to a specified number of decimal places and the formula is =ROUND(A6,1)

Question 15

What does the COUNTIF function do and what is the formula for it

Answer 15

Count the number of cells in a range that meet a certain condition and the formula is =COUNTIF(C5:C20,”M”)

Question 16

Ways to troubleshoot formulas and functions

Answer 16

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

Question 17

How to set or clear a print area

Answer 17

1. Select the range of cells that you want to set up as the print area
2. Click on the page layout tab, page setup group, print area, set printer area.