Office Productivity Tools
Exam Bank
Course Introduction
Office Productivity Tools introduces students to essential software applications used in modern workplace environments to enhance efficiency and streamline daily tasks. The course covers key programs such as word processors, spreadsheets, presentation software, and collaboration platforms, focusing on practical skills for creating documents, analyzing data, preparing impactful presentations, and managing projects. Students will develop proficiency in integrating these tools to support communication, organization, and teamwork, preparing them to effectively manage information and contribute to professional environments.
Recommended Textbook
Your Office Microsoft Office 2010 Volume I 2nd Edition by Amy S. Kinser
Available Study Resources on Quizplus
24 Chapters
1775 Verified Questions
1775 Flashcards
Source URL: https://quizplus.com/study-set/1539
Page 2
Chapter 1: Integrated Projects, workshop 1: Integrating Word and Excel
Available Study Resources on Quizplus for this Chatper
26 Verified Questions
26 Flashcards
Source URL: https://quizplus.com/quiz/30394
Sample Questions
Q1) The file you insert an object into is called the ________ file.
A) source
B) objective
C) target
D) destination
Answer: D
Q2) Editing a(n)________ object in the destination file affects only the object in the destination file.
Answer: embedded
Q3) An Excel chart embedded into a Word document becomes part of the document and any changes made to the chart will update the source document.
A)True
B)False
Answer: False
Q4) When a destination file is closed and then opened,the linked object must be manually updated unless you turn OFF automatic updates in the Links options.
A)True
B)False
Answer: False
Page 3
To view all questions and flashcards with answers, click on the resource link above.
Chapter 2: Integrated Projects, workshop 2: Integrating
Available Study Resources on Quizplus for this Chatper
26 Verified Questions
26 Flashcards
Source URL: https://quizplus.com/quiz/30405
Sample Questions
Q1) The Mail Merge Wizard will not work if the Access database you are importing data from is in ________ mode.
A) exclusive
B) update
C) locked
D) data entry
Answer: A
Q2) It is a good business practice to maintain the same records in two or more different programs.
A)True
B)False
Answer: False
Q3) When you first open a database,if the Security Warning bar displays below the ribbon,you must click the ________ button before you can make changes to the database.
A) Security Checker
B) Close Security
C) Enable Content
D) Virus Checker
Answer: C
Page 4
To view all questions and flashcards with answers, click on the resource link above.
Chapter 3: Integrated Projects, workshop 3: Integrating
Available Study Resources on Quizplus for this Chatper
26 Verified Questions
26 Flashcards
Source URL: https://quizplus.com/quiz/30408
Sample Questions
Q1) Using the ________ button moves paragraphs to a higher level in the outline.
Answer: Promote
Q2) The ________ button allows you to show the lower levels in an outline after they have been collapsed.
A) Display
B) Expand
C) Show/Hide
D) Collapse
Answer: B
Q3) When you create PowerPoint slides from a Word outline,PowerPoint uses the highest level of paragraphs in the outline as ________.
A) bullet lists
B) slide text
C) slide titles
D) the presentation title
Answer: C
Q4) A hierarchical representation of paragraphs is called a(n)________.
Answer: outline
Q5) The top level of the Outline hierarchy is called the ________ paragraph.
Answer: Level 1
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Integrated Projects, workshop 4: Integrating
Available Study Resources on Quizplus for this Chatper
41 Verified Questions
41 Flashcards
Source URL: https://quizplus.com/quiz/30409
Sample Questions
Q1) The ________ Wizard in Access will walk you through the steps to create a data collection form.
Q2) In the data collection form,you can include AutoNumber,Attachment,and OLE type fields.
A)True
B)False
Q3) Themes and templates are managed in a similar way in ________.
A) a form
B) a report
C) a database
D) Office 2010
Q4) To re-send a data collection form you must use the Manage Data Collection Messages dialog box.
A)True
B)False
Q5) A(n)________ is a saved collection of fonts,colors,effects,and backgrounds which can be applied to an e-mail message.
To view all questions and flashcards with answers, click on the resource link above. Page 6
Q6) Since not everyone has Access installed on their computers,you can send an e-mail ________ with Access data formatted as another type of object.
Chapter 5: Microsoft Access 2010,workshop 1: Understanding the Four Main Database Objects
Available Study Resources on Quizplus for this Chatper
80 Verified Questions
80 Flashcards
Source URL: https://quizplus.com/quiz/30410
Sample Questions
Q1) The database object that holds organized data arranged in columns and rows is a
A) report
B) form
C) table
D) query
Q2) You have to tell Access that you trust content before features that a(n)________ might use to infect your computer will work.
Q3) Connie's boss has asked her to provide him a list of all customers who live in San Francisco,CA.To do this,Connie will create a ________.
A) PDF
B) form
C) query
D) question
Q4) Linking ________ together is what makes databases powerful.
Q5) Data is an important asset,because it permits businesses to make better decisions once it is converted into information.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Microsoft Access 2010,workshop 2: Gathering
Data Into a Database
Available Study Resources on Quizplus for this Chatper
84 Verified Questions
84 Flashcards
Source URL: https://quizplus.com/quiz/30411
Sample Questions
Q1) Primary and foreign keys form a common field between tables that makes it possible to form a(n)________ between the two tables.
Q2) The comma or tab are typical ________ characters.
A) normal
B) spacing
C) delimiter
D) special
Q3) The maximum length of a data field is the ________.
A) information size
B) field length
C) data size
D) field size
Q4) A(n)________ defines a consistent template and provides the punctuation.
Q5) In a database,data about a person,place,item or event is called a(n)________.
A) row
B) entity
C) field
D) attribute
Q6) Information about an entity is called a(n)________.
Q7) In Access,the relationship information is stored in the ________ window. Page 8
To view all questions and flashcards with answers, click on the resource link above.
Page 9
Chapter 7: Microsoft Access 2010,workshop 3: Accessing
Information From an Access Database
Available Study Resources on Quizplus for this Chatper
89 Verified Questions
89 Flashcards
Source URL: https://quizplus.com/quiz/30412
Sample Questions
Q1) The Access tool used to format calculated fields correctly is called the ________.
Q2) When you sort by multiple fields,the first field you select to sort on is called the ________ sort field.
A) secondary
B) primary
C) principle
D) beginning
Q3) Sorting is the process of pulling matching records from several different tables.
A)True
B)False
Q4) When you suspect that you have multiple instances of a record in a table,you should use the ________ query wizard.
A) Cross-Tab
B) Orphan
C) Find Unmatched
D) Find Duplicates
Q5) The ________ logical operator is true if ONLY one of the criteria is met.
Q6) To view all the records in a table at one time,open the ________ view.
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 8: Microsoft Access 2010,workshop 4: Maintaining and Presenting Data
Available Study Resources on Quizplus for this Chatper
86 Verified Questions
86 Flashcards
Source URL: https://quizplus.com/quiz/30413
Sample Questions
Q1) ________ not only lets you see how the report will look when it is printed,it also provides you with options to make design changes to the report before you send it to the printer.
A) Design view
B) Report view
C) Layout view
D) Print Preview
Q2) You CANNOT select a(n)________ other than Office while using the Report Wizard.
Q3) When you save a report as an Adobe PDF file,the PDF file is usually larger than the original document.
A)True
B)False
Q4) A ________ is a formatted printout of data.
A) form
B) datasheet
C) report
D) query
Q5) To calculate totals for smaller groups of records,you can add ________ to the report.
Q6) The final result of a report is usually a(n)________. Page 11
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 9: Microsoft Excel 2010,workshop 1: Understanding and Manipulating Microsoft Excel 2010
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/30414
Sample Questions
Q1) A worksheet that is not currently visible can be changed to the ________ worksheet by clicking on the worksheet tab in the bottom-left corner of the Excel window.
A) default
B) referenced
C) dormant
D) active
Q2) J42 is an example of a cell reference.
A)True
B)False
Q3) A that is page wider than it is tall is in ________ orientation.
Q4) C6 is an example of a cell range.
A)True
B)False
Q5) Pressing Alt+Tab allows a user to quickly move between open workbooks.
A)True
B)False
Q6) Moving the location of the current cell is known as worksheet ________.
Q8) Shrinking data to fit on one page is known as ________. Page 13
Q7) ________ are lettered in ascending sequence from left to right.
To view all questions and flashcards with answers, click on the resource link above.
Page 14
Chapter 10: Microsoft Excel 2010, workshop 2: Formatting, formulas, and
Functions
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/30395
Sample Questions
Q1) The formula below contains a hard-coded value: =J3*SUM(A1:A2)
A)True
B)False
Q2) A(n)________ is a value that may potentially change over time and is stored in a cell and referenced in a formula.
Q3) A cell reference that changes when copied is known as a(n)________ cell reference.
Q4) Which of the following has the highest priority per order of operations?
A) parentheses
B) exponentiation
C) division
D) addition
Q5) A cell with contents centered in that cell is said to have a centered cell ________ .
Q6) The following is an example of a built-in function: =J4+J2
A)True
B)False
Page 15
Q7) The function that allows users to determine how many numerical values exist in a range is the ________()function.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 11: Microsoft Excel 2010,workshop 3: Conducting
Excel Analysis Through Functions and Charts
Available Study Resources on Quizplus for this Chatper
62 Verified Questions
62 Flashcards
Source URL: https://quizplus.com/quiz/30396
Sample Questions
Q1) Named ranges make formulas easier to read.
A)True
B)False
Q2) If you type a formula into a cell and instead of results you see a formula,it is because you have likely switched the Show Formulas feature on.
A)True
B)False
Q3) Syntax rules state that functions start with an equal sign.
A)True
B)False
Q4) If a cell in a formula should remain in the same row when copied,but change the column,use a(n)________.
A) relative reference
B) named range
C) absolute reference
D) mixed reference
Q5) Inputs given to a function are known as ________.
Q6) A formula which states =B1*$B5 contains two ________ references.
To view all questions and flashcards with answers, click on the resource link above. Page 16
Q7) The PMT function's first argument is the periodic interest ________ of the loan.
Chapter 12: Microsoft Excel 2010,workshop 4: Using Charts
Available Study Resources on Quizplus for this Chatper
54 Verified Questions
54 Flashcards
Source URL: https://quizplus.com/quiz/30397
Sample Questions
Q1) To compare data in groups horizontally,use a(n)________ chart.
Q2) Which of the following could be used to easily group and compare categorized data sets?
A) bar
B) line
C) area
D) scatter
Q3) An individual piece of data on a data series is also known as a(n)________.
Q4) A(n)________ chart is a variation of a stacked line chart that emphasizes the magnitude of change over time and visually depicts a trend.
Q5) Pie charts can display parts of a whole effectively.
A)True
B)False
Q6) Bar charts and column charts are identical in function aside from the direction the bars are drawn in.
A)True
B)False
Q7) A set of data to be charted is also known as a(n)________.
Q8) A(n)________ chart conveys the relationship between two variables.
To view all questions and flashcards with answers, click on the resource link above. Page 17
Chapter
13: Microsoft Office Outlook 2010, workshop 1: Communicating With E-Mail, and Managing Contacts, calendars, and Tasks
Available Study Resources on Quizplus for this Chatper
86 Verified Questions
86 Flashcards
Source URL: https://quizplus.com/quiz/30398
Sample Questions
Q1) To create a new note,click the Notes button on the Navigation Pane and then click
A) New Note on the Home tab
B) New Note on the Insert tab
C) Create Note on the Insert tab
D) Create Note on the Home tab
Q2) Conversations,messages that can be viewed in groups,can be expanded or collapsed.
A)True
B)False
Q3) In Outlook,you can use ________ to help you organize your work by grouping together similar items and assigning a group name and color.
A) flags
B) graphics
C) colors
D) Categories
Q4) When you delete a message from the Inbox,it has been permanently removed from your computer.
A)True
B)False Page 18
To view all questions and flashcards with answers, click on the resource link above.
Page 19
Chapter 14: Microsoft Powerpoint 2010 workshop 1:
Communicating With Presentations
Available Study Resources on Quizplus for this Chatper
84 Verified Questions
84 Flashcards
Source URL: https://quizplus.com/quiz/30399
Sample Questions
Q1) A sans serif font is generally used for large blocks of text.
A)True
B)False
Q2) The people listening to your presentation are also known as the ________ audience.
Q3) Which of the following statements about the PowerPoint Show format is TRUE?
A) PowerPoint Shows are saved in the PowerPoint PDF format.
B) A PowerPoint Show opens in the Adobe Reader application.
C) Once saved in a PowerPoint Show format, the file cannot be changed.
D) A PowerPoint Show opens directly in the Slide Show view.
Q4) The ________ view is used to edit slides.
A) Slide Sorter
B) Slide Show
C) Normal
D) Reading
Q5) The Rule of 6's states in part that a slide should have a maximum of six lines per slide,including the title.
A)True
B)False
Page 20
Q6) Click on the ________ tab to display thumbnails of each slide.
To view all questions and flashcards with answers, click on the resource link above.
Page 21
Chapter 15: Microsoft Powerpoint 2010,workshop 2: Applying and Modifying Text
and Graphics
Available Study Resources on Quizplus for this Chatper
65 Verified Questions
65 Flashcards
Source URL: https://quizplus.com/quiz/30400
Sample Questions
Q1) The right to reproduce,distribute,create derivative works,perform and display intellectual property is known as ________.
A) copyright
B) Pecha Kucha
C) trademark
D) registration
Q2) ________ contain slide backgrounds,color schemes,font selections,sample content,and slide layouts.
Q3) Picture styles allow you to do all of the following EXCEPT ________.
A) add frames
B) change the picture's shape
C) add shadows
D) rotate a picture
Q4) Characters not available on a standard keyboard are also referred to as special ________.
A) macros
B) fonts
C) symbols
D) characters
22
Q5) Characters not available on a standard keyboard are known as special ________.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 16: Microsoft Powerpoint 2010,workshop 3: Applying and Modifying Multimedia
Available Study Resources on Quizplus for this Chatper
69 Verified Questions
69 Flashcards
Source URL: https://quizplus.com/quiz/30401
Sample Questions
Q1) Hyperlinks not only can link the audience to a web page,they can also link to an e-mail address.
A)True
B)False
Q2) Which of the following is a FALSE statement about PowerPoint's audio and video capabilities?
A) Audio can be set to play as a background song for an entire presentation.
B) Video files on your hard drive can be embedded in a presentation.
C) Slide narrations must be recorded with a separate program (such as Audacity) and then inserted in to a presentation.
D) Sounds can be inserted from audio files, such as MP3 or WAV files.
Q3) To play a sound on an object that already contains animation,use a(n)________.
Q4) To shorten an animation,you need to change the animation delay to a smaller number.
A)True
B)False
Q5) An action that happens as an object enters a slide is known as a(n)________ animation.
Q6) Though you can use a text box,you can alternately insert a(n)________.
Q7) The way a transition enters the screen is determined by the effect ________. Page 23
To view all questions and flashcards with answers, click on the resource link above.
Page 24
Customizing, Collaborating, and Presenting
Available Study Resources on Quizplus for this Chatper
62 Verified Questions
62 Flashcards
Source URL: https://quizplus.com/quiz/30402
Sample Questions
Q1) Company logos,fonts,and color schemes are all visual identities associated with a(n)________.
A) company character
B) corporate identity
C) business paradigm
D) industrial image
Q2) The Thesaurus is one example of PowerPoint's ________ tools.
Q3) PowerPoint presentations are limited to two sections.
A)True
B)False
Q4) Logos,color schemes,and fonts are used as part of a company's ________.
Q5) A slide master contains layouts for a template.
A)True
B)False
Q6) Outlines can be imported from Word into PowerPoint.
A)True
B)False
Q7) Document integrity can be ensured by adding a Digital Signature.
A)True
B)False Page 25
To view all questions and flashcards with answers, click on the resource link above. Page 26
Chapter 18: Microsoft Word 2010,workshop 1: Reviewing and Modifying a Document
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/30403
Sample Questions
Q1) Web storage that Microsoft makes available free of charge is called ________.
A) SkyWeb
B) WebDrive
C) SkyDrive
D) OnlineDrive
Q2) To select an entire document,you ________.
A) triple-click anywhere on the page
B) press Ctrl+A
C) press Shift+Alt
D) press and hold Ctrl while dragging the mouse
Q3) When you need to transmit a Word document in a compatible and secure format,you should always save the document as a txt file.
A)True
B)False
Q4) When you begin working with Microsoft Word,a(n)________ document will open.
A) template
B) blank
C) empty
D) starter
Q5) Files sent to the web from Word 2010 are saved to a(n)________ account.
To view all questions and flashcards with answers, click on the resource link above. Page 27
Chapter 19: Microsoft Word 2010,workshop 2: Creating and Editing a Document
Available Study Resources on Quizplus for this Chatper
89 Verified Questions
89 Flashcards
Source URL: https://quizplus.com/quiz/30404
Sample Questions
Q1) Indenting is considered to be ________ formatting.
Q2) ________,similar to Live Preview,is a new Word 2010 feature that lets you see the effect of a change before you accept it.
A) Document Preview
B) Move Preview
C) Paste Preview
D) Change Preview
Q3) A design element that enables you to create professional,color-coordinated documents with minimal errors is called a(n)________.
A) design plan
B) theme
C) design style
D) image style
Q4) A(n)________ is a type of command that is clicked once to begin an action,and a second time to end it.
Q5) Depending on what you select,a linked style behaves as either a character style or a paragraph style.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 28
Chapter 20: Microsoft Word 2010,workshop 3: Including
Tables and Objects
Available Study Resources on Quizplus for this Chatper
89 Verified Questions
89 Flashcards
Source URL: https://quizplus.com/quiz/30406
Sample Questions
Q1) Using the center resizing handles on a picture allows you to resize the picture proportionally.
A)True
B)False
Q2) Two easy ways to set up several columns of data is to use ________ or a table.
A) tabs
B) the ruler
C) cells
D) the spacebar
Q3) Jade needs to add a two column section to the center of a document page,with normally formatted text before and after the section.To do this,Jade will use the Next Page section break.
A)True
B)False
Q4) Table rows can ONLY be sorted in alphabetic and numeric order.
A)True
B)False
Q5) Selecting a row and using the Delete key deletes only the ________ of the row.
Q6) To start a new page after you finish a section or chapter in a Word document,insert a(n)________. Page 29
To view all questions and flashcards with answers, click on the resource link above.
Page 30
Chapter 21: Microsoft Word 2010,workshop 4: Formatting
Special Documents and Using Mail Merge
Available Study Resources on Quizplus for this Chatper
86 Verified Questions
86 Flashcards
Source URL: https://quizplus.com/quiz/30407
Sample Questions
Q1) Saving a newsletter developed in Word as a PDF file prevents accidental alteration of the text,photos,and content in the newsletter.
A)True
B)False
Q2) Marshal has developed a three column newsletter for his college music class.Unfortunately,the last column is not as long as the others,which makes the page look unprofessional and unfinished.To correct this and balance the columns,Marshal should use a ________.
A) textbox
B) section break
C) page break
D) column break
Q3) A regularly scheduled ________ is often used as a marketing strategy.
Q4) Word allows you to create mailing labels or print addresses on envelopes.
A)True
B)False
Q5) The ________ style is the principle style used in the sciences,such as biology,chemistry,computer science,math,and physics.
Q6) Using a(n)________ will help to balance and align columns more evenly.
To view all questions and flashcards with answers, click on the resource link above. Page 31
Chapter 22: Appendix: Microsoft Windows 8: Understanding
the Windows 8 Interface
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/30415
Sample Questions
Q1) The taskbar is located at the top of the Windows 8 screen.
A)True
B)False
Q2) Programs that help the user perform a specific task are called ________ software.
Q3) Operating system software are programs that help the user perform specific tasks.
A)True
B)False
Q4) To switch between applications in Windows 8 the user swipes from the right bezel towards the left.
A)True
B)False
Q5) The Charm menu in Windows 8 has twelve options to choose from.
A)True
B)False
Q6) Application software controls and coordinates computer hardware operations. A)True
B)False
Q7) The edge of the Windows 8 screen is called the ________.
To view all questions and flashcards with answers, click on the resource link above. Page 32
Chapter 23: Common Features,workshop 1: Understanding
the Common Features of Microsoft Office
Available Study Resources on Quizplus for this Chatper
88 Verified Questions
88 Flashcards
Source URL: https://quizplus.com/quiz/30416
Sample Questions
Q1) Microsoft PowerPoint is a(n)________ application.
A) planner and note taking
B) information management
C) spreadsheet
D) presentation
Q2) A file name includes the name you specify for the file and a file ________ that is assigned by the Office program to indicate the file type.
Q3) The Windows Live ________ is a free online file storage area where you can save up to 25 GB of files.
Q4) To prevent loss of work,you must save the work before exiting a program or turning off the computer.
A)True
B)False
Q5) A list of commands related to a selection that appears when you right-click is called a(n)________.
A) shortcut menu
B) dialog box
C) Mini toolbar
D) option menu
To view all questions and flashcards with answers, click on the resource link above. Page 33
Chapter 24: Windows 7, workshop 1: Understanding the Windows 7 Desktop
and Managing Windows
Available Study Resources on Quizplus for this Chatper
85 Verified Questions
85 Flashcards
Source URL: https://quizplus.com/quiz/30417
Sample Questions
Q1) When items in a drop-down menu are ________,they are not available at that time.
A) missing
B) invisible
C) red
D) grayed out
Q2) When you choose a desktop ________ for your computer,you need to make sure that it will not make it difficult to see the icons and to perform tasks.
A) icons
B) window
C) background
D) theme
Q3) ________ uses a hierarchical storage system to manage folders and files.
Q4) The area at the top left of the Start menu is the ________ area,where you can access frequently used programs and make them easily available.
A) user selected programs
B) selected programs
C) pinned programs
D) most used programs
Q5) A(n)________ is a rectangular frame that displays a program,folder or file.
To view all questions and flashcards with answers, click on the resource link above. Page 34