Introduction to Microsoft Office Question Bank
Course Introduction
Introduction to Microsoft Office provides students with a foundational understanding of the essential applications in the Microsoft Office suite, including Word, Excel, PowerPoint, and Outlook. Through practical exercises and guided instruction, learners will develop skills to create and format documents, manage spreadsheets, craft effective presentations, and organize email communications. By the end of the course, students will be able to efficiently use Microsoft Office tools for academic, professional, and personal tasks, enhancing their digital literacy and productivity.
Recommended Textbook
New Perspectives Microsoft Office 365 and Excel 2016 Comprehensive 1st Edition by June Jamrich
Available Study Resources on Quizplus
13 Chapters
935 Verified Questions
935 Flashcards
Source URL: https://quizplus.com/study-set/2189
Page 2
Chapter 1: Getting Started With Excel
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43584
Sample Questions
Q1) The AutoComplete feature automatically completes an entry based on previous entries in a column._________________________
A)True
B)False
Answer: True
Q2) Which of the following will not change the location of the active cell?
A) drag and drop
B) scrolling
C) clicking another cell
D) clicking a column heading
Answer: B
Q3) Ctrl + G is used to access the ____.
A) Go to Next worksheet command
B) G column
C) Go to a location in the worksheet command
D) formula view
Answer: C
Q4) When you ____________________ a workbook,a dialog box might open,asking whether you want to save the workbook.
Answer: close
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Formatting Workbook Text and Data
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43585
Sample Questions
Q1) Harold needs to format several cells with 11pt Calibri font,two decimal places,right-aligned,and a blue font color.The most efficient way to accomplish this would be to _____.
A) use Format Painter
B) format each element using the Toolbar
C) select all cells and use the Formatting dialog box
D) apply a table style
Answer: A
Q2) Put the following five steps in the order in which you would perform them to use the Paste Special function.?1.Select and copy a range.?2.Click the Paste button arrow in the Clipboard group on the HOME Tab.?3.Specify exactly what you want to paste.?4.Click Paste Special to open the dialog box.?5.Select the range where you want to paste the Clipboard contents.
A) 1, 2, 4, 3, 5
B) 1, 2, 4, 5, 3
C) 1, 5, 2, 4, 3
D) 1, 5, 2, 3, 4
Answer: C
Q3) A(n)____________________ is text printed in the top margin of each page.
Answer: header
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: 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/43586
Sample Questions
Q1) The ____ function returns the maximum value in the range.
A) TOP
B) FIRST
C) MAX
D) MOST
Answer: C
Q2) Absolute references are marked with a ____.
A) <
B) :
C) $
D) !
Answer: C
Q3) In the formula =INT(AVERAGE(A1:A100)),which would occur first? ____
A) The average of the values in the range A1:A100 is added to the integer.
B) The average of the integer value is calculated.
C) The average of the values in the range A1:A100 is calculated.
D) The integer portion of the value is extracted.
Answer: C
Q4) TODAY is an example of a(n)____________________ function.
Answer: date
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Analyzing and Charting Financial Data
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43587
Sample Questions
Q1) An _______ chart takes up less space than a chart sheet.
Q2) The FV function stands for ____.
A) function value
B) future value
C) financial value
D) formulated value
Q3) The possible values for the type argument in the function above are.
A) 0 or null
B) 0 or 1
C) 0, 1, or 2
D) 0, 1, 2, or 3
Q4) Placing a chart in a ____ displays only the chart and no worksheet cells.
A) new worksheet
B) tabbed view
C) graph display
D) chart sheet
Q5) ______ are horizontal and vertical lines that help you compare data and category values.
Q6) Each data source is a collection of ____________________,which is a range of values plotted as a single unit on a chart.
Page 6
To view all questions and flashcards with answers, click on the resource link above.
Chapter 5: Working With Excel Tables, Pivottables, and Pivotcharts
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43588
Sample Questions
Q1) You can display or hide filter arrows for an Excel table by using the Filter button in the Sort & Filter group on the ____ tab.
A) Category
B) View
C) Data
D) Home
Q2) Every ____ consists of an object that contains a button for each unique value in that field.
A) piece
B) slicer
C) section
D) part
Q3) When related fields are grouped together in a row,they form a(n)____________________,a collection of fields that describes a person,place,or thing.
Q4) The Subtotal command inserts a subtotal row into the range for each group of data and adds a grand total row below the last row of data.____________________
A)True
B)False
7
To view all questions and flashcards with answers, click on the resource link above.
Chapter 6: Managing Multiple Worksheets and Workbooks
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43589
Sample Questions
Q1) You can create a(n)____ reference by deleting the $ from the row reference in the cell reference $B$6.
A) mixed
B) absolute
C) relative
D) indexed
Q2) Which of the following statements about hyperlinks in Excel workbooks is correct?
A) They are usually represented by bold faced words with underlines or images.
B) They can be used to jump to a specific cell or range within the active worksheet, another worksheet, or another workbook.
C) They cannot be used to jump to other types of files or sites on the Web.
D) To use a hyperlink, you can click anywhere in the cell that contains the link, including white space in the cell or any text that flows into an adjacent cell.
Q3) The ____ caption indicates a worksheet group.
A) [Worksheets]
B) [Selected Sheets]
C) [Group]
D) [Workgroup]
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Developing an Excel Application
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43590
Sample Questions
Q1) In VBA,macros are called _____ procedures.
A) body
B) sub
C) commented
D) modular
Q2) A protected sheet can always be unprotected,but you can also require users to enter a(n)____________________ before the protection is removed.
Q3) The Visual Basic Editor is a separate application that works with Excel and all of the Office products to edit and manage VBA code._________________________
A)True
B)False
Q4) As Ted does more even work in Excel,he has begun to develop a collection of publishers whom he trusts to deliver macros that are problem-free.What should his option be in the Trust Center?
A) Enable all trusted macros
B) Enable all macros
C) Disable all macros except digitally signed macros
D) Disable a macro with notification
To view all questions and flashcards with answers, click on the resource link above.
9
Chapter 8: Working With Advanced Functions
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43591
Sample Questions
Q1) If all of the logical conditions are true,the AND function returns the logical value
A) FALSE
B) ON
C) TRUE
D) OFF
Q2) When Excel automatically fills the rest of a table column with a formula entered into an empty table column,this is referred to as a(n)_____ column.
A) concatenated
B) calculated
C) autofilled
D) custom
Q3) The _____ error value means that a value is not available to a function or formula.
A) #NAME?
B) #N/A
C) #NULL!
D) #NUM!
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Exploring Financial Tools and Functions
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43592
Sample Questions
Q1) Which of the following functions does Lisa say is used to calculate a straight-line depreciation?
A) DB
B) SLN
C) SYD
D) DDB
Q2) How do you determine which method of depreciation is most appropriate?
Q3) The _______ function calculates the present value of an investment or loan.
A) PRES
B) PV
C) NPER
D) FV
Q4) The FV function calculates the full value of an investment or loan._________________________
A)True B)False
Q5) If you don't include a pv value,Excel assumes a future value of 1._________________________
A)True
B)False
11
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10: Performing What-If Analyses
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43593
Sample Questions
Q1) At the break-even point,revenue equals expenses.
A)True
B)False
Q2) Goal Seek uses a different approach from traditional _______ analysis.
A) trial-and-error
B) what-if
C) worksheet
D) hypothetical
Q3) After trying out solutions for a short time,Solver displays the _______ dialog box,which displays the message that indicates Solver has found a solution that satisfies the constraints.
A) Solver Answer
B) Solver Solution
C) Solver Results
D) Solution
Q4) _______ are important because they ensure a realistic solution to your problem.
A) Constraints
B) Parameters
C) Targets
D) Optimals
Page 12
To view all questions and flashcards with answers, click on the resource link above.
Chapter 11: Analyzing Data With Business Intelligence
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43594
Sample Questions
Q1) Database tables can be inserted directly into PivotCharts and PivotFigures.
A)True
B)False
Q2) The source editor is an office tool used to write queries.
A)True
B)False
Q3) A ________ is an organization of fields that start with the most general and go down to the most specific.
A) Hierarchy
B) Trendline
C) Data Cube
D) Timeline slicer
Q4) A data source is usually organized in the way you need it for your report.
A)True
B)False
Q5) To create a worksheet containing forecasted values,including values that follow a seasonal pattern,you click the Forecast Sheet button.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 12: Collaborating on a Shared Workbook
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43595
Sample Questions
Q1) Where a list of the changes made to the workbook are stored
A)linked object
B)embedding object
C)PDF (Portable Document Format)
D)Standard properties
E)Custom properties
F)Object linking and embedding (OLE)
G)Encryption
H)digital certificate
I)certificate authority (CA)
J)source file
K)shared workbook
Q2) The most serious differences between Excel 2016 and older versions of Excel include:
A) Worksheet size
B) International dates
C) Sparklines
D) All of the above
Q3) Describe how you can control Excel recalculating Formulas.Discuss the Automatic,Automatic except for data tables,and Manual options.
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 13: Working With Text Functions
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/43583
Sample Questions
Q1) You can use Text functions to:
A) return the number of characters in a string
B) remove extra spaces
C) change the case of text strings
D) all of the above
Q2) You can use the LEN and LEFT functions nested in a(n)____ function to convert all of the zip codes to the shorter form.
A) IF
B) MID
C) Text
D) PROPER
Q3) Which of the following is not one of the four commonly used formats?
A) Zip code
B) Phone number
C) Social Security
D) Birth date
Q4) The PROPER function replaces existing text with new text.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 15