Ms office practical question paper download

Using the chart component of the spreadsheet package create a graph showing the months and the increasing end of month balances from the beginning of to the end of as shown in the illustration.

Note the type of graph, labels, formatting on the axises, orientation, etc. Save the work as YourSurnameSaving. In the file Prices look at the Price List Cameras worksheet. Find the prices of digital cameras. Create a quotation for him in Excel in the worksheet Quotation.

Use the quotation format of an invoice as shown below. Copy where possible to make keyboarding quicker. Save the file as YourSurnameQuotation. Open the e-mail program which you normally use. Attach the file YourSurnameQuotation to the e-mail. Do not send the e-mail! In the body of the email send a polite message to MrBloggs telling him that you have attached his quotation and how you hope your photographic shop can be of service to him.

In the e-mail inform him of the cost of this card reader. End the letter politely with your name. Make a screen dump of the e-mail message with all the details. Copy the screen dump to a word processor program. Save it as YourSurnameEmail. Objectives: The Learner will be able to: 1. Enter data into an Excel Spreadsheet 2. Apply formatting to cell text 5. E3 Try It! Test your equations. Do they work?

Save the spreadsheet and name it: Excel Advanced Practice 2 Explain the difference between absolute and relative references 3. Enter data and equations into an Excel Spreadsheet 4. Hint: You can use a relative reference for the first value under Quantity, but you need absolute references for the remainder of the formulas. Do your subtotals change? Change the Increment to Save the spreadsheet and name it: Excel Advanced Practice 3 Copy worksheets 2. Add the following sales data in Column B.

The second argument asks: "Where is the look up table? Calculate the Bonus Check Now all of the pieces are in place to figure out how much bonus the sales reps receive. The Car Payment You see an ad for a used car that you would like to buy.

What is the amount you need to finance? Use the PMT function to determine what your monthly payments will be. Show both scenarios in your worksheet. Alphabetize the list. Using the Lookup formula, calculate the letter grade for each student whereby anything over 90 is an A, 80 is a B, 70 is a C, 60 is a D and anything lower is an F. Chart the final grades in a bar chart. Vacation Budget Before you create the worksheet in Excel, explain where you want to go and what kind of activities you would like to do while you are there.

What is your proposed budget? Set up your worksheet for transportation costs airfare, car rental, trains, etc.

Include any other activities you might enjoy. Another pie chart. Start Microsoft Excel and type the following spreadsheet exactly as shown follow the column and row headings as a guide. You can either print out the following instructions or have two windows open Microsoft Excel - your spreadsheet, and your browser with these instructions.

Enter your name and today's date in the spaces shown on the spreadsheet. Adjust the column widths to accommodate the longest entries in each of the columns. Copy this formula to E9, E10, and E Define a range named percent to all the percent values in column E. Display the values in E8 through E11 as one decimal and add a percent sign. Enter a function in E14 to calculate an average percent of all tests combined.

Use the range name percent in the function argument. Move the label Course Records to C5 and bold and underline it. Center the values in B8 to B11, C8 to C Use ChartWizard to create a pie chart using the default chart sub-type with the top left corner in A Make sure that the legend is moved to the left hand side of the pie chart.

Add the following title: Word Test Results. Close the file and exit Microsoft Excel. Make B2 bold, underlined and size Make all headings, i. A4 — D4, bold. Put borders on all entries of the sheet. Save document as Qn2data and print it. The pie chart should have an appropriate title, legend, and each portion should show the percentage occupied by each item. Use your print preview regularly. You have been asked to prepare a spreadsheet to show the profit and loss figure for the last financial year.

The profit and loss should be shown as a dollars and as a percentage. Month Income Expenditure March Also validate marks — should not contain more than or less than 0.

If so persist warning information. Enter the headings as asked in sheet1 and sheet2. A2 and hit Enter. This will produce on A2 of Sheet2 whatever it was on A2 of Sheet1. Drag the fill handle down to fill the same formula to all the rows existing in Sheet1. Save it as Salary advice. Vehicle Allowance U. Calculate Net Salary. Format all figures to 2d. Save it as Salary advice2. Calculate the Gross salary, ii.

PAYE, iii. Aids Levy, iv. Housing allowance, v. Transport allowance and vi. Net Salary. Adjust the column width so that the formulae are displayed in full and the sheets fits into one side of A4 landscape format and save it as formulas.

