Question about Microsoft EXCEL 2004 for Mac

2 Answers

What are the formulas in grading the grades uisng microsoft excel

Posted by on

  • shujat_hussa
    shujat_hussa Nov 08, 2012

    please visit to learn all excel functions and formulas All-in-One Excel Functions and Excel Formulashttp://atips4pc.blogspot.com

×

Ad

2 Answers

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Novelist:

    An expert who has written 50 answers of more than 400 characters.

    Governor:

    An expert whose answer got voted for 20 times.

  • Expert
  • 182 Answers

Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.

Formulas used in Excel must follow a certain syntax.

  1. All formulas begin with an equals sign (=).
  2. Some formulas use operands such as +,-, *,/ for addition, subtraction, multiplication or division.
    For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3.
  3. Other formulas refer to different functions such as SUM, AVERAGE and others.
    For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3.
  4. Formulas can be combined with operands.
    For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10.
  5. Functions can be nested within each other.
    For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.

Posted on Aug 19, 2011

Ad
  • Level 1:

    An expert who has achieved level 1.

    MVP:

    An expert that got 5 achievements.

    New Friend:

    An expert that has 1 follower.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Contributor
  • 24 Answers

Please visit to learn all excel functions and formulas
All-in-One Excel Functions and Excel Formulas

Posted on Nov 08, 2012

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE:

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Can you please give me a formula on how to compute the grades?


Grades?
If you are talking about GPA (Grade Point Average)
Then you can calculate it here
If you need to know, how it works, that goes here and here.
Regards,
Waqar.

Aug 13, 2009 | Microsoft Computers & Internet

1 Answer

What are uses of vlookup n hlookup?


An implementation of the vlookup in Excel could be:
You have an Excel table with student names and their grades.
You wish that you could somewhere in the sheet type a student name, and immediately retrieve his grade (based on the data in the table).
To achieve this, you can use "Vlookup": the function will look for the student’s name in the first column in the table, and will retrieve the information that is next to his name in the second column (which is his grade).

Hlookup is the same excpet it is for data arranged by rows instead of columns.

Dec 29, 2008 | Microsoft Office Home and Student 2007...

1 Answer

Formulas in computing grades in excel


www.youtube.com/watch?v=xOU_hL2_zBo

i havent watched it, but i think it might help. hope it helps, enjoy

Nov 16, 2008 | Microsoft EXCEL 2004 for Mac

1 Answer

NEED IF FORMULA FOR LETTER GRADING A-F


Hi again,

it would seem that you posted twice. Pls click here for you other post with my response.

Hope this be of initial help/idea. Pls post back how things turned up or should you need additional information.

Good luck and kind regards. Thank you for using FixYa.

Nov 02, 2008 | Microsoft Windows XP Home Edition

4 Answers

I need Excel's Furmula's


I found some excellent links to excel formulas for you:

This link lists excel formulas by category:

http://www.techonthenet.com/excel/formulas/

This link has some custom formulas for excel that you can download:

http://www.ozgrid.com/VBA/Functions.htm

Sep 20, 2008 | Microsoft Computers & Internet

2 Answers

I have been trying to get this formula or function to work all day


You might try looking/posting on forum sites like http://www.mrexcel.com/archive/index.html
That has helped me with different things, especially correct syntax.

MM85

Jul 27, 2008 | Microsoft Computers & Internet

1 Answer

Matching data


1. Open up both workbooks.
2. Copy one worksheet from one workbook to another using.
Right click on the tab of one book and Select "Move or Copy"
3. A dialog box will appear..Next to the "To book" select the workbook you want to move it to.
4. Be sure to select the 'create a copy' box in the bottom left of the dialog box.
5. Sort each worksheet by students name. Data..Sort.
6. Copy the scores from one sheet to another.
7. You then you can manipulate the scores and compare anyway you like by using formulas in different columns.

Apr 29, 2008 | Microsoft Excel for PC

1 Answer

Excel Formulas


http://office.microsoft.com/en-us/excel/HP030561151033.aspx
check this link for all excel formula

Sep 23, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?

Open Questions:

See all Microsoft EXCEL 2004 for Mac Questions

Microsoft EXCEL 2004 for Mac Logo

568 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18429 Answers

Alun Cox

Level 3 Expert

2679 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...