Beltron Online Test for DEO / STENO / PROGRAMMER Exam – Set 03| Beltron Previous Paper नमस्कार दोस्तों, बेल्ट्रान डाटा एण्ट्री ऑपरेटर, 2024 की तैयारी के लिए हमारे द्वारा MCQ, Quiz के माध्यम से आपके EXAM की तैयारी को अशान और बेहतर बनाने हेतु Beltron Quiz तैयार किया गया है, जिसमे बेल्ट्रान द्वारा 2019 में पूछें गए सभी प्रश्न रहेंगे, जो कि आप प्रतियोगियों के लिए अतिमहत्वपूर्ण सिद्ध होंगे। निर्देश: MCQ QUIZ का यह एक सेट है जिसमें साठ (60) MCQ Questions/प्रश्न दिए गये हैं। प्रत्येक प्रश्न के चार Options/विकल्प दिये गये हैं जिसमे से एक सही Option/विकल्प को चयन करना है। प्रत्येक Set के लिए आपको 60 मिनट का समय सीमा दिया गया हैं। अपना डिटेल्स भरने एवं निर्देशों को पढ़ने के लिए 2 मिनट अतरिक्त समय दिया गया है। समय सीमा समाप्त होने के बाद, किसी भी प्रकार का बदलाव या चयन नही किया जा सकता है। उत्तीर्णता हेतु 50 प्रतिशत अंक लाना आवश्यक है। उन सभी प्रतियोगियों को हमारे द्वारा एक बहुमूल्य Certificate/प्रमाण पत्र प्रदान किया जाएगा। Certificate/ प्रमाण पत्र प्राप्त करने के लिए प्रत्येक Set में 50 प्रतिशत से ज्यादा अंक लाना अनिवार्य है। सभी प्रतियोगियों का MCQ QUIZ का Result/परिणाम सभी प्रश्नों के अंतिम में सबमिट करने के बाद दिखाई देगा। आपसे अनुरोध है की अपना नाम एवं मोबाइल नंबर सही-सही भरे। Name Mobile No. Email 1. Q.1 To preventother users from accidentally or deliberately changing, moving or deleting data in a worksheet, you can lock the cells on your MS-Excel worksheet which will prevent them from being modified accidentally. In this context, which of the following sequence of activities should be done? First protect the worksheet with or without a password, and then unlock cells that others can edit. Select the range of cells to be protected, and then select worksheet > Range > Lock First unlock cells that others can edit, and then protect the worksheet with or without a password. Select the range of cells to be protected, and then select worksheet > Range >Protect None 2. Q.2 You want to change the font colour of all the cells in a particular row of an MS-Excel worksheet to light blue. After selecting the appropriate row, which one of the following features you will NOT use for performing this task? Use ‘Font Color’ Use Format > Format Cells > Font Use ‘Cell Styles’ Use ‘Fill Color’ None 3. Q.3 When you're using a version of MS-Word that's newer than the version used to create your document, you typically see _________ Mode in the title bar. Old Version Compatibility Previous Earlier None 4. Q.4 The Insert Table button on the Standard toolbar or Insert tab is one of the fastest ways to insert a table in a MS-Word document. If you click the button, a box extends below the button with smaller boxes inside. Move your mouse over the number of cells you'd like to insert into the document. Notice that the cells change _________ as you move the mouse over them. Shape Colour Format Size None 5. Q.5 In MS-Power Point, ‘Slide Size’ is found in ______ menu. Slide Design Animation Trition Review None 6. Q.6 To make the contents of all the cells in Row 8 of the worksheet italics, you will: Select Row 8, and use the command: Ctrl + T Select Row 8, and use the ‘I’ button on the Formatting toolbar. Select Row 8, and use the command: Format Painter > Italics Select Row 8, and use the command: Paste > Italics None 7. Q.7 Identify the INCORRECT predefined text direct ion in MS-Power Point. Rotate Heaped Horizontal Stacked None 8. Q.8 Which of the following is NOT a valid file name for naming a worksheet in MS-Excel? Account:1 Account1 Account’1 Account-1 None 9. Q.9 Identify the INCORRECT statement for TCP in the TCP/IP protocol. Handles dispatch of packets over the network Provides reliable transport service Converts messages into a set of packets at the source Ensures that messages sent from sender to receiver are properly routed None 10. Q.10 A/an _________ is an animated image that is activated on a personal computer display when no user activity has been sensed for a cert ain time. The original purpose of a screensaver was to prevent burn-in (the burning of an image into the phosphor inside the cat hode ray tube After hours of the same image being rescanned). explorer desktop background screensaver None 11. Q.11 To hide the selected column in a worksheet, the short cut key in MS-Excel is: Ctrl + H Ctrl + 0 (zero) Shift + H Alt + H None 12. Q.12 __________ chart scan show continuous data over time on an evenly scaled axis, so they're ideal for showing trends in data at equal intervals, like months, quarters or fiscal years. Bar Line X-Y Column None 13. Q.13 In class B networks, the first bit is set to 1 and second bit is set to 0. The range of class B network is: 128.0.0.0 to 19255.0.0 128.0.0 to 19255.0.0 255.0.0 to 255.255.0.0 255.0.0.0 to 255.255.0.0 None 14. Q.14 After adding a __________ to a spreadsheet, you can modify it by adding connector lines, changing the style, adding a mirror image, changing the colour, and applying a variety of other effects, such as shadows, glow and 3-D. Picture Shape Icon SmartArt None 15. Q.15 Cell A1 has a number 105 in it, and its background is white and font colour is black. When its contents change to 67, the background becomes pink and the font becomes red. When the number 206 is entered in the A1 cell, the background becomes light green and the font becomes dark green. What could be the reason for this? It is due to different ‘Cell Styles’ applied to the cell. It is due to ‘Top/Bottom Rules’ applied to the cell. It is due to ‘Conditional Formatting’ applied to the cell. It is due to a special Visual Basic program embedded in the worksheet. None 16. Q.16 _________ also incorporates a search feature that allows users to easily search for and locate files on the hard drive whenever they are unsure of file locat ions. File explorer Search box Taskbar Internet explorer None 17. Q.17 With respect to the Mail Merge operation in MS-Word, which of the following statement is FALSE? Mail merge can be used for creating labels. A spreadsheet cannot be a data source. Mail merge can be used for sending customised printed letters. The merge fields should be unique. None 18. Q.18 Which of the following statements is NOT true with respect to installation of a printer on a Windows-based computer? It is essential to connect the printer to the computer using a data cable during the installation procedure. A computer printer does notwork until you install the included drivers and software. The compatible device driverscan also be searched and found on the manufacturer’s website, downloaded and installed. The device drivers of common models of printers are already a part of the operating system. None 19. Q.19 In MS-Excel 2016, there is only one entry ‘ABCEFGHIJK’ in cell D5. In that cell, you have posit ioned the cursor on the boundary on the right side of the column heading, such that the cursor becomes + in shape. Then you double click the mouse. What would be the out come of this? Changes the column width to fit the smallest value in the column The column width remains same, but the contents in the cells of the selected column get word wrapped Changes the column width to fit the largest value in the column There will be no effect None 20. Q.20 Working on a quarterly operational report for management, Asha has a nice spreadsheet with some sales information that she would like to insert into a MSWord document that she is aut horing, such that the MS-Word document get s automatically updat ed, when the MS-Excel file is updat ed. Which of the following options should Asha choose? Copy and Paste Object Screenshot Pictures None 21. Q.21 The __________ functions in MS-Excel perform many of the common mathematical calculations, including basic arithmetic, conditional sums, exponents and logarithms. logical text statistical math None 22. Q.22 In MS-Word 2016, Spelling and Grammar check option is available under the _________ menu. Edit Tools Window Review None 23. Q.23 You want to print labels using mail merge in MS-Word 2016. At the end, when the labels look the way you want, go to Mailings → _________ → Print Documents. Check Records Update Labels View Labels Finish & Merge None 24. Q.24 Which of the following MS-Excel features simultaneously helps in formatting font size, colour, applying cell borders, shading etc.? Cell Styles Conditional Formatting Format Cells Format as Table None 25. Q.25 Which of the following is NOT an output device? Microphone Monitor Speaker Plotter None 26. Q.26 Identify the INCORRECT statement about POP server. User manipulates e-mail messages directly on the e-mail server It stores e-mail for a client on a remote server E-mail messages are downloaded from POP3 server to client computer It connects on port 110 None 27. Q.27 You have protected an MS-Excel workbook with a ‘Protect Structure’ option. This me that: rows and columns cannot be inserted or deleted the format of the cells of the worksheets in the workbook cannot be changed, without unprotecting it workbook cannot be opened without the password sheets cannot be moved, inserted, deleted, hidden, unhidden or renamed None 28. Q.28 For creating a MS-Excel data source file for mail merge, for each field of custom information you want to include in the merged document, create a:Q.28 For creating a MS-Excel data source file for mail merge, for each field of custom information you want to include in the merged document, create a: Worksheet Row Table Column None 29. Q.29 Which of the following statements is true for application software? A computer is unable to run without it. It runs only when the system is turned off. It always starts running when the system is turned on. It is designed for the users to perform their specific tasks None 30. Q.30 To capit alise each word, you would find the ‘Change Case’ option under: Layout tab Home tab Insert tab Design tab None 31. Q.31 In an MS-Excel worksheet, the Column L is not visible. How can you make this column visible? Select Column K and M, position the cursor on the right boundary of the Column M label and drag the mouse Select Column K, position the cursor on the right boundary of the Column K label and drag the mouse Select Column M, position the cursor on the right boundary of the Column M label and drag the mouse Select Column M and use Insert > Column > Left None 32. Q.32 Which of the following is considered as a software? Operating system Hard disk controller ROM Arithmetic logic unit None 33. Q.33 _________ allows the programmer to instruct the machine on an extremely low-level language yet use syntax that is readable. Compiler Interpreter Assembler Processor None 34. Q.34 Which of the following is NOT a valid option for selecting the pages for printing using the Print command in MS-Word 2016? Next Page All Page Range Current page None 35. Q.35 You cannot insert ________ into a main document unt il the data source has been created in MS Word. Data fields cells tables None 36. Q.36 Study the screenshot given below what happens if you click the arrow marked with a yellow box? The selected diagram will be inserted into the worksheet. The Excel file will close. The SmartArt Layouts gallery will expand. The Ribbon will be hidden. None 37. Q.37 What is the default format for expressing numbers in Excel? Percent General User-defined -1234 None 38. Q.38 RAM is _________ in nature. volatile as well as non-volatile non-volatile permanent volatile None 39. Q.39 In MS Excel 2016, how many number formats are available under Cell Style? two four five eight None 40. Q.40 To modify row height, click the _______ drop-down option in the ‘Cells’ group on the Home tab. Format Fill Insert Delete None 41. Q.41 Word Document scan be saved by using _________. File → Open File → Close Ctrl + M Ctrl + s None 42. Q.42 The File which was open in MS Word document can be closed using the _______ option available in the FILE tab. Open Close Edit Save None 43. Q.43 Text place holder in MS PowerPoint is a ________ line. rectangular solid dashed dotted Pink Coloured None 44. Q.44 What is the use of a light pen? Gaming Replacement Of the pen drive Graphics and designing Writing in a notepad without using the computer None 45. Q.45 Which of these is NOT a basic hardware requirement for getting online? Computer Printer Modem Telephone line None 46. Q.46 In MS Word, the default and Standard page format is ________. legal letter tabloid long bond None 47. Q.47 _________ data base is useful for printing labels Spreadsheet Notepad MS Paint Calculator None 48. Q.48 In MS Excel which short cut key is used to create a new blank workbook? Ctrl + N Ctrl + X Ctrl + Y Ctrl + V None 49. Q.49 _______ key is used to edit the contents of a cell in MS Excel. Shift + Enter Ctrl + Enter F2 F4 None 50. Q.50 Which of the following is NOT a function of an operating system? Processor management Database management File management Memory management None 51. Q.51 The information that remains the same for each version of the Mail Merge document in MS Word is called __________. main document data source merge the data with the document final document None 52. Q.52 One cannot merge more than two cells. May be FALSE TRUE Can’t determine None 53. Q.53 The _______ function in MS Excel is used to count the cells containing number data. SUM TOTAL COUNT ADD None 54. Q.54 The ________ enhances the capability of the hardware and directs the computer to perform operations like input, processing and output. GUI hardware software None 55. Q.55 What is the output of the following formula? =sum(1,2,3) 6 10 5 7 None 56. Q.56 How many options are available under Insert drop-down list in the Cells group in Home menu? 4 3 5 6 None 57. Q.57 The entire MS Word document can be printed by choosing _________ and OK. File → Close File → Save File → Print File → Open None 58. Q.58 Which tab in MS-Excel allows you to add a Smart Art object in a worksheet? Review Home Insert Formulas None 59. Q.59 The first page that you see when you open any website is known as ________. last page website home home page address None 60. Q.60 In MS Word 2010 the whole word can be selected by _______ clicking the word. single double ALT + triple None
