WAEC SSCE - Computer Studies - 2021

The "/exams"in the web address; https;//www.waec.org.ng/exams is called 

Antwoorddetails

Which of the following descriptions is not true about data?

Antwoorddetails

The statement "data is unorganized" is not true. Data can be either organized or unorganized. Data refers to a collection of raw facts and figures that have not been processed or analyzed. However, this data can be organized into a more meaningful format, such as tables, charts, or graphs, that can make it easier to understand and analyze. Once data is organized and analyzed, it can be converted into information, which is used for decision making. Therefore, all the other descriptions are true: data can be converted to information, it is a collection of raw facts and figures, and it is used for decision making.

The part of the MS Access interface labelled X in Figure 9 is called 

Antwoorddetails

The part of the MS Word interface labelled II in Figure 10 is called 

Antwoorddetails

The part of the MS Word interface labelled II in Figure 10 is called "Print Layout". This option allows users to view their document as it would appear on a printed page. It shows page margins, page breaks, headers and footers, and other elements that are important for formatting a printed document. Users can use this view to make sure their document looks the way they want it to before printing.

In Figure 6 the signals from modem X to modem Y is 

Antwoorddetails

The correct answer is either "analogue" or "digital," depending on the type of signal being transmitted. Analog signals are continuous, meaning they can take on any value within a range of values, whereas digital signals are discrete, meaning they can only take on specific, predetermined values. Without more information or context about the specific signals being transmitted in Figure 6, it is impossible to determine whether the signals are analogue or digital. However, it is safe to assume that they are one of these two types, as these are the most common types of signals used for communication between modems. In summary, the answer to the question "In Figure 6 the signals from modem X to modem Y is?" is either "analogue" or "digital," depending on the type of signal being transmitted.

Which of the following statements about URL is true? It is

Antwoorddetails

The statement that is true about URL is that it is "the address of a document or 'page' on the World Wide Web". URL stands for Uniform Resource Locator and it is a reference to the web resource that specifies its location on the internet. In simpler terms, a URL is the web address of a specific page or document on the internet. URLs consist of several parts, including the protocol (such as http or https), the domain name or IP address of the server where the resource is located, and the path to the specific file or document. The other options are not true about URL. A URL is not a computer software program, a type of web server, or an acronym for unlimited resources for learning.

In MS Excel, the cell that contains the pointer or cursor is called

Antwoorddetails

The cell in MS Excel that contains the pointer or cursor is called the "Active Cell". An active cell is the cell that is currently selected and ready to accept input. It is the cell in which you can type or edit data. The active cell is surrounded by a border and is the cell that is currently in use in the worksheet. This makes it easy to identify and is the cell that will be affected by any actions you take in the worksheet.

What is the least number of 750 MB capacity CD-ROM discs needed to transfer 10 GB size file?

Antwoorddetails

To transfer a 10 GB file, you need to find out how many 750 MB CD-ROM discs you would need. Each CD-ROM has a capacity of 750 MB, so you need to divide 10 GB by 750 MB to find out the number of discs required. 10 GB / 750 MB = 13.333 Since you can't have a fraction of a CD, you would need to round up to the nearest whole number. Therefore, you would need 14 CD-ROM discs to transfer a 10 GB file.

Which of the following statements is true about super computers? They

Antwoorddetails

The statement that is true about supercomputers is that they can process billions of operations in a second. Supercomputers are designed to perform complex and sophisticated computations that are beyond the capabilities of regular computers. They are capable of processing enormous amounts of data and performing multiple calculations simultaneously, which allows them to solve complex problems that regular computers cannot. However, they are typically large, expensive machines that are used in specialized fields such as scientific research, engineering, and weather forecasting, among others. They are not commonly found in homes and offices due to their high cost and specialized nature.

Use figure 4 to answer question 23

The basic problem with the flow chart is that it has 

Antwoorddetails

The logical equation for the logic circuit in Figure 3 is

Antwoorddetails

