Question 1

Question 1A university student uses a PC to help plan a budget for the first term. Their first attempt is shown below.(a) Tick one box to show which type of software package has been used.Tick one box onlyGraphicsDatabaseSpreadsheetMultimedia(b) Which cell contains the spending on rent per week ?(c) Which one of the following is the formula used in cell D23 ?Tick one box only= D21 - D8= D8 - D21= sum(D2 : D12)(d) Tick one box to show a disadvantage of using a software package to help work out the budget rather than using a calculator, pen and paper.Tick one box onlyThe formulae could be wrongThe wrong prices could be inputA virus may corrupt the informationMultiple printouts could be produced

Accepted Answer

(a)Tick one box onlyGraphicsDatabaseSpreadsheet✓Multimedia(b) D12(c)Tick one box only= D21 - D8= D8 - D21✓= sum(D2 : D12)(d)Tick one box onlyThe formulae could be wrongThe wrong prices could be inputA virus may corrupt the information✓Multiple printouts could be produced

Question 2

Question 2A self-employed car mechanic uses a spreadsheet to calculate bills for customers.(a) The mechanic made a mistake when entering the cost of an air filter. An air filter costs Rs. 400.00.Complete the sentences using words from this list.C7 ; copy ; D8 ; D7 ; rename ; highlight(i) The mechanic can change the cost of an air filter by editing cell .................. .(ii) The mechanic should .................. the cell and enter the new cost.(b) Give the cell references of two cells that should change automatically when the cost of an air filter is changed.(c) Cells can contain numbers or text.Tick three boxes to show other types of information a cell can contain.Tick three boxesPrinterWebsite addressIdeaFormulaPictureWord processor(d) On-line help is available within the spreadsheet.Tick three boxes to show what should be in the on-line help for the spreadsheet.Tick three boxesA lesson on percentages so the mechanic can calculate VATAn index to help the mechanic find the information neededA road map to help the mechanic find the route to the parts warehouseA tutorial guide to help the mechanic use the spreadsheetA dictionary that helps the mechanic understand the meaning of wordsA search engine to help the mechanic find the information needed(e)(i) The mechanic has to buy the air filter from an on-line store.Write the labels in order to show how the mechanic can do this.LabelAPay using a credit cardBEnter the key words: air filter, and press the search buttonCGo to the on-line store using a web browserDLook at the search results and find the right air filter(ii) The mechanic uses a search engine to find where to buy the air filter.State two reasons why the mechanic might search only websites in the India.(f) The mechanic gives customers a credit rating from 1 to 3.Credit Rating1Pays promptly and in full on collecting the car2Pays within four weeks of collecting the car3Money still owed after four weeksA customer who pays after four weeks is given the same credit rating as a customer who does not pay.(i) Describe one limitation of this coding system designed in OOo Calc.(ii) Design an improved coding system, if possible.

Accepted Answer

(a)(i) The mechanic can change the cost of an air filter by editing cell C7.(ii) The mechanic should highlight the cell and enter the new cost.(b) The two cells that should change automatically when the cost of an air filter is changed are C10 and C11.(c)Tick three boxesPrinterWebsite address✓IdeaFormula✓Picture✓Word processor(d)Tick three boxesA lesson on percentages so the mechanic can calculate VATAn index to help the mechanic find the information needed✓A road map to help the mechanic find the route to the parts warehouseA tutorial guide to help the mechanic use the spreadsheet✓A dictionary that helps the mechanic understand the meaning of wordsA search engine to help the mechanic find the information needed✓(e)(i) The mechanic can buy an air filter in the following manner:C — Go to the on-line store using a web browserB — Enter the key words: air filter, and press the search buttonD — Look at the search results and find the right air filterA — Pay using a credit card(ii) Two reasons the mechanic might search only websites in the India are :Local Compatibility — Searching for websites within India ensures that the mechanic finds options that are specifically designed to fit vehicles commonly used in the Indian market.Get the best price and faster delivery — By focusing on websites within India, the mechanic will avoid import duties so he can get the air filter at the best price. Also shipping time from suppliers within India will be less compared to overseas suppliers.(f)(i) One limitation of the coding system described in the scenario is that it lacks differentiation between different levels of late payments. In this system, both a customer who pays after four weeks and a customer who doesn't pay at all are given the same credit rating of 3. It fails to distinguish between a customer who eventually pays but is consistently late and a customer who doesn't pay at all.(ii) An improved coding system could address this limitation by incorporating more levels of credit ratings to reflect different degrees of payment behavior. Here's a possible improved coding system:New Credit RatingDescription1Pays promptly and in full on collecting the car2Pays within two weeks of collecting the car3Pays within four weeks of collecting the car4Pays within six weeks of collecting the car5Pays after six weeks but within two months6Money still owed after two months