The balance after the total deposit is paid in monthly installments over 24 months without interest. Column graph [5 marks] ii. Bar Chart [5 marks] iii. Mudehwe Eng. Bejera Eng. Mudzuri Eng. Muzawazi Eng. Zhawari Eng. Mavhunga Eng. The pie chart should have an appropriate title legend and each portion should show the percentage of hours accumulated by each Engineer. You have been asked to prepare a spreadsheet using the results of a survey on the types of fizzy drinks people prefer.

Save as marks and print a copy. Save as marks2 and print a copy. Do not put any lines or borders on it yet. Save it as Qn-fruits1. Use the Sum formula to calculate the Total weight kg of fruit packed by each worker. Format all the numbers as integer 2 decimal places.

Enter the information into the 2 columns. See example below. Delete the Names column 1 mark vii. Add shading to the column headings and borderlines to the full table. Include the column headings but not the title in the border. Set up the spreadsheet ready for printing in landscape format [1 mark]. Save the worksheet as Qn-fruit2. Do not show a legend on your chart.

Data labels indicating percentages should be displayed. Change the spreadsheet to display formulae you have used. Adjust the column width so that the formulae are displayed in full and the sheets fit into one side of A4 landscape format. Save the worksheet as formulas in landscape format.

USE IT as an absolute cell reference in the formula to calculate the markup per item. The rest of the worksheet must be formatted to display two decimals. The chance of contracting one of these computerviruses over the Internet has increased dramatically.

In fact, unless you run anti-virus software, your computer will almost certainly become infected. Typically, you get a virus by opening infected e-mail attachments. Some viruses are relatively harmless to individuals. They just attach themselves to outgoing messages or e-mail themselves to all the contacts listed in your address book.

The sudden flood of e-mail overwhelms mail servers, causing the system to crash. Other viruses are more destructive and may lie dormant until a certain date. Then they spring to life to do their dirty deeds. Sometimes a strange message appears on your screen, or data and programs may be modified. In the worst case, all the files on your hard drive may be wiped out. These pernicious programs start on one computer, then replicate quickly, infecting other computers around the world.

In a student at CornellUniversity sent out a virus out by accident, infecting more than 6, computers in minutes, nearly bringing the Internet to its knees. Last year alone, 10, new viruses, Trojan horses and worms were unleashed. Part 2 a Change the font type of the whole document to Courier or Courier new [2 marks].

Use font size A browser is a computer program that resides on your computer enabling you to use the computer to view WWW documents and access the Internet taking advantage of text formatting, hypertext links, images, sounds, motion, blogs, and other features.

Firefox and Internet Explorer are currently the leading "graphical browsers" in the world meaning they facilitate the viewing of graphics such as images and video and more.

There are other browsers e. Most offer many of the same features and can be successfully used to retrieve documents and activate many kinds of programs.

Browsers all rely on "plug-ins" to handle the fancier files you find on the Web. Plug-ins are sub-programs stored within a browser or elsewhere in your computer especially to support special types of files you may click on. If you click on a link, and your computer does not currently have the plug-in needed for the file you clicked on, you are usually prompted with an opportunity to get the plug-in. Most plug-ins are free, and easy and safe to install on your computer; follow the instructions you are given.

The main way in which browsers differ is in the convenience features they offer for navigating and managing the Web and all the URLs you may want to keep track of. Netscape and Internet Explorer both offer the ability to e-mail documents, download them to diskette, print them, and keep track of where you've been and sites you want to "bookmark" or "Add to Favorites" Microsoft's name bookmarks. Dube Mr. Moyo Mr. Sibanda MsNcube MsSibanda Mr.

Zuze Mr. Jazi Mr. Mugara Mrs. Madyira Mr. It should fit on one sheet. Adjust the column width so that the formulae are displayed in full and the sheet fits into one side of A4 landscape format. The Internet is the transport vehicle for the information stored in files or documents on another computer. It can be compared to an international communications utility servicing computers.

It is sometimes compared to a giant international plumbing system. The Internet itself does not contain information. It is a slight misstatement to say a "document was found on the Internet. What it was found in or on is one of the computers linked to the Internet. The WWW incorporates all of the Internet services above and much more. You can retrieve documents, view images, animation, and video, listen to sound files, speak and hear voice, and view programs that run on practically any software in the world, providing your computer has the hardware and software to do these things.