The logic circuit in Figure 3 has two inputs, A and B, and one input C. The output is Z. Looking at the circuit, we can see that the input C is connected directly to the output Z. This means that the value of C will always be present in the output Z, regardless of the values of A and B. The two inputs A and B are connected to an OR gate, and the output of the OR gate is connected to a NOT gate. The NOT gate inverts the output of the OR gate, which means that if the OR gate output is 0 (i.e., A and B are both 0), then the NOT gate output will be 1. Conversely, if the OR gate output is 1 (i.e., at least one of A or B is 1), then the NOT gate output will be 0. So, the overall logic equation for the circuit is: Z = \(\overline{A+B}\) \(\overline{C}\) In other words, the output Z is the logical NOT of the OR of A and B, ANDed with the logical NOT of C.

A single character in an EBCDIC encoding system can be represented using 

Antwoorddetails

A single character in an EBCDIC encoding system is represented using 8 bits. This means that each character is represented by a unique combination of 8 binary digits, or bits. 8 bits provides enough combinations to represent a wide range of characters, including letters, numbers, and special symbols. This allows EBCDIC to support a variety of character sets and languages, making it a flexible and widely-used encoding system.

A collection of wires through which data are transmitted from one part of the computer to another is known as 

Antwoorddetails

A collection of wires through which data are transmitted from one part of the computer to another is known as a bus. A bus is a set of wires that transfer data and information between different components in a computer. It acts like a highway for data to travel from one place to another within the computer. In simple terms, a bus is like a pathway that allows different parts of the computer to communicate and exchange information with each other.

The part of the graphic interface in Figure 8 labelled V is called 

Antwoorddetails

The part of the graphic interface labelled V in Figure 8 is called "fit to window". This option allows you to automatically adjust the size of the image or graphic to fit within the boundaries of the window or screen. For example, if you have an image that is too large to be displayed on your screen without scrolling or resizing, you can select the "fit to window" option and the image will be automatically scaled down to fit within the dimensions of the window or screen. This can be a helpful feature for working with large images or graphics, as it allows you to view them in their entirety without having to scroll or zoom in and out manually.

The binary number 0.1101 in decimal is 

Antwoorddetails

The use of natural language and symbols to write instructions for the computer is called

Antwoorddetails

The use of natural language and symbols to write instructions for the computer is called "high level language programming". High level programming languages use human-readable instructions and structures to write programs that can be understood by both humans and computers. Examples of high level programming languages include Python, Java, and C++. In contrast, machine language programming and assembly language programming use low level instructions and binary code that are difficult for humans to read and understand. Algorithm language programming is not a commonly used term in programming and may refer to the use of algorithms in programming, rather than a specific language.

The total possible combinations of th input variables for a logic gate containing three input variables is 

Antwoorddetails

Use the logic gate in Fig 2 to answer question 12.

Which of the logic gates will give an output opposite to the input state?

Antwoorddetails

To prevent unforeseen data loss, a user must 

Antwoorddetails

To prevent data loss, a user must backup the data. This means making a copy of important files and storing them in a safe place, such as an external hard drive or cloud storage. This way, if the original data gets lost or damaged, the user still has a copy that they can use to restore the data.

Use Figure 4 to answer question 24

What activity is the flowchart made to represent?

Antwoorddetails

Changing the default settings or appearance of the Taskbar in windows by a user is known as 

Antwoorddetails

The correct answer is "customization." Customization refers to the process of changing the default settings or appearance of the Taskbar in Windows by a user. This can include changing the position of the Taskbar, resizing it, changing its color or transparency, and adding or removing icons. Customizing the Taskbar allows users to personalize their computing experience and make their workflow more efficient by tailoring the Taskbar to their specific needs and preferences.

The screen background where icons and windows are displayed is GUI is called 

Antwoorddetails

Which of the following options is not a similarity between computer file and manual file? Both can 

Antwoorddetails

