Quiz — VOI001

Q1. MS Office is best described as a suite of:

A. Operating systems B. Productivity/application software C. Hardware devices D. Antivirus programs

Q2. Which of the following is NOT a component of the MS Office suite?

A. Word B. Excel C. Photoshop D. PowerPoint

Q3. The 'Ribbon' in MS Office applications refers to:

A. A physical device attached to the printer B. The tabbed toolbar containing grouped commands C. The status bar at the bottom D. A type of file format

Q4. The 'Backstage view' in MS Office is accessed via:

A. The Home tab B. The File tab C. The Insert tab D. Right-clicking the Ribbon

Q5. System software primarily manages:

A. User documents only B. Computer hardware and system resources C. Only internet browsing D. Only spreadsheet calculations

Q6. Application software, such as MS Word, is used to:

A. Manage computer hardware directly B. Perform specific user tasks like document creation C. Boot the computer D. Compile the operating system

Q7. In MS Word, 'Styles' are primarily used to:

A. Insert pictures automatically B. Apply consistent formatting and enable automatic table-of-contents generation C. Change the file extension D. Password-protect a document

Q8. A Section Break in MS Word is used to:

A. Delete all content after that point B. Allow different page layouts (e.g. orientation) within the same document C. Insert a picture D. Merge two documents into one file

Q9. Mail Merge in MS Word combines:

A. Two Word documents into one B. A main document with a data source to create personalized copies C. A Word document with a PowerPoint slide D. Two Excel files

Q10. Track Changes in MS Word is used to:

A. Permanently delete text B. Record edits with author attribution for collaborative review C. Automatically translate the document D. Compress the file size

Q11. In MS Word, headers and footers typically contain:

A. Only images B. Repeated content like page numbers, titles, or dates on every page C. The document's password D. Only hyperlinks

Q12. SmartArt in MS Word/PowerPoint is used to:

A. Insert audio files only B. Create visual diagrams (e.g., process, hierarchy) easily C. Encrypt a document D. Check spelling

Q13. In MS Excel, a relative cell reference (e.g., A1) when copied to another cell:

A. Stays exactly fixed B. Adjusts automatically relative to its new position C. Causes an error always D. Converts to text

Q14. An absolute cell reference in Excel is written as:

A. A1 B. $A$1 C. A$1 only D. 1A

Q15. The Excel function that adds a range of numbers is:

A. AVERAGE() B. SUM() C. COUNT() D. IF()

Q16. The Excel function that computes the arithmetic mean of a range is:

A. SUM() B. AVERAGE() C. MAX() D. COUNTA()

Q17. The IF() function in Excel is used to:

A. Sort data alphabetically B. Apply conditional logic, returning one value if true and another if false C. Create a chart D. Merge cells

Q18. VLOOKUP() in Excel is primarily used to:

A. Format cells with colour B. Look up and retrieve matching data from a table based on a lookup value C. Delete duplicate rows D. Insert a picture

Q19. Conditional formatting in Excel allows you to:

A. Change a formula's result B. Automatically highlight cells based on specified conditions C. Password-protect the workbook D. Convert numbers to text permanently

Q20. Sorting data in Excel arranges rows based on:

A. Random order B. The values in one or more selected columns C. Only alphabetical order of sheet names D. Font colour only

Q21. Filtering data in Excel allows you to:

A. Permanently delete rows that don't match criteria B. Temporarily display only rows matching specified criteria C. Convert the sheet to a PDF D. Change the workbook's file name

Q22. A chart in Excel is created based on:

A. The workbook's file name B. A selected range of data C. The computer's screen resolution D. The number of open workbooks

Q23. To assign 'Pass' or 'Fail' based on a student's marks in Excel, you would typically use:

A. SUM() B. IF() C. AVERAGE() alone D. COUNT() alone

Q24. In PowerPoint, the Slide Master controls:

A. Only the file's password B. The consistent look (fonts, colours, placeholders) across all slides using a theme C. The internet connection D. The printer settings

Q25. A 'transition' in PowerPoint refers to:

A. An effect applied to text within a single slide B. The visual effect that occurs when moving from one slide to the next C. A type of chart D. A file format

Q26. An 'animation' in PowerPoint refers to:

