1.
The
spreadsheet
below shows an order placed with the Delicious Delights Cake
Company.
(
a
)The
cell protection
feature of the spreadsheet package is used frequently.
(i) State what is meant by “cell protection”.
(ii) Name
one
cell in the above spreadsheet it would be sensible to
protect.
(
b
) The
formula
to calculate the cost of Fairy Cakes is in cell D7.
State the
range
of cells this formula has been replicated into.
1
A
B
C
D
1
Delicious Delights Cake Company
2
3
Invoice Number
8767
4
5
Item
Number
Price per cake
Cost
6
7
Fairy Cakes
36
£0·35
£12·60
8
Tiffin
72
£0·45
£32·40
9
Pineapple Cakes
50
£0·60
£30·00
10
Date Slices
40
£0·75
£30·00
11
Flapjacks
80
£0·50
£40·00
12
Custard Creams
40
£0·60
£24·00
13
14
Total Cost
£169·00
15
Discount
£16·90
16
Final Cost
£152·10
1. (continued)
(
c
) State the type of referencing used when the formula in D7 was replicated.
State
one
reason for your answer.
Type of referencing
Reason
(
d
) The discount is calculated as follows.
If the Total Cost of the order is greater than £100 then a discount of 10%
is given. If not, they do not get a discount.
State the formula that was entered in cell D15.
= IF ( , , )
(
e
) State the formula that was entered in cell D16 to calculate the Final Cost.
Page three
2
2.
Hannah has just finished taking part in a work
experience programme at school. She has to write a two
page report describing what she has enjoyed most.
(
a
) Hannah notices that her report is spread over three
pages.
State
two
ways that Hannah can ensure her report is only two pages long.
1
2
(
b
) When editing her report Hannah makes regular use of the
toolbar
and
keyboard shortcuts
.
(i) State what is meant by the term “toolbar”.
(ii) State
one
advantage to Hannah of using keyboard shortcuts.
(
c
) Before saving her report Hannah adds her name and date as a
footer
.
Explain what is meant by the term “footer”.
Page four
1
[0560/403]
1
2. (continued)
(
d
) She decides to
e-mail
a copy of the report to the company she was working
with.
State what you call a file that is sent along with an e-mail.
(
e
) When the company opens Hannah’s file they find they cannot read it.
State
one
reason why they cannot read the file.
Page five
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!
