Loading....
|
Press & Hold to Drag Around |
|||
|
Click Here to Close |
|||
Question 1 Report
(a) What is a function in MS Excel?
(b) List two categories of functions in MS Excel.
(c) What is the cell referencing in MS Excel.
(d)(i) State two types of cell referencing in MS Excel.
(ii) Give one example of each type in 1(d)(i)
This question tests understanding of functions and cell referencing in Microsoft Excel.
(a) A function in MS Excel. A function is a built-in, predefined formula that performs a specific calculation on given values (called arguments) and returns a result, for example \( =SUM(A1:A10) \) adds the values in the range.
(b) Two categories of functions. Examples include mathematical/arithmetic functions (such as SUM, PRODUCT) and statistical functions (such as AVERAGE, MAX, MIN, COUNT). Other acceptable categories are logical (IF, AND), date and time, and text functions.
(c) Cell referencing. Cell referencing is the way of identifying and using a cell (or range of cells) in a formula by its address, that is its column letter and row number, such as B4 or A1:A10, so that the formula uses the value stored there.
(d)(i) and (ii) Two types of cell referencing, with an example of each.
(A third type, mixed referencing, fixes only the row or only the column, e.g. \( =A\$1 \) or \( =\$A1 \).)
Examination reminder: the dollar sign is what makes a reference absolute; without it a reference is relative and will shift when the formula is filled or copied.
Answer Details
This question tests understanding of functions and cell referencing in Microsoft Excel.
(a) A function in MS Excel. A function is a built-in, predefined formula that performs a specific calculation on given values (called arguments) and returns a result, for example \( =SUM(A1:A10) \) adds the values in the range.
(b) Two categories of functions. Examples include mathematical/arithmetic functions (such as SUM, PRODUCT) and statistical functions (such as AVERAGE, MAX, MIN, COUNT). Other acceptable categories are logical (IF, AND), date and time, and text functions.
(c) Cell referencing. Cell referencing is the way of identifying and using a cell (or range of cells) in a formula by its address, that is its column letter and row number, such as B4 or A1:A10, so that the formula uses the value stored there.
(d)(i) and (ii) Two types of cell referencing, with an example of each.
(A third type, mixed referencing, fixes only the row or only the column, e.g. \( =A\$1 \) or \( =\$A1 \).)
Examination reminder: the dollar sign is what makes a reference absolute; without it a reference is relative and will shift when the formula is filled or copied.
Question 2 Report
Ciroma Chukwuma Adekunle has just opened a computer business centre within a school environment.
(a) State three computer services that may be provided in the business center
(b) List three devices required in the business centre
(c) Give two applications software needed in the business centre.
(d) Outline two precautions that must be taken by Ciroma Chukwuma Adekunle to ensure the safety of this computer if he accepts documents in movable devices from his customers.
This scenario tests knowledge of the services, devices and software of a computer business centre and of protecting a computer from infected removable media.
(a) Three computer services in the business centre.
(b) Three devices required. A computer (PC), a printer, and a scanner (a photocopier, UPS or modem/router are also acceptable).
(c) Two application software needed. A word processor (for example Microsoft Word) and a web browser (for example Google Chrome); a spreadsheet or graphics package is also acceptable.
(d) Two precautions when accepting documents on movable devices.
Examination reminder: the danger from customers' movable devices is malware; the correct precautions are antivirus scanning and disabling autorun, not physical handling.
Answer Details
This scenario tests knowledge of the services, devices and software of a computer business centre and of protecting a computer from infected removable media.
(a) Three computer services in the business centre.
(b) Three devices required. A computer (PC), a printer, and a scanner (a photocopier, UPS or modem/router are also acceptable).
(c) Two application software needed. A word processor (for example Microsoft Word) and a web browser (for example Google Chrome); a spreadsheet or graphics package is also acceptable.
(d) Two precautions when accepting documents on movable devices.
Examination reminder: the danger from customers' movable devices is malware; the correct precautions are antivirus scanning and disabling autorun, not physical handling.
Question 3 Report
(a) State the keyboard shortcut keys to;
(i) rotate an object in CorelDraw
(ii) position an object in CorelDraw
(iii) navigate to cell A1 in MS Excel worksheet
(b) Give one reason for including the plus sign (+) in the search text in a search engine.
(c) With the aid of diagrams, differentiate between LAN and WAN.
This question tests keyboard shortcuts, search-engine syntax, and the difference between LAN and WAN.
(a) Keyboard shortcuts.
(b) The plus sign (+) in search text. Placing a plus sign before a word tells the search engine that the word must be included in every result, narrowing the search to pages that contain that exact term.
(c) LAN versus WAN (with diagrams).
| Feature | LAN (Local Area Network) | WAN (Wide Area Network) |
|---|---|---|
| Coverage | Small area: one building or site | Very large area: cities, countries, worldwide |
| Ownership | Usually owned by one organisation | Often uses public/leased links, many owners |
| Speed | Higher data-transfer speed | Generally lower speed |
| Example | Office or school network | The Internet |
Simple sketches you should draw: a LAN as a few computers linked to one central switch/hub in a single room; a WAN as two or more such LANs in different towns joined by routers and a long-distance link (for example over the Internet).
Examination reminder: the single most important difference is geographical coverage - LAN is confined to one site, WAN spans large distances. The exam expects a labelled sketch, so always draw and label the nodes and the connecting link.
Answer Details
This question tests keyboard shortcuts, search-engine syntax, and the difference between LAN and WAN.
(a) Keyboard shortcuts.
(b) The plus sign (+) in search text. Placing a plus sign before a word tells the search engine that the word must be included in every result, narrowing the search to pages that contain that exact term.
(c) LAN versus WAN (with diagrams).
| Feature | LAN (Local Area Network) | WAN (Wide Area Network) |
|---|---|---|
| Coverage | Small area: one building or site | Very large area: cities, countries, worldwide |
| Ownership | Usually owned by one organisation | Often uses public/leased links, many owners |
| Speed | Higher data-transfer speed | Generally lower speed |
| Example | Office or school network | The Internet |
Simple sketches you should draw: a LAN as a few computers linked to one central switch/hub in a single room; a WAN as two or more such LANs in different towns joined by routers and a long-distance link (for example over the Internet).
Examination reminder: the single most important difference is geographical coverage - LAN is confined to one site, WAN spans large distances. The exam expects a labelled sketch, so always draw and label the nodes and the connecting link.
Question 4 Report
A school decides to harmonize the operation of its two campuses using a distributed database system as well as install air conditioners and uninterrupted power supply in the computer laboratory.
(a) State three (i) Importance of using distributed database (ii) disadvantages of using computer processing information in the school
(b) Give two reasons for installing the; (i) air conditioners (ii) uninterrupted power supply devices
This scenario tests the merits and demerits of distributed databases and the reasons for laboratory air-conditioning and a UPS.
(a)(i) Three importances of a distributed database.
(a)(ii) Three disadvantages of using computer processing of information.
(b)(i) Two reasons for installing air conditioners. To keep the equipment cool and prevent overheating that damages components, and to control humidity and dust, providing a comfortable environment for users and stable operation.
(b)(ii) Two reasons for installing a UPS (uninterruptible power supply). To provide backup power so the computers keep running during a power cut, and to protect equipment and unsaved data from sudden power failure and voltage fluctuations by allowing a safe, orderly shutdown.
Examination reminder: tie each reason to a consequence - air conditioning prevents overheating; a UPS prevents data loss and damage from power cuts. State the benefit, not just the device.
Answer Details
This scenario tests the merits and demerits of distributed databases and the reasons for laboratory air-conditioning and a UPS.
(a)(i) Three importances of a distributed database.
(a)(ii) Three disadvantages of using computer processing of information.
(b)(i) Two reasons for installing air conditioners. To keep the equipment cool and prevent overheating that damages components, and to control humidity and dust, providing a comfortable environment for users and stable operation.
(b)(ii) Two reasons for installing a UPS (uninterruptible power supply). To provide backup power so the computers keep running during a power cut, and to protect equipment and unsaved data from sudden power failure and voltage fluctuations by allowing a safe, orderly shutdown.
Examination reminder: tie each reason to a consequence - air conditioning prevents overheating; a UPS prevents data loss and damage from power cuts. State the benefit, not just the device.
Would you like to proceed with this action?