Online FINAL-Examination (DIT+)

0%
0 votes, 0 avg
230

Report a question

You cannot submit an empty report. Please add some details.
Created on By ICL Computer Private Limited

DIPLOMA IN INFORMATION TECHNOLOGY PLUS (FINAL EXAMINATION) 2026

Award of Grade:

The Grade of SATISFACTORY requires securing a minimum score of 40% in each internals as well as the final examination
& an overall weighted score of 50% An overall weighted score of 60-74% qualifies for CREDIT and >=75% qualifies for DISTINCTION.
General information: 1. The examination will comprise of Objective type Multiple Choice Questions (MCQs) 2. All questions are compulsory and each carries One mark. 3. The total number of questions, duration of examination, will be different based on the course, the detail is available on your screen. 4. The Subjects or topics covered in the exam will be as per the Syllabus. 5. There will be NO NEGATIVE MARKING for the wrong answers.

Fill in the form in all Capital Letters. 

फॉर्म ध्यानपूर्वक भरने के लिए मुख्य दिशा-निर्देश (Important Guidelines)

मोबाइल/ईमेल: हमेशा सक्रिय (Active) मोबाइल नंबर और ईमेल आईडी ही दें।

नाम (Name): मार्कशीट/आधार के अनुसार पूरा नाम लिखें।

पिता का नाम (Father's Name): स्पेलिंग जांचें।

जन्मतिथि (Date of Birth - DOB): - कैलेंडर से सही दिनांक चुनें।

1 / 100

1) The value of primary key cannot be

2 / 100

2) What is the default extension of Excel 2019 files?

3 / 100

3) Which of these references is an example of a relative reference?

4 / 100

4) The form that contains one or more subforms is called the _____ form.

5 / 100

5) What does COUNTA () function do?

6 / 100

6) A worksheet range is a

7 / 100

7) The first cell in EXCEL worksheet is...

8 / 100

8) Which function key is used to run the spelling checker?

9 / 100

9) __________ are documents that when filled in create records.

10 / 100

10) A filter is used to quickly limit the records you are already viewing in a datasheet or form.

11 / 100

11)  In Word Drop caps applied to      

12 / 100

12) The table can be related on a command field called.

13 / 100

13) Which of the following data types automatically generates a consecutive number?

14 / 100

14) Font size is commonly measured in?

15 / 100

15) What is the function of the Format Painter tool?

16 / 100

16) What is the correct way to refer the cell A10 on sheet3 from sheet1?

17 / 100

17) In Datasheet View, new records are added to a table _______________.

18 / 100

18) In Word, the ruler is displayed by default.

19 / 100

19) If a formula with relative reference is copied the cell references used in the formula remain unchanged.

20 / 100

20) In MS-Excel value used in a formula that does not change is called a

21 / 100

21) An existing presentation can be saved with a new name using the _________ command.

22 / 100

22) Which is an example of a formula?

23 / 100

23) Comments put in cells are called …..

24 / 100

24) A typical worksheet has ___ number of columns

25 / 100

25) What would be the result of =SUM(A1,250), if A1=25?

26 / 100

26)   A set of rules is known as protocol.

27 / 100

27) SQL stands for __________.

28 / 100

28) A main form can have only one subform.

29 / 100

29)   In MS-Excel what does SUMIF function do?

30 / 100

30) A database is an organized collection of records.

31 / 100

31) What would I choose to create a pre-formatted style?

32 / 100

32) How many characters can be typed in a single cell in Excel?

33 / 100

33) What is the symbol for dividing?

34 / 100

34)  "After a table has been created, which of the following operations cannot be performed?"

35 / 100

35)   If your text exceeds the size of the placeholder, Microsoft PowerPoint reduces the font size and line spacing incrementally as you type, to make the text fit.

36 / 100

36) How do you rearrange the data in ascending or descending order?

37 / 100

37)  "When you activate the Spelling and Grammar checker," 

38 / 100

38) How do you tell one cell from another?

39 / 100

39) The last cell in EXCEL worksheet is

40 / 100

40)  You can enlarge the sheet upto 500% while printing

41 / 100

