Article Content King

You are viewing: Test Your Knowledge for Microsoft Excel 2000
By Clive Haman

Test Your Knowledge for Microsoft Excel 2000

Articles - Computers - View Article



Publish this article

Here's a little exercise to see what you have learnt from previous articles or simply to test your knowledge of Microsoft Excel 2000

Open new worksheet

Type in

  • Cell A1 Block Trading Company
  • Cell A3 Weekly Figures
  • Cell B4 Week 1
  • Cell C4 Week 2
  • Cell D4 Week 3
  • Cell E4 Week 4
  • Cell F4 Total
  • Cell A5 Sales
  • Cell B5 2559
  • Cell C5 2496
  • Cell D5 1651
  • Cell E5 2542
  • Cell A6 Expenses
  • Cell B6 1098
  • Cell C6 1436
  • Cell D6 1354
  • Cell E6 1231
  • Cell A7 Gross Profit
  • Cell A8 VAT
  • Cell A9 Net Profit
  • Save worksheet as - Your name 2

Before doing the calculations we check to see if the figures are right and we discover that cell B5 should read 2556. We need to edit the cell. You can of course change the contents of any cell at any time.

To edit the contents of a cell

  • You select the cell you want to edit - in this case - B5 then click on the formula bar and change the 9 for a 6.
  • Arrow key to the require cell, tap the spacebar and type in the correct data

Note: You can check left side of the status bar to see if you are in edit mode

To Total

  • Click on F5
  • Click on AutoSum icon Make sure that the right formula is printed on the formula bar (=SUM(B5:E5)
  • Click the formula enter icon - The tick - or press the enter key on the keyboard.
  • Or in cell F5 type (=SUM(B5:E5) and press the enter key

To calculate the Gross profit

  • In cell B7 type =
  • Click in cell B5 and type -
  • Click in cell B6.
  • Press the 'enter key' on the keyboard or click on tick on the formula bar.
  • Or Type =Sum(B5:B6) and press the enter key

To calculate the VAT

  • In cell B8 type =
  • Click on cell B7 and type *17.5%
  • Press the 'enter key' on the keyboard or click on tick on the formula bar.
  • Or In cell B8 Type =
  • Arrow key to B7 and tap spacebar Type * then 17.5%
  • Press 'enter key' on keyboard

To calculate net profit

  • Click on cell B9 and type =
  • Click on B7 then type -
  • Click on B8
  • Press the 'enter key' on the keyboard or click on tick on the formula bar.
  • Or In cell B9 Type =Sum(B7:B8)
  • Press the enter key

Note: 17.5% is the UK rate.

See All articles From Author

Clive Harman Webmaster
Information on Microsoft Excel 2002
http://www.harmantraining.com/excel2.html

Article Source : http://www.articlecontentking.com

Tags: Microsoft Excel Excel tips
Word Count Appx. : 539 | Article Views 896 Published 10-03-2010


Related articles
The Evil Packet Sniffer
By: Eran Aharonovich | 03-12-2006
A "Packet Sniffer" is a utility that sniffs without modifying the network's packets in any way. By comparison, a firewall sees all of a computer's packet traffic as well, but it has the ability to block and drop any packets that its prog (read entire article)
Best Web Design Practices for E commerce sites
By: RamaKrishna Reddy | 29-04-2009
You might have come across several web design tips and practices which are general in nature or you might have come across some best E commerce tips and practices which are programming oriented. The best way to make you understand the need for good we (read entire article)
Test your Knowledge on Microsoft Excel
By: Clive Haman | 25-03-2010

Test your knowledge to find out how well do you know Microsoft Excel

(read entire article)
10 Steps To A Safe, Smooth Running PC
By: Michael A Silva | 08-02-2006
10 Steps To A Safe, Smooth Running PC will guide you through the process of improving the performance of your computer. (read entire article)
"We Do Not Know What We Are Talking About" - Nobel Laureate David Gross
By: Michael Strauss | 11-01-2006
Science has reached an enormous impasse. From biology to physics, astronomy to genetics, the scientific community is reaching the limits of understanding which often presage a complete rethinking of long-accepted theories. So characteristic (read entire article)
Drawing Scanning Vs Paper Drawing
By: Ethan Allen | 27-07-2009
Drawing scanning is an important feature to save your drawings in less space for very long period. You can hire drawing scanning service to avoid capital investment in new technology scanners. (read entire article)
10 Easy Steps For Getting Video On Your Business Website
By: Michael Street | 24-06-2006
I'm often asked, "I have no video training but I want to put video on my website to help promote my products and services what can I do?" Well the answer is simple. If you can shoot a home movie you can put a video clip on your website. Now (read entire article)
My PC Secret Formula
By: Bruce Hammond | 16-11-2008
Save time, save money and boost your internet speed by leaps and bounds like no other system on earth can do. Over 14,000 copies and counting sold. (read entire article)
Helping a senior citizen
By: Orson Dixon | 07-02-2009
You can also make senior citizens aware of the need for computers and how viruses render the software useless. (read entire article)