When you log onto the Internet using a web browser e. Hypertext is the ability to have web pages containing links, which are areas in a page or buttons or graphics on which you can click your mouse button to retrieve another document into your computer. This "click ability" using Hypertext links is the feature, which is unique and revolutionary about the Web.

Installation, Storage, and Compute with Windows Server Implementing a Software-Defined Datacenter. Analyzing and Visualizing Data with Microsoft Excel. Windows Server Administration Fundamentals. Introduction to Programming Using JavaScript. Microsoft Azure Architect Technologies beta. Designing an Azure Data Solution. Administering Relational Databases on Microsoft Azure. Microsoft Azure Data Fundamentals. Microsoft Dynamics for Sales. Firefox and Internet Explorer are currently the leading "graphical browsers" in the world meaning they facilitate the viewing of graphics such as images and video and more.

There are other browsers e. Most offer many of the same features and can be successfully used to retrieve documents and activate many kinds of programs. Browsers all rely on "plug-ins" to handle the fancier files you find on the Web. Plug-ins are sub-programs stored within a browser or elsewhere in your computer especially to support special types of files you may click on. If you click on a link, and your computer does not currently have the plug-in needed for the file you clicked on, you are usually prompted with an opportunity to get the plug-in.

Most plug-ins are free, and easy and safe to install on your computer; follow the instructions you are given. The main way in which browsers differ is in the convenience features they offer for navigating and managing the Web and all the URLs you may want to keep track of.

Netscape and Internet Explorer both offer the ability to e-mail documents, download them to diskette, print them, and keep track of where you've been and sites you want to "bookmark" or "Add to Favorites" Microsoft's name bookmarks.

The Internet is the transport vehicle for the information stored in files or documents on another computer. It can be compared to an international communications utility servicing computers. It is sometimes compared to a giant international plumbing system.

The Internet itself does not contain information. It is a slight misstatement to say a "document was found on the Internet. What it was found in or on is one of the computers linked to the Internet. The WWW incorporates all of the Internet services above and much more. You can retrieve documents, view images, animation, and video, listen to sound files, speak and hear voice, and view programs that run on practically any software in the world, providing your computer has the hardware and software to do these things.

When you log onto the Internet using a web browser e. Hypertext is the ability to have web pages containing links, which are areas in a page or buttons or graphics on which you can click your mouse button to retrieve another document into your computer. This "click ability" using Hypertext links is the feature, which is unique and revolutionary about the Web. Every document or file or site or movie or sound file or anything you find on the Web has a unique URL uniform resource locator that identifies what computer the thing is on, where it is within that computer, and its specific file name.

More explanation on the structure of URLs. Every Hypertext link on every web page in the world contains one of the URLs. When you click on a link of any kind on a Web page, you send a request to retrieve the unique document on some computer in the world that is uniquely identified by that URL. URLs are like addresses of web pages. Part 2 a Change the font type of the whole passage to Arial [2 marks].

When adding a peripheral device makes sure that your computer has a slot of the type needed by the device. Sound cards Allow computers to produce sound like music and voice. The older sound cards were 8 bit then 16 bit then 32 bit.

Though human ear can't distinguish the fine difference between sounds produced by the more powerful sound card they allow for more complex music and music production. Colour cards Allow computers to produce colour with a colour monitor of course. The first colour cards were 2 bits, which produced 4 colours [CGA]. It was amazing what could be done with those 4 colours. Next came 4 bit allowing for 16 [EGA and VGA] colours Then came 16 bit allowing for colours and then 24 bit which allows for almost 17 million colours and now 32 bit is standard allowing monitors to display almost a billion separate colours.

Video cards Allow computers to display video and animation. Some video cards allow computers to display television as well as capture frames from video. A video card with a digital video camera allows computers users to produce live video. A high speed or network connection is needed for effective video transmission. Network cards Allow computers to connect together to communicate with each other. Network cards have connections for cable, thin wire or wireless networks.

Input Home computers are microcomputers. Input is supplied to the microcomputer with the use of a keyboard, a mouse, or another input device. These input devices may be called peripheral devices.

