Office Productivity Software Exam Review
Course Introduction
This course covers the essential concepts and practical applications of office productivity software commonly used in educational, business, and professional environments. Students will gain hands-on experience with word processing, spreadsheet, presentation, and database management tools, learning to efficiently create, format, and manage documents, analyze data, automate tasks, and deliver dynamic presentations. The course emphasizes best practices for collaboration, data organization, and effective communication, preparing students to leverage productivity software to optimize workflow and enhance productivity in diverse workplace settings.
Recommended Textbook
New Perspectives Microsoft Office 365 and Office 2016 Introductory 1st Edition by Patrick Carey
Available Study Resources on Quizplus
18 Chapters
1311 Verified Questions
1311 Flashcards
Source URL: https://quizplus.com/study-set/1430
Page 2
Chapter 1: Creating a Database
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28362
Sample Questions
Q1) Each record in a table is uniquely identified by a foreign key._________________________
A)True
B)False
Answer: False
Q2) Which two keys on the keyboard allow an Access user to move the insertion point to the next field to the right in datasheet view when entering data?
A)Tab, Insert
B)Enter, PgDn
C)Insert, PgUp
D)Tab, Enter
Answer: D
Q3) Records in separate tables may be connected through a(n)____________________ that appears in both tables.
Answer: common field
Q4) The process of decreasing the file size of a database and enhancing the performance of the database is called ____________________ the database.
Answer: compacting
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Building a Database and Defining Table
Relationships
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28363
Sample Questions
Q1) A set of rules that Access uses to maintain consistency between related tables when data is updated in a database.
A)Cascade Update Related Fields Option
B)Cascade Delete Related Records Option
C)Composite key
D)data redundancy
E)Data Type gallery
F)Design
G)orphaned record
H)propagate
I)Quick Start selection
J)referential integrity
Answer: J
Q2) Performing a(n)____________________ is the process of relating tables in a database based on a common field.
Answer: join
Q3) ____________________ view allows the database designer to enter both the field names and define the field properties.
Answer: Design
Page 4
To view all questions and flashcards with answers, click on the resource link above.
Chapter 3: Maintaining and Querying a Database
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28364
Sample Questions
Q1) In the criterion,<=250,the operator will return values for the specified field that are
A)less than 250
B)equal to 250
C)less than or equal to 250
D)greater than or equal to 250
Answer: C
Q2) After creating the query,Jorge must set criteria to have the query return only those plants that need full sun. Entries for the Amount of Sun field include: partial sun,little sun,and full sun.How should Jorge enter the criteria for the exact match of full sun?
A)=>full sun
B)<=fullsun
C)<> full sun
D)"full sun"
Answer: D
Q3) The _________________ prompts for information by asking a series of questions and creates the appropriate results based on the answers to the prompts.
Answer: Query Wizard
To view all questions and flashcards with answers, click on the resource link above.
5
Chapter 4: Creating Forms and Reports
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28365
Sample Questions
Q1) Records printed in Form view are distinguished from one another in Print Preview by
Q2) Indicates editing mode.
A)(?)
B)Themes
C)Design view
D)control layout
E)Report Wizard
F)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)!
Q3) To design a form using the Form Wizard,begin by clicking on the ____ tab on the Access Ribbon.
A)HOME
B)CREATE
C)FILE
D)EDIT
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Introduction to Cloud Computing and Office 365
Available Study Resources on Quizplus for this Chatper
36 Verified Questions
36 Flashcards
Source URL: https://quizplus.com/quiz/28366
Sample Questions
Q1) When you are working on your own computer,you will need to sign out of your Microsoft account with significant frequency.
A)True
B)False
Q2) People store files in the ____ so they can access them from any device that has Internet access.
A)flash drive
B)hard drive
C)thumb drive
D)cloud
Q3) If you are signed into a Microsoft account and need to sign into another one,click ____ on the list arrow next to Your Name in the top-right corner of the Word window.
A)Sign into another account
B)Switch account
C)New account
D)Different user
Q4) Describe what happens when you open a file in OneDrive from a browser.
Q5) Describe the differences between Office 365 and Office Online.
Q6) How is OneDrive like having a personal hard drive in the cloud?
7
To view all questions and flashcards with answers, click on the resource link above.
Chapter 6: Essential Computer Concepts
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28367
Sample Questions
Q1) Software can be divided into two major categories: ____ and ____.
A)Microsoft, Apple
B)read-only, rewritable
C)system, application
D)license-ware, free-ware
Q2) Harvey has started a new consulting business,and wants to outfit his new Windows 10 computer with a wide array of software to help him perform the tasks he needs.Harvey is in the market for ____ software.
A)beta
B)system
C)application
D)utility
Q3) Any USB device can use any USB port,and for most devices power is supplied via the port so there is no need for extra power cables.
A)True
B)False
Q4) A(n)____________________ is a display that while showing you the output,allows you to touch it with your finger or a stylus to input commands.
Q5) The term GB stands for ____________________.
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Getting Started With Excel
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28368
Sample Questions
Q1) Multiplication before addition
A)function
B)Name box
C)worksheet
D)range
E)order of operations
F)sheet tabs
G)Ctrl
H)Normal view
I)minimize button
J)template
Q2) The name of the active workbook appears in the status bar of the Excel window._________________________
A)True
B)False
Q3) An Excel formula always begins with a(n)____.
A)parentheses
B)equals sign
C)plus sign
D)colon
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Formatting Workbook Text and Data
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28369
Sample Questions
Q1) To avoid splitting a worksheet in awkward places,you can insert a _____ to specify a specific breaking point.
A)page insert
B)manual page break
C)print area
D)selection
Q2) If you want to print only part of a worksheet,you can set a print area,which is the region of the worksheet that is sent to the printer._________________________
A)True
B)False
Q3) A footer appears at the top of each printed page._________________________
A)True
B)False
Q4) One way to ensure that you are using consistent formats is to copy and paste your formats using the Format _____.
A)Master
B)Gallery
C)Palette
D)Painter
Page 10
To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Performing Calculations With Formulas and Functions
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28370
Sample Questions
Q1) TODAY is an example of a(n)____________________ function.
Q2) A(n)____________________ function is a function that works with statements that are either true or false.
Q3) Use ____ references when you want different formulas to refer to the same cell.
A)mixed
B)relative
C)absolute
D)fixed
Q4) The ____ function returns the maximum value in the range.
A)TOP
B)FIRST
C)MAX
D)MOST
Q5) An error value begins with a pound sign (#)followed by an error name that indicates the type of error._______________
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 11
Q6) Some cell references are called ____________________ references because they are always interpreted in relation to the location of the cell containing the formula.
Chapter 10: Analyzing and Charting Financial Data
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28371
Sample Questions
Q1) Interest is the amount of money being loaned.___________
A)True
B)False
Q2) ____ is the amount added to the prinicpal of a loan by the lender.
A)Rate
B)Simple
C)Interest
D)Maximum
Q3) Mya needs to call attention to one category above all others.For this purpose,she should use a(n)____.
A)line chart
B)exploded pie chart
C)scatter chart
D)banded chart
Q4) Line charts are best suited for representing data that follows some nonsequential order.___________
A)True
B)False
Q5) An _______ chart takes up less space than a chart sheet.
Q6) Each value from a data series is represented by a ________.
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 11: Internet Basics and Information Literacy
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28372
Sample Questions
Q1) MLA stands for ____________________ Association.
Q2) Using a web browser,you type the URL you would like to visit into the ____.
A)Status bar
B)browser body
C)hyperlink bar
D)Address bar
Q3) ____________________ a webpage to the taskbar allows you to open the webpage directly from the desktop without first opening Microsoft Edge.
Q4) In the US,intellectual ____ is protected through patents,trademarks,trade secrets,and copyrights.
A)coercion
B)property
C)freedom
D)simulation
Q5) An HTTP identifies where a webpage is located on the Internet.
A)True
B)False
Q6) By default,the entries in the History list are organized into date folders.
A)True
B)False
Page 13
To view all questions and flashcards with answers, click on the resource link above.
Chapter 12: Managing Your Files
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28373
Sample Questions
Q1) You will find the New folder button in the Customize group on the Home tab of File Explorer._________________________
A)True
B)False
Q2) Describe some of the text's best practices for determining where to save files.
Q3) 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
Q4) When you move a folder,you also move all of the files contained in the folder.
A)True
B)False
Q5) The ____________________ and ____________________ buttons are ideal when you want to move or copy files without leaving the current folder.
Q6) Level 4 of the Windows 10 file system includes a folder for your user account,such as the User folder._________________________
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 13: Creating a Presentation
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28374
Sample Questions
Q1) During your presentation,you can easily display a blank black slide by pressing the ____ key(s).
A)B
B)F3
C)F6
D)Alt+B
Q2) ____ view displays the slides so that they almost fill the screen,and a status bar appears identifying the number of the current slide and providing buttons to advance the slide show.
A)Reading
B)Slide Show
C)Handouts
D)Presenter
Q3) Click the "Return to the previous slide" and "____ to the next slide" buttons to move from slide to slide in Slide Show view.
A)Move
B)Search
C)Advance
D)Progress
To view all questions and flashcards with answers, click on the resource link above.
Page 15
Chapter 14: Adding Media and Special Effects
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28375
Sample Questions
Q1) Kyle easily adds new shapes to a timeline.He simply clicks the shape he needs in the Shapes ____.
A)library
B)vault
C)clipboard
D)gallery
Q2) When you use ____________________ rows or columns,alternating rows or columns are filled with different shading.
Q3) Click the ____________________ button to apply a selected transition to all the slides in the presentation.
Q4) When you choose the ____ compression level for videos the file will be compressed to a quality suitable for streaming over the Internet.
A)Presentation Quality
B)Internet Quality
C)Network Quality
D)ISP Quality
Q5) Animation ____________________ numbers indicate the order in which items animate during the slide show.
Q6) To make a slide transition faster,decrease the ____________________.
Page 16
To view all questions and flashcards with answers, click on the resource link above.
Chapter 15: Creating and Editing a Document
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28376
Sample Questions
Q1) To accept an AutoComplete suggestion,press the _______ key.
A)Esc
B)Shift
C)Enter
D)Ctrl
Q2) 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
Q3) Blue is the default font color and appears at the top of the Font Color gallery,with "Automatic" next to it.____________________
A)True
B)False
Q4) Line spacing determines the amount of space between lines within a(n)____________________.
Q5) The ____________________ allow you to change the way the document is displayed.
Q6) ____________________ orientation is the default orientation for Word documents.
To view all questions and flashcards with answers, click on the resource link above. Page 17
Chapter 16: Navigating and Formatting a Document
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28377
Sample Questions
Q1) After you format a document with a variety of styles,you can alter the look of the document by changing the document's ____________________.
Q2) A(n)____________________ button allows you to click once to format the selected text,and click again to remove the formatting from the selected text.
Q3) To cut selected text,you can use the keyboard command ____.
A)Ctrl+X
B)Alt+C
C)Ctrl+C
D)Alt+V
Q4) To move text with ____________________,select the text you want to move,press and hold down the mouse button,drag the text to a new location,and then release the mouse button.
Q5) One of the most useful features of a word-processing program is the ability to move text easily.
A)True
B)False
Q6) The ____________________ guidelines were designed to ensure consistency in documents so that all research papers look alike.
To view all questions and flashcards with answers, click on the resource link above. Page 18
Chapter 17: Creating Tables and a Multipage Report
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28378
Sample Questions
Q1) The term ____________________ refers to the process of rearranging information in alphabetical,numerical,or chronological order.
Q2) A(n)continuous section break inserts a page break and starts the new section on the next page._________________________
A)True
B)False
Q3) There are default tab stops every one inch on the horizontal ruler._________________________
A)True
B)False
Q4) To change the width of a selected column,drag or ____________________ the right column border.
Q5) On the Table button grid,Word indicates the size of the table by ____ at the top of the grid when dragging the pointer across a selection.
A)columns and rows
B)width and height
C)inches
D)total cells
To view all questions and flashcards with answers, click on the resource link above. Page 19
Chapter 18: Enhancing Page Layout and Design
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/28379
Sample Questions
Q1) When WordArt is selected,the DRAWING TOOLS FORMAT tab appears as the active tab
A)on the Mini toolbar
B)in the background
C)on the ribbon
D)in the WordArt dialog box
Q2) To change the text wrap setting for clip art,click the _______ button.
A)Picture border
B)Picture Styles
C)Wrap Text
D)Wrap Picture
Q3) If a document is already divided into sections,by default,the column format is applied only to the section that currently contains the insertion point.
A)True
B)False
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
Page 20
To view all questions and flashcards with answers, click on the resource link above.