Introduction to Microsoft Office Study Guide Questions
Course Introduction
Introduction to Microsoft Office is a foundational course designed to provide students with practical knowledge and hands-on experience using the core applications in the Microsoft Office suite, including Word, Excel, PowerPoint, and Outlook. Through guided tutorials and real-world projects, students will learn how to create and format professional documents, develop and analyze spreadsheets, craft engaging presentations, and manage email and schedules efficiently. By the end of the course, students will be equipped with essential digital skills valuable for academic, personal, and professional success.
Recommended Textbook
GO with Microsoft Excel 2016 Comprehensive 1st edition by Shelley Gaskin
Available Study Resources on Quizplus
12 Chapters
1128 Verified Questions
1128 Flashcards
Source URL: https://quizplus.com/study-set/2442
Page 2
Chapter 1: Introduction to Microsoft Office 2016 Features
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/48546
Sample Questions
Q1) To send several large files,which may be too large to send in an email,create a ________ file that reduces the overall size of the files.
A)linked
B)shared
C)compressed
D)combined
Answer: C
Q2) You can use the keyboard shortcut ________ to cut text and place it on the clipboard.
A)Ctrl + C
B)Ctrl + V
C)Ctrl + X
D)Ctrl + S
Answer: C
Q3) You can print the Help information on any topic from within the Office Help tool.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above.
3
Chapter 1: Excell: Creating a Worksheet and Charting Data
Available Study Resources on Quizplus for this Chatper
97 Verified Questions
97 Flashcards
Source URL: https://quizplus.com/quiz/48535
Sample Questions
Q1) All formulas begin with a(n)________.
A)= sign
B)% sign
C)+ sign
D)# sign
Answer: A
Q2) You can use the Switch/Row Column command to move a chart from a set of rows on one worksheet to a set of columns on another.
A)True
B)False Answer: False
Q3) The Percent Style can have fewer or more places after the decimal that the default setting.
A)True
B)False
Answer: True
Q4) The ________ displays the name given to a selected cell,table,chart,or object. Answer: Name Box
Q5) A(n)________ is a vertical group of cells in an Excel worksheet. Answer: column
4
To view all questions and flashcards with answers, click on the resource link above.
Chapter 2: Excell: Using Functions, Creating Tables, and Managing Large Workbooks
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/48536
Sample Questions
Q1) You can double-click a sheet tab to rename it. A)True
B)False Answer: True
Q2) Ctrl + F1 is the is the keyboard shortcut for Print Preview.
A)True
B)False
Answer: False
Q3) ________ sheets store information summarized on a summary sheet. Answer: Detail
Q4) When excel enters a current date into a cell,it is accessed from your computer's internal calendar.
A)True
B)False Answer: True
Q5) You can leave the year off entirely when typing a date into a cell. A)True
B)False Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 3: Excell: Analyzing Data With Pie Charts, Line
Charts, and What-If Analysis Tools
Available Study Resources on Quizplus for this Chatper
79 Verified Questions
79 Flashcards
Source URL: https://quizplus.com/quiz/48537
Sample Questions
Q1) To size a chart proportionately,hold down the ________ key and ________.
A)Ctrl;drag a corner sizing handle
B)Shift;drag a left or right sizing handle
C)Shift;drag a top or bottom sizing handle
D)Shift;drag a corner sizing handle
Q2) Every Excel formula starts with an equal sign (=).
A)True
B)False
Q3) In Excel,you should use parentheses in order to specify the order in which operations needs to occur.
A)True
B)False
Q4) The order of data in the worksheet determines how the pie slices are ordered in a pie chart.
A)True
B)False
Q5) In a(n)________ time is displayed along the bottom axis and data point values connect in the chart to show a trend over time.
Q7) The ________ is the entire chart and all of its elements. Page 6
Q6) Excel follows a set of mathematical rules called the ________.
To view all questions and flashcards with answers, click on the resource link above.
Page 7
Chapter 4: Excell: Use Financial and Lookup Functions,
Define Names, Validate Data, and Audit Worksheets
Available Study Resources on Quizplus for this Chatper
99 Verified Questions
99 Flashcards
Source URL: https://quizplus.com/quiz/48538
Sample Questions
Q1) ________ look up a value in a defined range of cells located in another part of the workbook to find a corresponding value.
Q2) ________ is a technique in which you control the data or the values that are entered into a cell.
Q3) The Error Checking button displays as a ________.
A)purple arrow
B)blue circle
C)red square
D)yellow diamond
Q4) If you create a defined name and then decide that you no longer need it,you can delete the name and its associated range reference.
A)True
B)False
Q5) A defined name provides a logical reference to ________.
A)data
B)tables
C)functions
D)formulas
Q6) A(n)________ data table changes the value in only one cell.
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 5: Excell: Managing Large Workbooks and Using Advanced
Sorting and Filtering
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/48539
Sample Questions
Q1) To apply complex criteria to a single column,use a(n)________.
A)advanced filter
B)AutoFilter
C)custom filter
D)extracting filter
Q2) To save an Excel file in another file format,use the ________ command.
A)Delete
B)Format
C)Save As
D)Save
Q3) Instead of displaying a filtered list,you can copy the results of a filter to another area of your worksheet for comparison purposes;this action is known as ________.
A)extracting
B)filtering
C)pasting
D)coping
Q4) Excel worksheets and workbooks can be saved as web pages.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 6: Excell: Creating Charts, Diagrams, and Templates
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/48540
Sample Questions
Q1) Both the Text Pane and the SmartArt graphic contain ________ in which you can type text.
Q2) ________ means that all forms created within an organization will have a uniform appearance;the data will always be organized in the same manner.
Q3) A ________ is a visual representation of information and ideas.
A)template
B)chart area
C)SmartArt graphic
D)trendline
Q4) A(n)________ graphic is a graphical tool that depicts ideas or associations.
Q5) Excel includes predesigned templates,for example for a budget.
A)True
B)False
Q6) When you protect a worksheet,you can add an optional ________ to prevent someone from disabling a worksheet's protection.
A)lock
B)legend
C)scale
D)password
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 7: Excell: Creating Pivottables and Pivotcharts
Available Study Resources on Quizplus for this Chatper
91 Verified Questions
91 Flashcards
Source URL: https://quizplus.com/quiz/48541
Sample Questions
Q1) A PivotChart displays data series,categories,data markers,and axes in the same manner as a standard chart.
A)True
B)False
Q2) Excel uses the column titles as the ________ for the categories of data.
A)report names
B)field names
C)data labels
D)row labels
Q3) A PivotTable is an interactive Excel report that summarizes large amounts of data,allowing you to more easily analyze it.
A)True
B)False
Q4) The PivotTable report with data graphically represented in a PivotChart is that PivotChart's ________ PivotTable report.
Q5) Another term for viewing or summarizing data in a PivotTable is known as ________ the information around to get varying views of the data.
Q6) A Microsoft ________ database stores data in rows and columns.
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 8: Excell:
Using the Data Analysis, Solver, and Scenario Features, and Building Complex Formulas
Available Study Resources on Quizplus for this Chatper
96 Verified Questions
96 Flashcards
Source URL: https://quizplus.com/quiz/48542
Sample Questions
Q1) A scenario is a set of values that Excel saves and can substitute automatically in your worksheet.
A)True
B)False
Q2) When using Solver,which of the following will NOT be identified during the process?
A)Objective cells
B)Constraint cells
C)Decision variable cells
D)Result cells
Q3) A moving average is a ________ of averages computed from parts of a data series.
A)sequence
B)chart
C)combination
D)total
Q4) In a moving average,the number range that is averaged is constantly changing,dropping off the first number and adding on the most ________ number.
Q5) When you use Solver,your worksheet will include ________ cells that contain values that limit or restrict the outcome.
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 9: Excell: Using Macros and Visual Basic for Applications
Available Study Resources on Quizplus for this Chatper
97 Verified Questions
97 Flashcards
Source URL: https://quizplus.com/quiz/48543
Sample Questions
Q1) The word that notes the beginning of a VBA construct is ________.
Q2) The window where you can view and edit the module containing the Visual Basic code is the ________ window.
A)module
B)Visual Basic Editor
C)procedure
D)macro
Q3) ActiveX controls are NOT attached to cells,instead,they are similar to inserted shapes or SmartArt.
A)True
B)False
Q4) A collection of VBA declarations,statements,and procedures stored together as one named unit is known as a ________.
A)macro
B)module
C)construct
D)property
Q5) When assigning a button to the Quick Access Toolbar,go to the Excel ________ dialog box.
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter
Side-By-Side Tables
Available Study Resources on Quizplus for this Chatper
96 Verified Questions
96 Flashcards
Source URL: https://quizplus.com/quiz/48544
Sample Questions
Q1) Microsoft Access is a database program that manages database files.
A)True
B)False
Q2) Microsoft ________ is a database program that manages database files.
Q3) The ________ function removes extra blank spaces from a string of characters.
A)TRIM
B)LEFT
C)MID
D)RIGHT
Q4) When you convert a range to a table,a table style is applied,and the headings display ________ arrows.
Q5) To convert a table to a range,you must first select the entire table.
A)True
B)False
Q6) The ________ Wizard assists you with steps to import a text file into Excel.
Q7) Information stored in rows and columns is referred to as ________.
A)a record
B)a table
C)a chart
D)an array
Page 14
To view all questions and flashcards with answers, click on the resource link above.
Page 15
Chapter 11: Excell: Collaborating With Others and Preparing a
Workbook for Distribution
Available Study Resources on Quizplus for this Chatper
95 Verified Questions
95 Flashcards
Source URL: https://quizplus.com/quiz/48545
Sample Questions
Q1) If you need to edit a read-only file,save it with the same file name,which preserves the original file.
A)True
B)False
Q2) Which of the following finds potential issues for users with disabilities so that you can resolve the issues and make your file easier to use?
A)Compatibility Checker
B)Document Inspector
C)Accessibility Checker
D)Compatibility Mode
Q3) Once the changes are recorded,you can review the shared file and decide to ________.
A)delete the file
B)discard the file
C)accept or reject the changes
D)refresh the changes
Q4) ________ Inspector is an Excel feature that can find and remove hidden properties and personal information from a workbook.
To view all questions and flashcards with answers, click on the resource link above. Page 16
Q5) When you create your own ________,it is referred to as a self-signed project.