Microsoft office 2016 questions free

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

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. Instructions 1 Type in all text and numbers shown in the spreadsheet below. 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. The pie chart should have an appropriate title legend and each portion should show the percentage of hours accumulated by each Engineer. 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. Dube Mr. Moyo Mr. Sibanda Ms Ncube Ms Sibanda 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. Reduce the size of your legend if it is coming to contact with the Chart title. Use the first chart sub-type. Make sure every cell phone or mobile name is appearing on your graph.

Highest discount allowed. Lowest value added tax. Calculate the VAT. Discount Allowed is 3. Discount Allowed. Calculate the Net Cost. Calculate the total cost. Print it in landscape orientation. The formulae should fit on respective sheets.

The columns for the figures should have 4 borders. Underline where necessary using a cell border. Opening stock Purchases Return outwards Closing stock Gross profit? Remember the Test is out of 20, the Assignment out of and the Exam out of The list of students should be placed in cell range starting from cell A12 rmmakaha gmail. Johan wants to buy a camera.

He went to ABSA who suggested a savings account. He immediately opens the account with R Average Total 10 interest payments 11? Follow the instructions to help you with your spreadsheet. Use formulas or functions to do the necessary calculations. The typing of figures will not gain marks. Create a spreadsheet with headings similar to the diagram. Save it as YourSurnameSaving. Then perform the following operations. Provide the spreadsheet with appropriate headings. Format the headings so they appear as in the diagram.

Fill in the Month beginning on Jan in Column B for 24 months. Note the format of the date. Fill in the Monthly payment column Column F with R In row 3 calculate the Interest for the month Column E by multiplying the balance at the beginning of the month by the interest rate and dividing by In row 3 calculate the balance at the end of each month Column G by adding the balance at the beginning of that month to the interest for the month and adding the monthly payment.

In row 4 fill in the balance at the beginning of the month Column C. It is the same as the balance at the end of the previous month. Using autofill pull the formulaes down for 24 months. Highlight with red shading how much he has in Dec after he has saved for 24 months. Calculate the total amount of payments that will be paid over the 24 months total of Column F. Format the column widths so that the spreadsheet acquires a neat appearance.

The columns must be wide enough to show the figures. 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. Save the spreadsheet and name it: Excel Advanced Practice 1 rmmakaha gmail. E3 Try It! Do they work? Save the spreadsheet and name it: Excel Advanced Practice 2 rmmakaha gmail.

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 rmmakaha gmail.

Copy worksheets 2. 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. 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. Skills on the revision tools, header and footers, footnotes, and mailing tools are also assessed.

This domain covers skills with objects in Word documents: tables, charts, OLE objects, clipart images, and photos. Candidates will also find questions on the functionalities of editing and moving objects.

English French. Login Candidate Administrator. Test catalog Office, digital and programming skills test. Skills on the revision tools, header and footers, footnotes, and mailing tools are also assessed. This domain covers skills with objects in Word documents: tables, charts, OLE objects, clipart images, and photos. Candidates will also find questions on the functionalities of editing and moving objects. English French. Login Candidate Administrator.

Paint Editor. Save As. Auto Save. Web Page. Change Letter. Change Sentence. Change Case. Change Word. Photo Manager B.

Picture Manager C.

 
 

 

Microsoft office 2016 questions free

 

Some gree of Microsoft office microsoft office 2016 questions free is required from any new employees that an organization is looking to hire. The quiz below is specially designed for a micdosoft who needs a refresher on all things related to Ms. Is that you? Give it a try and get to see what you need to страница microsoft office 2016 questions free on before applying for the job you have been eyeing.

Here’s an interesting quiz for you. Search Speak now. Questions All questions 5 questions 6 questions 7 questions 8 questions 9 questions 10 questions 11 questions 12 questions 13 questions 14 questions 15 questions 16 questions 17 questions 18 questions 19 questions 20 questions 21 questions 22 questions 23 questions 24 questions 25 questions 26 questions 27 questions 28 questions 29 questions 30 questions 31 questions 32 questions 33 questions 34 questions 35 questions 36 questions 37 questions 38 questions 39 questions 40 questions 41 questions 42 questions 43 questions.

Feedback During the Quiz End of Quiz. Play as Quiz Flashcard. Questions and Offce. MS Office provides help in many ways. Which of these are more closer to the answer? Which bar is usually located below that Title Bar that provides categorized options?

Which of the following are valid Min. Which elements of a worksheet can be protected from accidental modification? Windows kmspico download free download converts selected text into the next larger size of the same offiec. Related Topics. Recent Quizzes. Microsoft OneNote Trivia Quiz! Trivia Quiz. Featured Quizzes. Which emotion best describes you? Which Christmas Character Are You? Popular Topics. Back to top. Excel Intermediate Quiz.

Microsoft Office Microsoft office 2016 questions free Test: Http://replace.me/28978.txt We have other quizzes rfee microsoft office 2016 questions free interest.