Office Automation MCQs

  1. What is the use of “Protect Sheet” in Excel?
    A) Delete sheet
    B) Lock sheet
    C) Print sheet
    D) Format sheet
    Answer: B
  2. What is “Protect Workbook”?
    A) Delete workbook
    B) Lock workbook structure
    C) Print workbook
    D) Format workbook
    Answer: B
  3. What is password protection?
    A) Hide file
    B) Secure file with password
    C) Delete file
    D) Format file
    Answer: B
  4. What is encryption?
    A) Hide data
    B) Convert data to secure format
    C) Delete data
    D) Copy data
    Answer: B
  5. What is digital signature?
    A) Written signature
    B) Electronic authentication
    C) Image
    D) Chart
    Answer: B
  6. What is file compression?
    A) Increase file size
    B) Reduce file size
    C) Delete file
    D) Copy file
    Answer: B
  7. What is ZIP file?
    A) Image
    B) Compressed file
    C) Document
    D) Spreadsheet
    Answer: B
  8. What is backup?
    A) Delete file
    B) Copy data for safety
    C) Format file
    D) Print file
    Answer: B
  9. What is restore?
    A) Delete file
    B) Recover backup
    C) Save file
    D) Print file
    Answer: B
  10. What is version control?
    A) Delete versions
    B) Manage file versions
    C) Print file
    D) Save file
    Answer: B
  11. What is a dashboard in Excel?
    A) Chart
    B) Data summary display
    C) Table
    D) Image
    Answer: B
  12. What is slicer in Excel?
    A) Filter tool
    B) Chart
    C) Table
    D) Image
    Answer: A
  13. What is sparkline?
    A) Mini chart
    B) Table
    C) Image
    D) Text
    Answer: A
  14. What is data analysis toolpak?
    A) Add-in for analysis
    B) Chart
    C) Table
    D) Image
    Answer: A
  15. What is scenario manager?
    A) Data analysis tool
    B) Chart
    C) Table
    D) Image
    Answer: A
  16. What is goal seek?
    A) Find result
    B) Chart
    C) Table
    D) Image
    Answer: A
  17. What is hyperlink editing?
    A) Modify link
    B) Delete link
    C) Insert link
    D) Format link
    Answer: A
  18. What is page orientation?
    A) Page direction
    B) Chart
    C) Table
    D) Image
    Answer: A
  19. What is portrait orientation?
    A) Vertical page
    B) Horizontal page
    C) Square page
    D) None
    Answer: A
  20. What is landscape orientation?
    A) Vertical
    B) Horizontal
    C) Square
    D) None
    Answer: B
  21. What is indentation?
    A) Space from margin
    B) Chart
    C) Table
    D) Image
    Answer: A
  22. What is tab stop?
    A) Cursor position
    B) Chart
    C) Table
    D) Image
    Answer: A
  23. What is bullet list?
    A) List with symbols
    B) Chart
    C) Table
    D) Image
    Answer: A
  24. What is numbered list?
    A) List with numbers
    B) Chart
    C) Table
    D) Image
    Answer: A
  25. What is find and replace?
    A) Search and change text
    B) Delete file
    C) Print file
    D) Save file
    Answer: A
  26. What is auto fill?
    A) Fill data automatically
    B) Delete data
    C) Save data
    D) Print data
    Answer: A
  27. What is drag and drop?
    A) Move items
    B) Delete items
    C) Copy items
    D) Save items
    Answer: A
  28. What is clipboard history?
    A) Past copied items
    B) File
    C) Folder
    D) Program
    Answer: A
  29. What is undo history?
    A) Past actions
    B) File
    C) Folder
    D) Program
    Answer: A
  30. What is redo history?
    A) Reverse undo
    B) Delete file
    C) Save file
    D) Print file
    Answer: A
  31. What is shortcut key?
    A) Quick command
    B) File
    C) Folder
    D) Program
    Answer: A
  32. What is ribbon customization?
    A) Modify toolbar
    B) Chart
    C) Table
    D) Image
    Answer: A
  33. What is quick access toolbar?
    A) Shortcut toolbar
    B) Chart
    C) Table
    D) Image
    Answer: A
  34. What is dark mode?
    A) Black theme
    B) Light theme
    C) Color theme
    D) None
    Answer: A
  35. What is add-in?
    A) Extra feature
    B) Chart
    C) Table
    D) Image
    Answer: A
  36. What is template customization?
    A) Modify template
    B) Delete template
    C) Save template
    D) Print template
    Answer: A
  37. What is export?
    A) Save in different format
    B) Delete file
    C) Print file
    D) Copy file
    Answer: A
  38. What is PDF format?
    A) Editable format
    B) Fixed format
    C) Chart
    D) Table
    Answer: B
  39. What is printing multiple copies?
    A) Print one
    B) Print many
    C) Save file
    D) Delete file
    Answer: B
  40. What is duplex printing?
    A) Single side
    B) Double side
    C) Color print
    D) Black print
    Answer: B
  41. What is print queue?
    A) Waiting list of print jobs
    B) Chart
    C) Table
    D) Image
    Answer: A
  42. What is printer driver?
    A) Software for printer
    B) Hardware
    C) Table
    D) Image
    Answer: A
  43. What is network printing?
    A) Local printing
    B) Shared printing
    C) Offline printing
    D) Manual printing
    Answer: B
  44. What is collaboration tool?
    A) Teamwork software
    B) Chart
    C) Table
    D) Image
    Answer: A
  45. What is real-time editing?
    A) Instant updates
    B) Delayed editing
    C) Offline editing
    D) Manual editing
    Answer: A
  46. What is cloud computing?
    A) Local computing
    B) Internet-based computing
    C) Manual computing
    D) Offline computing
    Answer: B
  47. What is SaaS?
    A) Software as a Service
    B) Storage as Service
    C) System as Service
    D) Server as Service
    Answer: A
  48. What is online collaboration?
    A) Working offline
    B) Working together online
    C) Printing
    D) Saving
    Answer: B
  49. What is file sharing?
    A) Sending files
    B) Deleting files
    C) Saving files
    D) Printing files
    Answer: A
  50. What is office automation system?
    A) Manual system
    B) Computer-based office system
    C) Paper-based system
    D) None
    Answer: B

Leave a Comment