We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>
+ Link For Assignments, GDBs & Online Quizzes Solution
+ Link For Past Papers, Solved MCQs, Short Notes & More
Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion
How to Add New Discussion in Study Group ? Step By Step Guide Click Here.
Assignment No. 04
Please read the following instructions carefully before submitting assignment:
For any query about the assignment, contact at firstname.lastname@example.org
Question: 1 Marks 10
Suppose given is a worksheet of MS Excel. (Figure 1)
Apply the Most appropriate formulas in MS Excel using the same data given in the below diagram, to find the result (same as shown in the diagram) of the below mentioned requirements and just write down the formulas in the solution file (MS word file).
Question: 2 Marks 5
The “HaseebSoft” organization launches a project for 1 year. Now the Project Manger wants to build a computer network for the project smooth running of the project. The project details are given below:
Project Duration: 1 year (Extendable)
Required Resources: 12 computers+ 1 printer+1 scanner
Future enhancements: 8 to 10 computers may be added
For such type of scenario, which topology is most suitable for network and why? Justify your answer.
BEST OF LUCK
.+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)
+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)+ Click Here to Search (Looking For something at vustudents.ning.com?) + Click Here To Join (Our facebook study Group)
Our main purpose here discussion not just Solution
Please Discuss here about this assignment.Thanks
Total Sale: 129000 ==>> =SUM(B6:B15)
Total sale of Asif: 78000 ==>> =SUM(B6,B8,B10,B12)
Average sale of Asif: 195000 ==>> =AVERAGE(B6,B8,B10,B12)
Total Number of Product sold by Asif: 4 ==>> =COUNT(B6,B8,B10,B12)
Maximum Price: 55000 ==>> =MAX(B6:B14)
its not logically solution yaar,,,,,think a while... if teacher give you an assignment which contains over one million records and you have to fulfill above requirement then "would you perform said action" Of course not otherwise it would take couple of days to find where is asif and its product sold-out figures:::::try sumif equal to formulas by giving specific range....Am sorry Its my suggestion not discouraging you all....Its looking very simple solution but professionlizum required to fill it with future references,,,,, try it like this (=SUMIF(K8:K16,"=Asif",J8:J16)
can you elaborate your point please
sir i think star topology is the best for asked setup. on switch is required
All students must share points and also your problems.... so it can discussed and solution can prepare.
Don’t wait for solutions just participate in Discussions because after discussions a correct solution will prepare...
2nd: star topology.
total number of product of asif =COUNTIF(C6:C14,"=Asif")
u just write formulas in word format.
I am a bit confuse about the 4th one, ap logon me sy kisi ne ye likha he k, =countif(c6:c14,"=asif") ka function use hoga lekin meri knowledge k mutabiq, ye function to is liay use hona chahiye k data men name Asif kitni bar aya he? answer to same hoga lekin formula men, I think kuch garbar he.. Kyunk hmen to no. of products batani he..nai?
Please somebody guide in this area and correct me if i am wrong...
Aur 2nd question men I think star hoga....
Uper wali diagram sy bhe yehi prove hota...
for solution of second question (those don't have enough knowledge about networking) make your house electricity board planning on simple paper, and you have to give connection to all rooms, all appliances and may be extended on upper portion in future.....This typically paper work lead you how to fll gap in networking by focusing extension in future...it means you have to focus on "Main boards" where all electricity connections having plug in and out with some extra switches for extension.....
thaaaaaaaaaaaaaaaaaaaaaaaaaaanx a lot for sharing samara...
Ist question ma mja b doubt ha plz any one guide correct solution,