Microsoft Office Applications Exam Preparation Guide
Course Introduction
This course provides a comprehensive introduction to Microsoft Office Applications, equipping students with essential skills in Word, Excel, PowerPoint, and Outlook. Through hands-on projects and practical exercises, students will learn how to create professional documents, manage spreadsheets, develop impactful presentations, and organize emails and calendars efficiently. The course emphasizes real-world applications, fostering proficiency in task automation, data analysis, and collaborative tools to enhance productivity in academic, personal, and professional settings.
Recommended Textbook Skills for Success with Office 2013 1st Edition Volume 1 by Kris Townsend
Available Study Resources on Quizplus
20 Chapters
2051 Verified Questions
2051 Flashcards
Source URL: https://quizplus.com/study-set/2707
Page 2
Chapter 1: Create Database Tables
Available Study Resources on Quizplus for this Chatper
96 Verified Questions
96 Flashcards
Source URL: https://quizplus.com/quiz/54000
Sample Questions
Q1) You can ________ data from an Excel spreadsheet into an Access table. Answer: import
Q2) The sort order and filter that a user creates in a datasheet are saved as a part of the table's design.
A)True
B)False
Answer: True
Q3) Reuse a database is an option on the Access start page.
A)True
B)False
Answer: False
Q4) When you join tables, the common fields must share the same ________. Answer: data type
Q5) A relationship where a record in one table can have many associated records in a second table is a(n) ________ relationship. Answer: one-to-many
Q6) Table Design view is a view that features table fields and their properties. A)True
B)False
Answer: True
Page 3
To view all questions and flashcards with answers, click on the resource link above.
Chapter 2: Create Select Queries
Available Study Resources on Quizplus for this Chatper
96 Verified Questions
96 Flashcards
Source URL: https://quizplus.com/quiz/54001
Sample Questions
Q1) The wildcard character, ________, matches any combination of characters. Answer: *, asterisk
Q2) The wildcard character, # (number sign), matches any single character.
A)True
B)False
Answer: False
Q3) A query's ________ is used to determine how the query should be grouped and summarized.
A) Total row
B) Show Table dialog box
C) Design view
D) Criteria row
Answer: A
Q4) When entering criteria that include wildcards, the ________ operator will automatically be entered.
A) Or
B) Like
C) And
D) =
Answer: B
Page 4
To view all questions and flashcards with answers, click on the resource link above.
Chapter 3: Create Forms
Available Study Resources on Quizplus for this Chatper
96 Verified Questions
96 Flashcards
Source URL: https://quizplus.com/quiz/54002
Sample Questions
Q1) A ________ form allows the user to add records to two tables at once.
A) one-to-many
B) many-to-many
C) some-to-some
D) some-to-one
Answer: A
Q2) Controls such as logos and titles can be added to forms.
A)True
B)False
Answer: True
Q3) In a one-to-many form, the main form displays in Single Form view, and the related records display in a subform in ________ view.
A) Design
B) Layout
C) Double Form
D) Datasheet
Answer: D
Q4) Forms created with the Form Tool use a(n) ________ layout.
Answer: tabular
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Create Reports
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/54003
Sample Questions
Q1) You CANNOT adjust the width of more than one control at a time.
A)True
B)False
Q2) The Query Wizard button is found in the ________ group under the Create tab.
A) Templates
B) Queries
C) Tables
D) Reports
Q3) Fields that contain dates can be grouped by days, months, quarters, and years.
A)True
B)False
Q4) Reports can be created quickly by selecting a table or query in the Navigation Pane, and then clicking the Report button.
A)True
B)False
Q5) The ________ command removes all filters from a report.
Q6) Each manufacturer uses a product ________ to identify its label sheets.
Q7) The ________ can be used to copy all the formatting from one control to other controls.
Q8) Only a subset of data appears when you ________ a report.
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Common Features of Office 2013
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/54004
Sample Questions
Q1) After a document is saved, the name of the files displays on the ________.
Q2) When you click the Save button from the Quick Access Toolbar, the ________ page displays.
A) Save As
B) Open
C) File
D) Save
Q3) In Excel, boxes formed by the intersection of a row and column are called ________.
Q4) Templates for Office applications can be opened from the ________.
Q5) A(n) ________ is a set of characters with the same design and shape.
A) font
B) indent
C) paragraph
D) textbox
Q6) In Excel, a selected cell is indicated by a thick, dark-green ________.
Q7) One way to edit text is to place the insertion point where text will be inserted.
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 Computer Concepts
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/54005
Sample Questions
Q1) An intranet is a website that only employees can access.
A)True
B)False
Q2) Apple iOS is a mobile operating system designed for iPhones and iPads.
A)True
B)False
Q3) When you save a document to The Cloud, it is uploaded to a ________.
A) server
B) DVD
C) card reader
D) port
Q4) You CANNOT password protect shared files.
A)True
B)False
Q5) In a Windows file system, a hard disk drive is commonly assigned the drive letter E. A)True
B)False
Q6) If you want to project text and graphics on a screen for an audience to view, it is best to use a(n) ________.
Page 8
To view all questions and flashcards with answers, click on the resource link above.
Chapter 7: Create Workbooks With Excel 2013
Available Study Resources on Quizplus for this Chatper
114 Verified Questions
114 Flashcards
Source URL: https://quizplus.com/quiz/54006
Sample Questions
Q1) Placing content in a cell can be done by pressing the Enter key or by clicking the
A) Cancel button
B) Enter button
C) Esc key
D) column header
Q2) The letter D in the cell address D5 refers to ________.
Q3) What is the address of the cell in the upper leftmost corner of a worksheet?
Q4) Options to insert a field (e.g., a filename) into a header or footer are in the ________ group of the Design contextual tab.
A) Header & Footer
B) Header & Footer Elements
C) Navigation
D) Options
Q5) Placeholders for predefined headers and footers begin with ________.
A) &
B) #
C) @
D) $
Q6) Formula AutoComplete displays a list of ________ names.
Page 9
To view all questions and flashcards with answers, click on the resource link above.
Chapter 8: Insert Summary Functions and Create Charts
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/54007
Sample Questions
Q1) The ________, the line that borders the chart plot border area, is used as a frame of reference for measurement.
A) chart border
B) gridline
C) category border
D) axis
Q2) The labels and data series of a chart are linked to the worksheet cells referred to as the ________.
Q3) Press the ________ key to close the range finder.
Q4) Press the ________ key to insert text from a Chart Title or Axis Title placeholder into the formula bar.
Q5) Rows and columns of totals are usually included in a column chart.
A)True
B)False
Q6) Bar chart
A)Displays part-whole relationship
B)Emphasizes magnitude of change over time
C)Illustrates comparisons of individual items
D)Illustrates change in data over time
E)Illustrates trends over time
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Manage Multiple Worksheets
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/54008
Sample Questions
Q1) The ________ option stops a worksheet tab from being displayed at the bottom of a workbook.
Q2) Hide
A)Groups selected worksheets.
B)Makes worksheet invisible
C)Inserts worksheet and is located to right of sheet tabs
D)Relocates worksheet tab in tab row
Q3) Worksheet tabs CANNOT be added to a worksheet.
A)True
B)False
Q4) Cell content and formatting can be copied from one worksheet in a workbook to another worksheet in the workbook.
A)True
B)False
Q5) When it is not clear which chart type is best for the selected data, select ________ from the Charts group on the Insert tab.
Q6) Content of a cell can be cleared by pressing the ________ key when the cell is active.
Q7) A gradient color on a worksheet tab indicates that the worksheet is ________.
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: More Functions and Excel Tables
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/54009
Sample Questions
Q1) Converting a range of cells in a worksheet to an Excel table is done primarily to have a larger selection of styles.
A)True
B)False
Q2) Quotation marks
A)Applies a logical test to see if a specific condition is true
B)Placed around text values used as function arguments
C)Conditions specified in a logical test
D)Compares two values and returns true or false
E)Placed between function arguments
Q3) Which is NOT a Total row summary function?
A) SUM
B) AVERAGE
C) TODAY
D) COUNT
Q4) The ________ is the first argument of the function IF.
Q5) Only text values can be rotated and angled.
A)True
B)False
Q6) When the Filter button is clicked, the ________ displays filter options.
Page 12
To view all questions and flashcards with answers, click on the resource link above.
Chapter 11: Browse With Internet Explorer
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/54010
Sample Questions
Q1) Clicking a site logo usually takes you to the site's home page.
A)True
B)False
Q2) ________ is a feature used to open multiple web pages in the same browser window.
Q3) A site index is sometimes called a(n) ________.
Q4) When you want to delete all your temporary Internet files and cookies, clear the ________ check box.
A) Preserve Favorites website data
B) Form data
C) History
D) Passwords
Q5) You can view thumbnails of open tabs using the taskbar.
A)True
B)False
Q6) When privacy is set to ________, only sites you allow can write cookies.
Q7) On the History tab, open any page in your history list by clicking its URL.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 13
Q8) When you point to a hyperlink, the mouse pointer changes to a(n) ________.
Chapter 12: Getting Started With Powerpoint 2013
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/54011
Sample Questions
Q1) The Snipping Tool is an application used to create screenshots called ________.
Q2) ________ are miniature images of the presentation slides.
Q3) Slide Sorter view can be used to reorganize a presentation.
A)True
B)False
Q4) The number of slide layouts is NOT the same for each slide design.
A)True
B)False
Q5) The ________ displays when you start PowerPoint 2013.
Q6) The keyboard shortcut ________ inserts a new slide into a presentation.
Q7) In the Replace dialog box, the Find what box is where you type the text you want to replace the previous text.
A)True
B)False
Q8) The lower half of Notes pages for any slides that do not contain notes remains ________.
Q9) PowerPoint includes several predefined ________ used to arrange slide elements.
Q10) Select a group of sequential slides using ________.
Q11) The ________ indicates the relative location in the presentation of the slide being viewed. Page 14
To view all questions and flashcards with answers, click on the resource link above.
Page 15
Chapter 13: Format a Presentation
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/54012
Sample Questions
Q1) Remove a placeholder by clicking the ________ and then pressing Delete.
Q2) The ________ option from the list that appears after clicking the Character Spacing button moves selected text characters closer together.
A) Condensed
B) Normal
C) Very Tight
D) Loose
Q3) After adding a picture as a background, slide text will always be easier to read due to the contrast between the font and the background image.
A)True
B)False
Q4) Background graphics can be hidden.
A)True
B)False
Q5) The background color of a blank presentation is white.
A)True
B)False
Q6) Command that removes a selection and places it in the Clipboard
Q7) Type a title in the ________.
Page 16
To view all questions and flashcards with answers, click on the resource link above.
Chapter 14: Enhance Presentations With Graphics
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/54013
Sample Questions
Q1) Click the Color button in the ________ group on the Format tab to change the video color back to the original.
A) Arrange
B) Preview
C) Adjust
D) Video Styles
Q2) A(n) ________ encloses the objects in a group as one unit.
A) solid border
B) set of sizing handles
C) moving marquee
D) dotted border
Q3) A(n) ________ box is an object used to position text on a slide.
Q4) Picture ________ are picture styles that include reflections, soft edges, and bevels.
Q5) ________ are lines that display on the ruler to give a visual indication of where the pointer is positioned.
A) Gridlines
B) Markers
C) Guides
D) Indents
To view all questions and flashcards with answers, click on the resource link above. Page 17
Chapter 15: Present Data Using Tables, Charts, and Animation
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/54014
Sample Questions
Q1) Category labels identify the categories of data in a chart.
A)True
B)False
Q2) The row headings displayed in the worksheet used to create a chart in PowerPoint will display along the bottom of the chart as ________.
A) category labels
B) data labels
C) axis titles
D) gridlines
Q3) Live ________ displays the table with the selected style.
Q4) The eyedropper allows you to match a color from any object or image and apply that color to another area.
A)True
B)False
Q5) On Click begins the animation sequence immediately after the completion of the previous animation.
A)True
B)False
Page 18
Q6) A(n) ________ chart is used to illustrate proportions.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 16: Getting Started With Windows 8
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/54015
Sample Questions
Q1) When you delete a file from your hard disk, it is moved to the ________.
A) My Documents folder
B) Ribbon
C) Library
D) Recycle Bin
Q2) A snip file can be shared.
A)True
B)False
Q3) On a touch display, you can open an app by ________ once with your finger.
Q4) When the Recycle Bin becomes full, it permanently deletes the ________ files.
A) newest
B) largest
C) oldest
D) smallest
Q5) When you copy and paste a folder, any ________ in the folder are included.
Q6) You CANNOT sign in to your PC using a picture password in Windows 8.
A)True
B)False
Q7) Before you work with Windows 8, you need to ________.
Q8) The ________ contains commands named Save and Undo.
To view all questions and flashcards with answers, click on the resource link above. Page 19
Chapter 17: Create Letters and Memos
Available Study Resources on Quizplus for this Chatper
114 Verified Questions
114 Flashcards
Source URL: https://quizplus.com/quiz/54016
Sample Questions
Q1) When multiple pages are displayed by zooming in, best fit is calculated based on
Q2) Which formatting option is used to apply a set of decorative features to characters?
A) Text Effects
B) Highlight Color
C) Font Color
D) Font
Q3) Clicking icon in the lower right corner of a Ribbon group
A)Mini toolbar appears
B)Dialog box appears
C)Formatting marks appear
D)Paste Options button appears
E)Shortcut menu appears
Q4) To apply a group of formatting settings to multiple nonconsecutive sections of text in a document, ________ the Format Painter button.
A) single-click
B) double-click
C) triple-click
D) right-click
To view all questions and flashcards with answers, click on the resource link above. Page 20
Chapter 18: Create Business Reports
Available Study Resources on Quizplus for this Chatper
114 Verified Questions
114 Flashcards
Source URL: https://quizplus.com/quiz/54017
Sample Questions
Q1) An option inserted into a document header or footer from the Quick Parts list is a(n)
Q2) In list of recipe ingredients would appear in a(n) ________.
Q3) In a report, the font for a footnote number is typically ________ than the font for the text.
Q4) The style guidelines for a report should be consulted before a bullet character or number format is selected for a list.
A)True
B)False
Q5) Header and footer areas are automatically activated when page numbers are inserted through the Page Numbering option in the Header & Footer group. A)True
B)False
Q6) A View option assists a Word user in moving through a document and in quickly location text is the ________.
Q7) The Insert Footnote button is in the Footnote group of the ________ tab.
Q8) The Increase Indent button is in the ________ group on the Home tab
To view all questions and flashcards with answers, click on the resource link above. Page 21
Q9) A(n) ________ is a note or comment placed at the end of a section or a document.
Chapter 19: Create Flyers
Available Study Resources on Quizplus for this Chatper
107 Verified Questions
107 Flashcards
Source URL: https://quizplus.com/quiz/54018
Sample Questions
Q1) Table features such as row height, column width, and vertical alignment of cell content are in the ________ dialog box.
Q2) Sizing handles appear as squares or circles on the border of an image.
A)True
B)False
Q3) Options for inserting and deleting columns and rows in a table are on the Table Tools contextual ________ tab.
A) Insert
B) Page Layout
C) Design
D) Layout
Q4) Numbers entered in a table cell are usually aligned ________.
Q5) A(n) ________ can be used to improve layout and summarize data.
Q6) The ________ align option positions text an equal distance from the left and right margins of a document.
A) Left
B) Center
C) Right
D) Justify
To view all questions and flashcards with answers, click on the resource link above. Page 22
Chapter 20: Create Newsletters and Mail Merge Documents
Available Study Resources on Quizplus for this Chatper
106 Verified Questions
106 Flashcards
Source URL: https://quizplus.com/quiz/54019
Sample Questions
Q1) A(n) ________ break forces text that appears after the break to flow into the next column.
Q2) Main document
A)Document section that can be formatted differently from rest of document
B)Extra details or hooks at the end of each stroke in a character
C)Font in which characters lack extra details or hooks at the end of each stroke
D)A mark indicating the end of one section and the beginning of another
E)Aligns text with left margin and right margin
Q3) When a SmartArt graphic is selected, the Design and Layout contextual tabs appear on the Ribbon.
A)True
B)False
Q4) Clip Art images are inserted by clicking the ________ button in the Illustrations group of the Insert tab.
A) Picture
B) Online Pictures
C) SmartArt
D) Screenshots
Q5) When labels are mail-merged, the merged document displays the labels in a(n)
To view all questions and flashcards with answers, click on the resource link above.