Horus University Information Technology Past Paper PDF

Horus University Information Technology 1. Which one of the following computer memory is a temporary and volatile? a. RAM b. ROM c. EPROM d. EEPROM 2. gif is an extension of a. Image file b. Video file...

Horus University Information Technology 1. Which one of the following computer memory is a temporary and volatile? a. RAM b. ROM c. EPROM d. EEPROM 2. gif is an extension of a. Image file b. Video file c. Audio file d. Word file 3. Which one is the first fully supported 64-bit operating system a. Windows Vista b. Mac c. Linux d. Windows XP 4. Computer Hard Disk was first introduced in 1956 by a. Dell b. Apple c. Microsoft d. IBM 5. Which one is a 'text editor' for Microsoft Windows a. MS Word b. Ms Excel c. WordPad d. Notepad 6. Which one is the default 'Word Processor' for Microsoft Windows a. MS Word b. Ms Paint c. WordPad d. Notepad 7. Which key combination is used to minimize all open windows and displays in the screen a. Alt+M b. Shift+M c. Windows Key+D d. CTRL+D 8. Which key combination is used to close a open application in Windows machine a. Alt+F8 b. CTRL+X c. Alt+F4 d. Shift+P Dr. Ibrahem Hemdan 6 Horus University Information Technology 9. When speaking of input, output etc. the input refers to a. Any data processing that occurs from new data input into the computer b. Data or information that has been entered into the computer c. The transmission of data that has been input into the computer d. Both ‘b’ and ‘c’ 10. Which one is the latest release of Windows Client Operating System a. Windows 11 b. Windows 7 c. Windows 8 d. Windows 10 11. 'Linux' is an example of a. Software b. Application c. Operating System d. Browser 12. Which key combination is used to permanently delete a file or folder a. Shift+delete b. Alt+delete c. CTRL+delete d. Delete 13. Which type of processing speed measurement is used primarily with supercomputer a. Gigahertz b. MIPS c. Flops d. Nacron 14. The ____________ protect systems from hackers a. Antivirus b. Backup c. Hard disk d. Firewall 15. The computer’s processor consist of following parts a. CPU and Main memory b. Hard disc and Floppy disc c. Main memory and storage d. Operating system and applications 16. The main memory of computer works with the conjunction of a. Special function cards b. RAM c. Intel d. CPU Dr. Ibrahem Hemdan 7 Horus University Information Technology 17. A computer which is portable and easy to carry by travelers is a. Super computer b. Mini Computer c. Laptop d. File Servers 18. _______ is the most important/ powerful computer in a typical network. a. Desktop b. Network client c. Network server d. Network station 19. Antivirus software is an example of a. Business software b. An operating system c. A security utility d. None of the above 20. A computer cannot ‘boot’ if it does not have the a. Compiler b. Loader c. Operating system d. Software 21. Which American Computer Company is also known by the nick name "Big Blue" a. Microsoft b. Apple c. Compaq Corporation d. IBM 22. The CPU contains a Special set of memory cells called– a. Registers b. Rule for Accounting c. Accounts d. Ledger 23. Virus is a computer __________ a. File b. Database c. Network d. Program Dr. Ibrahem Hemdan 8 Horus University Information Technology 24. RAM is– a. Random Access Memory b. Rate as Memory c. Rate All Money d. Rate as per Man e. None of these 25. Which is/are components of Hardware of Personal Computer? a. Input and Output Devices b. Processor c. Memory d. Storage e. All of these 26. ROM is– a. Read or Money b. Read only Memory c. Random on Money d. All of these e. None of these 27. How many megabytes are there in 1GB? a. 10 b. 1000 c. 1000 000 d. 1024 28. Select the smallest memory size a. Terabyte b. Gigabyte c. Kilobyte d. Megabyte 29. The place where accessories are connected in computer is known as a. Port b. Ring c. Bus d. Zip 30. System software is an interface between ____________ a. Hardware and Application Software b. Application software and User c. RAM and ROM d. CPU and UPS Dr. Ibrahem Hemdan 9 Horus University Information Technology 31. The speed of operations of cache memory used in computers is slower than that of ______ a. RAM b. ROM c. HDD d. Registers in CPU 32. A compiler is a a. A combination of computer hardware b. A software utility that translates a program written in machine language into high level language c. A software utility that translates a program written in high language into machine level language d. A combination of computer hardware and software 33. The output printed by a computer through a printer on the paper is called a. Virtual copy b. Hard copy c. Soft copy d. None of the Above 34. Which of the following is the outcome of data processing a. Software Program b. Data c. System d. Information 35. Which of the following is not a component in multimedia a. Audio b. Video c. Data d. Pen drive 36. Which of the following does not work on the principles of magnetization a. Hard Disk Drive b. Floppy Disk Drive c. Magnetic Tape d. Pen Drive 37. Which of the following is not the function of an Operating System a. Memory Management b. Input/Output Management c. Job Scheduling d. Database Management Dr. Ibrahem Hemdan 10 Horus University Information Technology 38. Microcomputer hardware consists of three basic categories of physical equipment ____ a. Keyboard, monitor, hard drive b. system unit, input/output, memory c. system unit, input/output, secondary storage d. system unit, primary storage, secondary storage 39. The smallest unit in a digital system is a......... a. Bit b. Byte c. Character d. Kilobyte 40. All of the logic and mathematical calculations done by the computer happen in/ on the........ a. system board b. central control unit c. central processing unit d. mother board 41. The Speed of The Central Processing Unit is measured in a. Mega hertz b. Hectares c. Revolutions per minute. d. Bits per second 42. Which The operating system called UNIX is typically used for_______ a. Desktop computers b. Laptop computers c. Super computers d. All of these 43. A Central Processing Unit (CPU) is a machine that can execute– a. Role of System b. Computer Programs c. Recent change and Community Portal d. Portal e. Web 44. Which is a Processor of Computer? a. CPU b. Local Area Network c. Computer d. Technology e. Link Dr. Ibrahem Hemdan 11 Horus University Information Technology 45. Input devices is / are– a. Keyboard, Mouse and Track-ball b. Touchpad c. Scanner d. Microphone e. All of these 46. Output devices includes– a. Scanner b. Speaker, Monitor and Printer c. Trackball d. Touch Pad e. Keyboard 47. Which one of the following computer memory is a temporary and volatile? a. RAM b. ROM c. EPROM d. EEPROM 48. The ________ lists the location of the files on the disk a. FAT b. Boot sector c. Data area d. Root Folder 49. Which of these is NOT one of the five parts of an information system? a. data b. procedures c. people d. networks 50. Which of these would be most appropriate for managing and storing patient records in a large hospital? a. peer-to-peer network b. mainframe c. personal computer d. supercomputer 51. Windows 10 and UNIX are examples of a(n) _________ ___________ (two words) a. operating system b. software c. Database d. Word pressing Dr. Ibrahem Hemdan 12 Horus University Information Technology 52. A computer cannot "boot" if it does not have the _____ a. Compiler b. Loader c. Operating system d. Assembler 53. The operating system called UNIX is typically used for_______ a. Desktop computers b. Laptop computers c. Super computers d. All of these 54. The information processing cycle consists of four phases: input, ________, output, and storage. a. productivity b. preparation c. processing d. promotion 55. The main memory of computer works with the conjunction of a. Special function cards b. RAM c. Intel d. CPU 56. Antivirus software is an example of a. Business software b. An operating system c. A security utility d. None of the above 57. A computer cannot ‘boot’ if it does not have the a. Compiler b. Loader c. Operating system d. Software 58. The CPU contains a Special set of memory cells called– a. Registers b. Rule for Accounting c. Accounts d. Ledger Dr. Ibrahem Hemdan 13 Horus University Information Technology 59. The computer's processor consists of the following parts a. CPU and Main Memory b. Hard Disk and Floppy Drive c. Control Unit and ALU d. Operating System and Application 60. The GUI means a. General User Interaction b. Graphical User Interface c. Guided User Interface d. General User Interface 61. The main job of a CPU is to a. carry out program instructions b. store data/ information for future use c. Process data and information d. both (a) and (c) 62. RAM is– a. Random Access Memory b. Rate as Memory c. Rate All Money d. Rate as per Man e. None of these 63. ROM is– a. Read or Money b. Read only Memory c. Random on Money d. All of these e. None of these 64. The operating system called UNIX is typically used for_______ a. Desktop computers b. Laptop computers c. Super computers d. All of these 65. The Speed of The Central Processing Unit is measured in a. Mega hertz b. Hectares c. Revolutions per minute. d. Bits per second Dr. Ibrahem Hemdan 14 Horus University Information Technology 66. The ______ is a box that houses the most important parts of a computer system. a. Software b. Hardware c. Input drive d. System unit 67. How many bits make a byte? a. 16 bits b. 8 bits c. 24 bits d. 12 bits 68. Which company bought the popular video teleconferencing software 'Skype' a. Google b. Accenture c. Oracle d. Microsoft 69. Mark Zuckerberg is the owner of a. Facebook b. Google c. Linux d. Linkedln 70. In which year, the Microsoft company was founded a. 1972 b. 1975 c. 1980 d. 1984 71. A........ is approximately one billion bytes a. Megabyte b. Gigabyte c. Terabyte d. None of these 72. Which of the following is the largest unit of storage? a. GB b. KB c. MB d. TB 73. _______ uses laser technology to store large amount of information a. Floppy disk b. CD-ROM c. Hard disk d. ED-ROM Dr. Ibrahem Hemdan 15 Horus University Information Technology 74. A removable magnetic disc that holds information ______ a. Floppy disk b. Hard drive c. Monitor d. Portable 75. _________ hard drives are permanently located inside the system unit and are not designed to be removed, unless they need to be repaired or replaced a. Static b. Internal c. External d. Remove 76. ________ is the process of dividing the disk into tracks and sectors a. Tracking b. Formatting c. Crashing d. Allotting 77. Which of the following refers to a small, single-site network? a. LAN b. DSL c. RAM d. USB 78.The type of computers which can executes millions of instruction and billions of data per second is known as a. Laptop b. Mini Computer c. Mainframe Computer d. Personal Computer 79.512 GB = 512 x 1024 = 524288 MB = 𝟓𝟏𝟐 𝟏𝟎𝟐𝟒 = 0.5 TB 80. (1010101)2 = (85)10 81. (11000111)2 = (199)10 82. (116)10 = (1110100)2 83. (254)10 = (11111110)2 Dr. Ibrahem Hemdan 16 Horus University Information Technology Word Multiple Choice Questions (MCQs) 1. In Word the Zoom is placed on a. View tab b. Home tab c. Status bar d. A & C both 2. Which is not a font style? a. Superscript b. Bold c. Italic d. Regular 3. Microsoft Office's personal information manager is a. Outlook b. Internet Explorer c. Organizer d. Access 4. By default, on which page the header or the footer is printed? a. on alternate page b. on first page c. none of the above d. on every page 5. Shortcut key to "Undo" the last action in a document? a. Ctrl + X b. Ctrl + Y c. Ctrl + B d. Ctrl + Z 6. The default page size for word document is a. Letter b. Legal c. A4 d. A3 7. Which one is the default extention of 2016 office word document a..doc b..docx c..xls d..pdf 8. Ctrl + A a. Align Right b. Change font c. Save document d. Select All Dr. Ibrahem Hemdan 17 Horus University Information Technology 9. Portrait and Landscape are a. Paper Size b. Page Layout c. All of above d. Page Orientation 10. What is the maximum size of a word document created a. 1 MB b. 32 MB c. 16MB d. 999KB 11. Changing the position of text on the screen is called... a. Alignment b. Centering c. Layout 12. Short cut Ctrl + P used to a. Open Paragraph Dialog Box b. Open Page Format Dialog Box c. Open Save Dialog Box d. Open Print Dialog box 13. From which menu you can access Picture, Test Box, Chart etc.? a. File b. View c. Insert d. Design 14. Shortcut key to "Undo" the last action in a document? a. Ctrl + X b. Ctrl + Y c. Ctrl + B d. Ctrl + Z 15. Ctrl + A a. Align Right b. Change font c. Save document d. Select All 16. Portrait and Landscape are a. Paper Size b. Page Layout c. All of above d. Page Orientation Dr. Ibrahem Hemdan 18 Horus University Information Technology 17. Ctrl + B a. Search the selected text b. Paste the selected text c. Bold the selected text d. Open the specified file 18. When sending a file as an attachment, you can send it in its native format, or you can send it as a formatted page description file in either Word 97-2003 Document or _____ format. a. PNG b. MOV c. PDF d. MP3 19. Microsoft Word is a a. Database program b. Spreadsheet program c. Presentation program d. Word processing program 20. What is the extension of Word files? a. FIL b. DOT c. DOC d. TXT 21. What is found in the lower-right corner of some groups on the Ribbon? a. the status bar b. the dialog box launcher c. a list box d. the Close button 22. What is the intersection of a row and a column in a worksheet called? a. Cell b. Table c. Cube d. Block 23. What is the shortcut key for " Replace" dialog box? a. Ctrl + F b. Ctrl + R c. Ctrl + H d. Ctrl + Shift + F Dr. Ibrahem Hemdan 19 Horus University Information Technology 24. What is the default font size of a new Word document based on Normal template in Word 2016? a. 10 pt b. 12 pt c. 14 pt d. None of above 25. How will MS Word will respond in repeated word. a. A Red wavy line under the repeated word b. A Green wavy line under the repeated word c. A Blue wavy line under the repeated word d. None of the above 26. What does Ctrl + = key effect? a. Superscript b. Subscript c. All Caps d. Shadow 27. What is the shortcut key for "Subscript" the selected text? a. Ctrl + = b. Ctrl + - c. Ctrl + Shift + = d. Ctrl + Shift + 28. What is the shortcut key for "Superscript" the selected text? a. Ctrl + = b. Ctrl + - c. Ctrl + Shift + + d. Ctrl + Shift + - 29. The space at the very top of a document is called the... a. Top b. Beginning c. Header d. Footer 30. The space at the end of a page is called the... a. Footer b. End c. Bottom d. Header Dr. Ibrahem Hemdan 20 Horus University Information Technology 31. How many different documents you can open at one time? a. No more than three b. Only one c. As many as your computer memory will hold d. As many as your taskbar can display 32. Which of the following command is not available in Tools menu? a. Auto text b. Autocorrect c. Auto summarize d. Macro 33. Word has a list of predefined typing, spelling, capitalization, and grammar errors that _____ can detect and correct. a. Auto Entry b. Auto Correct c. Auto Add d. Auto Spell 34. If you want to convert a symbol or several lines of text into an AutoCorrect entry, you should: a. Insert the symbol or type the text in a Word document first. Then, select the text or symbol and go to the AutoCorrect dialog box. b. Click the Tools menu and choose AutoCorrect Options. Then, click the Insert menu and choose Symbol (or click the Format menu and choose Paragraph) to add the symbol or paragraph to AutoCorrect. c. AutoCorrect can only accommodate one line of text. It is not possible to convert a symbol or multiple lines of text into an AutoCorrect entry. d. Insert the symbol or type the text in a Word document first. Then, select the text or symbol and click the Edit menu followed by Paste Special. Select New AutoCorrect Entry and then click OK. 35. Tabs stop position cannot be the following alignment a. Decimal Alignment b. Center Alignment c. Bar Alignment d. Justify Alignment 36. A feature of MS Word that saves the document automatically after certain interval is available on a. Save tab on Options dialog box b. Save As dialog box c. Both of above d. None of above Dr. Ibrahem Hemdan 21 Horus University Information Technology 37. After typing header text, how can you quickly enter footer text? a. Press Page Down key and type the text for footer b. Click on Switch between Heeder & Footer then type the text c. Both of above d. None of above 38. MS Word is an example of a. Operating System b. Processing Device c. Application Software d. Input Device 39. What is the default font used in MS Word 2007 document? a. Times New Roman b. Arial c. Calibri d. Preethi 40. When inserting Page number in footer it appeared 1 but you wish to show a. How can you do that? a. From format menu choose bullets and Numbering and configure necessary setting b. From Insert menu choose Page Number and specify necessary setting c. Click on Page Number Format tool and specify required setting d. All of above 41. How do you close a word document without closing Word window? a. Click on the Close button on the title bar b. Click on Minimize button on the title bar c. Click on the Close command on Office menu d. Click Exit on the File menu 42. What should you do if you require to paste the same format in many places? a. Click the Format painter and go on pasting in many places holding Alt Key b. Double click the format painter then go on pasting in many places c. Click the format painter then go on pasting to many places holding Ctrl Key d. All of above 43. Which would you choose to save a document with a new name? a. Press Ctrl+S b. Click File, Save c. Click Tools, Options, Save d. Click File, Save As Dr. Ibrahem Hemdan 22 Horus University Information Technology 44. Which of the following option is not available in Insert >> Picture? a. Chart b. Word Art c. Clip Art d. Graph 45. _____ key is pressed, the paragraph formatting in the previous paragraph is carried forward to the next paragraph. a. Enter b. Shift c. Ctrl d. alt 46. What is the short cut key to open Font dialog box? a. Ctrl + F b. Alt + Ctrl + F c. Ctrl + D d. Ctrl + Shift + D 47. Which key do you press to force a page break? a. CTRL+ALT b. CTRL+ break c. CTRL+ Enter d. none of the above 48. To erase a character to the right of the insertion point, press the _____ key. a. Cancel b. Backspace c. Delete d. either b or c e. cursor 49. Which of the following operations moves text from clipboard? a. Copy b. Paste c. Drag and Drop d. Cut 50. Where can you find the Draw Table tool button? a. Standard toolbar b. Formatting toolbar c. Drawing toolbar d. Tables and Formatting toolbar Dr. Ibrahem Hemdan 23 Horus University Information Technology 51. If you need to change the typeface of a document, which menu will you choose? a. Edit b. View c. Format d. Tools 52. To change margin settings, click _____ on the menu bar and then point to the Page Setup command. a. File b. Edit c. Format d. Tools 53. What is the shortcut key to Close Active Document in Microsoft Word? a. Ctrl + F4 b. Shift + F4 c. Ctrl + Shift + F4 d. None of above Dr. Ibrahem Hemdan 24 Horus University Information Technology Excel Multiple Choice Questions (MCQs) 1. Microsoft Excel is a a. Database program b. Spreadsheet program c. Presentation program d. Word processing program 2. Which of the following software programs is a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data? a. Office 2016 b. Windows c. Excel 2016 d. Calc 3. The maximum number of rows supported by Excel 2016 spreadsheet is a. 9,68,576 b. 12,15,857 c. 13,42,554 d. 10,48,576 4. The maximum number of rows supported by Excel 97-2003 spreadsheet is a. 9,68,576 b. 65536 c. 13,42,554 d. 10,48,576 5. To select multiple cells, rows, or columns in a table that are not adjacent to one another, select the first cell and then hold down the _____ key while selecting the next cell, row, or column. a. Alt b. Shift c. Enter d. ctrl 6. In EXCEL which command on the Home Tab displays the total of the selected cells directly after the selected cells? a. Add b. Sum c. Total d. Count 7. A---------------------------- is a collection of spreadsheet pages a. Workbook b. Artbook c. Worksheet d. Documents Dr. Ibrahem Hemdan 25 Horus University Information Technology 8. From which toolbar can we change chart type a. Formatting toolbar b. Chart toolbar c. Formula bar d. Clipboard bar 9. An Excel formula must begin with what symbol? a. ‘(single quote mark) b. = (equals sign) c. / (forward slash) d. + (plus, sign) 10. In EXCEL what function offers you the possibility to view different results depending on the entered condition? a. =Sum() b. =If() c. =SumIf() d. = Count() 11. Which of the following calculates the total from the adjacent cell through the first nonnumeric cell by default, using the SUM function in its formula? a. AVERAGE b. AutoSum c. COUNT d. MAX 12. A function that returns the largest value in a set of values a. MIN b. AVERAGE c. COUNT d. MAX 13. A function that counts the number of blank cells in a range. a. AVERAGE b. COUNT c. COUNTBLANK d. SUMIF 14. A function that determines how many cells in a range contain a number. a. AVERAGE b. COUNT c. COUNTBLANK d. SUMIF 15. A function that totals all of the cells in a range. a. SUM b. AutoSum c. COUNT d. MAX Dr. Ibrahem Hemdan 26 Horus University Information Technology 16. Which is the valid function for displaying the highest value in a range of values? a. High b. Max c. Upper d. Top 17. Which dialog box contains commands to rotate the chart area on 3-D charts? a. Chart Styles b. Format Chart Area c. Format Data Point d. Chart Position 18. Excel displays the current cell address in the........ a. Formula bar b. Name Box c. Status Bar d. Title Bar 19. Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in Excel? a. Workbook b. Worksheet c. Notepad d. Folder 20. Which of the following notebook- like features organizes the sheets for use in Excel? a. Workbook b. Worksheet c. Notepad d. Folder 21. What is immediately visible on screen when you open Excel 2016? a. Create new workbook dialog box b. Open a workbook dialog box c. A new workbook d. The File panel 22. What item at the bottom of an Excel worksheet window presents information about the worksheet, the progress of current tasks, and controls for viewing the worksheet? a. Scroll bar b. Navigation window c. Status bar d. Title bar Dr. Ibrahem Hemdan 27 Horus University Information Technology 23. What is considered the control center in Excel and many other Office programs? a. Title bar b. Ribbon c. Status bar d. Menu 24. Which Microsoft Office object would you use for quick, convenient, one-click access to frequently used Excel commands? a. Quick Access Toolbar b. Title bar c. Status bar d. Mini Toolbar 25. What is the intersection of a row and a column in a worksheet called? a. Cell b. Table c. Cube d. Block 26. What occurs when the cursor is moved over a cell and a user click? a. The row is selected b. The cell is selected c. The column is selected d. The worksheet is selected 27. What do you use to place worksheet titles, column titles, and row titles in a worksheet? a. Data b. Information c. Text d. Numbers 28. When you enter text into a cell, which Excel feature works behind the scenes to recognize and correct common mistakes? a. Auto Change b. AutoText c. Spelling & Grammar Check d. AutoCorrect Dr. Ibrahem Hemdan 28 Horus University Information Technology 29. In Excel, which feature makes an exact replica of the cell data and format while keeping the original cell intact? a. Repeat b. Move c. Cut d. Copy 30. Which command enables a user to save an existing worksheet with a new name or save the worksheet in a new location? a. Close b. Save c. Save As d. Exit 31. Which command do you use to save a new worksheet in Excel 2016? a. Close b. Save c. Save As d. Exit 32. In Excel 2016, what do you use to emphasize certain entries and make the worksheet easier to read and understand? a. Formatting b. Printing c. Arranging d. Configuring 33. Which defines the appearance and shape of the letters, numbers, and special characters in Excel 2016? a. Format b. Font c. Size d. Effects 34. What defines the color of the characters in an Excel worksheet? a. Font size b. Font color c. Cell color d. Background Dr. Ibrahem Hemdan 29 Horus University Information Technology 35. Which command on the Home Ribbon joins selected cells into one larger cell and centers that content in the new cell? a. Wrap Text b. Group Cells c. Cell Styles d. Merge & Center 36. Which area, on the left side of the formula bar, can you look at to determine the cell address of a selected cell? a. Cell box b. Address box c. Name box d. Formula box 37. What is the name of the zone on the worksheet where the chart appears? a. Chart region b. Chart sector c. Chart location d. Chart position 38. What ribbon contains the commands used to create a chart in Excel? a. Home Ribbon b. Insert Ribbon c. Formulas Ribbon d. Data Ribbon 39. Which tab do you use to display the area that contains the print command? a. Home b. Page Layout c. View d. File 40. Which key on the keyboard do you use to correct errors by deleting incorrect characters to the left of the insertion point? a. End b. Delete c. Backspace d. Enter 41. Which key on the keyboard do you use to correct errors by deleting incorrect characters to the right of the insertion point? a. End b. Delete c. Backspace d. Enter Dr. Ibrahem Hemdan 30 Horus University Information Technology 42. Where is the command to undo the last cell entry in an Excel worksheet located? a. Shortcut menu b. Quick Access Toolbar c. Home Ribbon d. Review Ribbon 43. What is a prewritten formula that is built into Excel called? a. Utility b. Procedure c. Function d. Statement 44. Where can you find the Insert Function button in Excel 2016? a. Quick Access Toolbar b. Formula bar c. Status bar d. Shortcut menu 45. Which of the following always begins with an equal sign (=) and performs calculations or other actions using the data in a worksheet? a. Formula b. Array c. Range d. Series 46. Which of the following is a valid Excel function? a. AVERAGE, MAX, and NUM b. MAX, MIN, and WEEK c. AVERAGE, MAX, and MIN d. WEEKDAY, MAX, and CLOSE 47. Which is the valid function for displaying the highest value in a range of values? a. Max b. High c. Upper d. Top 48. Which of the following is not valid data type in MS-Excel a. Number b. Character c. Label d. Date/Time Dr. Ibrahem Hemdan 31 Horus University Information Technology 49. What is the intersection of a column and row on a worksheet called a. Column b. Value c. Address d. Cell 50. Where can you find the command to apply a background color to a cell or range of cells in a worksheet? a. Home Ribbon b. Insert Ribbon c. Page Layout Ribbon d. View Ribbon 51. Which view is the default view used in Excel 2016? a. Page Layout b. Print c. Normal d. Web 52. Which command on the Home Ribbon do you use to rotate text to a vertical or diagonal angle in a worksheet? a. Font b. Orientation c. Wrap Text d. Merge & Center 53. Which command on the Home Ribbon do you use to replace information in a selected cell with new information or new formatting? a. Font b. Format Cell c. Cell Styles d. Find & Select 54. Which command on the Home Ribbon do you use to organize data in ascending or descending order? a. Find & Select b. Format Cell c. Sort & Filter d. Organize 55. Which command on the Home Ribbon do you use to remove cells, rows, or columns from a worksheet or table? a. Delete b. Remove c. Format d. Format as Table Dr. Ibrahem Hemdan 32 Horus University Information Technology PowerPoint Multiple Choice Questions (MCQs) 1. PowerPoint is a a. Database program b. Spreadsheet program c. Presentation program d. Word processing program 2. In currently open PowerPoint presentation, a new slide is inserted using shortcut key a. Ctrl + N b. Ctrl + S c. Ctrl + M d. Shift + N 3. What is a motion path? a. A type of animation entrance effect b. A method of advancing slides c. A method of moving items on a slide d. All of the above 4. Which option in File pull-down menu is used to close a file in PowerPoint? a. New b. Quit c. Close d. Exit 5. Which one is used for making presentation file from Microsoft Office package a. MS Outlook b. MS Excel c. MS Word d. MS PowerPoint 6. What is a motion path? a. A type of animation entrance effect b. A method of advancing slides c. A method of moving items on a slide d. All of the above 7. What is a slide-title master pair? a. The title area and text area of a specific slide b. slide master and title master merged into a single slide c. A slide master and title master for a specific design template d. All of above Dr. Ibrahem Hemdan 33 Horus University Information Technology 8. Which of the following should you use if you want all the slide in the presentation to have the same “look”? a. the slide layout option b. add a slide option c. outline view d. a presentation design template 9. in the context of animations, what is a trigger? a. An action button that advances to the next slide b. An item on the slide that performs an action when clicked c. The name of a motion path d. All of above 10. to preview a motion path effect using the custom animation task pane, you should a. click the play button b. click the show effect button c. double click the motion path d. all of above 11. special effects used to introduce slides in a presentation are called a. effects b. custom animations c. transitions d. present animations 12. Which is the best view for getting your thoughts for a presentation out on the computer? a. Outline view b. Notes page view c. Slide sorter view d. Slide view 13. Which option on the custom animation task pane allows you to apply a preset or custom motion path? a. Add effect b. Emphasis c. Animate now d. All of the above 14. the slide that is used to introduce a topic and set the tone for the presentation is called the……. a. table slide b. graph slide c. bullet slide d. title slide Dr. Ibrahem Hemdan 34 Horus University Information Technology 15. Which option allows you to select line, curve, freeform or scribble tools? a. Create effect b. Insert motion path c. Draw custom path d. All of the above 16. Which of the following tool enables you to add text to a slide without using the standard placeholders? a. Text tool box b. Line tool c. Drawing tool d. Auto shapes tool 17. Want your logo in the same position on every slide, automatically? Insert it on the……. a. Handout master b. Notes master c. Slide master d. All of the above 18. Which of the following views is the best view to use when setting transition effects for all slides in a presentation? a. Slide sorter view b. Notes pages view c. Slide view d. Outline view 19. to edit the text within the boxes of an organization chart, you a. select the box and text, then make changes b. select the box, then make the changes c. highlight the text, them make the changes d. a and b both 20. In Microsoft PowerPoint the entry effect as one slide replaces another in a show is called a (an) a. animation b. slide transition c. custom animation d. preset animation Dr. Ibrahem Hemdan 35 Horus University Information Technology 21. Presentation designs regulate the formatting and layout for the slide and are commonly called a. Design plates b. Templates c. Placeholders d. Blueprints 22. When using PowerPoint, to play a PowerPoint show for previewing the show, select a. View, slide sorter b. View, slide c. View, slide show d. View outline 23. Which of the following should be used when you want to add a slide to an existing presentation? a. File, add a new slide b. Insert, new slide c. File, open d. File, new 24. Which of the following method can insert a new slide in current presentation? a. Right click on the Slide panel and choose New Slide b. From Insert menu choose New Slide c. Click on New Slide button on toolbar d. All of above 25. From which menu you can access Picture, Test Box, Chart etc. a. File b. Edit c. Insert d. View 26. Which of the following should be used when you want to add a slide to an existing presentation? a. File, add a new slide b. Insert, new slide c. File, open d. File, new 27. What is a motion path? a. A type of animation entrance effect b. A method of advancing slides c. A method of moving items on a slide d. All of the above Dr. Ibrahem Hemdan 36 Horus University Information Technology 28. ----------------- is used to change the magnification of the page view. a. Hand tool b. Text tool c. Zoom tool d. Crop tool 29. The Microsoft clip gallery allows you to a. Add word art images to a slide b. Spell check your presentation c. Add clip art images to a slide or slides d. Add slides to a presentation 30. To start slide show of a presentation a. Hit F5 key b. From Slide Show menu choose View Show option c. From Slide Show menu choose Rehearse timing d. Both a & b 31. Which of the following is the default page setup orientation for slides in PowerPoint? a. Vertical b. Landscape c. Portrait d. None of above 32. Which file format can be added to a PowerPoint show? a. Jpg b. giv c. wav d. All of the above 33. What is a motion path? a. A type of animation entrance effect b. A method of advancing slides c. A method of moving items on a slide d. All of the above 34. Which of the following toolbars provide different options in various master views? a. Common tasks toolbar b. Drawing toolbar c. Formatting toolbar d. Standard toolbar Dr. Ibrahem Hemdan 37 Horus University Information Technology 35. Which option on the custom animation task pane allows you to apply a preset or custom motion path? a. Add effect b. Emphasis c. Animate now d. All of the above 36. What is the term used when a clip art image changes the direction of faces? a. Group b. Flip c. Rotate d. All of the above 37. Which of the following should be used when you want to add a slide to an existing presentation? a. File, add a new slide b. Insert, New slide c. File Open d. File, New 38. To add a header or footer to your handout, you can use a. The title master b. The slide master c. The handout master d. All of above 39. When using PowerPoint, to play a PowerPoint show for previewing the show, select a. View, slide sorter b. View, slide c. View, slide show d. View outline 40. The maximum zoom percentage in Microsoft PowerPoint is a. 100% b. 200% c. 400% d. 500% 41. Which key deletes text before, or the left of, the insertion point? a. Backspace b. Page up c. Delete d. Page down Dr. Ibrahem Hemdan 38 Horus University Information Technology 42. To insert a new slide in the current presentation, we can choose a. Ctrl + M b. Ctrl + N c. Ctrl + O d. Ctrl + F 43. What is the name of the form used to input chart values? a. Microsoft Word b. Microsoft Excel c. Microsoft graph d. Auto form 44. Which key on the keyboard can be used to view slide show? a. F1 b. F2 c. F5 d. F10 45. Which of the following fill effects can you use for the slide background? a. Gradient b. Texture c. Picture d. All of the above 46. To open the existing presentation, press a. Ctrl + L b. Ctrl + N c. Ctrl + A d. Ctrl + O 47. In Microsoft PowerPoint two kind of sound effects files that can be added to the presentation are a. wav files and.mid files b. wav files and.gif files c. wav files and.jpg files d. jpg files and.gif files 48. You can create a new presentation by completing all of the following except a. Clicking the new button on the standard toolbar b. Clicking file, new c. Clicking file open d. Pressing ctrl + N Dr. Ibrahem Hemdan 39 Horus University Information Technology each of the following statements either (True) or (False). 1. Computer games are a type of application software. a. True b. False 2. A trackball is a type of output device. a. True b. False 3. Wi-Fi is a synonym for Bluetooth. a. True b. False 4. The registers are memory storage areas within the CPU that hold the data that is worked on by the ALU. a. True b. False 5. Page Setup menu tab used to change the page margins, orientation and page size. a. True b. False 6. Auto Text tab helps you to reduce spelling error in the document. a. True b. False 7. DOC is the extension of Word files? a. True b. False 8. Ctrl + O shortcut key used to Save Document a. True b. False 9. In Word the Zoom is placed on Home tab a. True b. False 10. Ctrl + Z shortcut key used to "Undo" the last action in a document? a. True b. False 11. To add Gridlines to your printed worksheet you need to use View option? a. True b. False Dr. Ibrahem Hemdan 40 Horus University Information Technology 12. A word processor is used to produce letters and resumes a. True b. False 13. Pres the CTRL+B to apply bold c. True d. False 14. If you make a mistake while using an office program, you can press CTRL+U to undo the last entry a. True b. False 15. You can add words to the dictionary of the spelling checker e. True f. False Dr. Ibrahem Hemdan 41