[BA 3rd Sem Question Papers, Dibrugarh University, 2014, Computer Skill, General/Major, PC - Software]
1. Answer the following as directed: 1x5=5
- What is desktop?
- Round (89.642) will return ____. (Fill in the blank)
- It is impossible to copy a formula in MS-Excel. (State True or False)
- ____ is the extension of a PowerPoint file. (Fill in the blank)
- What is filtering?
2. (a) What is a desktop shortcut? 2
(b) Write the steps to save a workbook in MS-Excel. 2
(c) What are the four slide layouts available in PowerPoint? 2
(d) Write down the steps to add header and footer in an MS-word document. 2
(e) What are the different types of chart available in Excel? 2
3. (a) Differentiate between slide sorter view and slide show view. 3
(b) Write the functions of operating system. 3
(c) Explain the following functions: 5
- SUM()
- ABS()
- MIN()
- MAX()
- FLOOR()
Or
Explain in brief the features of Windows operating system. 11
4. (a) Explain the following: 3+3=6
- Advance features of MS-Excel.
- Goal seek and scenario.
(b) Explain about the linking and embedding object in MS-Word. 5
Or
Explain in brief about page formatting in MS-Word. 11
5. (a) On the basis of the following worksheet, answer the questions below:
A | B | C | D | |
Item | Price | Quantity | Value | |
1 2 3 4 5 | X Y S Total Max Price | 1000 2000 3000 | 180 300 400 |
- Write the formula to display ‘value’ for each item in column D. 2
- Write the formula to display total of value in cell D4. 2
- Write the formula to display maximum price in cell B5. 2
Also Read: Dibrugarh University Question Papers
(b) Write the steps to perform the following in a slide of PowerPoint presentation: 5
- Apply animation effect to each main point and sub-point.
- Hide a slide from slide show.
- Apply sound effect in each slide.
- Apply design template.
- Insert footer in a slide.
Or
Write short notes on the following: 6+5=11
- Features of MS-PowerPoint.
- Features of MS-Excel.
***
Post a Comment
Kindly give your valuable feedback to improve this website.