Processing Processing is done inside the computer in an area called the central processing unit CPU. Processing is the conversion of input to output. Storage Storage refers to holding information somewhere. It is volatile memory because the memory is automatically "erased" when the power is turned off or interrupted. The RAM memory is located inside the computer case on the motherboard. A motherboard is not the keyboard. The keyboard is what you type with. A motherboard holds RAM memory, electronic circuits and other computer parts including the central processing unit.

ROM, Read-Only-Memory, is not volatile meaning the memory is still there when power is interrupted or turned off. When the computer is turned back on again, ROM memory is still in storage on the internal hard disk. Output Output is the result of a computer process. Output may be viewed on a monitor screen, heard through speakers, printed on printers, and so forth. Output devices may be considered hardware and are also considered to be peripheral devices. Bold the headings.

A computer system refers to the computer AND all of its equipment. Equipment like speakers, printer, keyboard, scanner, etc. The central processing unit CPU is considered to be "the computer". Without peripheral equipment such as monitor, printer, speakers, etc. Your computer system cannot help you type a letter unless you have some type of software program to do this. A software program for your computer can be purchased at stores like Office Depot, Staples, and computer stores.

Check your local telephone directory for a computer store in your area. Sometimes when you purchase a computer it already has a word processing program installed. If you buy a computer from a large electronics chain store, even if you have to travel out of town, you will get a better price as a rule than buying from a smaller chain store in town. Ask in town first, if they would be willing to match another store's Advertised price See "Buying A Computer", next.

The Macintosh computer is commonly referred to as a "Mac". The operating system of the PowerMac G4 or G5 has undergone revisions. Each major version also has a name: OS X version The Apple PowerMac computers the G4 and the G5 have two processors for parallel processing instead of just one, and there is space inside the computer to upgrade to 4 hard disks in a RAID array to give more power to thecomputer functioning as a server.

Sometimes the computer tower is called a "box" which is a slang word for "the computer". You could say, "There are two processors inside the box. This software is called Move2Mac and is a product of Detto Technologies.

I found my copy of the shrink-wrapped software on a shelf at a large Fry's Electronics store. A lot of computer software can be purchased using a credit card with a secure connection over the Web, then downloading that software to your own computer. I prefer having a CD or other disk with the software on the disk. The Macintosh has excelled in the commercial graphics and publishing industries and thousands of people prefer a Mac for home use rather than a PC. The PC computerscurrently have a much greater market share and there are millions in use in homes and businesses throughout the world.

When you attend college the college will specify which type of computer, Mac or PC, will be in use at the college for faculty and students. Some colleges use just Mac computers in campus buildings and for the faculty.

Other colleges use PCs. In the following paragraphs I use OS to mean "operating system" Prior to the Macintosh OS X operating system the Macs used an operating system based upon a single processor computer CPU which processed data and ran applications using what was called cooperative multitasking. Cooperative multitasking allowed programs to sometimes take control of the central processing unit.

Now with the newer Macintosh operating system, OS Identification of the distribution. Calculation of test statistics from data collected. Do not reject Make a Reject the null the null statistical hypothesis hypothesis decision. Conclude null hypothesis may Conclude alternative be true hypothesis is true. Make sure the top margin is equal to the bottom margin. The computer processor inside a PC or PC-clone computer has totally different architecture microscopic "wiring" schematic inside the central processing unit chip the CPU, or "chip".

In other words, the specific way the circuits are laid out in a computer chip CPU, central processing unit is called the chip architecture. PC chips and Mac chips have processing units with totally different architecture. Software is not interchangeable. An Apple or Mac computer is not a PC. Most PCcomputers are sold new with a Windows operating system but keep in mind that other operating systems can also run on PC-architecture machines.

One example of another operating system that can run on a PC machine is Linux for Windows. When two operating systems are on a disk they are installed on separate "partitions" of the disk. That is similar to two songs on one CD having to be on separate "tracks". Usually, things you can see and touch on a computer or inside a computer are called "hardware" whereas programs for the computer digital instructions are called software.

A computer programmer who writes lines of code for the computer creates software. An interpreter or compiler is a smaller program, which changes the programmer's code into machine instructions for the central processing unit. After much testing and debugging, the programmer's code is finally "packaged" into executable files which make up the final "software" which can be purchased later, or might be "bundled" with the computer when you buy it meaning that some software is already installed when you buy the computer.

