CS101 Assignment no 4 Fall 2012 Idea Solution written update

CS101 Assignment no 4 Fall 2012 Idea Solution written update 

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 [IMG]file:///C:/DOCUME~1/ADMINI~1/LOCALS~1/Temp/msohtmlclip1/01/clip_image003.jpg[/IMG] (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

-->