The option that is not a similarity between a computer file and manual file is "store multimedia." Both computer files and manual files can be accessed and retrieved to obtain the information contained within them. A manual file might refer to a physical document or record, while a computer file is a digital representation of data stored on a computer system, but in both cases, the information can be retrieved and accessed. Both types of files can contain information, such as text, numbers, or images. However, manual files may be limited in the type of information they can store, as they are physical documents, while computer files can store a wide range of information, including multimedia like videos, audio, and animations. Therefore, while both types of files share similarities in terms of accessibility, retrieval, and information storage, the ability to store multimedia is a feature that is unique to computer files.

A computer system on the network that stores pages, takes request from clients as well as send out information is called a 

Antwoorddetails

A computer system on the network that stores web pages, takes requests from clients, and sends out information is called a "web server". A web server is a program or a computer that stores, processes, and delivers web pages to clients on request. When a user enters a website's URL into a web browser, the browser sends a request to the web server asking for the website's content. The web server then responds by sending the requested web pages and files to the user's web browser, which displays them on the screen. Web servers use protocols like HTTP (Hypertext Transfer Protocol) to communicate with clients and deliver web pages. Examples of web servers include Apache, Nginx, and Microsoft IIS.

The following actions are the effects of virus infection in a system except

Antwoorddetails

Virus infections can cause various harmful effects on a computer system, but among the given options, the action that is not an effect of virus infection is hard disk failure. A virus is a malicious software program that can infect a computer system, replicate itself and spread to other systems. Once a virus infects a system, it can cause various problems such as deleting files, slowing down the system's operation, and displaying unwanted messages. Deletion of files: A virus can delete important files or programs on a system, making it difficult or impossible to use certain applications or access certain data. Slow operation: A virus can consume a significant amount of a system's resources, which can cause the computer to operate slowly and inefficiently. This can cause frustration and hinder productivity. Display of unwanted messages: A virus can display pop-up messages or advertisements that are unwanted and can be distracting or harmful. These messages may also try to trick the user into downloading more harmful software. Hard disk failure: While a virus can cause data loss and corruption, it is not typically the direct cause of hard disk failure. Hard disk failure is usually due to physical damage or wear and tear over time. In summary, a virus infection can cause several negative effects on a computer system, including file deletion, slow operation, and display of unwanted messages. However, hard disk failure is not typically caused by a virus.

The part of the computer system shown in Figure 11 is used to 

Antwoorddetails

The part of the computer system shown in Figure 11 is used to power on or off the computer. The figure shows a power button symbol, which is typically used to turn on or off the computer. When you press the power button, the computer's power supply sends electricity to the motherboard, which then initializes the various components in the computer and starts up the operating system. Pressing and holding the power button for a few seconds can force the computer to shut down in case it's not responding or has frozen. Therefore, the power button is an essential component of any computer system, allowing users to turn it on and off as needed.

The figure 2 in the number 1101\(_2\) is indicated in MS Word using a feature called 

Antwoorddetails

The figure 2 in the number 1101\(_2\) is indicated in MS Word using the superscript feature. The superscript feature in MS Word is used to format text or numbers in a smaller font size and raised above the normal line of text. In this case, the superscript feature can be used to raise the number 2 above the rest of the binary number 1101, indicating its position as the second power or exponent of the base number 2. Therefore, to indicate the number 2 in the binary number 1101\(_2\) using MS Word, you can type "1101^2" where the superscript feature is used to raise the number 2. The resulting output will be "1101²" with the 2 raised and in a smaller font size.

The windows shortcut key for closing an active application is

Antwoorddetails

The windows shortcut key for closing an active application is Alt+F4. When you press the Alt+F4 keys on your keyboard, it sends a signal to the currently active application that you want to close it. This can be useful when you want to quickly exit a program that you are no longer using. The Alt+F4 shortcut is designed to work with most applications in Windows, including web browsers, text editors, and media players. When you press Alt+F4, the program will usually ask if you want to save any changes you've made before closing. It's important to note that Alt+F4 will only close the active application, which means that if you have multiple programs open, you'll need to switch to each one and press Alt+F4 individually to close them. In summary, Alt+F4 is a simple and convenient shortcut key that can help you quickly close applications in Windows.

