1.
A shoe shop uses a software package for calculating shoe sales.
(
a
) State the
type
of application package being used.
(
b
) State how cell D7 has been formatted.
(
c
) (i) The Total Cost is calculated by multiplying the Price and the
Number Sold.
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.
Page two

1
1
1
1
A
B
C
D
E
F
1
Down at Heel
2
3
4
Daily Takings
5
Date
25/04/2010
6
Item Number
Description
Size
Price
Number
Sold
Total
cost
7
3245
leather boot
5
£45·99
6
£275·94
8
6543
strap sandal
7
£25·67
10
£256·70
9
4312
check boot
4
£36·98
4
£147·92
10
11
Total
£680·56
Page three

1. (continued)
(
d
) The number of boots in cell E9 has changed to 6.
Name
one
other cell that would automatically change when this number is
entered.
(
e
) The SUM function has been used in cell F11.
What does this function do?
Tick (
?
)
one
box.
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.
(
f
) The staff have decided they need to include the colour of the shoes in their
sales sheet.
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
player.
State
one
item of hardware required to
record
the audio
training file.
[Turn over
3.
Tracey is studying art at college. Her designs combine a mixture of hand drawn
and computer drawn shapes.
(
a
) She creates the following shape in a graphics package.
(i) Identify the tool used to make this shape.
Tick (
?
)
one
box.
(ii) Tracey would like to edit her graphic as shown below.
Name the
two
operations which have been carried out on the picture.
1
2

Original graphic
Edited graphic

3. (
a
) (continued)
(iii) She copies her original single leaf three times and creates the following
graphic.
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.
(
b
) 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.
  
  
    
    
  
  
  
  
  
  




3. (
b
) (continued)
(ii) Tracey used an input device to enter her hand drawn artwork into the
computer.
State the type of input device Tracey used.
Tick (
?
)
one
box.
Keyboard
Scanner
Web cam
Modem
(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.

You Want A Similar Paper Done? Don’t be stressed, Click Here To Order this essay!!!

ScholarMatic: Explanation & Answer

Your ready answer from a verified tutor is just a click away for as little as $14.99

---

  

Click Order Now to get 100% Original Answer Customized to your instructions!