Question 3

Question 3A customer downloads a bank account statement from an online bank.The statement is downloaded into a spreadsheet.(a) Tick three boxes to show what can be contained in a cell in a spreadsheet.Tick three boxesA mouseA dateA numberA websiteA pictureA word processor(b) The cell reference of the cell which contains 'Balance brought forward' is B3.Write down the cell reference of the cell which contains .'Gas Company'.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 boxesControlling output from a scannerDrawing a picture of the car you want to buyCalculating mortgage repaymentsWriting to the bank managerModelling future spendingDisplaying 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.LabelAPosition the cursor in the word processorBSelect copyCSelect pasteDHighlight 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 only150 Megabytes80 Gigabytes15 Kilobytes10 bytes0 bytes

Accepted Answer

(a)Tick three boxesA mouseA date✓A number✓A websiteA picture✓A word processor(b)The cell which contains 'Gas Company' is B5.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 boxesControlling output from a scannerDrawing a picture of the car you want to buyCalculating mortgage repayments✓Writing to the bank managerModelling 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 spreadsheetB — Select copyA — Position the cursor in the word processorC — 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 only150 Megabytes80 Gigabytes15 Kilobytes✓10 bytes0 bytes

Question 4

Question 4A finance officer uses a spreadsheet to record sales from an equipment shop. This is part of the spreadsheet.(a)LabelFormulaLabelFormulaA=SUM(D4 : D10)D=SUM(D4 : D8)B=B7 * C7E=A7 * B7 * C7C=C6 * D6Write the label of the formula in cell D7.Write the label of the formula in cell D10.(b) The price of a generator is reduced to 4000.00.Describe how the spreadsheet should be edited.When the spreadsheet was edited, the values displayed in some cells changed automatically. Write in the box the cell reference of two cell that changed automatically.Tick one box to show why a cell would change automatically when another cell is edited.Tick one box onlySpreadsheet cells are all linkedThe cell contains a formula that refers to the other cellAll the cells know what is happening in other cellsThe cell contains a description that refers to the other cellThe spreadsheet contains a graph

Accepted Answer

(a)The label of the formula in cell D7 is B.The label of the formula in cell D10 is D.(b)To edit the price of the generator, follow the given steps:Step 1 — Select cell B6.Step 2 — Type '4000' in the cell. The previous value (5000) will be overwritten.The formula of cell D6 (= B6 * C6) will automatically update the sales value in the spreadsheet.D6 and D10.Reason for cell updating automatically:Tick one box onlySpreadsheet cells are all linkedThe cell contains a formula that refers to the other cell✓All the cells know what is happening in other cellsThe cell contains a description that refers to the other cellThe spreadsheet contains a graph

Question 5

Question 1In OOo Calc formula starts with ............... .+[= sign]-*

Accepted Answer

[= sign]Reason — In OOo Calc formula starts with equal to ( = ) sign.

Question 6

Question 2The cell having bold boundary is the ............... cell.LastNextFirstActive

Accepted Answer

ActiveReason — The cell having bold boundary is the active cell.

Question 7

Question 3In ............... referencing the relative address of the cell gets adjusted w.r.t. the current cell.RelativeAbsoluteMixedNil

Accepted Answer

RelativeReason — In relative referencing the relative address of the cell gets adjusted w.r.t. the current cell.

Question 8

Question 4To create an absolute cell reference ............... sign is used before the parts of formula.$ sign#^%

Accepted Answer

$ signReason — To create an absolute cell reference $ sign is used before the parts of formula.

