Office Productivity Software
Solved Exam Questions
Course Introduction
This course provides students with a comprehensive introduction to office productivity software, focusing on widely-used applications such as word processors, spreadsheets, presentation tools, and databases. Through hands-on exercises and practical projects, students will develop proficiency in creating professional documents, managing data, designing impactful presentations, and utilizing collaboration features. Emphasis is placed on enhancing workplace efficiency, organizational skills, and digital communication, preparing students to effectively leverage technology in various academic and professional settings.
Recommended Textbook
Your Office Microsoft Office 2016 Volume 1 1st Edition by Amy S. Kinser
Available Study Resources on Quizplus
18 Chapters
1777 Verified Questions
1777 Flashcards
Source URL: https://quizplus.com/study-set/707
Page 2
Chapter 1: Understanding the Common Features of Microsoft Office
Available Study Resources on Quizplus for this Chatper
92 Verified Questions
92 Flashcards
Source URL: https://quizplus.com/quiz/13798
Sample Questions
Q1) Windows Hello,a new feature in the Windows 10 operating system,allows a user to log in using the ________ instead of typing a password.
A) keyboard
B) microphone
C) function keys
D) camera
Answer: D
Q2) In Windows 10,screen Tiles support ________ size options. Answer: four
Q3) ________ software is software that helps control and coordinate computer hardware.
Answer: System,Operating system
Q4) A ________ is a tool that can help guide a user through complex tasks.
A) hub
B) URL
C) wizard
D) device driver
Answer: C
Q5) ________ software is software that helps a user complete a specific task.
Answer: Application
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Explore Windows and File Management
Available Study Resources on Quizplus for this Chatper
95 Verified Questions
95 Flashcards
Source URL: https://quizplus.com/quiz/13803
Sample Questions
Q1) Microsoft designed its Office applications to create the same level of familiarity and comfort with its ribbons,features,and functions.
A)True
B)False
Answer: True
Q2) The Tell me what you want to do tool is new in Office 2016.
A)True
B)False
Answer: True
Q3) The Undo and Redo buttons are located on the Mini toolbar.
A)True
B)False
Answer: False
Q4) The file extension for a Microsoft Excel 2016 spreadsheet is ________.
A) .xlsx
B) .docx
C) .pptx
D) .accdb
Answer: A
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: Review and Modify a Document
Available Study Resources on Quizplus for this Chatper
95 Verified Questions
95 Flashcards
Source URL: https://quizplus.com/quiz/13793
Sample Questions
Q1) In written communication,________ should be avoided because the message can come across the wrong way.
A) using an active voice
B) humor
C) exclamation points
D) all lowercase letters
Answer: B
Q2) Word processing is often cited as one of the main reasons to use a computer.
A)True
B)False
Answer: True
Q3) When each character requires the same amount of space,the font's spacing is said to be ________.
Answer: monospaced
Q4) ________ is an alignment style that spreads text evenly between the right and left margins so that lines begin on the left margin and end uniformly on the right margin.
Answer: Justified
Q5) The Bodoni and Century Schoolbook typefaces are examples of ________ fonts. Answer: serif
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Create and Edit a Document
Available Study Resources on Quizplus for this Chatper
96 Verified Questions
96 Flashcards
Source URL: https://quizplus.com/quiz/13792
Sample Questions
Q1) Characters that typically do not display on the keyboard are called ________.
A) lists
B) filters
C) shortcuts
D) symbols
Q2) Clear All Formatting is located under the ________ tab.
A) Design
B) Insert
C) Review
D) Home
Q3) A ________ style can behave as either a character style or paragraph style.
A) linked
B) merged
C) character
D) paragraph
Q4) Predefined watermarks are available on the ________ tab.
A) Layout
B) Insert
C) Design
D) View
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Include Tables and Objects
Available Study Resources on Quizplus for this Chatper
94 Verified Questions
94 Flashcards
Source URL: https://quizplus.com/quiz/13791
Sample Questions
Q1) If a dashed or solid border is displayed around any of the individual shapes within a SmartArt object,the individual shape has been selected as opposed to the entire SmartArt.
A)True
B)False
Q2) ________ is used to create diagrams such as organization charts and process flows.
Q3) When text wrapping is set to ________,text will follow the shape but will not overlap it.
A) Tight
B) Square
C) Top and Bottom
D) In Line with Text
Q4) The small circles that appear on the border surrounding an object are called ________.
Q5) When text wrapping is not set to In Line with Text,a(n)________ shows the paragraph that the object is associated with.
Q6) Tab stops can be created within a cell of a table.
A)True
B)False
Page 7
To view all questions and flashcards with answers, click on the resource link above.
Chapter 6: Special Document Formatting and Mail Merge
Available Study Resources on Quizplus for this Chatper
95 Verified Questions
95 Flashcards
Source URL: https://quizplus.com/quiz/13790
Sample Questions
Q1) You can define up to ________ columns in each section or page.
A) one
B) two
C) three
D) four
Q2) When working with mail merge,the ________ mainly consists of text that will not change regardless of how many times it is duplicated
Q3) When you ________,the comment will shrink in size and become grayed out.
A) mark a comment as done
B) edit a comment
C) delete a comment
D) reply to a comment
Q4) Which of the following is NOT true about using MLA style to format a research paper?
A) The first line of each paragraph is indented.
B) Lines are single-spaced.
C) Include a right-aligned header with your last name and page number.
D) Margins are set to 1".
Q5) Once bibliography entries are changed to ________ text,the citations will need to be manually edited.
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Create, Navigate, Work With, and Print
Worksheets
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/13802
Sample Questions
Q1) In ________,the ribbon and shortcut menus are enlarged to make selecting commands with your fingertip easier.
Q2) The intersection of each row and column is called a(n)________.
Q3) The keyboard shortcut to move to cell A1 is ________.
A) Home
B) Shift + Home
C) Alt + Home
D) Ctrl + Home
Q4) A file that contains one or more worksheets is a(n)________.
Q5) A ________ is a grid of columns and rows in which data is entered.
A) database
B) presentation
C) document
D) worksheet
Q6) In Excel,date and time data are special forms of numeric data.
A)True
B)False
Q7) When collecting data in a spreadsheet,each ________ is a field in a record.
Q8) ________ data contains numbers and special characters such as the period (.)and hyphen (-). Page 9
To view all questions and flashcards with answers, click on the resource link above.
Page 10
Chapter 8: Formats, Functions, and Formulas
Available Study Resources on Quizplus for this Chatper
94 Verified Questions
94 Flashcards
Source URL: https://quizplus.com/quiz/13801
Sample Questions
Q1) In a function,arguments are included inside the parentheses following the function name.
A)True
B)False
Q2) The Accounting Number Format is formatted so the currency symbol is placed directly left of the value.
A)True
B)False
Q3) Formatting will change the value stored in a cell,as well as add information value.
A)True
B)False
Q4) +,*,and ^ are examples of Excel ________.
Q5) A(n)________ format is used to present information in charts,graphs,and pictures.
Q6) To hide gridlines,check the Gridlines box in the Show group on the View tab. A)True
B)False
Q7) Cell ________ allows cell content to be arranged horizontally as well as vertically.
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 9: Cell References, Named Ranges, and Functions
Available Study Resources on Quizplus for this Chatper
92 Verified Questions
92 Flashcards
Source URL: https://quizplus.com/quiz/13800
Sample Questions
Q1) A named range is a group of cells that have been given a name,which you can use when writing a formula or function.
A)True
B)False
Q2) The ________ function is similar to looking up a phone number in a phone book.
Q3) When using a text string in an argument,enclose the string in ________ so Excel will recognize it as a text string rather than a named range.
A) asterisks * *
B) brackets [ ]
C) parentheses ( )
D) quotes " "
Q4) An absolute cell reference is denoted by a(n)________.
A) dollar sign ($)
B) asterisk (*)
C) number sign (#)
D) at sign (@)
Q5) ________ refers to the structure and order of the function and the arguments used by Excel to perform a calculation.
Q6) The ________ logical function returns true only if one of its arguments is true.
Page 12
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10: Effective Charts
Available Study Resources on Quizplus for this Chatper
92 Verified Questions
92 Flashcards
Source URL: https://quizplus.com/quiz/13799
Sample Questions
Q1) The default display of gridlines in Excel is to display the major gridlines and hide the minor gridlines.
A)True
B)False
Q2) Any action that can be completed in the Chart Formatting Control can also be completed through the Chart Tools contextual tab.
A)True
B)False
Q3) A group of related data values to be charted is a(n)________.
A) analysis
B) data bar
C) data point
D) data series
Q4) A chart is like a picture,where a picture is worth 1,000 words.
A)True
B)False
Q5) The ________ feature analyzes your data and suggests which chart would best represent your data.
Q6) In a chart,the ________ is an index that identifies the data.
Page 13
To view all questions and flashcards with answers, click on the resource link above.
Chapter 11: The Four Main Database Objects
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/13804
Sample Questions
Q1) The bottom half of the window in a query's design view is the Query ________.
Q2) A ________ is used to ask a question of the data.
A) report
B) table
C) query
D) form
Q3) To move through the data in a table,Access provides a(n)________ at the bottom of the table.
Q4) ________ view shows how a report would look in a continuous page layout.
Q5) Which of the following is NOT true about the advantages that automated databases have over paper databases?
A) The information in an automated database is much easier to find.
B) Automated databases can be used to enforce accuracy and other quality standards.
C) The information in an automated database can be manipulated and processed more rapidly.
D) Paper databases make it easier for businesses to be competitive.
Q6) A report allows you to enter,edit,and delete data.
A)True
B)False
Page 14
To view all questions and flashcards with answers, click on the resource link above.
Chapter 12: Tables,Keys,and Relationships
Available Study Resources on Quizplus for this Chatper
92 Verified Questions
92 Flashcards
Source URL: https://quizplus.com/quiz/13805
Sample Questions
Q1) The ________ data type lists either values retrieved from a table or query or a set of values that you entered when the field was created.
Q2) If one customer can purchase many items,one-to-many is called the ________ of the relationship.
A) cardinality
B) redundancy
C) joining
D) integrity
Q3) The ________ key in one table acts as a primary key of another table.
A) numeric
B) natural
C) composite
D) foreign
Q4) In a customer table,a(n)________ field would serve as a good primary key.
A) phone number
B) customer ID
C) address
D) date of birth
Q5) In a database,________ occurs when data is repeated multiple times.
Q6) A(n)________ helps to enter data in a consistent manner.
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 13: Queries and Data Access
Available Study Resources on Quizplus for this Chatper
94 Verified Questions
94 Flashcards
Source URL: https://quizplus.com/quiz/13806
Sample Questions
Q1) ________ are the lines connecting the tables that represent relationships.
Q2) When you want to specify criteria in multiple fields,and at least one of the criteria must be true for a record to be included in the results,then the ________ logical operator is used.
A) AND
B) OR
C) NOT
D) BETWEEN
Q3) When you ________,you select a value in a record and Access filters the records that contain only the values that match what you have selected.
A) use the Find command
B) filter by selection
C) use the Replace command
D) use the Navigation bar
Q4) A(n)________ query is used when you want to describe one field in terms of two or more fields in the table.
Q5) A(n)________ query is used when you want to find the rows in one table that do not have a match in the other table.
Q6) The ________ operator matches text values by using wildcards.
Page 16
To view all questions and flashcards with answers, click on the resource link above.
Chapter 14: Using Forms and Reports in Access
Available Study Resources on Quizplus for this Chatper
91 Verified Questions
91 Flashcards
Source URL: https://quizplus.com/quiz/13807
Sample Questions
Q1) When the Report Wizard is done creating the report,it shows you the report in Layout view.
A)True
B)False
Q2) Form view is only for viewing data,so to make any changes to the form you need to switch to either Print Preview or Design view.
A)True
B)False
Q3) When navigating a subform,pressing ________ will move the cursor to the last field of the last record of the subform.
Q4) On a report,________ calculate totals for smaller groups of records.
Q5) A(n)________ is a form created from one table,but it has a Form view and a Datasheet view in the same window.
Q6) To break a report into smaller sections,subtotals or groups may be added.
A)True
B)False
Q7) When navigating a main form,pressing ________ will move the cursor to the first field of the current record.
Q8) A(n)________ is a built-in combination of colors and fonts.
To view all questions and flashcards with answers, click on the resource link above. Page 17
Chapter 15: Presentation Fundamentals
Available Study Resources on Quizplus for this Chatper
95 Verified Questions
95 Flashcards
Source URL: https://quizplus.com/quiz/13797
Sample Questions
Q1) Demoting outline text moves the text up a level,and promoting outline text moves the text down a level.
A)True
B)False
Q2) When viewing a slide show,which of the following is NOT a key that advances to the next slide?
A) G
B) PgDn
C) Enter
D) Down arrow
Q3) The Header & Footer button is located in the ________ tab.
A) Comments group on the Insert tab
B) Comments group on the Design tab
C) Text group on the Insert tab
D) Text group on the Design tab
Q4) The ________ tool provides access to a variety of reference books,dictionaries,research websites,and business and financial sites.
Q5) A design ________ add visual interest to a presentation,including background,color,and font selections.
To view all questions and flashcards with answers, click on the resource link above. Page 18
Chapter 16: Text and Graphics
Available Study Resources on Quizplus for this Chatper
95 Verified Questions
95 Flashcards
Source URL: https://quizplus.com/quiz/13796
Sample Questions
Q1) The ________ format allows for multibit transparency,a full range of color,and better compression.
A) Graphic Image File
B) Joint Photographic Experts Group
C) Portable Network Graphics
D) Tagged Image File Format
Q2) ________ are the lines that surround selected graphic objects that enable the user to remove unneeded portions.
Q3) Like pictures,________ of numeric data assist the audience in grasping the message.
A) lists
B) WordArt
C) charts
D) tables
Q4) Trebuchet is a type of serif font.
A)True
B)False
Q5) The Kelvin scale describes a standard color temperature of light sources.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 19
Chapter 17: Multimedia and Motion
Available Study Resources on Quizplus for this Chatper
94 Verified Questions
94 Flashcards
Source URL: https://quizplus.com/quiz/13795
Sample Questions
Q1) Hyperlinks should always appear in full and on multiple lines if necessary.
A)True
B)False
Q2) A(n)________ can be used to automatically advance slides after a set amount of time.
Q3) ________ mark sections of an audio or video file so the user can jump to a certain point in the file before starting the playback.
A) Partitions
B) Sectors
C) Bookmarks
D) Segments
Q4) The file extension for a Windows Media audio file is ________.
Q5) By adding a(n)________ in an audio or video file,you mark a section of the file so the user can directly go to a certain place in the file before starting the playback.
Q6) A ________ is like a presentation within a presentation.
A) kiosk slide show
B) Photo Album
C) custom slide show
D) subset slide show
To view all questions and flashcards with answers, click on the resource link above. Page 20
Chapter 18: Customization and Collaboration
Available Study Resources on Quizplus for this Chatper
88 Verified Questions
88 Flashcards
Source URL: https://quizplus.com/quiz/13794
Sample Questions
Q1) Organize speaker notes with numbers or letters in outline format.
A)True
B)False
Q2) Nine different layouts that can be used in a presentation are included in Master Slide view.
A)True
B)False
Q3) ________ is an add-in to PowerPoint that turns PowerPoint presentations into interactive lessons.
Q4) Slides in PowerPoint 2016 are typically displayed in a 16:9 ratio.
A)True
B)False
Q5) Because PowerPoint 2016 has been optimized for widescreen monitors and tablets,the slides are generally displayed in a(n)________ ratio.
Q6) KFC's Colonel Sanders is an example of a corporate identity.
A)True
B)False
Q7) Slide ________ cannot be moved or modified in a handout master.
Q8) Short notes attached to a presentation are called ________.
To view all questions and flashcards with answers, click on the resource link above. Page 21