NABTEB Office Practice Past Questions And Answers (Objective and Theory)

 

Section A: Office Practice Questions

 

Question: In Microsoft PowerPoint, how can you apply a transition between slides?

 

a) Ctrl+T

b) Ctrl+S

c) Ctrl+P

d) Ctrl+Shift

Answer: a) Ctrl+T

 

Question: What is the purpose of the “AutoSum” function in Microsoft Excel?

 

a) Calculates the average of selected cells

b) Adds up a range of selected cells

c) Multiplies the values in selected cells

d) Divides the values in selected cells

Answer: b) Adds up a range of selected cells

 

Question: How can you change the line spacing in a Microsoft Word document?

 

a) Ctrl+1

b) Ctrl+2

c) Ctrl+3

d) Ctrl+4

Answer: b) Ctrl+2

 

Question: In Microsoft Excel, what does the formula “=COUNTA(A1:A10)” do?

 

a) Finds the sum of the range A1 to A10

b) Counts the number of non-empty cells in the range A1 to A10

c) Multiplies the values in the range A1 to A10

d) Divides the values in the range A1 to A10

Answer: b) Counts the number of non-empty cells in the range A1 to A10

 

Question: What is the purpose of the “Reply All” feature in email applications?

 

a) Replies only to the sender

b) Replies to all recipients, including those in the CC and BCC fields

c) Replies with an attachment

d) Replies with a high-priority flag

Answer: b) Replies to all recipients, including those in the CC and BCC fields

 

Section B: Office Practice Theory Questions

 

Question: Discuss the advantages of using collaborative online platforms for document editing in office environments.

Answer: Collaborative online platforms enable real-time editing, version control, and seamless communication among team members, fostering efficient collaboration and improving overall productivity in office document workflows.

 

Question: Explain the concept of “mail merge” in the context of Microsoft Word and its applications.

Answer: Mail merge in Microsoft Word involves combining a document with a data source to create personalized documents, such as letters or labels, streamlining the process of mass communication and reducing manual effort.

 

Question: How does the “Track Changes” feature in Microsoft Word contribute to the editing and review process?

Answer: The “Track Changes” feature allows users to mark and monitor modifications made to a document, facilitating collaborative editing and providing transparency in the review process.

 

Question: Describe the purpose of using hyperlinks in a Microsoft Excel worksheet.

Answer: Hyperlinks in Excel enable users to navigate between different sheets, workbooks, or external resources, enhancing the accessibility and interconnectedness of data within a spreadsheet.

 

Question: Discuss the significance of using spell check and grammar check features in office document preparation.

Answer: Spell check and grammar check features in office applications, such as Microsoft Word, ensure accuracy and professionalism in written communication, helping to avoid errors and improve the overall quality of documents.