Skip to main content
Aliexpress WW
Aliexpress WW

Why It's Easier to Succeed With Using Functions In Excel 2000 Than You Might Think

Using functions

Important terms:

  • A function is a predefined formulathat helps perform common mathematical functions.
Each function has a specific order, called syntax. Syntax must be followed for the function to work correctly.

To use syntax order:

  1. All functions begin with the equalssign.
  2. After the equals sign is the function name.
  3. One or more arguments are enclosed in parentheses. If there is more than one argument, they are separated by commas.
An example of a function with one argument:

equal sign, function name, argument

An example of a function with more than one argument:

equal sign, function name, argument

Excel has hundreds of functions or predefined formulas to assist you with your calculations. As you know, building individual formulas can be difficult and time consuming. Using Excel's functions can save you a lot of time and headaches.

Excel's different functions

There are many functions in Excel. For our purposes in Excel 2000, we will discuss some common functions.

Statistical functions:

SUM: Summation adds a range of cells together.
AVERAGE: Average calculates the average of a range of cells.
COUNT: This counts the number of chosen data in a range of cells.
MAX: This identifies the largest number in a range of cells.
MIN: This identifies the smallest number in a range of cells.

Financial functions:

Interest rates
Loan payments
Depreciation amounts

Date and time functions:

Day of week
Year
Time
Date
Important pointYou don't have to memorize the functions, but you should have an idea of what they will do for you.

Accessing functions

The Sum function is located on the Standardtoolbar.

AutoSum Button

To use the Sum function:

  • If necessary, enter the numbers you want to calculate.
  • Select the numbers you want to total.
  • On the Standard toolbar, click the Sum button. AutoSum Button
  • Your total appears in the cell below the range you selected.

To access other common functions:

  • Click the cell where you want the result of the function to appear.
  • Type the equals sign.
  • On the Formula bar, click the Edit Formula button. Edit Formula Button
  • Choose a function from the Function Box drop-down list.
  • The result of the function appears.
Function Box drop down list
Important pointIf you didn't see the function you were looking for, there are other functions available through the Paste Function dialog box, which are explained below.

 Excel will not always tell you if your function contains an error, so it's up to you to check all of your functions. To learn how to do this, read the Double-Check Your Formulas lesson from our Excel Formulas tutorial.

To access other available functions:

  • Click the cell where you want to place the end result.
  • Type the equals sign.
  • On the Formula bar, in the function box drop-down list, choose More Functions.
  • The Paste Function dialog box opens. Choosing InsertLesson ActionFunctions or clicking the Paste Function button Paste Function Buttonopens the Paste Function dialog box as well.
  • Notice the function categoriesavailable, including statistical, financial, and date and time.
  • When a function category is selected, the corresponding function namesdisplay. Additional information about the function name displays in the lower part of the dialog box.
  • Click OK.
Paste Function Dialog Box


Challenge!

  • In Excel, re-create the spreadsheet shown below.
  • In cell address B11, enter the sum of the range B5:B9 using the Sum function.
  • Copy the formula to the other columns (C11:F11), totaling columns C, D, E, and F.
  • In cell address B12, enter the averageof the range B5:B9 using the Edit Formula button.
  • Copy the function to the other columns (C12:F12), averaging columns C, D, E, and F.
  • Use the Paste Function button Paste Function Button to enter the COUNT in cell B13. Copy the function to the other columns (C13:F13).
  • columns (C13:F13).
    • Mary's Boutique Example
Labels:

Comments

Post a Comment

Popular posts from this blog

The Advanced Guide to Colours In Graphic Design

The power of color Color plays a vital role in  design  and  everyday life . It can draw your eye to an image. Sometimes it can trigger an emotional response. It can even communicate something important without using words at all. So how do we know which colors look good together and which ones don't? The answer is simple:  Color theory . Artists and designers have followed  color theory  for centuries, but anyone can learn more about it. It can help you feel confident in many different situations, whether it's  choosing colors for a design  or  putting together the perfect outfit . With a little insight, you'll be looking at color in a whole new way. Color basics Let's start at the beginning with a refresher on the basics. Remember learning about  primary and secondary colors  in school? Then you already have some knowledge of color theory. Secondary colors  are created by combining two  primary colors...
Post a Comment
Read more

The Ultimate Cheat Sheet On Making Basic Adjustments In Image Editting

Introduction Image editing is all about adjusting your images to make them look better. We're going to talk about some of the most  basic image adjustments , along with some common problems to watch out for when making these changes. The adjustments we'll cover in this lesson include: Cropping : If you want to remove parts of an image, you can  crop  it. You can think of cropping as using a pair of scissors to  cut out  the parts you no longer want. Resizing : If you want to make an image smaller or larger, you can  resize  it. However, keep in mind that making an image larger than its original size generally does not look good. Rotating : If you want to change the  orientation  of an image, you can  rotate  it to the left or right. Optional : If you'd like to follow along, you can download some or all of our  example images . Just click any of the images below to open a full-sized version. Then right-click the full-si...
3 comments
Read more

Layout And Composition In Graphic Design: It's Not as Difficult as You Think

What is composition? In many ways, layout and composition are the  building blocks  of design. They give your work structure and make it easier to navigate, from the margins on the sides to the content in between. Why is composition so important? In short, it's the  way your content is arranged . It doesn't matter if you're working with text, images, or elements in a graphic; without a thoughtful, well-composed layout, your work would basically fall apart. Five basic principles The key to mastering layout and composition is to  think like a designer . Luckily, it's easier than it sounds. There are  five basic principles  that can help you transform your work and sharpen your eye for design. Keep them in mind during your next project, and look for ways to apply them. Proximity Proximity is all about using  visual space  to show  relationships  in your content. In practice, it's pretty simple—all you have to do is make su...
Post a Comment
Read more