Fast-Food Industry, industry concerned with the provision of fast food to customers, either prepared in restaurants or other outlets, or sold in packaged form for buyers to consume or prepare at home.

Although it is acknowledged to be an increasingly significant sector of the hotel and catering industry, defining fast food in any meaningful way has proved difficult.

Both perspectives are inadequate, because they focus on how and where fast food is produced rather than what is traded. A more instructive approach is to define fast food retail as the sale of an end or finished product with four generic characteristics. It has a low relative price. The finishing and in some cases total production and service times are quick.

The product is suitable for eating with the fingers, has disposable packaging, and, where applicable, disposable cutlery. While this aspect facilitates the takeaway, drive-through, and home delivery options of product delivery, it has also attracted substantial criticism from environmentalists. The durability of the finished product such as maintenance of heat, nutritional value, etc. Typical fast-food products falling within this generic definition include hamburgers, fish and chips, scooped ice cream, kebabs, fried and broiled chicken, chips or French fries, pizza, Chinese and Indian takeaway food, sandwiches, and other forms of ready-to-eat products, as well as canned or packaged ready-to-drink beverages.

Many people believe that fast food is not only synonymous with the American lifestyle, but also had its origins in the United States, and that it is a modern phenomenon. However, much fast food is European in origin, with a considerable history. The hamburger derived from the Baltic provinces of Russia in the Middle Ages, where various tribes ate steak tartare.

These Tartars, or Tatars, introduced the delicacy to their German trading partners from the port of Hamburg. The Germans fried the meat and seasoned it with onions. When German immigrants arrived in the United States, they brought this steak dish with them. This said, there is also some evidence to suggest that the Romans ate a form of hamburger as long. The sandwich allegedly owes its existence to John Montagu, 4th Earl of Sandwich, who asked for such an item during a gambling session in the early s.

The debate concerning the origin of fish and chips, whether it derived from London or from Mossley in Lancashire, only serves to underline the European dimension. What is attributable to the United States is the standardized chain-owned fast-food concept, the subsequent innovations that improved the efficiency of these operations, and their growth through franchising from Within the fast- food market, the origin of the standardized chain is attributed to the White Castle company, when Walter Anderson and Edgar Ingram opened their first store in The emphasis on standardization has attracted criticism because it has served to reduce labour skills and thereby reduce wages; it has also been cited as the primary cause of the decline of independently owned and operated fast-food businesses, and as an example of US cultural imperialism.

This growth has not only been fuelled by consumer demand, but also through the expansion of the supply base through diversification. This diversification has taken four forms. For example, the major hamburger chains offer not only pizza, chicken, baked potatoes, sandwiches, and salads, but also different variations of these foodstuffs.

Their provision means that the chains are able to offer a new experience to their existing customers and possibly appeal to a new customer base.

In the United States, product diversity has taken a branded route, with companies supplying complementary products, forming strategic alliances in order to create dual-branded stores. Complete the following tasks. Type the passage above as it is [10] 2. Set the margins to 2 cm [1] General - 5 3.

Make the line spacing 1. Make the normal text point size 12 [1] 5. Make all the text in the whole document Comic Sans [1] 1. Make all the headings bold [1] Main headings - 3 2.

Make all the headings point size 14 [1] 3. Make all the headings sentence case [1] Insert your name and class, and page numbers in the footer 1. Align your name and class in the footer left [1] Footer - Name and 2. Make your name and class in the footer point size 8 [1] class, and page numbers - 5 3. Make sure that your name and class in the footer is only found on the first page [1] 4.

Insert page numbering in the footer in the centre of the page [1] 5. Insert page numbering from page 2 [1] Insert the words Foods fast in the header wrong wording - no marks for the header 1. Make the wording in the header Foods fast bold [1] Header - 6 2. Make the words in the header point size 8 [1] 3. Make the words in the header left aligned [1] 4.

Put a border around the header [1]. Give the header a light shading [1] 6. Start the header from page 2 [1] Insert a clipart picture of a cooked chicken between any two paragraphs wrong position - no marks for the picture 1. Alter the bigger the picture, e. Making it smaller, Clipart picture - 3 bigger, narrower or wider does not count. Leave an open line space before the clipart illustration [1] 3. Centre the clipart illustration on the page [1] Insert an appropriate picture between any two paragraphs wrong position - no marks for the picture 1.

