Download PTU BHMCT 2nd Semester 2019 May 14519 COMPUTER II Question Paper

Firstranker's choice

FirstRanker.com

Roll No.

--- Content provided by‍ FirstRanker.com ---

Total No. of Questions : 09

BHMCT (Sem.-2)

COMPUTER-II

Subject Code : BH-108

M.Code: 14519

--- Content provided by FirstRanker.com ---

Total No. of Pages : 02

Time: 3 Hrs.

Max. Marks : 30

INSTRUCTION TO CANDIDATES :

1. SECTION-A is COMPULSORY consisting of TEN questions carrying ONE mark each.

--- Content provided by‌ FirstRanker.com ---

2. SECTION-B contains FIVE questions carrying 21/2 (Two and Half) marks each and students has to attempt any FOUR questions.
3. SECTION-C contains THREE questions carrying FIVE marks each and students have to attempt any TWO questions.

SECTION-A

Answer briefly :

1. Define spreadsheet.

--- Content provided by⁠ FirstRanker.com ---

2. Define Row Height
3. Define Cell Address.
4. Define Active cell.
5. How to delete a worksheet?
6. How to rename a Worksheet?

--- Content provided by FirstRanker.com ---

7. What is Cell Range?
8. How to undo mistakes in Excel?
9. Define Formula bar.
10. What is the purpose of Freezing columns?

SECTION-B

--- Content provided by​ FirstRanker.com ---

2. Explain splitting worksheet window.
3. How to print whole worksheet in a page?
4. How to add header and footer in a report?
5. What is chart wizard?
6. How to attach comments to a cell?

--- Content provided by​ FirstRanker.com ---

SECTOR-C

7. What are Excel database facilities?
8. Define Function. Explain with the help of four different functions.
9. Write a note on “Protecting a worksheet”.

NOTE : Disclosure of Identity by writing Mobile No. or Making of passing request on any page of Answer Sheet will lead to UMC against the Student.

--- Content provided by​ FirstRanker.com ---