1.

SECTION-A

Employability Skills

Answer any 5 questions out of the given 6 questions (1 x 5 = 5 marks)

1. In the ..................... process, words or non-verbal means are utilized to translate the thought into a message

2. ............. barrier in communication occurs when people are unable tounderstand each other's customs and traditions, resulting in inconveniences and difficulties.

3. .............. means to stay updated on the best practices and be ready for new changes, so that transitions can happen seamlessly.

4. By managing ......................, you can deal with daily pressures and triggers, and meet challenges head-on.

5. The machinery of a computer which includes keyboard, monitor, CPU, etc., is known as

6. ................. includes using or distributing unlicensed and unauthorized copies of a computer program

software.

7.

SECTION -B

KNOWLEDGE BASED QUESTIONS

A/AN ................ is a set of formats that you can apply to selected pages, text, frames and other elements in your document.

8. In setting up subtotals in the subtotal dialog box, which option in not avialable in the use fu

nction box?

9. A database is an organized collection of

10. Wh ich of these styles includes header and footer, border and margins ?

11. By adding a scenario, we can quickly change the .................. of a formula and view the new results.

12. Which of the following is not a database program ?

13. Which of these options ca n be used to apply font size, bold and italics format etc., to the selected text?

14. In OpenOffice.org Calc, we ca nnot consolidate data by...............

15. .............. stores data in single table.

16. What is the shortcut for opening styles and formatting window?

17. Duplication of data is called ...........

18. ...............are dedicated computers that hold the actual databases, and run on ly DBMS and related Software.

19. ............... is used to apply a style to many different areas quickly without having to go back to the Styles and Formatting window, and double-click every time.

20. Which option in the Options tab of Subtotal is deselected to deactivate Sort tab?

21.

GUl acts as front end and database server acts as........

22. We can create style by :

23.

 Which option is not available in the Settings option of Create scenario dialog box?

24.

 Which function key is used to edit a formula in Excel?

25.

We can also modify the predefined styles -True or False?

26.

What does + sign indicate in this section of spreadsheet?

27.

SECTION-C

Competency Based Questions

Answer any 5 questions out of the given 6 questions(1 x 5 = 5 marks)

Study the table given below and answer the following:

After working out her budget, Sonam realizes that total expenses, i.e. = 18,278 ismuch more than her income, i.e. = 12850. She wants to modify her budget byreducing all her non-essential budget items. Which analytical tool can she use toachieve this?

28.

Global Artwork Ltd. did its maximum sales of art books and notebooks in themonth of April and wanted to highlight the worksheet tab for that month with redcolour. How can they make their worksheet tab look red?

29.

Raman is working on a photo album and is using picture toolbar. He wants toknow what does the percentage value in the given box signify?

30.

Rehman wants to write a blog for his trip to Himalayan Ranges. He has clickedsome pictures as well which should come along with the write up. Which featureisthe most suited to achieve this?

31.

Databases available on the database servers are accessed through command lineor graphic user interface tools referred to as ........; database servers arereferred to as .......... Such type of data access is referred to as a.........

32.

Given below are the two files maintained by the Admin and the Academicsdepartment separately, for keeping records of their students. Which of thefollowing problem occursin the records?