Centre the picture on the page [1] Picture from file - 4 2. Centre a caption under the picture [1] 3. Make the caption bold [1] 4. Make sure there is an open line between the caption and the following text [1] Insert a table with the following information between paragraphs in the section on the History wrong position - no marks for the table Country of origin Type of food Column headings a.

Russia, Germany and Ancient Rome Hamburger b. Ancient Rome Pizza c. England Fish and chips d. England Sandwiches e. United States Standardized chain-owned fast-food concept 1. Leave one open line space before the table [1] Table - 10 2. Centre the table on the page [1] 3. Shade the column headings [1] 4. Make the text in the column headings bold [1] 5.

Centre the text in the column headings [1] 6. Make the columns of the table just wide enough [1] 7. Make the text in the body of the table left aligned [1] 8. Add the caption Country of origin just below the table 9. Centre the caption [1] Bold the caption [1] The caption underneath the table must read Population [2] 2. Align the labels with the countries names at 90 degrees [2] 3. Make the columns or bars the colour red. Insert a background picture of a chicken to the graph [2] From the word McDonalds add a footnote with the words This firm opened a branch in Pinelands in Footnote - 2 [2] Insert an index at the end of the last paragraph [0] Index - 6 1.

Index 5 important words not headings or words that begin a sentence [5] 2. The index must be in one column [1]. When creating text content for a slide presentation which one of the following should be used?

Use long detailed paragraphs to make a point. Use as many different fonts as possible in the presentation. Use only short concise phrases. Fill each slide with text to eliminate white space. Enter A, B, C, or D in answerfile. Save and close your presentation keeping the same filename answerfile.

Save and close your presentation keeping the same filename apple varieties. Save this file to your Student folder using the new filename apple marketing. Apply the design template pomme. Apply a Title Slide layout. Use the most suitable tool to complete this task. Find the name John Browne titled Finance Manager.

Add a subordinate. His name is Carl Kent titled of Assistant Accountant. Save your presentation keeping the same filename apple marketing. Add the following text as a note for the presenter: Carl Kent — newly appointed to the Finance Team. Increase the font size for the title Apple Varieties to Apply a shadow effect to the text Granny Smith.

Resize the image to 11 cm high and 8. Enter the following bullet point text: -Jams and jellies -Classic pies and crumbles -Sauce for meats - goose and pork [1 Mark]. Do NOT move or resize the objects. Change the font colour for the bullet point text to a colour of your choice. Create a pie chart from the data below: Pies jams sauces juices 30 75 32 Accept default settings.

Add value data labels to the column chart. Save your presentation keeping the same filename applemarketing. Change the paragraph spacing for ALL bullet points to 0. Choose a slide layout which allows a title ONLY to be added. Move slide 5 titled Finally so it becomes the last slide in the presentation.

Accept the default settings. Find slide 2 titled Apple Trees. Copy the apple image from this slide to the bottom right corner of slide 6 titled When Buying Apples in the file apple marketing. Save both presentations keeping the same filenames apple trees. Close your presentation apple trees.

Hide this slide. Find slide 9 titled Cooking With Apples. Delete this slide. Make corrections where needed. You can safely ignore proper names. As in any other sphere of technology, computers could be used for good as well as evil purposes. Computer ethics refers to the standards which determine whether it is applied in a positive way or in a negative way.

In other words they are moral guidelines that can be followed in the use of information technology. A computer security risk is any event or action that could cause a loss of or damage to computer hardware, software, data, information or processing capability. Some are accidental, some are planned.

Any illegal act involving a computer is generally referred to as a computer crime. In this section we will investigate some of the issues that are involved. In the information era in which we live, information is power. If information is used correctly, it has great potential to raise our standard of living and to promote progress. In the hands of a dishonest person the computer can be used as an instrument that inflicts damage on a financial as well as a personal level.

Privacy is the right of an individual or orgainzation to control information about themselves. People are worried about how computer security or the actual absence of computer security could influence their lives. Various government departments have comprehensive databases in which a lot of personal information of people is held. Internal affairs, the South African Revenue Service, local municipalities, the army, banks and if a person is unlucky, the police, all have personal records of people on their computers.