Office Automation MCQs

by

  1. What is the default extension of MS Excel files?
    A) .docx
    B) .pptx
    C) .xlsx
    D) .txt
    Answer: C
  2. Which key is used to start a slideshow in PowerPoint?
    A) F1
    B) F5
    C) F10
    D) F12
    Answer: B
  3. What is a workbook in Excel?
    A) Single cell
    B) Collection of worksheets
    C) Chart
    D) Table
    Answer: B
  4. Which tool is used to insert images in Word?
    A) Insert Tab
    B) Review Tab
    C) Layout Tab
    D) Design Tab
    Answer: A
  5. What is a formula bar?
    A) Menu bar
    B) Tool for entering formulas
    C) Status bar
    D) Title bar
    Answer: B
  6. Which function counts numbers in Excel?
    A) SUM
    B) COUNT
    C) AVG
    D) MAX
    Answer: B
  7. What is mail merge used for?
    A) Sending emails
    B) Creating multiple documents
    C) Printing slides
    D) Creating charts
    Answer: B
  8. What is the function of Ctrl + N?
    A) New document
    B) Save
    C) Print
    D) Open
    Answer: A
  9. What is the use of Ctrl + O?
    A) Save
    B) Open file
    C) Close file
    D) Print
    Answer: B
  10. Which tab is used to check grammar in Word?
    A) Insert
    B) Review
    C) Layout
    D) Home
    Answer: B
  11. What is the use of Ctrl + B?
    A) Bold text
    B) Italic text
    C) Underline text
    D) Copy
    Answer: A
  12. What is the use of Ctrl + I?
    A) Bold
    B) Italic
    C) Underline
    D) Save
    Answer: B
  13. What is the use of Ctrl + U?
    A) Bold
    B) Italic
    C) Underline
    D) Save
    Answer: C
  14. Which feature helps to find words in a document?
    A) Replace
    B) Find
    C) Insert
    D) Save
    Answer: B
  15. What is the function of Ctrl + F?
    A) Find
    B) Format
    C) File
    D) Font
    Answer: A
  16. What is a pivot table?
    A) Chart
    B) Data summarization tool
    C) Table
    D) Slide
    Answer: B
  17. Which function finds average in Excel?
    A) SUM
    B) AVG
    C) AVERAGE
    D) COUNT
    Answer: C
  18. What is the use of AutoSum?
    A) Formatting
    B) Automatic addition
    C) Printing
    D) Editing
    Answer: B
  19. What is a template?
    A) Blank file
    B) Pre-designed document
    C) Chart
    D) Table
    Answer: B
  20. What is the use of Ctrl + Y?
    A) Undo
    B) Redo
    C) Copy
    D) Paste
    Answer: B
  21. Which option is used to change page orientation?
    A) Layout
    B) Insert
    C) Home
    D) Review
    Answer: A
  22. What are margins?
    A) Borders
    B) Page edges space
    C) Font style
    D) Alignment
    Answer: B
  23. What is line spacing?
    A) Space between lines
    B) Space between pages
    C) Space between words
    D) Space between columns
    Answer: A
  24. Which tool changes font size?
    A) Font Size
    B) Alignment
    C) Layout
    D) Insert
    Answer: A
  25. What is the function of Ctrl + K?
    A) Insert link
    B) Copy
    C) Save
    D) Print
    Answer: A
  26. What is SmartArt?
    A) Chart
    B) Diagram tool
    C) Text tool
    D) Image tool
    Answer: B
  27. What is the use of headers and footers?
    A) Add text at top/bottom
    B) Add charts
    C) Add tables
    D) Add images
    Answer: A
  28. What is a slide layout?
    A) Design of slide
    B) Chart
    C) Text
    D) Table
    Answer: A
  29. What is theme in PowerPoint?
    A) Slide show
    B) Design template
    C) Chart
    D) Table
    Answer: B
  30. What is animation pane?
    A) Shows animations
    B) Shows slides
    C) Shows charts
    D) Shows text
    Answer: A
  31. What is conditional formatting?
    A) Format based on condition
    B) Text editing
    C) Saving
    D) Printing
    Answer: A
  32. What is freeze pane?
    A) Lock rows/columns
    B) Delete data
    C) Insert data
    D) Save file
    Answer: A
  33. What is a filter in Excel?
    A) Delete data
    B) Sort data
    C) Show specific data
    D) Format data
    Answer: C
  34. What is sorting?
    A) Arranging data
    B) Deleting data
    C) Saving data
    D) Editing data
    Answer: A
  35. What is a macro?
    A) Chart
    B) Automated task
    C) Table
    D) Slide
    Answer: B
  36. What is a textbox?
    A) Chart
    B) Text container
    C) Table
    D) Image
    Answer: B
  37. What is WordArt?
    A) Decorative text
    B) Chart
    C) Table
    D) Image
    Answer: A
  38. What is the use of Ctrl + L?
    A) Align left
    B) Align right
    C) Center
    D) Justify
    Answer: A
  39. What is the use of Ctrl + E?
    A) Center align
    B) Left align
    C) Right align
    D) Justify
    Answer: A
  40. What is the use of Ctrl + R?
    A) Align right
    B) Align left
    C) Center
    D) Justify
    Answer: A
  41. What is justification?
    A) Align both sides
    B) Left align
    C) Right align
    D) Center
    Answer: A
  42. What is track changes?
    A) Editing tool
    B) Review changes
    C) Print tool
    D) Save tool
    Answer: B
  43. What is comments feature?
    A) Add notes
    B) Delete text
    C) Save file
    D) Print file
    Answer: A
  44. What is page break?
    A) New page
    B) Delete page
    C) Save page
    D) Print page
    Answer: A
  45. What is zoom?
    A) Increase/decrease view
    B) Save file
    C) Print file
    D) Edit file
    Answer: A
  46. What is status bar?
    A) Shows document info
    B) Shows menu
    C) Shows toolbar
    D) Shows slide
    Answer: A
  47. What is ribbon in MS Office?
    A) Toolbar
    B) Menu
    C) Interface with tabs
    D) Status bar
    Answer: C
  48. What is clipboard?
    A) Storage of copied items
    B) File
    C) Folder
    D) Program
    Answer: A
  49. What is print preview?
    A) View before printing
    B) Print document
    C) Save document
    D) Edit document
    Answer: A
  50. What is collaboration in Office apps?
    A) Single user work
    B) Multiple users working together
    C) Printing
    D) Saving
    Answer: B
    )
Pages: 1 2 3 4

Leave a Comment