# CS 101 – 4th Assignment Solution

Assignment No. 04
Semester: Fall 2012
Introduction to Computing-CS101

Total Marks: 15

Due Date:24/01/2013

Instructions:

• You will submit your assignment before or on due date on VU-LMS.
• Assignment should be completed by your own efforts it should not be copied from internet, handouts or books.
• You should submit your MS Word File via assignment interface at VU-LMS.
• Assignment sent via Email will not be replied and accepted/graded in any case.
• If the submitted assignment does not open or file is corrupt, it will not be graded.
• You will submit solution only in MS Word file (.doc or .docx) file.

Objectives:

• To understand the fundamental concepts of Spread sheet and Network topologies

For any query about the assignment, contact at cs101@vu.edu.pk

Assignment Questions

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).

 Total sale Total sale of Asif Average sale of Asif Total Number of Products sold by Asif Maximum Price

(Figure 1)

 Notes for question # 1:

1) While writing formulas; only use the given range in formulas, other range should not be accepted

2) Do not send excel file, send us the word file only

3) Do not paste the excel file in the word file.

4) You are to only write down formulas in the 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