The type of network represented in Figure 7 is called 

Antwoorddetails

The sequence of operation of a computer is 

Antwoorddetails

The sequence of operation of a computer is as follows: 1. Input: The computer accepts data or information from input devices such as a keyboard, mouse, microphone, or scanner. 2. Processing: The computer processes the input data by performing operations on it using its central processing unit (CPU), memory, and other components. The processing involves performing arithmetic and logical operations on the data, manipulating it, and storing it in memory. 3. Output: After processing the data, the computer produces output in the form of information or results. The output can be displayed on a screen, printed on paper, or sent to other devices such as a speaker or a network. In summary, the sequence of operation of a computer involves accepting input data, processing it using the CPU and memory, and producing output in the form of information or results.

The expression 5 + 3*4/2 - 3^2 in QBASIC evaluate to

Antwoorddetails

The IF... THEN statement in BASIC is called 

Antwoorddetails

The device is Figure 5 uses a transmission method called 

Antwoorddetails

A computer program that gathers information about a person or organization without their knowledge or consent  is known known as

Antwoorddetails

Spyware is specifically designed to covertly collect information about a person or organization without their knowledge or consent. Unlike adware, which displays advertisements, a time bomb, which is a type of malware that is set to execute at a specific time, or a trojan horse, which disguises itself as a legitimate program but carries out harmful actions, spyware focuses on gathering sensitive information such as browsing habits, keystrokes, personal data, and other confidential information. This information is then typically transmitted to third parties without the user's consent, posing significant privacy and security risks. Therefore, spyware fits the description of a computer program that gathers information without the user's knowledge or consent, making it the correct choice for the given question.

Quantitative data can exist in 

Antwoorddetails

Quantitative data can exist in both continuous and discrete forms. Continuous data can take on any value within a range, such as height or weight, and is typically measured using a scale. Discrete data, on the other hand, can only take on specific values, such as the number of children in a family or the number of pets someone has. Both forms of data can be used to perform mathematical operations and statistical analyses, and can provide valuable insights into a wide range of phenomena. For example, quantitative data can be used to study trends in population growth, track changes in consumer behavior, or explore the relationship between variables in scientific research.

The operating system performs the following operations except  

Antwoorddetails

The operating system does not perform the operation of "creation of data". This operation is typically performed by the user or other software programs running on the system. The operating system's role is to manage and organize the data and resources of the computer, but it does not create new data.

COBOL was developed for 

Antwoorddetails

COBOL (Common Business Oriented Language) was developed specifically for business operations. It was created in the late 1950s and early 1960s, during a time when computers were becoming more prevalent in the business world. COBOL was designed to handle large amounts of data, particularly data related to business transactions and financial records. It was intended to be an easy-to-learn language that could be used by non-technical people, such as business analysts and accountants, to write computer programs. Today, COBOL is still used by many organizations for legacy systems that were developed using the language.

Use Figure 4 to answer question 25

If N in the flowchart is represented by 10, which of the following conditions is not true?

Antwoorddetails

The condition "If C = 10, stop picking orange" is not true based on the flowchart in Figure 4. If N is represented by 10, then when C is equal to 10, the flowchart shows that the next step is to "continue picking orange", not to "stop picking orange".

Use the logic gate in Fig 2 to answer question 13.

Which of the following statements is true about logic gates X and Y?

Antwoorddetails

Which of the following formulas will display the current seconds past the minute os the clock in MS Excel?

Antwoorddetails

Evaluate 10011\(_2\) - 1111\(_2\) 

Antwoorddetails

Data created by the user is called 

Antwoorddetails

Data created by the user is called primary data. This refers to information that is collected directly by the person or organization that needs it, typically through surveys, experiments, or observations. Primary data is unique to the specific research question or problem and is tailored to meet the specific needs of the user. It is usually more accurate and reliable than secondary data, which is data that has been collected and reported by someone else for another purpose. Examples of primary data include customer feedback surveys, laboratory experiments, and field observations.

What factors will motivate a field engineer into choosing a notebook computer over a desktop computer?

