Fundamentals, DOS, Word, Power_Point MOCK-1 Exam Conducted by C.K. Road Youth Computer Training Centre (Near Rail Gate) 1 / 51 1) Central Processing Unit is a Combination of Control and Storage Control and Output unit Arithmetic Logic and Input unit Arithmetic Logic and Control unit 2 / 51 2) Auto text is under Home View Data Insert 3 / 51 3) A disabled menu item does not appear in the ____ bar Menu Standard Status Title 4 / 51 4) For Sorting the data we use are index sort index and sort All of the Above 5 / 51 5) 1 Nibble equals to 8 bits 16 bits 4 bits 5 bits 6 / 51 6) An Error in Software or Hardware is called a Bug. What is an alternative computer jargon for it? Leech Squid Slug Glitch 7 / 51 7) ASCII stands for American Stable Code for International Interchange American Standard Case for Institutional Interchange American Standard Code for Information Interchange American Standard Code for Interchange Information 8 / 51 8) An Exception is another name for a: Compile Error. Logic Error. Runtime Error. Superficial Error. 9 / 51 9) Full form of IPTV is Internet Process Transmit Intranet to Process Technology Internet productivity Tools Internet Protocol Television 10 / 51 10) AutoCorrect was originally designed to replace _________ words as you type. Short, repetitive Grammatically incorrect Misspelled None 11 / 51 11) American Date Format is MM/DD/YY DD/MM/YY yy-DD-mm None of These 12 / 51 12) CSS stands for Client Resource System Character Style system Cable System Style Cascading Style Sheet 13 / 51 13) Default font size in MS word is 11 12 13 14 14 / 51 14) CD-ROM stands for Compactable Read Only Memory Compact Data Read Only Memory Compactable Disk Read Only Memory Compact Disk Read Only Memory 15 / 51 15) Computer is an …… device Eltron Proton Eletric Electronic 16 / 51 16) Capacity of 3.5" floppy is 1.44 MB 1.54 MB 2 MB 1.44 GB 17 / 51 17) CAD Stands for Computer Aided Design Computer Algorithm for Design Computer Application in Design All of the above 18 / 51 18) Format Painter copy ? Text Formatting Object Formatting Both of these None 19 / 51 19) Borders can be applied to Cells Paragraph Text All of above 20 / 51 20) A Computer consists of A Central Processing Unit A Memory Input and Output Unit All of the above 21 / 51 21) End Key is used to Moves the cursor end of the line Moves the cursor end of the document Moves the cursor end of the paragraph Moves the cursor end of the screen 22 / 51 22) Attrib command is used to To change the File Attributes To change the Directory Attributes Both of these None of these 23 / 51 23) A Computer can not boot if it does not have a __________ Loader Compiler OS Assembler 24 / 51 24) Copy and X-copy are same in the sense Both are internal commands of DOS Both are external commands of DOS Both can be used to copy file or group of files Both a and b 25 / 51 25) From which menu you can insert Header and Footer? Edit Insert View Home 26 / 51 26) At first the professor scowled with concern. But then he said, that's all right. Run to my house. Tell my wife to give you one of my shirts. "Mrs. Esputa quickly fetched one of her husband's white shirts. But when Philip put it on, she began to exclaim, Check 27 / 51 27) Filter option is display Formula Tab Data Tab Home tab View Tab 28 / 51 28) A character that is raised above the baseline and is smaller in size is known as Outlined Raised Superscript Subscript 29 / 51 29) By default, on which page the header or the footer is printed? on first page on alternate page on every page None 30 / 51 30) CTOD stands for ______ Character of Date Character to Date Character for Digit None of These 31 / 51 31) Change the _____ to create a document in wide format Page Orientation Page margins Paper Style Paper Source 32 / 51 32) A Compiler means A person who compiles source programs The same thing as a programmer A program which translates source program into object program Keypunch operator 33 / 51 33) “Ctrl + PageDown” is used to Moves the cursor one Paragraph Down Moves the cursor one Page Down Moves the cursor one Line Down Moves the cursor one Screen Down 34 / 51 34) By default in MS-Word 2010, your document prints with 1 inch top and bottom margins A Portrait Orientation 1.25 inches left and right margins 1" Top, bottom, Left and Right 35 / 51 35) Drop Cap means All Caps Small Caps Small Caps None of these 36 / 51 36) Any type of storage that is used for holding information between steps in its processing is Intermediate Storage Storage unit CPU Primary Storage 37 / 51 37) DHCP stands for Dynamic Host Configuration Protocol Dual Host Configuration Protocol Dual Host Control Protocol Dynamic Host Control Protocol 38 / 51 38) From where can we set the timing for each object? Slide Show, Custom Transition Slide show, Slide Transition slide show, custom animation view, slide sorter 39 / 51 39) Full form of IETF is Internet Emerging Task Frame Intranet Evolutionary Task Force Internet Evolution Task Force Internet Engineering Task Force 40 / 51 40) A Computer Program that converts Assembly Language to Machine Language is Compiler Interpreter Assembler Comparator 41 / 51 41) Floppy Disk is a Primary Memory Secondary Memory Temporary Memory Volatile Memory 42 / 51 42) CD.. command is used for Goto Root Directory Goto Parent Directory Goto Child Directory Goto Sub Directory 43 / 51 43) A Billionth of a second is defined as a: Millisecond Microsecond Nanosecond Picoseconds 44 / 51 44) Full form of DRAM DRIVE RANDOM ACCESS MEMORY DIRECT RANDOM ACCESS MEMORY DYNAMIC RANDOM ACCESS MEMORY NONE 45 / 51 45) A New slide can be inserted in a presentation by Using New slide command on Insert menu. Using New slide command of Common Tasks option of Formatting toolbar. Pressing key combination Ctrl+M. All of the above. 46 / 51 46) Bold, Italic, Regular are known as Font Styles Font Effects Word Art Text Effects 47 / 51 47) Ellipse Motion is a predefined ____ Design Template Color Scheme Animation Scheme Color Effects 48 / 51 48) After typing header text, how can you quickly enter footer text? Press PageDown key and type the text for footer Click on Switch between Heeder and Footer then type the text Both of above None 49 / 51 49) A new presentation can be created from Blank Presentation From Existing Presentation From Design Template All of above 50 / 51 50) Drop Cap is used on ? Text Sentenece Paragraph Word 51 / 51 51) 1st Generation of Computer were based on usage of I.C Microprocessor Chips Vacum Tube Your score isThe average score is 67% 0% Submitted Successfully Fundamentals, DOS, Word, Power_Point MOCK-2 Exam Conducted by C.K. Road Youth Computer Training Centre (Near Rail Gate) 1 / 52 1. Main Storage is called Register Accumulator CPU Memory 2 / 52 2. How many ways you can save a document? 3 4 5 6 3 / 52 3. The Option "Loop Continously until Esc" appear from Design Transition Slide show Review 4 / 52 4. One Kilobyte is equal to 1000 bytes 1024 bytes 100 bytes 1023 bytes 5 / 52 5. How many types of Page Orientation are there in MS-Word? 1 2 4 None 6 / 52 6. The selected design template can be applied To current slide only To all the slides To all the new presentation you create All of above 7 / 52 7. Operating system is a System Software Application software Open Source software None of above 8 / 52 8. Integrated Circuit is stand for ? ICT IC ITT IB 9 / 52 9. How many types of Tab are available in MS-Word ? 2 3 6 None 10 / 52 10. In Microsoft PowerPoint two kinds of sound effects files that can be added to the presentation are .wav files and .mid files .wav files and .gif files .wav files and .jpg files none 11 / 52 11. The difference between Slide Design and Auto Content Wizard is Both are same AutoContent Wizard is just the wizard version of Slide Design Slide Design does not provide sample content but Auto Content Wizard provides sample content too! Slide Design asks your choice in steps but Auto Content Wizard does not let you make choices 12 / 52 12. The slide that is used to introduce a topic and set the tone for the presentation is called the table slide graph slide bullet slide title slide 13 / 52 13. In recent years, the issue of high groundwater levels has caught attention. Unfavorable consequences of high groundwater levels are especially damage to buildings, infrastructure, and the environment. Processes that lead to high groundwater levels are hydrological (heavy or extended rainfall and flood events), or anthropogenic (reduced groundwater extractions, interaction with sewer networks, Check 14 / 52 14. Machine language is Machine dependent Difficult to program Error prone All of above 15 / 52 15. The Shortcut Key Ctrl+F2 shortcut is used for Re-name Page setup Open Page preview 16 / 52 16. How can you get your photo album slide show to play continuously ? Use random slide transition Launch an online broadcast Loop continuously All of above 17 / 52 17. In slide layout panel how many layouts are available for text layout by default? 4 7 12 None 18 / 52 18. In a Power Point Presentation Sound clips can be inserted but not movie clips Movie clips can be inserted but not sound clips Both cannot be inserted Both can be inserted 19 / 52 19. To exit the PowerPoint click the application minimize button click the document close button double click the applications control menu icon double click the document control menu icon 20 / 52 20. One of the Important components of first generation computer was Transistors Vacuum Tubes Integrated Circuit Capacitor 21 / 52 21. How many Tabs are there in a Ribbon of MS Word ? 7 8 9 10 22 / 52 22. Internet explorer falls under : Operating System Compiler Browser IP address 23 / 52 23. The extension part of MS PowerPoint file is .docx .pptx .txt .rtf 24 / 52 24. Plotter is a- INPUT DEVICE OUTPUT DEVICE BOTH None 25 / 52 25. Lowest unit of speed is Milli Second Micro Second Nano Second Pico second 26 / 52 26. How many steps are there between Start and Finish in Auto Content Wizard? 3 4 5 6 27 / 52 27. In which Tab can you find features like Slide Design, Slide Layout etc.? Insert Home Tools Slide Show 28 / 52 28. Full form of ISOC Intercity Society Intranet Social Internet Society Interanet Service 29 / 52 29. Shortcut to align left paragraph is CTRL+S CTRL+K CTRL+R CTRL+L 30 / 52 30. Full form of RAM RANDOM ACCESS MEMORY READ ACCESS MEMORY RAMBUS ACCESS MEMORY None 31 / 52 31. Shortcut key to move one word to the right in MS word shift+right arrow alt+right arrow ctrl+right arrow None 32 / 52 32. The default size of header and footer is ... 0.5 inch 1 inch 0.75 inch 0.25 inch 33 / 52 33. Magnetic disks are the most popular medium for Direct access Sequential access Both of above None of above 34 / 52 34. MS-Word is a Application Software System Software Drawing Software Writing Software 35 / 52 35. One Gigabyte is approximately equal to 1000,000 bytes 1000,000,000 bytes 1000,000,000,000 bytes None 36 / 52 36. Shortcut key to delete and entire word is Alt+Del Shift+Alt+Del Ctrl+Del Shift+Del 37 / 52 37. In MS-Word, By default we get _________ number of Columns 4 2 1 3 38 / 52 38. The default lines to drop for drop cap is 3 2 6 4 39 / 52 39. Portrait and Landscape are Page Orientation Page Size Alignment Style 40 / 52 40. How many Types of Computer Memory ? 1 2 3 4 41 / 52 41. At first the professor scowled with concern. But then he said, that's all right. Run to my house. Tell my wife to give you one of my shirts. "Mrs. Esputa quickly fetched one of her husband's white shirts. But when Philip put it on, she began to exclaim, Check 42 / 52 42. Full form of PROM PROGRAM READ ONLY MEMORY PROGRAMMABLE READ ONLY MEMORY PROGRAMMING READ ONLY MEMORY None 43 / 52 43. Memory Unit is a part of Input device Control unit Output device Central Processing Unit 44 / 52 44. The Blank Presentation does not include Preset design Color Content suggestion All of these 45 / 52 45. How many different positions can you set for Drop Cap? 1 2 4 6 46 / 52 46. Shortcuts to Doc Maximize CTRL+F10 CTRL+F4 CTRL+F6 None 47 / 52 47. Full form of POST is Power On Self Test Power On System Test Power On Signal Test None 48 / 52 48. Special effects used to introduce slides in a presentation are known as ? transitions effects custom animations annotations 49 / 52 49. The Shortcut Key Ctrl+E is used for Open the search bar Start the find utility Open the history bar None of these 50 / 52 50. How many types of Paragraph Alignment are there in MS Word? 1 2 3 4 51 / 52 51. How many Types of Main (Primary) Memory ? RAM and ROM Hard Disk and floppy Disk DVD and CD All Of the above 52 / 52 52. Main components of 2nd generation Computer is Vacuum Tubes I.C Interpreter Transistor Your score isThe average score is 54% 0% Submitted Successfully Fundamentals, DOS, Word, Power_Point MOCK-3 Exam Conducted by C.K. Road Youth Computer Training Centre (Near Rail Gate) 1 / 51 1. Which key can be used to view Slide show ? F5 F2 F1 F6 2 / 51 2. Which unit holds data permanently? Input unit Secondary storage unit Output Unit Primary Memory Unit 3 / 51 3. Why Drop Caps are used in document? To drop all the capital letters To automatically begin each paragraph with capital letter To begin a paragraph with a large dropped initial capital letter None of above 4 / 51 4. Which of the following panes is NOT available in Task Pane? Slide Design Master Slide Slide Layout Slide Transition 5 / 51 5. Which of these PowerPoint features would allow any user to create a given simple presentation quicker? Animations Chart Wizard Transition Wizard AutoContent Wizard 6 / 51 6. To insert a Drop Cap in one of the paragraphs, you should access Insert References PageLayout None of these 7 / 51 7. To insert slide numbers Insert a text box and select Insert-Page Number Insert a textbox and select Insert - Number - Page Number Choose Insert - Slide Number Insert a new text box and select Insert - slide Number 8 / 51 8. Want a PowerPoint photo album slide show to play continuously? Use random slide transitions Loop continuously Launch an online broadcast All of the above 9 / 51 9. Which of the following memories needs refresh? SRAM DRAM ROM All of above 10 / 51 10. Which of the following is internal memory? Disks Pen Drives RAM CDs 11 / 51 11. Which of the following is not computer language? High level language Medium level language Low level language All of the above 12 / 51 12. Which of the following is not a part of Slide Design? Design Template Color Scheme Animation Scheme Slide Layout 13 / 51 13. What feature helps you to inserts the contents of the Clipboard as text without any formatting in MS Word? Paste Special Page setup Styles Format Painter 14 / 51 14. To shortcut of "Save " Ctrl+X Ctrl+S Ctrl+c Ctrl+f 15 / 51 15. Which of the following statements is not true? You can type text directly into a PowerPoint slide but typing in text box is more convenient. From Insert menu choose Picture and then File to insert your images into slides. You can view a PowerPoint presentation in Normal, Slide Sorter or Slide Show view. You can show or hide task pane from View >> Toolbars 16 / 51 16. Which of the following toolbars provide different options in various master views? Common tasks toolbar Drawing toolbar Formatting toolbar Standard toolbar 17 / 51 17. What is the best way to create another copy of a slide? Click the slide then press Ctrl+A and paste in new slide From Insert Menu choose Duplicate Slide Right click on slide and tehn Duplicate Slide None of abov 18 / 51 18. You can hyperlink the file ... Pressing the Ctrl+k Pressing the Ctrl+Shift+K Hyperlinks command from insert menu Both A and C 19 / 51 19. To start slide show of a presentation Hit F5 key From Slide Show menu choose View Show option From Slide Show tab choose From Begining Both A & B 20 / 51 20. Which menu provides you options like Animation Scheme, custom Animation, Slide Transition? Insert Menu Format Menu Tools Menu Slide Show Menu 21 / 51 21. Which of the following is the default page setup orientation for slides in PowerPoint? Vertical Landscape Portrait None of above 22 / 51 22. You cannot close MS Word application by Choosing File menu then Exit submenu Press Alt+F4 Click X button on title bar From File menu choose Close submenu 23 / 51 23. Which of the following sections does not exist in a slide layout? Titles Lists Charts Animations 24 / 51 24. Which file starts MS Word? Winword.exe word.exe word2003.exe 2007.exe 25 / 51 25. We can Insert Picture In Ms Word from VIEW INSERT HOME Review 26 / 51 26. Which of the following is NOT a tab found on the PowerPoint Ribbon? The Review tab The View Tab. The Page Layout Tab. The Insert Tab. 27 / 51 27. Which of the following is not a valid version of MS Office? Office XP Office Vista Office 2007 None of above 28 / 51 28. When you delete a text box object from a slide in PowerPoint Presentation The object is deleted but text box and the text inside is left on the slide The text box is deleted and the text is pasted on the slide The text box and text both are deleted None of above 29 / 51 29. The File that consists of readymade styles that we can easily use for our presentation is known as: Pre formatting Template Wizard Auto Style 30 / 51 30. To insert a hyperlink in a slide Choose Insert >> Hyperlink Press Ctrl + K Hyperlinks can’t be inserted in slides Both a & b 31 / 51 31. Which tab is not available on left panel when you open a presentation? Slides Outline Notes All of above are available 32 / 51 32. Where on the PowerPoint Ribbon will you find the Spelling Check function? Under the Language and Proofing tab on the Ribbon. Under the View tab on the Ribbon. There is no Spelling Check function in PowerPoint as we are dealing with slides, not a document. Under the Review tab on the Ribbon. 33 / 51 33. When using PowerPoint, to play a PowerPoint show for previewing the show, select View, slide sorter View, slide slide show tab, From beginning View outline 34 / 51 34. What feature will you use to apply motion effects in between a slide exits and another enters? Slide Transition Slide Design Animation Objects Animation Scheme 35 / 51 35. What is the term used when a clip art image changes the direction of faces? Group Flip Rotate All of the above 36 / 51 36. You can show the shortcut menu during the slide show by Clicking the shortcut button on the formatting toolbar Right clicking the current slide Clicking an icon on the current slide a and b 37 / 51 37. Which command brings you to the first slide in your presentation? Next slide button Page up Ctrl + Home Ctrl + End 38 / 51 38. Which is not a computer classification? mainframe maxframe mini notebook 39 / 51 39. What lets you to create new presentation by selecting ready-made font color and graphics effects? Presentation Template Master Slide Design Template Animation Scheme 40 / 51 40. To open the existing presentation, press CTRL + A CTRL + O CTRL + L CTRL + B 41 / 51 41. Which option on the custom animation task pane allows you to apply a preset or custom motion path? Add effect Emphasis Animate now All of the above 42 / 51 42. What happens when you click on Insert --> Clip Art It inserts a Clipart Picture into a Document It lets you choose Clipart to insert into a Document It opens Clip Art taskbar None of above 43 / 51 43. To start Microsoft PowerPoint application Click on Start / Programs / All Programs /Accessories / Microsoft PowerPoint Hit Ctrl + R then type ppoint.exe and Enter Click Start / Run then type powerpnt then press Enter All of above 44 / 51 44. Which of the following have the fastest access time? Semiconductor memories Magnetic disks Magnetic Tapes Compact disks 45 / 51 45. What is a motion path? A type of animation entrance effect A method of advancing slides A method of moving items on a slide All of the above 46 / 51 46. What is the extension file name of Microsoft Word 2007? .doc .docx .document none 47 / 51 47. Water is the most important and valuable natural resource on Earth. It sustains all life. There is no life without water. Water is not only important for human beings but for the entire ecosystem. Without enough water, the existence of humans, as well as animals, is next to impossible. After fresh air, water is the second most important natural resource for the survival of any living being. Water is necessary for the survival of each living creature on this planet, be it a small worm, plant, or full-grown tree. Animals and plants cannot survive without water. About 71% of Earth’s surface is covered with water. Unfortunately, only 3% of the water available is freshwater. About two-thirds of the freshwater lies in the form of frozen glaciers and ice caps. The rest of the small portion is available in the form of groundwater and surface water. Check 48 / 51 48. What are the three options available in Insert >> Picture menu? Clipart, Pictures, Shapes Clipart, From File, Shapes Clipart, From Files, AutoShapes Clipart, Pictures, AutoShapes 49 / 51 49. What does MS stands for in MS Word ? Mini Soft Microsoft Mothersoft None 50 / 51 50. To want a PowerPoint photo album slide show to play continuously - Use random slide transitions Launch an online broadcast Loop continuously All of the above 51 / 51 51. What does Ctrl + = key effect? Superscript Subscript All Caps Shadow Your score isThe average score is 42% 0% Submitted Successfully CITA Final Exam Exam Conducted by C.K. Road Youth Computer Training Centre (Near Rail Gate) 1 / 71 1. ___ is the programming language used to write a Macro in MS Excel. Visual basic C+ Java C++ 2 / 71 2. Where on the PowerPoint Ribbon will you find the Spelling Check function? Under the Language and Proofing tab on the Ribbon. Under the View tab on the Ribbon. There is no Spelling Check function in PowerPoint as we are dealing with slides, not a document. Under the Review tab on the Ribbon. 3 / 71 3. Which tab is not available on left panel when you open a presentation? Slides Outline Notes All of above are available 4 / 71 4. You can hyperlink the file ... Pressing the Ctrl+k Pressing the Ctrl+Shift+K Hyperlinks command from insert menu Both A and C 5 / 71 5. ____ type of chart is good for a single series of data. Column chart Cone chart Line chart Pie chart 6 / 71 6. ____ is not a function in Excel. SUM() MIN() SUBTRACT() MAX() 7 / 71 7. To insert slide numbers Insert a text box and select Insert-Page Number Insert a textbox and select Insert - Number - Page Number Choose Insert - Slide Number Insert a new text box and select Insert - slide Number 8 / 71 8. A quick way to return to a specific area of a worksheet is to type in the _____ Formula bar Zoom box Name box None 9 / 71 9. By default, How many sheets are there in Excel - 2003 or 2007 file ? 1 2 3 0 10 / 71 10. ___is the function used to match multiple values and returns the first match in Windows/ MAC(if you have Office 2019, or if you have a Microsoft 365 subscription) IF() IFS() IIF() SWITCH() 11 / 71 11. Which of the following memories needs refresh? SRAM DRAM ROM All of above 12 / 71 12. ___________ Command is used to delete the ( * ) marked records. Pack Zap Delete None 13 / 71 13. Extension of form file in Foxpro .scx .frm .cdx None 14 / 71 14. What does Ctrl + = key effect? Superscript Subscript All Caps Shadow 15 / 71 15. What feature helps you to inserts the contents of the Clipboard as text without any formatting in MS Word? Paste Special Page setup Styles Format Painter 16 / 71 16. What lets you to create new presentation by selecting ready-made font color and graphics effects? Presentation Template Master Slide Design Template Animation Scheme 17 / 71 17. Excel is a Graphic program Word processor A spreadsheet None 18 / 71 18. The Greater Than sign (>) exemplifies a/an _____ operator. Arithmetic Conditional Logical Greater 19 / 71 19. Radioactive waste is any pollution that emits radiation beyond what is naturally released by the environment. It’s generated by uranium mining, nuclear power plants, and the production and testing of military weapons, as well as by universities and hospitals that use radioactive materials for research and medicine. Radioactive waste can persist in the environment for thousands of years, making disposal a major challenge. Check 20 / 71 20. Which file starts MS Word? Winword.exe word.exe word2003.exe 2007.exe 21 / 71 21. You cannot close MS Word application by Choosing File menu then Exit submenu Press Alt+F4 Click X button on title bar From File menu choose Close submenu 22 / 71 22. By Edit Command, we can Modify any file Create any file Both of these Delete any file 23 / 71 23. Extension of database file in Foxpro .dbc .dba .dbf None 24 / 71 24. Command used to tag the current record for deletion delete delete current deleted None 25 / 71 25. $A$2 is an example of : Absolute Reference Relative Reference Mixed Reference None 26 / 71 26. Which of the following have the fastest access time? Semiconductor memories Magnetic disks Magnetic Tapes Compact disks 27 / 71 27. Which of the following panes is NOT available in Task Pane? Slide Design Master Slide Slide Layout Slide Transition 28 / 71 28. What is the row limit of MS Excel 2019? 4,81,0576 1,048,576 1,57,648 1,63, 84 29 / 71 29. Which of the following is not computer language? High level language Medium level language Low level language All of the above 30 / 71 30. Data Types available in Visual FoxPro are 13 types 10 types 8 types None 31 / 71 31. Which of the following is internal memory? Disks Pen Drives RAM CDs 32 / 71 32. Create A New Database With The Same Structure Copy Structure To File Name create database to filename Copy database to filename None 33 / 71 33. What does MS stands for in MS Word ? Mini Soft Microsoft Mothersoft None 34 / 71 34. Which of the following statements is not true? You can type text directly into a PowerPoint slide but typing in text box is more convenient. From Insert menu choose Picture and then File to insert your images into slides. You can view a PowerPoint presentation in Normal, Slide Sorter or Slide Show view. You can show or hide task pane from View >> Toolbars 35 / 71 35. Command used to copy data from a Visual FoxPro table to a file in a different format. export to filename [type] send to filename [type] add to filename [type] Both option 1 and 2 36 / 71 36. Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook? work sheet chart sheet module sheet data sheet 37 / 71 37. By Formatting a cell in Currency format, you can specify ? Decimal Places Currency Symbol Both 1 and 2 Options None of above 38 / 71 38. Create command creates Table Row Column Index 39 / 71 39. Excel uniquely identifies cells within a worksheet with a cell name Cell names Column numbers and row letters Column letters and row numbers Cell locator coordinates 40 / 71 40. Which key can be used to view Slide show ? F5 F2 F1 F6 41 / 71 41. Want a PowerPoint photo album slide show to play continuously? Use random slide transitions Loop continuously Launch an online broadcast All of the above 42 / 71 42. Extension of Excel 2007 file .xls .xlsx .exl None 43 / 71 43. Which unit holds data permanently? Input unit Secondary storage unit Output Unit Primary Memory Unit 44 / 71 44. An Optical Input Device that interprets pencil marks on paper media is O.M.R Punch card reader Optical scanners Magnetic tape 45 / 71 45. Which is not a computer classification? mainframe maxframe mini notebook 46 / 71 46. What is the =NPV in Excel used for? Net Present Value New Present Value Number Payment Value None 47 / 71 47. When using PowerPoint, to play a PowerPoint show for previewing the show, select View, slide sorter View, slide slide show tab, From beginning View outline 48 / 71 48. We can Insert Picture In Ms Word from VIEW INSERT HOME Review 49 / 71 49. Databases store information in the form of Reports Forms Tables None 50 / 71 50. What is a motion path? A type of animation entrance effect A method of advancing slides A method of moving items on a slide All of the above 51 / 71 51. Which option on the custom animation task pane allows you to apply a preset or custom motion path? Add effect Emphasis Animate now All of the above 52 / 71 52. By default column width of Excel 7.43 8.43 6.34 8.34 53 / 71 53. To start Microsoft PowerPoint application Click on Start / Programs / All Programs /Accessories / Microsoft PowerPoint Hit Ctrl + R then type ppoint.exe and Enter Click Start / Run then type powerpnt then press Enter All of above 54 / 71 54. The File that consists of readymade styles that we can easily use for our presentation is known as: Pre formatting Template Wizard Auto Style 55 / 71 55. To start slide show of a presentation Hit F5 key From Slide Show menu choose View Show option From Slide Show tab choose From Begining Both A & B 56 / 71 56. "Goal Seek" can be applied on Multiple Records Single Record Either A or B None 57 / 71 57. What feature will you use to apply motion effects in between a slide exits and another enters? Slide Transition Slide Design Animation Objects Animation Scheme 58 / 71 58. Excel probably considers the cell entry January 1, 2000 to be a Label Value Formula Text string 59 / 71 59. To open the existing presentation, press CTRL + A CTRL + O CTRL + L CTRL + B 60 / 71 60. Extension of a Database table file is ___________ Wk4 .DBF .DBC .FDP 61 / 71 61. Which of the following is the default page setup orientation for slides in PowerPoint? Vertical Landscape Portrait None of above 62 / 71 62. DBF' stands for Data British File Digit Base File Digit Base File Database File 63 / 71 63. Why Drop Caps are used in document? To drop all the capital letters To automatically begin each paragraph with capital letter To begin a paragraph with a large dropped initial capital letter None of above 64 / 71 64. Which of these PowerPoint features would allow any user to create a given simple presentation quicker? Animations Chart Wizard Transition Wizard AutoContent Wizard 65 / 71 65. What is the extension file name of Microsoft Word 2007? .doc .docx .document none 66 / 71 66. Default date format in visual foxpro British American ANSI None 67 / 71 67. Extension of a Report file .Fra .FRX .DBF None 68 / 71 68. Water is the most important and valuable natural resource on Earth. It sustains all life. There is no life without water. Water is not only important for human beings but for the entire ecosystem. Without enough water, the existence of humans, as well as animals, is next to impossible. After fresh air, water is the second most important natural resource for the survival of any living being. Water is necessary for the survival of each living creature on this planet, be it a small worm, plant, or full-grown tree. Animals and plants cannot survive without water. About 71% of Earth’s surface is covered with water. Unfortunately, only 3% of the water available is freshwater. About two-thirds of the freshwater lies in the form of frozen glaciers and ice caps. The rest of the small portion is available in the form of groundwater and surface water. Check 69 / 71 69. Formula in Excel starts with____ * + = - 70 / 71 70. To shortcut of "Save " Ctrl+X Ctrl+S Ctrl+c Ctrl+f 71 / 71 71. _____ logical function indicates TRUE only if all arguments are assessed as TRUE, and FALSE otherwise. OR AND IF ANDIF Your score isThe average score is 74% 0%
