Get premium membership and access revision papers, questions with answers as well as video lessons.

Got a question or eager to learn? Discover limitless learning on WhatsApp now - Start Now!

Ms Excel Practical Exam Question Paper

Ms Excel Practical Exam

Course:

Institution: question papers

Exam Year:2012

GROOVE TECHNOLOGIES LTD
EXCEL PRACTICAL
Saturday, May 05, 2012

A. In a new worksheet, create a table and insert the following information. Use different fonts for different columns.

1. Names of people (at least 25)

2. Their ages

3. Number of years they have worked

4. Salary per month

5. Show housing, medical, travel and hardship allowances, and columns

B. Using the table to do the following:

1. (a) Calculate the total salary for each person and grand total for all persons.
(b) Calculate Average, Minimum, Maximum and count entries.

2. Show a graph of the their salaries

3. Copy and paste your graph from sheet 1 to sheet 2, name your graph sheet ‘CHARTS’

4. Add columns where necessary to include: leave payment, over time payment and sick off amount, and then calculate the net salary
.

ALL THE BEST ALL THE BEST ALL THE BEST ALL THE BEST

More Question Papers

Probability And Statistics (Exam 1/P)

,Him 011: Food Production 1,2013

Advanced Certificate In Counselling/Chaplaincy Exam

Aeb 302: Crop Protection

Ansc 352: Non Ruminant Animal Production

Association Of Chartered Certified Accountants(Acca)

Business

Business Communication And Management

Business Research Methods

Buss 100: Principles And Practice Of Management

Computer Security

Core Technical 1 Financial Mathematics

Core Technical 1 Financial Mathematics [Including Examiners Report(2005-2011)]

Crd 232: Plant Growth And Development

Crop 531: Plant Breeding

Cuu 100: Communication Skills (Day Class)

Digital Electronics

Dis302

Dis302

Dit 407: Network Design &Amp; Implementation.

Dom 102

Ece Cotemporary In Early Childhoold Development

Economics

Economics Including Examiners Report

Ect 300:Educational Technology

Elements Of Law

Financial Management

Food Legislation

Gpr 205: Sale Of Goods And Agency Module Ii

Hcb2103-Mathematics For Business Cat

Industrial Management

Information System

Information System

Information System (Ms Access)

Information System Development

Internet Exam

Internet Technology

Introduction To Information Technology

Introduction To Law(Kasneb)

Introduction To Philosophy

Introduction To Windows

Kasneb Cpa Part 1 Section 2Cps Part I Section 2Csia Part 1 Section 2Ccp Part I Section 2Economics

Language In Broadcasting

Lit 100: Critical Reading And Response

Macro Economic Theory

Organization Behaviour (Term Paper)

Management Of Human Resource

Principles Of Marketing

Principles Of Marketing (Cat)

Operations Management

Popular Exams

Return to Question Papers

Quick Links