Office Productivity Software Practice Questions
Course Introduction
This course provides students with a comprehensive introduction to widely-used office productivity software applications, including word processing, spreadsheets, presentation tools, and database management systems. Emphasizing practical skills, the course guides learners through creating professional documents, analyzing data using spreadsheets, designing engaging presentations, managing electronic communications, and organizing information efficiently. By the end of the course, students will be able to leverage these essential digital tools to increase productivity and efficiency in academic, professional, and personal tasks.
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) 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
Q2) Data such as a chart,a picture,a table,or a sound click can be linked as a(n)________ in the source file.
A) module
B) node
C) object
D) paragraph
Answer: C
Q3) Any item that can be selected and manipulated independently of surrounding text is a(n)________.
Answer: object
Q4) Editing a(n)________ object in the destination file affects only the object in the destination file.
Answer: embedded
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Integrated Projects, workshop 2: Integrating
Word, excel, and Access
Available Study Resources on Quizplus for this Chatper
26 Verified Questions
26 Flashcards
Source URL: https://quizplus.com/quiz/30405
Sample Questions
Q1) 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
Q2) If a Word document is open when you try to complete a Mail Merge from within Access,you will ________.
A) receive an error message that the Mail Merge completed but cannot be saved
B) receive a message that you must initiate the Mail Merge from within Word
C) receive a message indicating a successful merge
D) receive an error message that the file is locked for editing
Answer: D
Q3) The ________ bar reports that certain features of Access have been disabled to maintain security and prevent viruses from infecting your computer.
Answer: Security Warning
To view all questions and flashcards with answers, click on the resource link above. Page 4
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) There is no import or export command for moving Access data to a(n)________ presentation.
Answer: PowerPoint
Q2) Importing data from an Access database into an Excel worksheet creates a(n)________ connection.
Answer: permanent
Q3) Word automatically assigns ________ to the paragraphs when you type a paragraph into a document in Outline view.
A) font styles
B) paragraph names
C) end-of-paragraph marks
D) heading styles
Answer: D
Q4) Using the ________ button moves paragraphs to a higher level in the outline.
Answer: Promote
Q5) If you use Access data to create an Excel chart,and then link the chart to a PowerPoint presentation,when the data is updated in Access,it can be ________ in Excel and PowerPoint at the same time.
Answer: refreshed
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) To process data from the e-mails you send,________ must be installed on your computer,but does not have to be open and running.
Q2) A saved collection of fonts,colors,effects and backgrounds is called a template.
A)True
B)False
Q3) To respond to your e-mail,the ________ needs to click Reply,fill out the form,and then click Send.
Q4) In the data collection form,you can include AutoNumber,Attachment,and OLE type fields.
A)True B)False
Q5) To re-send a data collection form you must use the Manage Data Collection Messages dialog box. A)True B)False
Q6) You only have to store e-mail addresses in the database if you are updating records.
A)True B)False
To view all questions and flashcards with answers, click on the resource link above. Page 6
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) A ________ contains all the data concerning one person,place,thing,or event.
A) table
B) query
C) report
D) record
Q2) A ________ is a database that is presupplied with data.
A) beginner database
B) template database
C) sample database
D) starter database
Q3) To put records within a group into a specific order based on the values of a specific field,you ________ them.
A) join
B) group
C) sort
D) arrange
Q4) Having multiple large tables open at once in Access can slow the database management system down.
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) The first field in a table is the ________,which must be a unique entry.
A) export key
B) primary key
C) import key
D) composite key
Q2) The Text data types give users the ability to calculate values.
A)True
B)False
Q3) If the Undo button is dimmed,you CANNOT ________ the change you made.
A) Redo
B) Undo
C) Enter
D) Delete
Q4) ________ are created by joining the tables in a relational database together.
A) Relationships
B) Reports
C) Forms
D) Queries
To view all questions and flashcards with answers, click on the resource link above. Page 8
Q5) A(n)________ is a set of cells that can be referred to by a name rather than by the cell references.
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 Find Duplicates Query Wizard finds duplicate records in related tables.
A)True
B)False
Q2) The ________ logical operator is true if ALL the criteria are met.
Q3) 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
Q4) When two tables containing 100 records each are used in a query and the query returns 10,000 records,you know this is a result of the multiplier effect.
A)True
B)False
Q5) The ________ query wizard helps you identify orphan records.
Q6) In Design view,tables can be added to a query by dragging them from the Navigation Pane.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 9
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) Because the action is permanent,you CANNOT use the ________ button after you confirm a deletion.
A) Undo
B) Esc
C) Tab
D) Edit
Q2) If you need to change the sorting and grouping options of your report,you can do this from the Layout view or the Design view.
A)True
B)False
Q3) In a report,you can change the appearance of a control by adding borders or fill color.
A)True
B)False
Q4) A split form displays data from two different tables,with the information from the main table at the top of the window,and the information from the secondary form in the bottom of the window.
A)True
B)False
Page 10
To view all questions and flashcards with answers, click on the resource link above.
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(n)________ is a powerful computer program with a user interface that is a grid of rows and columns.
Q2) If the background of a worksheet is yellow,the area without data or documentation is referred to as yellow space rather than white space.
A)True
B)False
Q3) Microsoft's spreadsheet application is known as ________.
A) Publisher
B) Excel
C) Access
D) Outlook
Q4) Changing the cell alignment so words fit on to multiple lines is also known as wrapping text.
A)True
B)False
Q5) A cell in the second row and fifth column would be referred to by the cell reference
11
Q6) ________ are lettered in ascending sequence from left to right.
Q7) The part of a document that does not contain data is known as ________.
To view all questions and flashcards with answers, click on the resource link above.
Chapter
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/30395
Sample Questions
Q1) Variables or values inside a function's parentheses are known as ________.
Q2) C5 is an example of a cell ________.
Q3) Predefined set of formatting properties that determine the appearance of a table are known as table ________.
Q4) The correct order of operations is:
Exponentiation and Parentheses
Multiplication and Division
Addition and Subtraction
A)True
B)False
Q5) Sales tax is one example of a value well-suited to being a parameter.
A)True
B)False
Q6) Information presented in charts is said to be in ________ format.
A) oral
B) narrative
C) graphical
D) tabular
Page 12
Q7) The theme that is automatically applied unless you specify otherwise is known as the ________ workbook theme.
To view all questions and flashcards with answers, click on the resource link above. Page 13
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) 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
Q2) Some functions have optional arguments that can remain blank.
A)True
B)False
Q3) Which of the terms below would be most closely associated with the following formula:
=$J1+44
A) mixed reference
B) absolute reference
C) named range
D) relative reference
Q4) Names for named ranges must start with a number.
A)True
B)False
Q5) A set of cells that have been given a label that can then be used within a formula or function is a(n)________ range.
To view all questions and flashcards with answers, click on the resource link above. Page 14
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) Which of the following chart types would be used to compare parts of a whole?
A) bar
B) column
C) line
D) pie
Q2) A(n)________ chart is used within a spreadsheet to give an immediate visual trend analysis and it adjusts as the source data changes.
Q3) Which of the following charts could be used to easily group and compare categorized data sets?
A) pie
B) area
C) column
D) line
Q4) A simple way to display change over time,which also emphasizes the data by displaying colored layers,is by using a(n)________ chart.
Q5) To compare data in groups vertically,use a(n)________ chart.
Q6) Sparklines facilitate quick analysis of trends.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 15
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) When you place ________ in folders,they will be shown on the main To-Do List.
Q2) A unique word that identifies you to the mail server is your ________.
A) code name
B) user name
C) password
D) identification name
Q3) Using a rule,you can apply ________ to appointments on your calendar to help remind yourself that a meeting is important.
A) exclamation points
B) asterisks
C) a graphic
D) conditional formatting
Q4) It is illegal for employers to monitor employee e-mail sent using the company e-mail system.
A)True B)False
Page 16
Q5) The Contacts component in Outlook keeps track of addresses and other personal information.
A)True B)False
To view all questions and flashcards with answers, click on the resource link above.
Page 17
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) Asking "why were you asked to speak?" and "why is this topic important to the audience?" are ways to effectively plan your presentation for your target audience.
A)True
B)False
Q2) Which of the following options gives the user handouts with note lines?
A) 3 Slides handout
B) 6 Slides handout
C) 9 Slides handout
D) 1 Slide handout
Q3) ________ view displays slides one at a time,offering tools such as the title bar Minimize,Maximize/Restore,and Close buttons,and navigation buttons for moving between slides.
A) Reading
B) Slide Sorter
C) Normal
D) Slide Show
Q4) Sans serif fonts are considered more print-friendly than serif fonts.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 18
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 Color tool will allow you to change the color of a picture to better match the color scheme of a template.
A)True
B)False
Q2) If you add more blue to an image,you are said to be adjusting the color ________ (or temperature).
Q3) A presentation which displays 20 slides,for 20 seconds each,during which the presenter speaks is known by the name ________.
Q4) Templates provide a consistent look for a presentation.
A)True
B)False
Q5) ________ charts show proportions that add up to 100%.
Q6) Which of the following can only be inserted as a special symbol?
A) =
B) :
C) ~
D) é
Q7) Combining two cells in a table is known as ________.
Q8) Characters not available on a standard keyboard are known as special ________. Page 19
To view all questions and flashcards with answers, click on the resource link above.
Page 20
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) Animations can be started in three ways: clicking,with any previous action,or after another animation.
A)True
B)False
Q2) A Photo Album generated through PowerPoint is stored as part of the same file as the presentation.
A)True
B)False
Q3) ________ Buttons are special shapes,predefined to include actions that help you navigate through slides.
Q4) A special shape with predefined actions that can be added to a presentation is also known as a(n)________.
A) hyperlink
B) transition
C) trigger
D) Action Button
Q5) PDF and XPS files can contain audio and video.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 21
Chapter
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) Templates are saved in the My Documents folder by default.
A)True
B)False
Q2) PowerPoint annotations can only be done in one color - black.
A)True
B)False
Q3) To customize your speaker notes,modify the ________ master.
A) title
B) notes
C) slide
D) handout
Q4) A presentation can use Presenter View to show speaker notes on one monitor and the presentation slides on a second monitor.
A)True
B)False
Q5) Corporate identities refer to logos and other visual elements that make a company's products recognizable.
A)True
B)False
Q6) PowerPoint presentations are saved by default in the ________ folder. Page 22
To view all questions and flashcards with answers, click on the resource link above.
Page 23
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) A tool that makes setting measurements for tabs and indents easier is the
A) tab dialog box
B) ruler dialog box
C) table dialog box
D) ruler
Q2) The feature with which Word automatically wraps text from one line to the next is called ________.
Q3) A quick way to open recently accessed Word documents is to ________.
A) click Recent Documents
B) click the question mark at the top right corner of the screen
C) click Open
D) click the File tab to open the Backstage view
Q4) A view that is sometimes used as the starting point for a table of contents or PowerPoint summary is called the ________ view.
A) Draft
B) Web Layout
C) Print Layout
D) Outline
24
Q5) When the pointer is near a selection,a(n)________ is revealed.
To view all questions and flashcards with answers, click on the resource link above.
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) The ________ of a document includes settings such as margins,orientation,and alignment.
A) page setup
B) document setup
C) formatting setup
D) paragraph setup
Q2) Page orientation can be set at the document level or at the section level.
A)True
B)False
Q3) Word defines a paragraph as any text that ends with a ________.
A) period
B) soft return
C) hard return
D) tab
Q4) When you drag a selection to another location in a document,a small ________ will indicate the position where the text will be placed.
A) vertical bar
B) arrow
C) shadow cursor
D) blinking line
To view all questions and flashcards with answers, click on the resource link above. Page 25
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) When using WordArt,a(n)________ styles gallery enables you to change the formatting of the box surrounding the WordArt selection.
Q2) Using the center resizing handles on a picture allows you to resize the picture proportionally.
A)True
B)False
Q3) When typing a report or document that is divided into sections or chapters,you need to insert a ________ at the end of each section or chapter.
A) page end mark
B) page break
C) new page mark
D) section break
Q4) A picture can be resized proportionately using a(n)________ resizing handle.
Q5) A(n)________ is a paragraph's last line that appears alone at the top of a page.
Q6) To add a tab leader to your document,you MUST use the Tab dialog box.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 26
Q7) To change the formatting of different sections on a single page,you would use the ________ section break.
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) Internal newsletters are designed for ________.
A) employees and customers
B) only customers
C) only employees
D) the general public
Q2) Since Word will check your newsletter for spelling and common grammatical errors,you do not need to proofread your document.
A)True
B)False
Q3) The act of giving credit for ideas and information in your research paper is called ________.
A) mentioning B) citing C) assigning D) noting
Q4) Excel spreadsheets are NOT valid sources of data for Word's Mail Merge function. A)True B)False
To view all questions and flashcards with answers, click on the resource link above. Page 27
Q5) ________ knowledge is knowledge or information you do not have to cite in your paper.
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) Microsoft released Windows 7 in the year 2000.
A)True
B)False
Q2) The Windows operating system does not support multitasking.
A)True
B)False
Q3) System software ________ and coordinates computer hardware operations.
A) fixes
B) restores
C) controls
D) manages
Q4) The snipping tool allows users to take pictures of their current screen.This feature was introduced in ________.
A) Windows XP
B) Windows Vista
C) Windows 7
D) Windows 8
Q5) Microsoft's alternative to the Android and Apple devices is called ________.
Q7) The new desktop interface for Windows 8 is called the ________ interface. Page 28
Q6) Applications designed for Windows 8 will not include the ________ button.
To view all questions and flashcards with answers, click on the resource link above. Page 29
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) File names can ONLY be 12 characters long,excluding the extension.
A)True
B)False
Q2) The ________ opens a corresponding dialog box or task pane which provides more options or settings beyond those available in the Ribbon.
Q3) When text is selected,a(n)________ appears.
A) Mini toolbar
B) option box
C) dialog box
D) contextual tab
Q4) When you are finished with a program,you should ________ the program to save system resources.
A) remove
B) exit
C) minimize
D) switch
Q5) A(n)________ button turns on a feature if you click it once,then turns the same feature off if you click it a second time.
Q6) The keyboard shortcut used to access Help is the ________ key.
To view all questions and flashcards with answers, click on the resource link above. Page 30
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) A bar that appears on the right side of the menu when all items are not visible on the menu list is the ________.
A) scan bar
B) jump bar
C) roll bar
D) scroll bar
Q2) To use Aero Flip 3D,you hold down the ________ key combination.
Q3) The default for the screen saver wait time is 25 minutes.
A)True
B)False
Q4) The change your view button allows you to preview images as medium,large,or extra large icons.
A)True
B)False
Q5) To see all open windows,you can display them side-by-side or ________ them.
Q6) The left pane of the Start menu contains the ________ programs list,which displays the last 10 programs that were opened.
Q8) When you click the Shut down button,Windows may start to install ________. Page 31
Q7) You can double-click the ________ of a window to maximize it or to restore it.
To view all questions and flashcards with answers, click on the resource link above. Page 32