Office Productivity Tools
Exam Materials
Course Introduction
Office Productivity Tools introduces students to essential software applications that streamline and enhance workplace efficiency. The course covers word processing, spreadsheet management, presentation creation, and email communication, with hands-on practice using industry-standard programs such as Microsoft Office or Google Workspace. Students will learn to create, format, and manage documents, analyze and visualize data, design impactful presentations, and collaborate effectively in digital environments. By mastering these tools, students develop critical skills for academic, professional, and personal productivity.
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) The specific content of a field is referred to as the ____.
A)field content
B)field value
C)table value
D)column value
Answer: B
Q2) All of the data in a relational database are contained in ____________________.
Answer: tables
Q3) Which Access database object asks a question about the data stored in a database and displays specific fields and records that answer the question?
A)form
B)table
C)query
D)report
Answer: C
Q4) It is possible to view all Access objects in the Navigation Pane._________________________
A)True
B)False
Answer: True
Page 3
To view all questions and flashcards with answers, click on the resource link above.
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 record in a table that is related to a primary table but has no matching record established with the primary table.
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: G
Q2) ____________________ values are never allowed by Access in the primary key field.
Answer: Duplicate
Q3) In a single table,all ____________________ must be unique within that table.
Answer: field names
Q4) The "one" table in a one-to-many relationship is the ____________________ table.
Answer: primary
To view all questions and flashcards with answers, click on the resource link above. Page 4
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) The ascending sort order for the Date/Time data type sorts dates from ____________________.
Answer: oldest to most recent date
Q2) When a question is asked of a database using a select query,the answer is returned as a data sheet.____________________
A)True
B)False
Answer: True
Q3) The query type that gives Access an example of the information being requested and retrieves information based precisely on matching the example is which type of query?
A)crosstab
B)append
C)query by example (QBE)
D)update
Answer: C
Q4) A set of restrictions placed on records in an open datasheet or form that temporarily isolates a subset of the records is called a ____________________. Answer: filter
To view all questions and flashcards with answers, click on the resource link above. Page 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) Discuss three considerations that are important to form design for the form to convey written information clearly and effectively.
Q2) When using the Report Wizard,the report title entered in the Wizard is also the name of the report ____________________.
Q3) Design changes cannot be made to a form in Form view.____________________
A)True
B)False
Q4) In addition to standard colors,the font color gallery displays ____ colors.
A)Pantone
B)graphic
C)theme
D)print
Q5) Before applying a conditional format in a report,the ____ box must be selected.
A)field label
B)caption
C)field value
D)design
Q6) A report formatted in _____________________ is wider than it is tall.
To view all questions and flashcards with answers, click on the resource link above. Page 6
Q7) A report layout may be changed using options on the ____________________ tab.
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) Cloud pricing structure is a ____-based model.
A)flat
B)box
C)subscription
D)pay-as-you-go
Q2) How is OneDrive like having a personal hard drive in the cloud?
Q3) Discuss how to coauthor documents using OneDrive.
Q4) From ____,you can open a document in the full Office application if the application is installed on the computer you are using.
A)OneDrive
B)Outlook.com
C)Microsoft.com
D)All of the above
Q5) Word Online has as many features as the full version of Word._________________________
A)True
B)False
Q6) Describe the differences between Office 365 and Office Online.
Q7) A Microsoft account consists of a(n)____________________ and a password.
Q8) Describe what happens when you open a file in OneDrive from a browser.
To view all questions and flashcards with answers, click on the resource link above. Page 7
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) A ____ connects devices on a network so all the devices can access network components.
A)router
B)trafficker
C)token
D)peer
Q2) Worms and Trojan horses are specific types of firewalls._________________________
A)True
B)False
Q3) The term cloud computing means that data,applications,and even resources are stored on servers accessed over the Internet rather than on users' computers._________________________
A)True
B)False
Q4) Application software helps the computer user perform specific tasks,such as document production or database management._________________________
A)True
B)False
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) To change the order of operations,enclose part of the formula in ____.
A)brackets
B)italics
C)parentheses
D)quotation marks
Q2) A preformatted workbook with many design features and some content already filled in.
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
Q3) The worksheet is organized into individual cells._________________________
A)True
B)False
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) Formatting changes only the appearance of data-it does not affect the data itself._________________________
A)True
B)False
Q2) In a workbook's theme,_____ colors are designated for text and background,_____ colors are used for accents and highlights,and _____ colors are used for hyperlinks.
A)Four, two, six
B)Two, four, six
C)Four, six, two
D)Six, four, two
Q3) A(n)____________________ is a collection of formatting that specifies the fonts,colors,and graphical effects used throughout the workbook.
Q4) _____ are an example of conditional formats in Excel.
A)Data bars
B)Quick Analysis tools
C)Font sets
D)Percentages
Q5) Explain how to use conditional formatting effectively.
To view all questions and flashcards with answers, click on the resource link above. Page 10
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) Excel functions are organized into ____ categories.
A)8
B)10
C)11
D)13
Q2) A mixed reference "locks" one part of the cell reference while the other part can change._______________
A)True
B)False
Q3) In the formula =IF(A1=B1,C1,C2),the result will be C2 if ____.
A)A is equal to B
B)A does not equal B
C)A1+B1 is equal to C1
D)A1>B1 is equal to C2
Q4) The ____ category of Excel functions returns (true-false)values.
A)Information
B)Statistical
C)Logical
D)Math & Trig
Q5) The ____________________ is the middle value from a sample.
To view all questions and flashcards with answers, click on the resource link above. Page 11
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) Line charts are best suited for representing data that follows some nonsequential order.___________
A)True
B)False
Q2) Each data source is a collection of ____________________,which is a range of values plotted as a single unit on a chart.
Q3) To resize an embedded chart,____.
A)select the chart and drag the corner sizing handle of the selection box
B)right click the chart and then click Resize on the shortcut menu
C)select the chart and press Tab
D)both a and b
Q4) The goal of a ______ is to convey the maximum amount of information within a very small space.
Q5) The ____ CHART TOOLS contextual tabs appear on the Ribbon when you select a chart.
A)INSERT and DESIGN
B)DESIGN and FORMAT
C)INSERT and FORMAT
D)FORMAT and PRINT
Q6) An _______ chart takes up less space than a chart sheet.
Page 12
To view all questions and flashcards with answers, click on the resource link above.
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) The term intellectual property refers to all creations of the human mind.
A)True
B)False
Q2) a common protocol on the Internet
A)thumbnail
B)FTP
C)citation
D)tabs
E)webpage
F)search query
G)favorite
H)tangible expression
I)web server
J)home page
K)hyperlink
L)hub
Q3) Popular search engines including Google,Bing,and Yahoo!
A)True
B)False
Q4) MLA stands for ____________________ Association.
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) The non-icon views available in File Explorer include ____________________,Details,Tiles,and Content.
Q2) When you delete a folder or file from the hard disk,it is permanently deleted immediately,and unrecoverable.
A)True
B)False
Q3) File Explorer displays the current file path in the ____ so you can keep track of your current location as you navigate.
A)status bar
B)reading pane
C)address bar
D)ribbon
Q4) A file ____ includes the three or four characters that follow the dot in the filename and identify the file's type.
A)tag
B)extension
C)hook
D)delimiter
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
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) When you select an existing list and then click the Convert to SmartArt Graphic button in the Paragraph group on the ____________________ tab,a gallery of SmartArt layouts appears.
Q2) If you don't choose a theme,the default ____ theme is applied.
A)blank
B)Office
C)corporate
D)primary colors
Q3) You can use the buttons in the Presentation Views group on the ________________ tab to switch views.
Q4) A textbox is a region of a slide reserved for inserting text or graphics.
A)True
B)False
Q5) A second-level item in a list is sometimes called a subitem.
A)True
B)False
Q6) To copy selected text or objects,you use the Copy button in the ____________________ group on the HOME tab.
Q7) In ____________________ view,each slide fills the screen,one after another.
Page 15
To view all questions and flashcards with answers, click on the resource link above.
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) The PICTURE TOOLS STYLES tab appears when a picture is selected._________________________
A)True
B)False
Q2) If you animate a list,the default is for the first-level items to appear ____.
A)one at a time
B)two at a time
C)all at one time
D)one word at a time
Q3) When you choose the ____ compression level for videos the file will be compressed slightly and will maintain the quality of the videos.
A)Presentation Quality
B)Internet Quality
C)Television Quality
D)Digital Quality
Q4) You would click the Transition Sound arrow in the Timing group to insert a sound effect to accompany each transition.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 16
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) Which of the following errors will AutoCorrect catch?
A)"red" for "read"
B)"your" for "you're"
C)"teh" for "the"
D)"their" for "there"
Q2) Before typing a document,you should make sure nonprinting characters are displayed..____________________
A)True
B)False
Q3) The grammar checker marks grammatical errors with a wavy red line.
A)True
B)False
Q4) A(n)_______ is a window that helps you navigate through a complex feature.
A)task pane
B)landscape
C)portrait
D)manager
Q5) To work with a photo or other type of picture in a document,you first need to ____________________ it.
Q6) Discuss the use of color and special effects in formal documents.
Page 17
To view all questions and flashcards with answers, click on the resource link above.
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) The First Line Indent marker looks like the top half of a(n)____________________.
Q3) 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
Q4) 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
Q5) You can copy selected text by pressing Ctrl + C. A)True
B)False
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) To create SmartArt,switch to the INSERT tab and use a button in the ____ group.
A)Illustrations
B)Art
C)Graphics
D)Draw
Q2) Josephine's boss likes her table,but has asked that she also include each team member's home office number.What's the best way for Josephine to go about adding this information?
A)Press the Tab key at the end of the last row.
B)Click the Select button in the Table group, then press Delete.
C)Click the Add Column button at the top of the column border.
D)Delete the current table and insert a new table with the correct number of columns and rows.
Q3) The best way for Josephine to organize her data in Microsoft Word would be to use
A)a chart
B)a table
C)multiple text boxes
D)the shapes function
Q4) To sort a column in reverse order,click the ____________________ option button.
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) Desktop publishing is the process of preparing commercial-quality printed material.
A)True
B)False
Q2) To view the exact dimensions of a selected clip art graphic,click the _______ tab to access the Shape Height and Shape Width boxes.
A)PICTURE SIZE
B)PICTURE TOOLS FORMAT
C)FORMAT GRAPHIC
D)OBJECT FORMATTING
Q3) WordArt is considered a(n)_______ that can be manipulated independently of the text.
A)element
B)baseline
C)object
D)index
Q4) The drop cap will extend three lines into the paragraph by default.
A)True
B)False
Q5) A(n)____________________ object is attached,or anchored,to a specific paragraph.
To view all questions and flashcards with answers, click on the resource link above. Page 20