Antwoorddetails

Field engineers are professionals who perform their work outside the office or in the field. When it comes to choosing a computer, factors such as cost, size, convenience, and battery life are essential to consider. Among the given options, the factors that will most likely motivate a field engineer to choose a notebook computer over a desktop computer are size, convenience, and battery life. Size: A notebook computer is more portable and lightweight compared to a desktop computer. It can easily fit into a bag or backpack, making it easy to transport from one location to another. This is essential for field engineers who need to move around to different job sites. Convenience: A notebook computer is also more convenient than a desktop computer because it does not require a power outlet to function. A field engineer can use the notebook computer on the go without worrying about finding a power source. Additionally, a notebook computer allows for more flexibility when it comes to where work can be done, as it can be used in a car or at a remote job site. Battery life: A notebook computer's battery life is an important factor for field engineers who may not have access to a power source for an extended period. A notebook computer with a long battery life allows field engineers to work for extended periods without needing to recharge the device. Cost is also an important consideration for any professional, including field engineers. However, the convenience and portability of a notebook computer make it a more attractive option for field engineers who need to work on the go. Overall, the factors that are most likely to motivate a field engineer to choose a notebook computer over a desktop computer are size, convenience, and battery life.

The Slide Rule is accurate to 

Antwoorddetails

The logic gates represented in Figure 1 is called 

Antwoorddetails

The logic gates represented in Figure 1 are called NAND gates. A NAND gate is a digital logic gate that gives an output of "low" (logic 0) only when all of its inputs are "high" (logic 1). In all other cases, the output of a NAND gate is "high" (logic 1). In Figure 1, there are two inputs connected to a NAND gate symbol (which looks like an AND gate with a small circle at the output). This indicates that the gate performs the NAND function on its inputs.

Which of the following stages of the SDLC is post operational stage?

Antwoorddetails

The fundamental purpose of the BIOS is 

Antwoorddetails

The operation of a computer and peripherals attached to it is controlled by

Antwoorddetails

The operation of a computer and its peripherals is controlled by the system software. System software, also known as the operating system, is the software that manages and controls the computer hardware and other software programs. It acts as a bridge between the computer hardware and the user, allowing the user to interact with the computer and run different applications. Examples of popular operating systems are Windows, MacOS, and Linux. The operating system manages the computer's memory, processing power, and input/output operations, ensuring that all components work together smoothly and efficiently.

What type of relationship can you deduce from the statement a department has many employees?

Antwoorddetails

The type of relationship that can be deduced from the statement "a department has many employees" is a "one-to-many" relationship. In a one-to-many relationship, one entity in a database is related to many instances of another entity. In this case, the "department" entity is related to many instances of the "employee" entity. This means that a single department can have multiple employees working for it, but each employee can only be associated with one department at a time. For example, in a database that tracks employee information for a company, there might be a "departments" table and an "employees" table. The "departments" table would contain information about each department in the company, such as the department name and manager, while the "employees" table would contain information about each employee, such as their name, job title, and department ID. The department ID field in the "employees" table would be used to establish the one-to-many relationship between the "departments" and "employees" tables. Each employee record would have a department ID that corresponds to a department record in the "departments" table, allowing the database to link employees to their respective departments. Overall, the one-to-many relationship between departments and employees is a common type of relationship in many database systems, and is useful for organizing and managing large amounts of related data.

The file access method shown in Figure 12 is called 

Antwoorddetails

(a) What are "Reports" in a database system?

(b) List four (4) ways in which Reports can be viewed in database management system.

(c) Outline the steps to prints a Report in MS Access.

Antwoorddetails

a) Reports in a database system are formatted outputs that present selected data from one or more tables in an organized and easily readable manner. They allow users to summarize and analyze data, track trends, and make informed decisions based on the information provided.

b) The four ways in which reports can be viewed in a database management system are:

1. Print: Reports can be printed on paper for easy reference.
2. Screen View: Reports can be viewed on a computer screen or monitor.
3. Preview: Reports can be previewed on the screen to verify that they contain the desired information and to check the formatting.
4. Export: Reports can be exported to other formats such as PDF or Excel for further analysis or sharing.