41) To create a new worksheet, select worksheet from the file menu.

42 / 100

42) In which tab is the Header and Footer button found?

43 / 100

43) In M.S Access 2010 the extension of database is

44 / 100

44) Which symbol displays the text in upper case?

45 / 100

45) In Datasheet View, what appears at the top of each column?

46 / 100

46) Which of these references is an example of a mixed reference?

47 / 100

47)  ISP is a company that provides an Internet connection  

48 / 100

48) To print information from a table, the __________ tool is the best choice.

49 / 100

49) The __________ field is used to hold a yes or no answer.

50 / 100

50) slide show begins with the _______________.

51 / 100

51) "In Word, print preview command is found under which menu?" 

52 / 100

52) To have Microsoft Excel always use a specific currency symbol, change the currency symbol selected in Regional Settings in Control Panel before you start Excel.

53 / 100

53) When you turn on background printing, you can continue working in PowerPoint while you print.

54 / 100

54) Which Chart can be created in Excel?

55 / 100

55) Which cell alignment is assigned to most values by default?

56 / 100

56) The undo command is found where in Access?

57 / 100

57) How do you display current date and time in MS Excel?

58 / 100

58)    GUI is used as an interface between

59 / 100

59) To insert a header or footer in a worksheet, select Header and Footer option in the File menu.

60 / 100

60) Pressing [Ctrl]+[M] _______________.

61 / 100

61) Which function key is used to run the slide show

62 / 100

62) How many worksheets can a workbook have by default?

63 / 100

63) Which is an example of a function?

64 / 100

64) Which of the following statements about the Undo option in PowerPoint is NOT correct?

65 / 100

65) A command button executes one or more actions on a form.

66 / 100

66) When information is keyed for a footer, by default, where will it appear?

67 / 100

67) Which area in an Excel window allows entering values and formulas?

68 / 100

68) How is a spelling error indicated?

69 / 100

69)  In Excel, once a range has been named, you can go to a range

70 / 100

70) What is the keyboard shortcut to move to the last records in a table?

71 / 100

71) If you key 1.2385 and format the cell for two decimal places, what will be displayed in the formula bar?

72 / 100

72) An Excel Workbook is a collection of …….

73 / 100

73) The field size can vary for text field from

74 / 100

74) Users can turn off the Format Painter button by pressing the _______________ key.

75 / 100

75) The purpose of AutoSum in Excel is to 

76 / 100

76) Which of the following is not a valid data type in Excel?

77 / 100

77) The __________ is used to access one record at a time.

78 / 100

78) Excel displays the current cell address in the ……….

79 / 100

79) Memo field is used to the picture.

80 / 100

80) Microsoft Excel is a powerful………..

81 / 100

81) In the formula, which symbol specifies the fixed columns or rows?

82 / 100

82) Which of the following is not a term of MS-Excel?

83 / 100

83) A formula does not always start with = sign

84 / 100

84) In M.S Access the default text field size is.......

85 / 100

85) Fiber optics have the advantage of _____.

86 / 100

86) e-mail is   

87 / 100

87) How do you display current date only in MS Excel?

88 / 100

88) The Default view in MS Power point 2010

89 / 100

89) Theme effects are most noticeable when?

90 / 100

90) What is the short cut key to highlight the entire column?

91 / 100

91)  

In MS-Excel which is used to perform what if analysis?

92 / 100

92) Status bar shows different types of keys: 

93 / 100

93) In addition to the Slides tab in Normal view, which view allows a user to select slides?

94 / 100

94) "When you create a formula that contains a function, the Insert Function dialog box helps you enter worksheet functions."

95 / 100

95) To delete records or perform calculations on a table, the best tool to use is a

96 / 100

96) To select an entire column in MS-EXCEL, press?

97 / 100

97) Which function counts the number of cells that contain numeric as well as text

98 / 100

98) To perform calculation on database we use the following formula =DFUNCTION(database, criteria, field).

99 / 100

99) To print the PowerPoint presentation, press

100 / 100

100) It is possible to use Sum, Average and Count Function together in a single Subtotal operation

Your score is

0%

Exit