Data Analysis with Excel Exam Questions
Course Introduction
This course provides a comprehensive introduction to data analysis using Microsoft Excel, equipping students with essential skills to organize, process, and interpret data effectively. Participants will learn how to use Excels powerful features, such as formulas, functions, pivot tables, charts, and conditional formatting, to manage large datasets, perform statistical analyses, and visualize trends. Emphasis is placed on practical applications across various disciplines, preparing students to turn raw data into meaningful insights for decision-making in academic, business, and research contexts.
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) If you want to access your files anywhere from almost any connected device,you should store your files on your ________.
A)hard drive
B)my documents folder
C)desktop
D)OneDrive
Answer: D
Q2) 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
Q3) When you create a new Word document,you have the option to create a blank document or use a pre-defined ________.
Answer: template
Q4) A ________ is a reserved area for text or graphics that display at the top of a document.
Answer: header
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) The Sum button resides on both the Home tab and the Formulas tab.
A)True
B)False
Answer: True
Q2) Match each of the following terms to its definition:
i.data series
II.data point
III.data marker
IV.y-axis
v.x-axis
A)a symbol in a chart that represents a single data point
B)related data points
C)also known as the category axis
D)also known as the value axis
E)a value that originates in a cell
Answer: B,E,A,D,C
Q3) A(n)________ is a predefined set of colors,fonts,line,and fill effects that coordinate for an attractive look.
Answer: theme
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) What is an Excel table?
A)A series of rows and columns that contains related data that can be managed independently from other data in a worksheet
B)A series of rows and columns that has been assigned a name and can be used in a formula or function
C)A series of rows and columns that contain related data located on a minimum of two worksheets
D)A series of rows or columns on a separate worksheet that can be managed independently from other data in a worksheet
Answer: A
Q2) Which symbols does Excel use to indicate that a cell is not wide enough to display a formula or function result?
A)*
B)@ C)#
D)-
Answer: C
Q3) The ________ command divides a window into multiple panes.
Answer: Split
Page 5
To view all questions and flashcards with answers, click on the resource link above.
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) A(n)________ chart emphasizes the flow from one data point value to the next.
Q3) When you select the data range for a pie chart,you should be sure to include the total cell on the worksheet.
A)True
B)False
Q4) When you print a chart sheet,how is it automatically formatted?
A)It is left-aligned on the page.
B)It is right-aligned on the page.
C)It is centered on the page.
D)It is has a default footer and page number.
Q5) Which of the following resides along the left side of a column chart?
A)The x-axis
B)The plot area
C)The y-axis
D)The legend
To view all questions and flashcards with answers, click on the resource link above. Page 6
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) An Excel function that looks up values in a table array arranged as vertical columns is the ________ function.
A)COLUMN
B)VLOOKUP
C)HLOOKUP
D)MATCH
Q2) To see how different interest rates affect a monthly payment,use a ________.
A)two-variable data table
B)one-variable data table
C)defined name
D)table array
Q3) When borrowing money,the interest rate and number of periods is quoted in months.
A)True
B)False
Q4) Defined names can contain ________.
A)uppercase and lowercase letters with spaces
B)the letter C by itself
C)the same value as a cell reference,such as M$10
D)uppercase and lowercase letters
To view all questions and flashcards with answers, click on the resource link above. Page 7
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 publish a document and ensure that the appearance of the document is the same no matter what computer it is displayed on,save the document in ________ format.
Q2) To specify three or more criteria for a particular column,use a(n)________ filter.
Q3) The active area of a worksheet contains data or has contained data and does NOT contain cells that were not used in the worksheet.
A)True
B)False
Q4) Hyperlinks can be attached to which of the following items?
A)Page breaks
B)Text and graphics
C)An instructor
D)Another hyperlink
Q5) Saving an Excel worksheet as a ________ separates the cells of each row with tab characters.
A)macro
B)template
C)comma separated value
D)tab delimited text file
To view all questions and flashcards with answers, click on the resource link above. Page 8
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 display trends over time,use a ________ chart.
A)line
B)bar
C)column
D)pie
Q2) When a template design is complete,you should enable protection.
A)True
B)False
Q3) All shapes in an organization chart must be the same color.
A)True
B)False
Q4) A ________ is a graphic representation of data.
A)Style
B)Legend
C)Chart
D)List
Q5) An Excel template is saved with the ________ extension.
9
Q6) ________ charts can show trends over time.
Q7) A(n)________ graphic is a visual representation of your information and ideas.
Q8) A(n)________ graphic is a graphical tool that depicts ideas or associations.
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) When a numeric field is added to a PivotTable,it is placed in the ________ area of the PivotTable field list.
A)COLUMNS Area
B)FILTERS Area
C)ROWS Area
D)VALUES Area
Q2) A slicer includes a slicer header that specifies the category of the slicer items. A)True
B)False
Q3) In Microsoft Access,the field used to uniquely identify a record is the ________.
Q4) A series of rows that contains related data with column titles in the first row is known as a(n)________.
Q5) A Microsoft ________ database stores data in rows and columns.
Q6) In Microsoft Access,each row is a ________ where all the categories of data pertaining to one person,place,event,thing,or idea is stored.
Q7) You can modify the data that displays in the PivotChart by dragging the ________ between areas in the PivotChart Fields list.
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) Income for a business generally consists of the ________ of products and services.
A)purchase
B)expense
C)operating cost
D)sale
Q2) The point of profitability is the same as the break-even point.
A)True
B)False
Q3) The custom date code,"ddd,mmm dd" displays in the format ________.
A)Wednesday,July 15
B)Wed,Jul 15
C)Wednesday,Jul 15
D)Wed,July 15
Q4) 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
Page 12
To view all questions and flashcards with answers, click on the resource link above.
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 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
Q2) You can ________ that the macro is from a trusted source by using a digital signature.
Q3) 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
Q4) To edit and check VBA code,you would click on View Code from the ________.
A)Edit group
B)Properties group
C)Developer group
D)Controls group
Q5) A macro is an action or set of actions can ________ tasks within Excel.
To view all questions and flashcards with answers, click on the resource link above. Page 13
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) Database functions are identified by the letters DF.
A)True
B)False
Q2) A(n)________ is a collection of data related to a particular topic or purpose.
Q3) Each vertical column stores information that describes the record and is referred to as a ________.
Q4) Custom headers and footers provide ________ sections where you can type your own text or insert header and footer elements.
A)two
B)three
C)one
D)four
Q5) You can ________ data into Excel from an Access database.
Q6) Side-by-side tables must contain the same number of rows and columns. A)True
B)False
Q7) Data refers to facts about people,events,things,or ideas.
A)True
B)False
14
Q8) Data that is organized in a useful manner is referred to as ________.
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) The process by which a file is encoded so that it cannot be opened without the proper password is known as ________.
Q2) Within the Properties dialog box for a file on the General Tab,there are additional properties that can be viewed and changed,such as ________.
A)protection parameters
B)keywords
C)backstage options
D)the date the file was last accessed
Q3) When you activate the Track Changes feature,the workbook automatically becomes a ________ workbook.
Q4) 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
Q5) When you create your own ________,it is referred to as a self-signed project.
Page 16
Q6) A ________ line specifies that an individual must digitally sign the document.
Q7) Sheet names make it easier to understand and navigate a ________.
To view all questions and flashcards with answers, click on the resource link above.