Bright Tutorials Bright Tutorials
CBSE Class 9 Computer Applications Question 3 of 53

Spreadsheet Tool : OO Calc I — Question 3

Back to all questions
3
Question

Question 3

A customer downloads a bank account statement from an online bank.

The statement is downloaded into a spreadsheet.

A customer downloads a bank account statement from an online bank. Tick three boxes to show what can be contained in a cell in a spreadsheet. Spreadsheet Tool: OO Calc, Computer Applications Code 165 Sumita Arora Solutions CBSE Class 9.

(a) Tick three boxes to show what can be contained in a cell in a spreadsheet.

Tick three boxes
A mouse
A date
A number
A website
A picture
A word processor

(b) The cell reference of the cell which contains 'Balance brought forward' is B3.

  1. Write down the cell reference of the cell which contains .'Gas Company'.
  2. Write down the cell reference of the cell which contains .'Paid out'.

(c) Tick one box to show the formula contained in cell E6.

Tick one box only
=E6 + C6 + D6
=E5 - C6 + D6
=D5 + D6 + D7
=E5 * C6 * D6
=E5 + C5 + D5

(d) Tick one box to show the formula contained in cell E9.

Tick one box only
=E8
=E8 - C8 + D8
=E7 * C8 * D8
=E8 + D8
=E8 - C8

(e) (i) Tick three boxes to show what a spreadsheet should be used for.

Tick three boxes
Controlling output from a scanner
Drawing a picture of the car you want to buy
Calculating mortgage repayments
Writing to the bank manager
Modelling future spending
Displaying the balance carried forward each month of the year in a graph

(ii) State one other task a spreadsheet can be used for.

(f) The customer is using a word processor to fill in a tax return.

The customer needs to copy the monthly interest into the tax return.

Write down the labels in order to show how cell D7 could be copied into the tax return.

Label
APosition the cursor in the word processor
BSelect copy
CSelect paste
DHighlight D7 in the spreadsheet

(g) The customer saves the statement on a flash memory stick. Give one reason why this may not be secure and suggest a way to make the statement more secure.

(h) Tick one box to show how much space the spreadsheet file (.ods) is likely to use on backing storage.

Tick one box only
150 Megabytes
80 Gigabytes
15 Kilobytes
10 bytes
0 bytes
Answer

(a)

Tick three boxes
A mouse
A date✓
A number✓
A website
A picture✓
A word processor

(b)

  1. The cell which contains 'Gas Company' is B5.
  2. The cell which contains 'Paid out' is C2.

(c) Formula contained in cell E6:

Tick one box only
=E6 + C6 + D6
=E5 - C6 + D6✓
=D5 + D6 + D7
=E5 * C6 * D6
=E5 + C5 + D5

(d) Formula contained in cell E9:

Tick one box only
=E8✓
=E8 - C8 + D8
=E7 * C8 * D8
=E8 + D8
=E8 - C8

(e)

(i) A spreadsheet should be used for:

Tick three boxes
Controlling output from a scanner
Drawing a picture of the car you want to buy
Calculating mortgage repayments✓
Writing to the bank manager
Modelling future spending✓
Displaying the balance carried forward each month of the year in a graph✓

(ii) Spreadsheet can also be used to compute and manage student grades for academic purposes.

(f) To copy the monthly interest from cell D7 into the tax return, follow the given steps:

D — Highlight D7 in the spreadsheet
B — Select copy
A — Position the cursor in the word processor
C — Select paste

(g) Storing a bank statement on a flash memory stick may not be secure due to the risk of physical loss or theft. If the memory stick is misplaced or stolen, unauthorized individuals could gain access to sensitive financial information.

To make the statement more secure, use password protection. To set a password for an OOo Calc document, follow the given steps:

Step 1 — Open the statement in OOo Calc.
Step 2 — Go to "File" > "Save As."
Step 3 — In the "Save As" dialog box, check the "Save with password" option.
Step 4 — Enter and confirm your desired password.
Step 5 — Save the document.

(h) Space used by spreadsheet file (.ods) on backing storage:

Tick one box only
150 Megabytes
80 Gigabytes
15 Kilobytes✓
10 bytes
0 bytes