Advanced Excel for Business Review Questions
Course Introduction
Advanced Excel for Business delves into sophisticated spreadsheet techniques essential for effective data analysis, reporting, and decision making in a business context. The course covers advanced functions and formulas, pivot tables, data validation, conditional formatting, and automation through macros and basic Visual Basic for Applications (VBA). Emphasis is placed on practical applications manipulating large datasets, creating dynamic dashboards, and building analytical models to solve real-world business problems. Students will develop proficiency in leveraging Excels advanced features to manage, interpret, and present business data with accuracy and efficiency.
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) After naming and saving a file,you can click the Save command from the Quick Access toolbar without having to go to Backstage view to save changes.
A)True
B)False
Answer: True
Q2) Use the ________ feature to search a document for hidden data or potentially personal data that should not be shared.
A)Inspect Document
B)Check Accessibility
C)Check Compatibility
D)Check Properties
Answer: A
Q3) Only one item may be placed in the clipboard at a time.
A)True
B)False
Answer: False
Q4) Adding keywords to the document property called ________ makes the file easier to search for.
Answer: tags
To view all questions and flashcards with answers, click on the resource link above. Page 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) A cell style often includes font,font size,font color,and cell borders.
A)True
B)False
Answer: True
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 shortcut key for accessing the Spelling command is ________. Answer: F7
Q4) A data marker is a value that originates in a worksheet cell.
A)True
B)False
Answer: False
Q5) The ________ displays the name given to a selected cell,table,chart,or object. Answer: Name Box
Q6) When you select a range of data,the ________ button displays. Answer: Quick Analysis
To view all questions and flashcards with answers, click on the resource link above. Page 4
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) The Find and Replace feature searches the cells in a worksheet-or in a selected range-for matches,and then replaces each match with a replacement value of your choice.
A)True
B)False
Answer: True
Q2) When a cell has conditional formatting and the condition is false,the cell is formatted.
A)True
B)False
Answer: False
Q3) The ________ function adds the values in a range of cells,and then divides the result by the number of values in the range.
Answer: AVERAGE
Q4) What is the keyboard shortcut for flash fill?
A)Alt + E
B)Ctrl + E
C)Ctrl + F
D)Ctrl + F2
Answer: B
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) When a worksheet is selected that is part of a group,the [Group] notation displays in the ________.
Q2) In the ________ pane,you can change the bounds of the axes.
Q3) Excel follows a set of mathematical rules called the ________.
Q4) Formula AutoComplete displays a list of function names that match the letter or two that you type.
A)True
B)False
Q5) In a line chart,which of the following resides along the bottom of the chart?
A)The x-axis
B)The plot area
C)The y-axis
D)The legend
Q6) A shape effect that uses shading and shadows is a ________.
Q7) To what extent can a pie chart be rotated?
A)Up to 360 degrees
B)Up to 180 degrees
C)Up to 90 degrees
D)Up to 45 degrees
6
Q8) A workbook sheet that contains only a chart is a(n)________.
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) When you use a(n)________ in a formula,the result is the same as if you typed the cell reference.
Q2) When you start typing a formula,such as =SUM(B Excel will display the ________,which contains all of Excel's built in functions starting with the letter B.
A)table array
B)Formula AutoComplete list
C)defined name
D)AutoFill
Q3) ________ arrows show the relationship between the active cell and its related cells.
Q4) A defined name that is distinctive and easy to remember,typically describes the ________ of the selected cells.
Q5) A data tables is useful for all of the following except for ________.
A)calculating possible values for each argument
B)viewing and compare results
C)determining the Future value (Fv)
D)calculating multiple versions in one operation
Q6) In a lookup formula,the defined range is referred to as the ________.
Q7) A ________ list is a list of values that are acceptable for a group of cells.
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) Fonts are associated with different themes and can be customized by ________.
A)clicking in the default themes option
B)using the predefined themes that come with Office 2016
C)mixing Colors and Fonts from any of the supplied themes
D)using Live Preview
Q2) When using custom or advanced filters,the selected range can be formatted as a table or a database.
A)True
B)False
Q3) When filtering by format or value using AutoFilter in Excel,each filter type is mutually exclusive for the column;that is,you can use only one at a time.
A)True
B)False
Q4) You can customize your table by creating and applying a custom table style of your own design.
A)True
B)False
Q5) ________ is the process of organizing data in a specific order.
To view all questions and flashcards with answers, click on the resource link above. Page 9
Q6) By using a(n)________ filter,you can apply complex criteria to a single column.
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) To add text to a SmartArt graphic,you can type in the shape placeholders or you can open the ________.
Q2) If you try to enter data in a protected cell,a message displays informing you that the cell is protected and therefore ________.
A)read-only
B)unlocked
C)invalid
D)embedded
Q3) When you create a chart,you must first decide if you are going to plot values representing ________.
A)columns OR details
B)totals OR details
C)sparklines OR trendlines
D)columns OR trends
Q4) A line chart can have only one line.
A)True
B)False
Q5) A Process SmartArt graphic can display steps in a process or a ________.
To view all questions and flashcards with answers, click on the resource link above. Page 10
Q6) A(n)________ graphic is a graphical tool that depicts ideas or associations.
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 chart that illustrates the relationship of each part to a whole is called a ________.
A)column chart
B)line chart
C)pie chart
D)bar chart
Q2) Most of the formatting that has been practiced in standard charts works the same way in a PivotChart.
A)True
B)False
Q3) An area to position fields that you want to display as rows in the PivotTable reports is called the ________.
A)COLUMNS area
B)ROWS area
C)VALUES area
D)FILTER area
Q4) You can modify the data that displays in the PivotChart by dragging the ________ between areas in the PivotChart Fields list.
Q5) 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
Available Study Resources on Quizplus for this Chatper
96 Verified Questions
96 Flashcards
Source URL: https://quizplus.com/quiz/48542
Sample Questions
Q1) Solver is located in the ________ group on the Data tab.
Q2) A ________ is a prediction of the future,often based on past performances.
Q3) Excel has ________ codes that enable you to display dates in a specific date format.
A)symbol
B)date
C)text
D)number
Q4) One of the basic tools to help project future results based on past performance is ________.
A)a moving average
B)an interval
C)a decision variable
D)a scenario
Q5) Solver is one of Excel's ________ tools.
A)prediction
B)forecast
C)break-even
D)what-if analysis
Page 12
Q6) ________ functions,for example AND and NOT,test for specific conditions.
To view all questions and flashcards with answers, click on the resource link above. Page 13
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 With denotes the beginning of a ________,an instruction that enables the macro to perform multiple operations on a single object.
A)VBA with
B)VBA constrict
C)VBA construct
D)VBA procedure
Q2) You would choose which of the following workbooks to save a macro that is used in other workbooks?
A)Personal Worksheet
B)Personal Workbook
C)Personal Macro Worksheet
D)Personal Macro Workbook
Q3) A macro will record the actions to automate a task.
A)True
B)False
Q4) An ActiveX Control can be added that inserts a ________ button to control when code can be attached and initiates an action when clicked.
Q5) To access the ________ window,click the Debug button within the Microsoft Visual Basic dialog box.
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 10: Excell: External Data, Database Functions, and
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) A ________ is a horizontal row in a database table that stores all of the data about one database item.
Q2) To convert a table to a range,you must first select the entire table.
A)True
B)False
Q3) An icon set can make data visually easier to interpret.
A)True
B)False
Q4) Custom headers and footers can be added to worksheets.
A)True
B)False
Q5) The ________ function extracts a series of characters from a text string given the location of the beginning character.
A)FRONT
B)LEFT
C)MID
D)RIGHT
Q6) Microsoft ________ is a database program that manages database files.
Page 15
Q7) Filtering arrows are removed from column headings when you use the ________ to Range command.
To view all questions and flashcards with answers, click on the resource link above.
Page 16
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) By scrambling the contents of a file,you are using ________ to restrict access to the file.
A)the Mark as Final command
B)cloud computing
C)a Microsoft Account
D)encryption
Q2) In Excel,a Marked as Final document will display Read-Only in the ________ bar.
Q3) To edit a Marked as Final workbook in Excel,you click on the ________.
A)Final button
B)Save button
C)Edit Anyway button
D)Read-only button
Q4) Encryption prevents you from ________ a file.
Q5) When more than one copy of the shared workbook contains marked changes,first ________ the workbooks so that you can view everyone's changes in a single workbook.
A)merge
B)save
C)accept
D)discard
To view all questions and flashcards with answers, click on the resource link above. Page 17