Study Groups By Subject code Wise (Click Below on your university link & Join Your Subject Group)
Looking For Something at vustudents.ning.com?Search Here
Assignment No. 05
Objective: To understand the basic features of MS Excel Spreadsheet.
Please read the following instructions carefully before solving and submitting assignment:
Note: It is recommended to use your VU ID as name of the assignment.
For any query about the assignment, contact at firstname.lastname@example.org
Please check attached idea solution
ye idea solution hai???????
is me tu kuch b nahi hai.
I can't see any guideline asking for categorizing students, this Excel assignment is just to make sure the basics of MS Excel, and in my solution i used strings by using values like 4.0 to view as 4.0, however if you type 4.0 in normal you will see it shown as 4 only and the ".0" will be hidden because of using number and you asked to format cells for GPA column. For Most efficient peoples, use formulas at your own risk. Thanks
yaar is mein to kch b ni
CS101_5th Assignment Idea guidline
its SO Easy assignment....
Put These Formula...
A Grade Students =SUMPRODUCT(--($C$2:$C$21>=4))
B Grade Students =SUMPRODUCT(--($C$2:$C$21>=3),--($C$2:$C$21<4))
C Grade Students =SUMPRODUCT(--($C$2:$C$21>=2),--($C$2:$C$21<3))
D Grade Students =SUMPRODUCT(--($C$2:$C$21>=1),--($C$2:$C$21<2))
F Grade Students =SUMPRODUCT(--($C$2:$C$21>=0),--($C$2:$C$21<1))
And Pie chart is so much easy to put... its too much easy assignment...
and these formulas are 100% correct if u apply..
thnkssssssssss i had done using
achha mazak he.serious effrts kro yaar
graph kasy bnana ha yaha
Salam main nay ya formula laga kar kam kia ha but graph nahi bna please help me
Download the Solution File of CS101 Assignment No 5 Solution Fall 2011
see attachment of cs 101 assignment solution
Ap Sub Ko Marwao Ge 2 Column Banane The Ap Ne Teen bana die.Baqi agey Kia Kro Ge Ap Hmare Saath