c) To print a report in MS Access, follow these steps:

1. Open the database and navigate to the "Reports" section.
2. Select the report you want to print.
3. Click on the "Print" button in the "Print Preview" tab or the "Print" tab.
4. In the "Print" dialog box, select the printer you want to use.
5. Select the number of copies you want to print.
6. Choose any additional print options you want, such as double-sided printing or collation.
7. Click the "Print" button to start printing the report.
8. Wait for the printer to finish printing the report.
9. Collect the printed report from the printer and verify that it contains the desired information and is formatted correctly.

Overall, printing a report in MS Access is a straightforward process that involves selecting the report, choosing the printer and print options, and clicking the "Print" button. The resulting report can then be used for further analysis or distributed to other users for their reference.

TEST OF PRACTICAL KNOWLEDGE QUESTION

(a) Using the star shape tool in CorelDraw, draw a 30 pts star of diameter 18 cm and fill it with grey colour.

(b) Use sharpness tool to adjust the corner sharpness of the star by 25 pts.

(c) Place three circles; circle 1, circle 2 and circle 3 with diameters 10 am, 7.6 cm and 5.4 cm respectively inside the star.

(d) Use Text tool to type ARISE AND SHINE and place it in-between circle 2 and 3.

(e) Fill cicle2 with lemon colour and circle 3 with white colour.

(f) Place five stars inside circle 3.

(g) Group your drawing.

(h) Type in your full name as a footer.

(i) Save and print your work.

(j) Submit your printout to the supervisor.

Antwoorddetails

To complete this task in CorelDraw, follow these steps:

(a) To create a 30 pts star of diameter 18 cm, select the Star tool from the toolbar on the left side of the screen. Click on the workspace and a dialog box will appear. Enter 18 cm as the width and height of the star, and set the number of points to 5. Click "OK" to create the star. Then, use the Fill tool to fill the star with grey color.

(b) To adjust the corner sharpness of the star by 25 pts, select the star shape with the Pick tool. Then, go to the Property bar at the top of the screen, and locate the "Sharpness" option. Increase the sharpness by 25 points to make the corners sharper.

(c) To place three circles inside the star, select the Ellipse tool from the toolbar. Draw a circle with a diameter of 10 cm, duplicate it twice and resize to make one with a diameter of 7.6 cm and another with a diameter of 5.4 cm. Use the Pick tool to position the circles inside the star.

(d) To type "ARISE AND SHINE" and place it in-between circle 2 and 3, select the Text tool from the toolbar, click on the workspace and type the text. Use the Pick tool to position the text in between circle 2 and 3.

(e) To fill circle 2 with lemon color and circle 3 with white color, select each circle shape with the Pick tool, and use the Fill tool to apply the respective colors.

(f) To place five stars inside circle 3, use the Star tool to create a smaller star shape, and duplicate it four more times. Use the Pick tool to position the stars inside circle 3.

(g) To group your drawing, use the Pick tool to select all the shapes, then right-click and select "Group" from the dropdown menu.

(h) To type your full name as a footer, select the Text tool from the toolbar and click on the workspace to type your name at the bottom of the drawing.

(i) To save and print your work, click on "File" on the top left corner of the screen, and select "Save As" to save the file. Then, click on "File" again and select "Print" to print the drawing.

(j) To submit your printout to the supervisor, hand over the printed drawing to the supervisor.

(a)(i) What is Universal Serial Bus (USB)?

(ii) State two benefits of using USB connection between a computer and another device.

(b) In Table 1, three storage devices are described, Use it to answer questions 3(b)(i) and 3(b)(ii).

(i) In column 2, name the storage device being described in column 1.

(ii) Show the category of storage device being described in column 1 by ticking in any of the column 3, 4 or 5

Antwoorddetails

(a)(i) Universal Serial Bus (USB) is a standard cable connection interface used to connect different devices to a computer or other electronic devices. It is a plug-and-play interface that allows devices to be connected and disconnected without turning off the computer.

