A shoe shop uses a software package for calculating shoe sales.
) State the
of application package being used.
) State how cell D7 has been formatted.
) (i) The Total Cost is calculated by multiplying the Price and the
State a suitable formula for cell F7.
(ii) A similar formula is needed in cells F8 and F9.
Name a feature of the application which should be used to do this.
Down at Heel
) The number of boots in cell E9 has changed to 6.
other cell that would automatically change when this number is
) The SUM function has been used in cell F11.
What does this function do?
Finds the largest value in a range of cells.
Multiplies the values of a range of cells.
Adds the values of a range of cells.
Finds the average of the values of a range of cells.
) The staff have decided they need to include the colour of the shoes in their
This information must be displayed between Size and Price.
Describe how this change would be made.
(g) Staff are trained by listening to an audio file on an MP3
item of hardware required to
Tracey is studying art at college. Her designs combine a mixture of hand drawn
and computer drawn shapes.
) She creates the following shape in a graphics package.
(i) Identify the tool used to make this shape.
(ii) Tracey would like to edit her graphic as shown below.
operations which have been carried out on the picture.
(iii) She copies her original single leaf three times and creates the following
When she clicks on the graphic it can be moved as one shape.
Describe what she has done to make her new graphic into a single shape.
) Tracey has to demonstrate her artwork to the whole college. Below are two
pages from her multimedia presentation.
(i) Tracey wants every page to have a similar layout. She uses a feature of
the package to do this.
Name this feature.
(ii) Tracey used an input device to enter her hand drawn artwork into the
State the type of input device Tracey used.
(iii) During the presentation, once the slide has appeared, the slide title
disappears slowly, allowing her artwork to fill the screen.
State the text effect used on her titles.
(iv) State the most appropriate output device to display her presentation to
the whole college.