Office Productivity Tools
Solved Exam Questions
Course Introduction
Office Productivity Tools is designed to introduce students to essential software applications commonly used in academic, business, and personal environments to increase efficiency and effectiveness. The course covers word processing, spreadsheet management, presentation creation, and basic database operations using industry-standard programs such as Microsoft Office and Google Workspace. Students will learn to create professional documents, analyze data, manage information, and develop visually engaging presentations. Emphasis is placed on practical skills, collaborative work features, and digital organization strategies, preparing students to meet the technological demands of the modern workplace.
Recommended Textbook
New Perspectives on Microsoft Word 2013 Comprehensive 1st Edition by S. Scott Zimmerman
Available Study Resources on Quizplus
11 Chapters
1096 Verified Questions
1096 Flashcards
Source URL: https://quizplus.com/study-set/2172 Page 2
Chapter 1: Creating and Editing a Document
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/43321
Sample Questions
Q1) In the block style business letter, the inside address appears below the date, with one blank _______ in between.
A) space
B) paragraph
C) line
D) document
Answer: B
Q2) With ____________________ alignment the text is aligned along the right margin and is ragged along the left margin.
Answer: right
Q3) Which of the follow is a question to consider when creating effective documents?
A) Who is the audience?
B) What do they know?
C) What do they need to know?
D) All of the above
Answer: D
Q4) You can add envelopes to existing documents.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Navigating and Formatting a Document
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/43322
Sample Questions
Q1) The Office ____ is a temporary storage area on your computer that holds objects such as text or graphics until you need them.
A) Clipboard
B) Navigation page
C) Repository
D) Memory
Answer: A
Q2) To <u>move</u> means to copy a selected item to the Clipboard, leaving the item in its original location. _________________________
A)True
B)False
Answer: False
Q3) To copy selected text, you can use the keyboard command ____.
A) Ctrl+V
B) Alt+C
C) Ctrl+C
D) Alt+V
Answer: C
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: Creating Tables and a Multipage Report
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/43323
Sample Questions
Q1) Text printed at the bottom of every page
A)record
B)footnote
C)endnote
D)header
E)footer
F)reference marker
G)header row
H)sort
I)tab stop
J)section
Answer: E
Q2) To delete the structure of a row, column, or table, select the row, column, or table, and then use ____.
A) the Delete button on the keyboard
B) the Backspace button on the keyboard
C) the Redo command
D) the Delete button in the Rows & Columns group
Answer: D
To view all questions and flashcards with answers, click on the resource link above.
Page 5
Chapter 4: Enhancing Page Layout and Design
Available Study Resources on Quizplus for this Chatper
97 Verified Questions
97 Flashcards
Source URL: https://quizplus.com/quiz/43324
Sample Questions
Q1) You can place a drop cap in the margin, next to the paragraph, or you can have the text of the paragraph <u>wrap around</u> the drop cap.
A)True
B)False
Q2) To position a border relative to the text, not the edge of the page, select the ____________________ drop-down menu in the Border and Shading Options dialog box.
Q3) Discuss writing for a newsletter, including the relationship between design and the writing itself.
Q4) Which of the text wrapping settings flows around the exact outline of an object?
A) Tight
B) Square
C) Through D) Top and Bottom
Q5) To insert special characters in Word, choose the Special Characters tab from the ____________________ dialog box.
Q6) A text box is considered a(n)<u> shape</u>. _________________________
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Working With Templates, Themes, and Styles
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/43325
Sample Questions
Q1) A ____ style contains all the character formatting options as well as formatting options such as line spacing, text alignment, tab stops, and borders.
A) character
B) paragraph
C) linked
D) page
Q2) Every document has two of these, which are used in the document's styles
A)linked style
B)theme colors
C)character spacing
D)template
E)theme fonts
F)Reveal Formatting pane
G)Style Inspector pane
H)paragraph style
I)Normal template
J)style set
Q3) The ____________________ template does not have any text, formatting, or graphics, but it does include all the default settings you are accustomed to in Word.
To view all questions and flashcards with answers, click on the resource link above.
Page 7
Chapter 6: Using Mail Merge
Available Study Resources on Quizplus for this Chatper
99 Verified Questions
99 Flashcards
Source URL: https://quizplus.com/quiz/43326
Sample Questions
Q1) Which of the following can't Duncan use to generate a data source?
A) Word
B) Excel
C) PowerPoint
D) Access
Q2) The order of field names in the data source does not affect their placement in the main document.
A)True
B)False
Q3) After you complete a mail merge, a connection exists between the main document file and the data source file.
A)True
B)False
Q4) As you create a data source, keep in mind that you cannot have _______ fields with the same name.
A) three
B) four
C) five
D) two
Q5) The default save location is a subfolder of the ____________________ folder.
Page 8
To view all questions and flashcards with answers, click on the resource link above.
Chapter 7: Collaborating With Others and Integrating Data
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/43327
Sample Questions
Q1) As shown in the accompanying figure, when you place the mouse pointer over a newly inserted word in a document in which tracked changes display, a(n) ____________________ displays information about the edit, along with the date and time the edit was made.
Q2) To embed, but not link, an object, select the _______ option in the Paste Special dialog box.
A) Paste
B) Embed
C) Embed, but not link
D) Paste link
Q3) OLE stands for ____________________.
Q4) Clementine notices that there is text in a contrasting color with an underline. What type of text is this?
A) text to which a comment has been attached
B) deleted text
C) inserted text
D) highlighted text
Q5) Of the webpage file types in Word, a(n) ____________________ saves the document as an HTML file, with graphics stored in a separate folder.
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Customizing Word and Automating Your Work
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/43328
Sample Questions
Q1) When Simon creates a macro, which of the following is a valid macro name?
A) Resize Pic
B) ResizePic
C) ResizePic!
D) Resize.Pic
Q2) For a draft version of your newsletter, you want the document to be able to be emailed, so it is important to keep the overall file size small. What compression setting should you use for the images?
A) 72 ppi
B) 96 ppi
C) 150 ppi
D) 220 ppi
Q3) ____ are helpful when you work with a team of people who all need to create similar documents.
A) Indices
B) Templates
C) Action buttons
D) Modules
Q4) Discuss the role of global content standards in written communication.
Q5) The item marked 3 in the accompanying figure is the ____________________ window.
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Creating Online Forms Using Advanced Table Techniques
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/43329
Sample Questions
Q1) Some of Tanya's text phrases in the table need to be aligned better. She does not care for the default alignment, which is _______.
A) left and center
B) left and bottom
C) left and top
D) right and center
Q2) You can split cells vertically to increase the number of ____________________ in a row.
Q3) Describe in detail the ways in which AutoFit behavior works in tables.
Q4) All of the following are types of content controls in Word EXCEPT _______.
A) Rich Text
B) Drop-Down List
C) Combo Box
D) Time Picker
Q5) <u>Arguments </u>appear between parentheses immediately after the name of the function. _________________________
A)True
B)False
Q6) A(n) ____________________ is a mathematical statement that calculates a value. Page 11
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 10: Managing Long Documents
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/43330
Sample Questions
Q1) List the steps to marking an index entry.
Q2) A digital signature is an electronic attachment, not visible within the contents of the document, that verifies the authenticity of the _______ or the version of the document.
A) software
B) author
C) comments
D) subdocuments
Q3) Henry also sees lots of red marks and crossed out text. He is looking at _______. A) revision marks
B) corrections
C) encrypted text
D) footnotes
Q4) In the accompanying figure, the text below the image of the woman is called a(n) ____________________.
Q5) Scrolling two documents at once allows you to quickly assess the overall structure of two documents.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 11: Managing Your Files
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/43320
Sample Questions
Q1) The File Explorer status bar displays ____.
A) all view buttons
B) only the Details and Large icons view buttons
C) only the Tiles, List, and Content view buttons
D) no view buttons
Q2) the default view for folders in the Pictures library
A)backslash
B)Large icons
C)Clipboard
D)root directory
E)SkyDrive
F)extension
G)folder
H)archive
I)Details
J)library
Q3) You can open a file using File Explorer by ____________________ it in the right pane of File Explorer.
Q4) Describe some of the text's best practices for determining where to save files.
Q5) What are the text's three main guidelines for creating folders?
To view all questions and flashcards with answers, click on the resource link above. Page 14