A. An effect applied to individual objects within a slide B. The effect between two slides only C. A password feature D. A printing option

Q27. Presenter View in PowerPoint is useful because it:

A. Shows the audience the speaker's notes B. Shows the speaker their notes and the next slide while the audience sees only the current slide C. Hides all slides from the speaker D. Disables slide transitions

Q28. Inserting a scanned image into a PowerPoint slide is done via which tab?

A. Home B. Insert C. Review D. Slide Show

Q29. Which of these is a benefit of using a consistent theme across PowerPoint slides?

A. It slows down the presentation B. It gives a professional, consistent visual appearance C. It disables all animations D. It reduces the number of slides allowed

Q30. The World Wide Web (WWW) is best described as:

A. A single website B. A system of interlinked hypertext documents accessed via browsers over the internet C. A type of computer virus D. A programming language

Q31. A web browser is software used to:

A. Compile programs B. Render and display web pages C. Format Word documents D. Calculate spreadsheet formulas

Q32. HTTPS in a website address indicates:

A. The site uses an unsecured, plain-text connection B. A more secure, encrypted connection to the website C. The site is definitely a scam D. The site cannot be visited

Q33. CC in an email typically stands for:

A. Confidential Copy B. Carbon Copy (visible to all recipients) C. Cannot Copy D. Compressed Content

Q34. BCC in an email allows you to:

A. Send a copy visible to all recipients B. Send a hidden copy not visible to other recipients C. Block the recipient's email address D. Automatically delete the email

Q35. An email attachment refers to:

A. The email's subject line B. A file sent along with an email message C. The sender's email address D. The email's timestamp

Q36. In MS Access, a Table is used to:

A. Ask questions of stored data B. Store structured data in rows and columns C. Generate a formatted printed output only D. Play multimedia files

Q37. In MS Access, a Query is used to:

A. Store raw data permanently B. Ask specific questions of the data stored in tables C. Format text in a document D. Play a slideshow

Q38. In MS Access, a Form is primarily used for:

A. Data entry through a user-friendly interface B. Compiling code C. Creating charts only D. Sending emails

Q39. In MS Access, a Report is used to:

A. Enter new data only B. Present data in a formatted, printable output C. Delete a table permanently D. Connect to the internet

Q40. Saving a file with a proper extension (e.g., .docx, .xlsx, .pptx) is important because it:

A. Has no effect on how the file opens B. Tells the operating system which application should open the file C. Changes the file's content permanently D. Encrypts the file automatically

Q41. The Quick Access Toolbar in MS Office is typically used for:

A. Rarely used advanced settings only B. Frequently used commands like Save, Undo and Redo C. Only spell-check D. Changing the computer's date and time

Q42. Which MS Office application is best suited for creating a multi-slide visual presentation?

A. Word B. Excel C. PowerPoint D. Access

Q43. Which MS Office application is best suited for tabulating and calculating student marks?

A. Word B. Excel C. PowerPoint D. Access

Q44. Which MS Office application is best suited for drafting a formatted resume with a covering letter?

A. Word B. Excel C. PowerPoint D. Access

Q45. A folder in file management is used to:

A. Delete files permanently B. Organize related files together in one location C. Convert files between formats D. Encrypt the entire hard drive

Q46. Which of the following is a valid absolute reference to lock only the row (not the column)?

A. A$1 B. $A1 C. $A$1 D. A1

Q47. The COUNTA() function in Excel is typically used to:

A. Count only numeric cells B. Count non-blank cells (text or numbers) C. Sum all values in a range D. Calculate the average of a range

Q48. Safe use of the internet includes:

A. Sharing passwords publicly B. Verifying HTTPS and avoiding suspicious downloads/links C. Downloading all email attachments blindly D. Disabling all security software

Q49. Which of the following best distinguishes a template from a regular document in MS Office?

A. A template cannot be edited at all B. A template is a reusable starting design/layout for creating new documents C. A template can only contain images D. A template is only used in Excel

Q50. Grouping formatting into character, paragraph and document levels in Word helps you:

A. Apply consistent, hierarchical formatting efficiently B. Slow down the editing process intentionally C. Prevent saving the file D. Disable spell-check

VOI00150-Question MCQ Quiz