Data Entry Nios Plus Two PQ Welcome to your Data Entry Nios Plus Two PQ Total Questions: 78 Name Mobile No. 1. Fill in the blanks: Which function is used to calculate sum of a range of cells with respect to a given criteria ? COUNTIF IF SUMIF SUM None Hint 2. Different effects can be applied on smart art graphics with the help of which tab? Data Format Design Developer None Hint 3. By default, Tab stops are set at 0.5 inch intervals. State True or False for the following statements: False Only in MS Excel Only in Notepad True None Hint 4. Fill in the blanks: What is the shortest way of selecting a whole paragraph? Press Ctrl + A Triple-click anywhere in the paragraph Double-click at the beginning of the paragraph Click and drag the mouse pointer None Hint 5. Which of the following is correct cell address if the column name is F and row number is 15F F/15 F15 F@15 None Hint 6. Which of the following shortcut key is used to select entire document? Ctrl+All Ctrl+A Ctrl+Whole Ctrl+Ent None Hint 7. Expand the following PC Public Console Primary Control Private Computer (B) Personal Computer None Hint 8. Which of the following syntax for a function is correctly written? SUM (=“P3 : A3”) SUM (F5/A5) SUM =\*P5 SUM (B3 : F3) None Hint 9. Name the types of printer which is extremely fast but works quietly with automatic paper loading feature. Laser Printer Drum Printer Line Printer Dot Matrix Printer None Hint 10. Fill in the blanks: A____________ is text which is added to the top margin of every page. Footer Title Header Heading None Hint 11. Fill in the blanks: _____ colour wavy line appears under a misspelt word. Blue Yellow Red Green None Hint 12. Expand the following TLD Transfer Link Device Top Layer Domain Transport Line Data Top Level Domain None Hint 13. Fill in the blanks: ____ is the short-cut key for paste option Ctrl + V Ctrl + P Ctrl + X Ctrl + C None Hint 14. Expand the following ISDN Internet Signal Data Node Integrated Services Digital Network International Standard Digital Network Indian Standard Data Network None Hint 15. Fill in the blanks! _______ is the short-cut key for Paste option. Ctrl + V Ctrl + X Ctrl + C Ctrl + P None Hint 16. Fill in the blanks: ________ colour wavy line appears under misspelt word. Green Red Yellow Blue None Hint 17. Suneeta was teaching about printers and its types in a computer class. At the end she asked students following two questions. Please try to answer. Name the printer type which produces text by combination of dots on a paper.? Thermal Printer Dot Matrix Printer Laser Printer Inkjet Printer None Hint 18. Name the text that is added to the bottom margin of every page. Footnote Title Footer Header None Hint 19. Expand the following ISDN stands for: Internet Subscriber Data Network Interconnected Service Digital Network Integrated Services Digital Network Internal Signal Device Network None Hint 20. Which function is used to calculate sum of a range of cells with respect to a given criteria? AVERAGEIF COUNTIF SUMIF SUM None Hint 21. What is a High level language? Give at least two examples. A programming language that is closer to human language and easier to understand (eg; Python and Java) A language that uses only binary code and works directly with hardware (eg; Assembly and Machine Language) A language that cannot be compiled or interpreted (eg; TCP and IP) A language that is used only to control printers and keyboards (eg; HTML and XML) None Hint 22. Which of the following feature helps to add cell values ? Auto add Auto Sum Add all ASUM None Hint 23. Which of the following key combination is pressed to make the line of text bold after its selection? Ctrl+B Ctrl+Bold Ctrl+1 Ctrl+O None Hint 24. In Excel, the value of the formula: F3 = B3 + C3 + D3 + E3 will be ____________if the values for B3 = 50, C3 = 93, D3 = 89 and E3 = 30. 260 261 259 262 None Hint 25. What is the difference between a compiler and an assembler? A compiler translates a high-level language program into machine code, while an assembler converts assembly language into machine code. A compiler is used to translate voice to text, and an assembler helps in printing documents. None Hint 26. Expand the following TCP stands for: Transmission Control Protocol Technical Command Protocol Transfer Coding Process Terminal Connection Point None Hint 27. Expand the following TCP Transport Control Protocol Transfer Communication Protocol Transmission Control Protocol Technical Communication Path None Hint 28. Suneeta was teaching about printers and its types in a computer class. At the end she asked students following two questions. Please try to answer. Name the types of printer which is extremely fast but works quietly with automatic paper loading feature.? Dot Matrix Printer Thermal Printer Laser Printer Inkjet Printer None Hint 29. What is a High-Level Language? Give at least two examples. A language that is closer to human language and allows easy programming, such as Python or Java. A language that uses machine-level instructions and is hardware dependent. None Hint 30. Fill in the blanks: What is the key combination which is pressed to insert a page break? Alt + Enter Ctrl + Shift + Enter Shift + Enter Ctrl + Enter None Hint 31. What is the difference between a compiler and an assembler? Compiler converts high-level language to machine code, assembler converts assembly language to machine code. Assembler is used to compile high-level languages like Python. Compiler and assembler are the same. Compiler converts binary to text, assembler converts text to binary. None Hint 32. Identify the feature of Excel which allows you to draw geometrical shapes: Graphics Geometry Shapes Auto Shapes None Hint 33. Which of the following is not a component of chart? Grid lines Flow charts Legends Tick marks None Hint 34. Fill in the blanks: When you cut or copy text, the text is stored in an area of memory called _____ Clipboard Buffer ROM Register None Hint 35. Fill in the blanks! When you cut or copy text, the text is stored in an area of memory called________ Storage Cache Clipboard Buffer None Hint 36. State True or False for the following statements: By default, Tab stops are set at intervals of: 0.25 inch 0.5 inch 2 cm 1 inch None Hint 37. Which of the following syntax for a function is correctly written? SUM (83: F3) SUM (F5/A5) SUM (P3: A3) SUM (PS) None Hint 38. 19. (a) Name the printer type which produces text by combination of dots on a paper. (b) Name the types of printer which is extremely fast but works quietly with automatic paper loading feature. Suneeta was teaching about printers and its types in a computer class. At the end she asked students following two questions. Please try to answer. None Hint 39. Fill in the blanks! __________ is a slide that is used as a starting point for all other slides of the presentation, Layout Slide Design Template Slide Master Title Slide None Hint 40. Expand the following ISP Internet Software Program Internet Service Provider International Service Provider Internal Security Protocol None Hint 41. Fill in the blanks: XY charts are also known as _______ charts. Bar Pie Scatter Line None Hint 42. Identify the type of element which can not be shown inside a text box: Clip art Smart art Paper sheet Table None Hint 43. ___________ is a slide that is used as a starting point for all other slides of the presentation. Master Slide Title Slide Index Slide Layout Slide None Hint 44. Ctrl+L and Ctrl+R activate which type of oprations on text ? Replacement Alignment Selection Deletion None Hint 45. Ctrl+) keys are pressed to do which of the following action? To go to the end of the document To Print a text To Replace a text To make the text aligned as justified None Hint 46. In the questions given below, there are two statements marked as Assertion (A) and Reason (R) Assertion (A):Bar Code Reader is an image scanner. Reason (R):An image scanner translates printed images in an electronic format which can be stored in a computer's memory Both (A) and (R) are true but (R) is not the correct explanation of (A). (A) is true but (R) is false. Both (A) and (R) are false. Both (A) and (R) are true and (R) is correct explanation of (A). (A) is false but (R) is true. None Hint 47. If you press function key F7, which feature will get activated? Find and Replace Save As Spell Check Print Preview None Hint 48. State True or False for the following statements: Font size is measured in: Meters Pixels Inches Points None Hint 49. Which of the following is not a PowerPoint view? Normal Content Slide Sorter Slide Show None Hint 50. Which function is used to calculate sum of a range of cells with respect to a given criteria? SUMIF() SUM() COUNTIF() IFSUM() None Hint 51. In the questions given below, there are two statements marked as Assertion (A) and Reason (R) Assertion (A):Line spacing determines the height of text in the paragraph.Reason (R): The default option is single line spacing Both (A) and (R) are true and (R) is the correct explanation of (A) Both (A) and (R) are false. Both (A) and (R) are true but (R) is not the correct explanation of (A). (A) is true but (R) is false. (A) is false but (R) is true. None Hint 52. Which of the following is a logical operator? + \ / > None Hint 53. What happens when we press Ctrl + A while working in a Word document? Entire document is copied Entire document is selected Entire document is deleted Entire document is capitalised None Hint 54. Name the type of printer which is extremely fast but works quietly with automatic paper loading feature. Laser Printer Line Printer Inkjet Printer Dot Matrix Printer None Hint 55. Expand the following PC stands for: Portable Circuit Private Circuit Personal Computer Primary Computer None Hint 56. Name the printer type which produces test by combination of dots on a paper. Inkjet Printer Dot Matrix Printer Thermal Printer Laser Printer None Hint 57. Fill in the blanks: ______ is the shortcut key for the Paste option. Ctrl + C Ctrl + P Ctrl + V Ctrl + X None Hint 58. What is a high-level language? Give at least two examples. A high-level language is a programming language that is easy for humans to read and write. Examples include Python and Java. A high-level language is one that only robots can understand. Examples include BIOS and HTTP. None Hint 59. Which of the following is not a text alignment option? Left Right Center South None Hint 60. Name the tool bar on which lie the bulleted list button. Drawing Toolbar Standard Toolbar Review Toolbar Formatting Toolbar None Hint 61. Which of the following is a valid cell reference? X59Y 2001 A4 25A None Hint 62. Fill in the blanks! ________is a single media file which includes sound, animation, art or movie. Spreadsheet Template Document Multimedia None Hint 63. What is the difference between a compiler and an assembler? A compiler converts high-level language into machine code, while an assembler converts assembly language into machine code. A compiler converts machine code into high-level language, while an assembler converts high-level code into assembly code. None Hint 64. Fill in the blanks: ___________ is a slide that is used as a starting point for all other slides of the presentation. Title Slide Main Slide Slide Master Home Slide None Hint 65. State True or False for the following statements: Font size is measured in meters. True False Depends on the font type Only in MS Word None Hint 66. State True or False for the following statements: By default, Tab stops are set at 0.5 inch intervals. False Only in spreadsheets True Cannot be changed None Hint 67. Which of these is not a type of chart? Pic Column Laser Bar None Hint 68. Name the two orientation options for any page of a document: Vertical and Horizontal Left and Right Portrait and Landscape Top and Bottom None Hint 69. Fill in the blanks: You can add _______ to any side of a paragraph along with background shading. Margins Footnotes Borders Headers None Hint 70. Font size is measured in meters. State True or False for the following statements: True None of these Can't Say False None Hint 71. Fill in the blanks: When you cut or copy text, the text is stored in an area of memory called _______ Pen drive Hard disk RAM Clipboard None Hint 72. Fill in the blanks! All line spacing options are found under__________ dialog box. Font Page Setup Format Paragraph None Hint 73. Fill in the blanks: _________ is a printer that produces images by pushing electrically heated pins against heat-sensitive paper. Dot Matrix Printer Thermal Printer Inkjet Printer Laser Printer None Hint 74. Which of the following is not a type of slide layout? Section Header Title only Comparison Chart None Hint 75. Expand the following TLD stands for: Technical Link Design Transfer Level Domain Total Link Data Top Level Domain None Hint 76. Name the printer type which produces text by combination of dots on a paper. Laser Printer Inkjet Printer Thermal Printer Dot Matrix Printer None Hint 77. Fill in the blanks! ________ colour wavy line appears under a misspelt word. Green Yellow Blue Red None Hint 78. Which of the following syntax for a function is correctly written? SUM (P3: A3) SUM (B3: F3) SUM (P5) SUM (F5/A5) None Hint Time's up Share: admin Previous post Maths Nios Plus Two PQ June 23, 2025 Next post Sociology Nios Plus Two PQ VIII June 24, 2025
