# CS101 Introduction to Computing Assignment 4 solution

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.

Question: 01

Solution:

• 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 =SUM(B6:B14) Total sale of Asif                               =SUMIF(C6:C14,”Asif”,B6:B14) Average sale of Asif =AVERAGEIF(C6:C14,”Asif”,B6:B14) Total Number of Products sold by Asif                              =COUNTIF(C6:C14,”Asif”) Maximum Price =MAX(B6:B14)

The most suitable topology for such a network is “Star Topology”. By this type of topology the computers will be connected with each other using a “central hub” by which we can connect more computers with the network at any time without any breakage or any problem in the network. So,Star Topology is more reliable than that of other like “Ring Topology”because if a computer failed to work or have any problem it will not affect the entire network. So, We can replace computer at any time or can also add computers without any failure of the network. We can also share printer or scanner with entire work.

Comparison of all Topologies.

Ring Topology:

If we establish a network using Ring Topology it will stop entire network in case of a single node or computer failure. So, it is not so reliable to use in such an office.

Bus Topology:

If we install a Bus Topology for such a network it will be more reliable but it will be very slow in performance.

Star Topology:

If we use a “Star Topology” it will reduce all such problems and the network performance will be faster and reliable and in case of fault of a computer or node the entire network will not affected and we can easily replace or can add more computers in this network using central hub.