Final Paper - QUESTION PAPER Time allowed 2 hours ALL FIFTY...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
QUESTION PAPER Time allowed 2 hours ALL FIFTY questions are compulsory and MUST be answered using the answer sheet provided
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Write down the purpose and syntax (parameters) of the following functions: i. IF() ii. LEFT() iii. COUNTIF() (09) Q. No. 2 Write down Function / Formula for the data given below: A B C D E F 1 Employee_Name Basic Pay House Rent G.P. Fund Gross Pay Status 2 Mr. Ahmad Ali 3 Mr. Imran Asad 4 Mr. Abrar Ahmad (i) If Basic Pay of Mr. Ahmad Ali is greater than 25,000/- then his Status should be Manager, otherwise it should be Assistant Manager (In Status Column) (ii) 45% House Rent of Basic Pay of Mr. Imran Asad (In House Rent Column) (iii) 10% G.P. Fund of Basic Pay of Mr. Abrar Ahmad (In G.P. Fund Column) (09) Q. No. 3 What is a Topology? Differentiate the Star and Mesh Topologies with their advantages and Disadvantages. . (12) Q. No. 4 What is an input device? Describe any three input devices in detail. (10)
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

Final Paper - QUESTION PAPER Time allowed 2 hours ALL FIFTY...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online