Question 9

Question 5Calc worksheets are given ............... extension..odf[= sign].ods.odw

Accepted Answer

.odsReason — Calc worksheets are given .ods extension.

Question 10

Question 6Cell address A4 in a formula means it is a :Mixed cell referenceAbsolute cell referenceRelative cell referenceNone of the above

Accepted Answer

Relative cell referenceReason — Cell address A4 in a formula means it is a Relative cell reference as in this cell referencing technique, the cells are referred to by their relative position in the worksheet.

Question 11

Question 7Cell address $A$4 in a formula means it is a :Mixed cell referenceAbsolute cell referenceRelative cell referenceAll the above.

Accepted Answer

Absolute cell referenceReason — Cell address $A$4 in a formula means it is an Absolute cell reference because the use of $ sign makes the column and row absolute, i.e., the address will not change when the formula is copied to any other cell.

Question 12

Question 8Cell address $A4 in a formula means it is a :Mixed cell referenceAbsolute cell referenceRelative cell referenceAll the above.

Accepted Answer

Mixed cell referenceReason — Cell address $A4 in a formula means it is a Mixed cell reference because the column A is absolute while the row 4 is relative. Thus, when the formula is copied to any other location, the column will remain the same while the row will change.

Question 13

Question 9Cell address A$4 in a formula means it is a :Mixed cell referenceAbsolute cell referenceRelative cell referenceNone of the above

Accepted Answer

Mixed cell referenceReason — Cell address A$4 in a formula means it is a Mixed cell reference because the column A is relative while the row 4 is absolute. Thus, when the formula is copied to any other location, the column will change while the row will remain the same.

Question 14

Question 10How would you refer to the range starting from 1st column, 1st row and spread till 6th column and 3rd row ?[E3 : A1][A1 : E3][I6 : A1][A1 : F3]

Accepted Answer

[A1 : F3]Reason — The cell address of 1st column, 1st row is A1 and the cell address of 6th column and 3rd row is F3. Since a range is specified by giving the addresses of the first cell and the last cell in the range, the range will be referred as [A1 : F3].

Question 15

Question 11The keyboard shortcut for Copy is ................ and for Paste is ................. .Ctrl + CCtrl + XCtrl + ACtrl + V

Accepted Answer

Ctrl + C, Ctrl + VReason — The keyboard shortcut for Copy is Ctrl + C and for Paste is Ctrl + V.

Question 16

Question 12When you ................. or ................. , the selected range gets surrounded by a moving border.Copy, PasteCopyCutCut, Paste

Accepted Answer

Copy, CutReason — When you copy or cut, the selected range gets surrounded by a moving border.

Question 17

Question 13The ............... operation copies data from the source range to target range and erases it from the source range.Cut and CopyCut, Copy and PasteCopy and PasteCut and Paste

Accepted Answer

Cut and PasteReason — The Cut and Paste operation copies data from the source range to target range and erases it from the source range.

Question 18

Question 14If you enter 12 + 24 in a cell, Calc will display ...............36A12 + A24A12 : A2412 + 24

Accepted Answer

12 + 24Reason — If we enter 12 + 24 in a cell, Calc will treat it as text and display it as it is i.e., 12 + 24 and not 36.

Question 19

Question 15Address of the cell at 20th column and 30th row is ............... .T20T3020, 3030T

Accepted Answer

T30Reason — Address of the cell at 20th column and 30th row is T30 because this cell is formed by the intersection of column T and row 30.

Question 20

Question 16The formula in cell A2 is = B2 + C3. On copying this formula to cell C2, the formula in cell C2 will be ................. .= B2 + C3= C3 + B2= D2 + E3= E3 + D2

Accepted Answer

= D2 + E3Reason — When we copy the formula from cell A2 to cell C2, Calc adjusts the relative cell references in the formula based on the new location. When we copy the original formula "= B2 + C3" to cell C2, Calc will adjust the formula to "= D2 + E3", where it shifts the column references by 2 columns to the right and keeps the row references the same.

Spreadsheet Tool : OO Calc I

Application Oriented Questions

Objective Type Questions

Theoretical Questions