(a)(ii) Two benefits of using USB connection between a computer and another device are:

1. Versatility: USB ports are available on most computers and other electronic devices, making it a universal standard for connecting various devices. It can connect peripherals such as keyboards, mice, printers, and cameras, and storage devices like external hard drives and USB flash drives.
2. High-speed data transfer: USB connections offer fast data transfer speeds compared to other interfaces. USB 3.0, the latest version of USB, has a maximum transfer rate of up to 5Gbps, making it ideal for transferring large files quickly.

(b)(i) The storage device being described in column 1 of row 1 is a floppy disk.

(b)(ii) The category of storage device being described in column 1 of row 1 is primary storage. The category of storage device being described in column 1 of row 2 is secondary storage. The category of storage device being described in column 1 of row 3 is offline storage.

Perform the following conversions in the stated number bases;

(a) AB1\(_{16}\) to Octal system

(b) 1110111.101\(_2\) to Denary system 

(c) 507\(_2\) to Binary system.

Antwoorddetails

None

TEST OF PRACTICAL KNOWLEDGE QUESTION

A supermarket listed ten items on sale.
Use Microsoft Excel application to create an inventory for the supermarket.
(a) Type in the following headings from cell A1 to F1 respectively.
SN, Goods Cost Price, Selling Price, Gain/Loss and Target.

(b) Populate the table by supplying ten different items sold in a supermarket. In column A, fill in the numbers 1 to 10 from cells A2 to A11. Similarly, list the ten items from cells B2 to B11. Supply Cost Price and Selling Price from cell B2 to B11. Supply Cost Price and Selling Price from cells C2 to C11 and D2 to D11 respectively. Note that it is possible to have some selling prices lower than the cost price. Create borders around the table.

(c) Use formula or function to calculate; (i) the gain (if the selling price is higher than the cost price) or the loss (if the cost price is higher than the selling price) of each item from cells E2 to E11 
(ii) 110% of the cost price of each item from cells F2 to F11.

(d) Determine whether target is met or not by typing "target met" or "target not met" in cells H2 to H11 for each item.
Note that target is met when the selling price is 110% of the cost price or more otherwise target is not met.

(e) Insert a footer and type in your full name  and index number.

(f) Save your work in the folder created on the desktop using your full name as th file name.

(g) Print your work showing formulas and functions and submit to the supervisor. 
 

Antwoorddetails

To create an inventory for the supermarket using Microsoft Excel, follow these steps:

(a) In cell A1 to F1 respectively, type in the following headings: SN, Goods Cost Price, Selling Price, Gain/Loss, and Target.

(b) Populate the table with ten different items sold in the supermarket. In column A, fill in the numbers 1 to 10 from cells A2 to A11. List the ten items from cells B2 to B11. Supply Cost Price and Selling Price from cell C2 to C11 and D2 to D11 respectively. Note that it is possible to have some selling prices lower than the cost price. Create borders around the table.

(c) Use formulas or functions to calculate:

(i) The gain (if the selling price is higher than the cost price) or the loss (if the cost price is higher than the selling price) of each item from cells E2 to E11 using the formula: =D2-C2.

(ii) 110% of the cost price of each item from cells F2 to F11 using the formula: =C2*1.1.

(d) Determine whether the target is met or not by typing "target met" or "target not met" in cells H2 to H11 for each item. Note that the target is met when the selling price is 110% of the cost price or more; otherwise, the target is not met. Use the formula: =IF(D2>=F2,"target met","target not met").

(e) Insert a footer and type in your full name and index number.

(f) Save your work in the folder created on the desktop using your full name as the file name.

(g) Print your work showing formulas and functions and submit it to the supervisor.

In summary, to create an inventory for a supermarket using Microsoft Excel, you need to add headings, populate the table with the necessary information, use formulas or functions to calculate the gain/loss and target, and insert a footer with your name and index number. Finally, save your work using your name as the file name and print your work showing formulas and functions before submitting it to your supervisor.