Office Productivity Tools
Mock Exam
Course Introduction
This course provides an in-depth introduction to essential office productivity tools widely used in both academic and professional environments. Students will gain practical experience with word processing, spreadsheet, and presentation software, learning how to create, edit, and manage documents, analyze and visualize data, and design effective presentations. Emphasis is placed on developing skills that increase efficiency, accuracy, and collaboration in workplace tasks, including document formatting, data organization, chart creation, and cloud-based sharing. By the end of the course, students will be able to confidently utilize office tools to streamline workflows and contribute to team productivity.
Recommended Textbook
New Perspectives on Microsoft Office 2013 First Course 1st Edition by Ann Shaffer
Available Study Resources on Quizplus
20 Chapters
1948 Verified Questions
1948 Flashcards
Source URL: https://quizplus.com/study-set/1957 Page 2
Chapter 1: Creating a Database
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/38989
Sample Questions
Q1) A table is a predesigned database that includes professionally designed database objects.
A)True
B)False
Answer: False
Q2) The ____________________ box in the Navigation Pane (displayed in the accompaying figure) allows the Access user to search for all database objects that contain a specific value, such as the city, "Albany."
Answer: Search
Q3) The default sort order for records in an Access table is based on the values in the <u>primary key</u> field. _________________________
A)True
B)False
Answer: True
Q4) Records in separate tables may be connected through a(n) ____________________ that appears in both tables.
Answer: common field
Q5) All of the data in a relational database are contained in ____________________.
Answer: tables
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
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/38990
Sample Questions
Q1) Access does not require a table to have a(n) <u>primary key</u>.
A)True
B)False
Answer: True
Q2) In the accompanying figure, fields inserted into the table using the Address Quick Start fields will be inserted prior to the ____ field.
A) Phone
B) Email
C) Fax
D) PatientID
Answer: B
Q3) In the accompanying figure, the <u>default value property</u> for the State field is "CT". _________________________
A)True
B)False
Answer: True
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
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/38991
Sample Questions
Q1) Access queries provide several capabilities that allow data analysis and manipulation using tables and other Access database objects. List five capabilities that allow for data analysis and manipulation in Access.
Answer: Display selected fields and records from a table
Sort records
Perform calculations
Generate data for forms, reports, and other queries
Update data in the tables in a database
Find and display data from two or more tables
Q2) The ascending sort order for the Date/Time data type sorts dates from ____________________.
Answer: oldest to most recent date
Q3) To use an existing query as the basis for a new query, it is necessary to ____ the query before designing the new query.
A) modify
B) rename
C) delete the existing query
D) include comparison operators
Answer: B
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
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/38992
Sample Questions
Q1) The Report Wizard window makes this option available to display tips for creating reports.
A)(?)
B)Themes
C)Design view
D)control layout
E)Report Wizard
F)Show me more information
G)Find
H)Layout view
I)shading
J)#
Q2) In the accompanying figure, the icons and titles shown in bracket number 2 represent the ____ Access database object.
A) Form
B) Query
C) Report
D) Table
Q3) The default theme for a new form that is created is the ____________________ theme.
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Essential Computer Concepts
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/38993
Sample Questions
Q1) The term GB stands for ____________________.
Q2) Harvey is in the market for ____ software.
A) beta
B) system
C) application
D) utility
Q3) Spreadsheet software creates a ____, composed of a grid of columns and rows.
A) presentation
B) worksheet
C) record
D) document
Q4) ____ means that data, applications, and even resources are stored on servers accessed over the Internet rather than on users' computers.
A) Apping
B) i-Computing
C) Cloud computing
D) Hyperlinking
Q5) Flash memory is similar to ROM except that it can be written to more than once.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Getting Started With Excel
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/38994
Sample Questions
Q1) Two common ____________________ changes are adding borders to cells and changing the font size of text.
Q2) To change a column width, you can click ____ on the Column submenu to make the column(s) as wide as the longest entry of the cells in the column.
A) QuickFit
B) AutoFit
C) Full Column
D) Longest
Q3) In the figure above, Box 1 points to the formula =F13*G13 in the ____.
A) address box
B) address bar
C) formula box
D) formula bar
Q4) In the above figure, which box displays the formula in the formula bar?
A) 1
B) 2
C) 5
D) 6
Q5) Changing the page orientation affects only the ____________________ sheet.
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Formatting Workbook Text and Data
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/38995
Sample Questions
Q1) As a general rule, you should _____.
A) center column titles, left-align text, and right-align numbers
B) center column titles, right-align text, and left-align numbers
C) right-align column titles, left-align text, and right-align numbers
D) left-align column titles, left-align text, and right-align numbers
Q2) A _____ indicates a manual page break.
A) dashed blue line
B) solid blue line
C) dashed red line
D) solid red line
Q3) The appearance of non-theme fonts, colors, and effects remains unchanged no matter which theme is applied to the workbook.
A)True
B)False
Q4) Explain why it is important to use proper formatting, citing at least three benefits of a well-formatted workbook.
Q5) One of the benefits of conditional ____________________ is that it helps you analyze data by highlighting significant trends in data.
Q6) A(n) ____________________ is text printed in the top margin of each page.
Page 9
To view all questions and flashcards with answers, click on the resource link above.
Chapter 8: Calculating Data With Formulas and Functions
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/38996
Sample Questions
Q1) ____________________ automates the trial-and-error process by allowing you to specify a value for a calculated item, which Excel uses to determine the input value needed to reach that goal.
Q2) When you nest functions, you should have ____.
A) the equal sign
B) the same number of left and right parentheses
C) at least two functions
D) the correct number of brackets
Q3) Ellen opens Excel 2013 and enters her monthly income for one year beginning with January. To create a series of months, she can ____.
A) Type = Jan-Dec in cell A1 and then press Enter.
B) Type January in cell A1 and then drag the filll handle.
C) Type =YEAR in cell A1 and then press Enter.
D) Type =DATE(Jan, Dec) in cell A1 and then press Enter.
Q4) ____________________ is an Excel function category that returns information about the format, location, or contents of worksheet cells.
Q5) The small black plus sign in the lower-right corner of a selected cell or range is called the ____________________.
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Analyzing and Charting Financial Data
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/38997
Sample Questions
Q1) The PMT function calculates the payment required in each period to pay back the loan.
A)True
B)False
Q2) 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
Q3) Sometimes Mya might want to see information on only specific slices. Rather than creating a new chart that includes only those selections, she can _____ an existing chart.
A) search
B) filter
C) find
D) examine
Q4) Consider the impact of a poorly designed chart. Explain why it is important to have a well-designed chart, and name at least four tips for creating a good chart.
Q5) An _______ chart takes up less space than a chart sheet.
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Exploring the Basics of Windows 8
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/38998
Sample Questions
Q1) Program that runs in full-screen and provides an uncluttered space for performing tasks
A)controls
B)snapping
C)window
D)ScreenTip
E)app
F)Files
G)background
H)Charms bar
I)desktop application
J)Switch List
Q2) The Switch List includes thumbnails for ____.
A) apps only
B) desktop applications only
C) both apps and desktop applications
D) neither apps nor desktop applications
Q3) In the accompanying figure, the box marked B points to the scroll bar.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 11: Integrating Word, Excel, Access, and Powerpoint
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/38999
Sample Questions
Q1) In the accompanying figure, the symbol denoted by box A is ____.
A) a nonprinting character
B) a merge field
C) an embedded icon
D) a section break
Q2) ____ fields contain instructions for replacing these field placeholders with the variable information from a data source.
A) Embedded
B) Merge
C) Query
D) Tapped
Q3) To update a linked table in Excel, the first steps are to right-click the table in the document, point to ____________________ on the shortcut menu, then click Edit Link.
Q4) You can export an Access query to ____.
A) an Excel worksheet only
B) a Word document only
C) either a Word document or an Excel worksheet
D) nothing; you can only export Access tables
Q5) The item labeled B in the accompanying figure denotes the ____________________.
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 12: Internet Basics and Information Literacy
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/39000
Sample Questions
Q1) A(n) ____________________ is a unique string of letters/numbers that make a web address easier to remember.
Q2) Clicking the item denoted by box ____ in the accompanying figure provides tools for viewing a history list of previously viewed webpages. A) A
B) F
C) E
D) C
Q3) The arrow denoted by box D in the accompanying figure is grayed out because ____.
A) you are currently visiting the latest webpage you have visited during your current Web session
B) the computer is not connected to the Internet
C) your History list is full
D) you only have one tab open
Q4) When you point to the Internet Explorer button on the task bar, ____________________ images (miniature pictures) of all open tabs are displayed.
Q5) MLA stands for ____________________ Association.
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 13: Introduction to Cloud Computing
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/39001
Sample Questions
Q1) People store files in the <u>cloud</u> so they can access them from any device that has Internet access. _________________________
A)True
B)False
Q2) The ability to work on Office Web App files at the same time as others is called ____.
A) multitasking
B) shared writing
C) coauthoring
D) app merging
Q3) When you search from the Start screen, the SkyDrive desktop application is named <u>SkyDrive-Desktop</u>. _________________________
A)True
B)False
Q4) The SkyDrive ____________________ comes with Windows 8.
Q5) its icon is clouds within a half-opened folder
A)Office 365 apps
B)SkyDrive desktop application
C)Apps bar
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 14: Managing Your Files
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/39002
Sample Questions
Q1) The non-icon views available in File Explorer include ____________________, Details, Tiles, and Content.
Q2) File Explorer displays the file path in the <u>Status</u> bar.
A)True
B)False
Q3) A duplicate copy of important files is known as a(n) ____________________.
Q4) File Explorer uses backslashes to separate locations in a file path.
A)True
B)False
Q5) To select many files that are listed together in the right pane of File Explorer, you click the first item, press and hold ____________________, and then click the last item.
Q6) The left pane of the File Explorer window is the ____ pane.
A) status
B) address
C) structure
D) navigation
Q7) You can open a file using File Explorer by ____________________ it in the right pane of File Explorer.
Page 16
To view all questions and flashcards with answers, click on the resource link above.
Chapter 15: Creating a Presentation
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/39003
Sample Questions
Q1) A ____ item is a main item in a list.
A) base-level
B) root
C) sub-
D) first-level
Q2) To check spelling, click the Spelling button in the ____ group of the REVIEW tab
A)Zoom in
B)smart guides
C)Compressing
D)Font
E)PICTURE TOOLS FORMAT
F)INSERT
G)Proofing
H)Clipboard
I)layout
J)FORMAT
Q3) A second-level item in a list is sometimes called a subitem.
A)True
B)False
Q4) Briefly explain how to undo and redo actions.
To view all questions and flashcards with answers, click on the resource link above. Page 17
Chapter 16: Adding Media and Special Effects
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/39004
Sample Questions
Q1) You can modify transitions in <u>Normal</u> or Slide Sorter view.
A)True
B)False
Q2) Keywords are words or phrases that describe an image.
A)True
B)False
Q3) To insert a table, in a content placeholder, click the INSERT tab on the ribbon, click the Table button in the ____ group, and then click Insert Table.
A) Data
B) Tables
C) Charts
D) Boxes
Q4) The start timing setting is on the VIDEO TOOLS PLAYBACK ____.
A) slider
B) tab
C) button
D) group
Q5) The ____________________ is the formatting of the area inside a shape.
To view all questions and flashcards with answers, click on the resource link above. Page 18
Chapter 17: Creating and Editing a Document
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/39005
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) Used to copy formatting from the selected text to other text in the document
A)Quick Access Toolbar
B)paragraph mark
C)insertion point
D)block style
E)paragraph spacing
F)margins
G)Format Painter button
H)Zoom level
I)alignment
J)nonprinting characters
Q3) With <u>center alignment</u> , text is centered between the left and right margins and is ragged along both the left and right margins. ____________________
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 19
Chapter 18: Navigating and Formatting a Document
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/39006
Sample Questions
Q1) The items listed in a bibliography are known as <u>resources</u>.
A)True
B)False
Q2) The Bullets button is located in the ____ group.
A) Styles
B) Font
C) Paragraph
D) Format
Q3) A format guide is a set of rules that describe the preferred format and style for a certain type of writing.
A)True
B)False
Q4) You can copy selected text by pressing Ctrl + C.
A)True
B)False
Q5) The ____________________ gallery is divided into Theme Colors and Standard Colors.
Q6) By default, the ____________________ gallery offers 16 styles, each designed for a specific purpose.
Page 20
To view all questions and flashcards with answers, click on the resource link above.
Chapter 19: 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/39007
Sample Questions
Q1) To ensure a smoother right margin, you can turn on automatic ____________________, in which case any word that ends within the last .25 inch of a line will be hyphenated.
Q2) Which of the following is not a panel in the Choose a SmartArt Graphic dialog box?
A) A larger image of the graphic, with an explanation of the graphic's purpose
B) A thumbnail description of the graphics in all categories
C) Categories of SmartArt Graphics
D) Graphics associated with the selected category
Q3) Which of the following is not a category in the SmartArt Graphic dialog box?
A) Relationship
B) Hierarchy
C) Protocol
D) Pyramid
Q4) A SmartArt graphic contains placeholder text that you replace with your own text.
A)True
B)False
Q5) As you drag the mouse pointer across a blank grid to insert a table, a(n) ____________________ of the table structure will appear in the document.
To view all questions and flashcards with answers, click on the resource link above. Page 21
Chapter 20: Enhancing Page Layout and Design
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/39008
Sample Questions
Q1) When you position the mouse pointer over a style in the WordArt gallery, a _______ displays some elements of the style.
A) Naming Icon
B) ScreenTip
C) Format Box
D) Table Style
Q2) To begin cropping a graphic, you click the Crop button in the Size group on the <u>GRAPHICS</u> TOOLS FORMAT tab. _________________________
A)True
B)False
Q3) With the option marked _______ in the accompanying figure, the object is layered behind the text, with the text flowing over it.
A) 3
B) 4
C) 5
D) 6
Q4) To move a graphic to one of several preset positions on the page, click the ____________________ button in the Arrange group on the PICTURE TOOLS FORMAT tab.
To view all questions and flashcards with answers, click on the resource link above. Page 22