Office Automation MCQs

by

  1. What is the use of “Save As”?
    A) Save file with new name
    B) Print file
    C) Close file
    D) Delete file
    Answer: A
  2. What is a shortcut for “Select All”?
    A) Ctrl + S
    B) Ctrl + A
    C) Ctrl + P
    D) Ctrl + X
    Answer: B
  3. Which feature automatically saves documents online?
    A) AutoSave
    B) AutoFormat
    C) AutoSum
    D) AutoFill
    Answer: A
  4. What is OneDrive?
    A) Software
    B) Cloud storage service
    C) Operating system
    D) Spreadsheet
    Answer: B
  5. What is Google Docs?
    A) Word processor
    B) Spreadsheet
    C) Presentation tool
    D) Database
    Answer: A
  6. What is Google Sheets used for?
    A) Writing
    B) Calculations
    C) Drawing
    D) Email
    Answer: B
  7. What is Google Slides used for?
    A) Spreadsheet
    B) Database
    C) Presentation
    D) Drawing
    Answer: C
  8. What is collaboration in Google Docs?
    A) Single user editing
    B) Multiple users editing
    C) Printing
    D) Saving
    Answer: B
  9. What is version history?
    A) File deletion
    B) Record of changes
    C) Printing history
    D) Formatting
    Answer: B
  10. What is a comment reply?
    A) Delete comment
    B) Respond to comment
    C) Add chart
    D) Insert image
    Answer: B
  11. What is sharing in office tools?
    A) Sending files
    B) Saving files
    C) Deleting files
    D) Printing files
    Answer: A
  12. What is permission in sharing?
    A) Access rights
    B) File size
    C) Format
    D) Layout
    Answer: A
  13. What is read-only mode?
    A) Edit file
    B) View only
    C) Delete file
    D) Print file
    Answer: B
  14. What is editing mode?
    A) View only
    B) Edit document
    C) Print document
    D) Save document
    Answer: B
  15. What is suggestion mode?
    A) Delete file
    B) Suggest edits
    C) Print file
    D) Format text
    Answer: B
  16. What is the use of “Insert Table”?
    A) Add rows/columns
    B) Add table
    C) Delete table
    D) Save table
    Answer: B
  17. What is data validation?
    A) Delete data
    B) Control input
    C) Save data
    D) Print data
    Answer: B
  18. What is a drop-down list?
    A) Chart
    B) List of options
    C) Table
    D) Image
    Answer: B
  19. What is a formula error?
    A) Correct result
    B) Wrong calculation
    C) Chart
    D) Table
    Answer: B
  20. What is IF function in Excel?
    A) Logical test
    B) Addition
    C) Counting
    D) Sorting
    Answer: A
  21. What is VLOOKUP?
    A) Chart
    B) Search function
    C) Formatting
    D) Printing
    Answer: B
  22. What is HLOOKUP?
    A) Vertical search
    B) Horizontal search
    C) Sorting
    D) Filtering
    Answer: B
  23. What is a cell reference?
    A) Cell name
    B) Chart
    C) Table
    D) Image
    Answer: A
  24. What is relative reference?
    A) Fixed reference
    B) Changes with position
    C) Chart
    D) Table
    Answer: B
  25. What is absolute reference?
    A) Changes
    B) Fixed reference
    C) Chart
    D) Table
    Answer: B
  26. What is the use of $ symbol in Excel?
    A) Currency
    B) Fix reference
    C) Format
    D) Print
    Answer: B
  27. What is text wrapping?
    A) Hide text
    B) Fit text in cell
    C) Delete text
    D) Copy text
    Answer: B
  28. What is merge cells?
    A) Split cells
    B) Combine cells
    C) Delete cells
    D) Format cells
    Answer: B
  29. What is split cells?
    A) Combine
    B) Divide cells
    C) Delete cells
    D) Format cells
    Answer: B
  30. What is border in Excel?
    A) Cell edge
    B) Chart
    C) Table
    D) Image
    Answer: A
  31. What is fill color?
    A) Background color
    B) Text color
    C) Border
    D) Chart
    Answer: A
  32. What is font color?
    A) Background
    B) Text color
    C) Border
    D) Layout
    Answer: B
  33. What is slide master?
    A) Slide design template
    B) Chart
    C) Table
    D) Image
    Answer: A
  34. What is notes pane?
    A) Add notes
    B) Add chart
    C) Add image
    D) Add table
    Answer: A
  35. What is handout?
    A) Printed slides
    B) Chart
    C) Table
    D) Image
    Answer: A
  36. What is print layout view?
    A) Editing view
    B) Print view
    C) Slide view
    D) Chart view
    Answer: B
  37. What is draft view?
    A) Editing mode
    B) Print mode
    C) Slide mode
    D) Chart mode
    Answer: A
  38. What is web layout view?
    A) Web page view
    B) Print view
    C) Slide view
    D) Chart view
    Answer: A
  39. What is outline view?
    A) Text structure
    B) Chart
    C) Table
    D) Image
    Answer: A
  40. What is print area in Excel?
    A) Selected area to print
    B) Chart
    C) Table
    D) Image
    Answer: A
  41. What is page setup?
    A) Formatting page
    B) Editing text
    C) Saving file
    D) Printing file
    Answer: A
  42. What is watermark?
    A) Background text/image
    B) Chart
    C) Table
    D) Image
    Answer: A
  43. What is page number?
    A) Numbering pages
    B) Chart
    C) Table
    D) Image
    Answer: A
  44. What is footnote?
    A) Bottom note
    B) Top note
    C) Chart
    D) Table
    Answer: A
  45. What is citation?
    A) Reference source
    B) Chart
    C) Table
    D) Image
    Answer: A
  46. What is bibliography?
    A) List of references
    B) Chart
    C) Table
    D) Image
    Answer: A
  47. What is index?
    A) List of topics
    B) Chart
    C) Table
    D) Image
    Answer: A
  48. What is mail merge field?
    A) Variable data
    B) Chart
    C) Table
    D) Image
    Answer: A
  49. What is envelope printing?
    A) Print envelopes
    B) Chart
    C) Table
    D) Image
    Answer: A
  50. What is label printing?
    A) Print labels
    B) Chart
    C) Table
    D) Image
    Answer: A
Pages: 1 2 3 4

Leave a Comment