WAEC Office Practice Past Questions And Answers (Objective and Theory)
Section A: Office Practice Questions
Question: What is the shortcut key for copying selected text in Microsoft Word?
a) Ctrl+C
b) Ctrl+X
c) Ctrl+V
d) Ctrl+A
Answer: a) Ctrl+C
Question: In Excel, what function is used to find the highest value in a range of cells?
a) MAX()
b) SUM()
c) AVG()
d) MIN()
Answer: a) MAX()
Question: Which software is commonly used for creating and editing presentations?
a) Microsoft Excel
b) Microsoft PowerPoint
c) Microsoft Access
d) Microsoft Outlook
Answer: b) Microsoft PowerPoint
Question: What is the purpose of BCC in email?
a) Bold, Copy, Cut
b) Blind Carbon Copy
c) Backup, Clear, Close
d) Business Correspondence Code
Answer: b) Blind Carbon Copy
Question: How can you align text to the center in Microsoft Word?
a) Ctrl+C
b) Ctrl+X
c) Ctrl+E
d) Ctrl+V
Answer: c) Ctrl+E
Question: Which file format is commonly used for saving documents in Microsoft Word?
a) .txt
b) .docx
c) .xlsx
d) .pdf
Answer: b) .docx
Question: In Microsoft Excel, what does the formula “=SUM(A1:A5)” do?
a) Multiplies the values in the range A1 to A5
b) Divides the values in the range A1 to A5
c) Adds the values in the range A1 to A5
d) Subtracts the values in the range A1 to A5
Answer: c) Adds the values in the range A1 to A5
Question: What is the purpose of a spreadsheet program like Microsoft Excel?
a) Creating and editing images
b) Managing emails
c) Analyzing and manipulating numerical data
d) Designing web pages
Answer: c) Analyzing and manipulating numerical data
Question: Which view in Microsoft PowerPoint allows you to see all the slides in a presentation at once?
a) Slide Show
b) Normal View
c) Slide Sorter
d) Outline View
Answer: c) Slide Sorter
Question: What does CC stand for in email?
a) Carbon Copy
b) Copy Content
c) Central Control
d) Computer Code
Answer: a) Carbon Copy
Question: How do you spell check a document in Microsoft Word?
a) F7
b) F5
c) Ctrl+S
d) Ctrl+P
Answer: a) F7
Question: In Microsoft Excel, what is the function of the formula “=AVERAGE(B1:B10)”?
a) Finds the sum of the range B1 to B10
b) Finds the average of the range B1 to B10
c) Multiplies the values in the range B1 to B10
d) Divides the values in the range B1 to B10
Answer: b) Finds the average of the range B1 to B10
Question: Which of the following is a common cloud storage service?
a) USB Drive
b) Google Drive
c) External Hard Drive
d) DVD-RW
Answer: b) Google Drive
Question: What is the primary function of a spreadsheet program like Microsoft Excel?
a) Word processing
b) Graphic design
c) Data manipulation and analysis
d) Video editing
Answer: c) Data manipulation and analysis
Question: In Microsoft PowerPoint, how can you add a new slide to a presentation?
a) Ctrl+C
b) Ctrl+X
c) Ctrl+M
d) Ctrl+V
Answer: c) Ctrl+M
Question: Which function key is commonly used to open the “Find and Replace” dialog in Microsoft Word?
a) F5
b) F8
c) F9
d) Ctrl+F
Answer: d) Ctrl+F
Question: What is the purpose of a mail merge in Microsoft Word?
a) Combining multiple emails into one
b) Merging cells in a table
c) Combining a document with a data source to create personalized documents
d) Creating a backup of emails
Answer: c) Combining a document with a data source to create personalized documents
Question: Which of the following is a presentation software alternative to Microsoft PowerPoint?
a) Adobe Photoshop
b) Google Slides
c) Microsoft Access
d) Apple Numbers
Answer: b) Google Slides
Question: What does the term “CC” stand for in the context of an email?
a) Closed Captioning
b) Courtesy Copy
c) Common Code
d) Centralized Communication
Answer: b) Courtesy Copy
Question: How can you undo the last action in most Microsoft Office applications?
a) Ctrl+Z
b) Ctrl+Y
c) Ctrl+X
d) Ctrl+C
Answer: a) Ctrl+Z
Section B: Office Practice Theory Questions
Question: Explain the purpose of using headers and footers in a document.
Answer: Headers and footers are used to add consistent information, such as page numbers, titles, or logos, to the top or bottom of each page in a document.
Question: What is the significance of using cell references in formulas in Microsoft Excel?
Answer: Cell references allow Excel to dynamically update formulas based on the content of referenced cells, providing flexibility and efficiency in data manipulation.
Question: Describe the importance of using strong passwords and password management in office environments.
Answer: Strong passwords enhance security by making it harder for unauthorized access. Password management ensures proper organization and protection of multiple complex passwords.
Question: How does the concept of “version control” contribute to efficient collaboration in office document editing?
Answer: Version control allows tracking changes and managing different versions of a document, facilitating collaboration by ensuring a coherent and organized editing process.
