Spreadsheet Applications Practice Exam
Course Introduction
Spreadsheet Applications introduces students to the fundamental concepts and practical skills needed to effectively use spreadsheet software such as Microsoft Excel or Google Sheets. The course covers essential topics including data entry, formatting, formulas, functions, data analysis, chart creation, and organization of large datasets. Emphasis is placed on using spreadsheets as powerful tools for problem-solving, decision-making, and automation in both academic and professional contexts. Through hands-on exercises and real-world projects, students develop the ability to handle complex data sets, create informative visualizations, and streamline workflow processes, preparing them for tasks commonly encountered in business, finance, research, and everyday life.
Recommended Textbook
Exploring Microsoft Office Excel 2016 Comprehensive 1st Edition by Mary Anne
Available Study Resources on Quizplus
13 Chapters
1301 Verified Questions
1301 Flashcards
Source URL: https://quizplus.com/study-set/1467
Page 2
Chapter 1: Introduction to Excel
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/29219
Sample Questions
Q1) Besides the Page Setup dialog box, where else can you create headers or footers?
A)Page Layout tab, Text group, Header & Footer
B)Insert tab, Text group, Header & Footer
C)Home tab, Text group, Header & Footer
D)View tab, Text group, Header & Footer
Answer: B
Q2) When you do not need the data on a worksheet you should ________ it to make the file smaller.
Answer: delete
Q3) Which of the following is not a valid number format?
A)$1,000.00
B)$ 1,000.000
C)(1,000.00)
D)$ -1,000.00
Answer: D
Q4) The cell at row 4 and column B, would be identified as 4B.
A)True
B)False
Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Formulas and Functions
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/29223
Sample Questions
Q1) If a cell containing =B$14 is copy and pasted three columns over and two rows down, what would the resultant cell reference become?
A)E$14
B)$E$14
C)B16
D)B$16
Answer: A
Q2) The most used logical function is the IF function.
A)True
B)False
Answer: True
Q3) What do you use to separate arguments in a function?
A)Period (.)
B)Semi-colon (;)
C)Comma (,)
D)Colon (:)
Answer: C
Q4) The ________ function finds the smallest value in a range.
Answer: MIN
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: Charts
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/29224
Sample Questions
Q1) Excel uses ________ to determine what categories are visible in a chart.
Answer: chart filters, filters
Q2) Including the column and row labels in a chart makes the chart harder to understand.
A)True
B)False
Answer: False
Q3) ________ charts are often used to represent data in educational, scientific, and medical experiments.
Answer: Scatter, X Y, X Y Scatter
Q4) Effective charts never overwhelm an audience.
A)True
B)False
Answer: True
Q5) Once a data source is selected for a chart, the only way to change the data source is to start over creating the chart.
A)True
B)False
Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Datasets and Tables
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/29225
Sample Questions
Q1) What is not true about using the AND function in a custom conditional formatting rule?
A)All the tests must be of the same data type, for example: all numbers or all text.
B)All the logical tests must be true for the formatting to be applied.
C)You must have at least two tests in the formula.
D)You may have as many tests as you need in the formula.
Q2) What is not true about creating a data table?
A)Make sure no column labels are the same.
B)Make sure to leave one blank row below the data labels.
C)Format the field names so that they stand out visually.
D)Keep field names short.
Q3) In the formula =SUBTOTAL(102,[PAID]), what does the word PAID represent?
A)The PAID record
B)The range to be included in the calculation
C)The Excel function called PAID
D)The label for the resultant Total Row
Q4) Records are individual pieces of information.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Subtotals, Pivottables, and Pivotcharts
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/29226
Sample Questions
Q1) You can clear all fields from a PivotTable.
A)True
B)False
Q2) Given a list of candy bars in a field called <b>Item </b>and their prices in a field called <b>Price</b> on an empty PivotTable, how would you find out how many of each type of candy bar you have?
A)Drag Item to both the VALUES and the ROWS area.
B)Drag Price to the ROWS and Item to the VALUES area.
C)Drag Item to the COLUMNS area.
D)Drag Item to the ROWS areas.
Q3) If you want to turn off grand totals for columns on a PivotTable, select this option in the Grand Totals options.
A)On for Rows Only
B)On for Columns Only
C)Off for Rows and Columns
D)On for Rows and Columns
Q4) A(n)________ is a collection of related tables forming a database.
Q5) The first step in using the subtotal feature in Excel is to ________ the data.
Q6) A(n)________ is a hierarchical structure used to group and summarize related data.
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: What-If Analysis
Available Study Resources on Quizplus for this Chatper
91 Verified Questions
91 Flashcards
Source URL: https://quizplus.com/quiz/29227
Sample Questions
Q1) An objective cell is required to complete a Solver model.
A)True
B)False
Q2) What-if analysis always provides a definitive solution to a problem.
A)True
B)False
Q3) A one-variable data table can be built ________.
A)vertically
B)horizontally
C)in column A
D)either horizontally or vertically
Q4) If Solver is installed on your computer, it will display on the ________ tab.
Q5) The number of scenarios that Scenario Manager can manage is unlimited.
A)True
B)False
Q6) Goal Seek is an Excel Add-in.
A)True
B)False
Q7) Business managers often create ________ /worst-case scenarios.
Page 8
Q8) ________ has an optional summary output of a PivotTable.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 7: Specialized Functions
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/29228
Sample Questions
Q1) A loan amortization table is a schedule that calculates the interest per payment period, principal repayment for each payment, and remaining balance after each payment is made.
A)True
B)False
Q2) The ________ function calculates the cumulative interest through a specified number of payments.
Q3) The ________ function identifies the highest value in a database column that matches specified conditions in a criteria range.
Q4) Which function calculates the total amount of interest paid over a specific number of payments?
A)CUMPMT
B)IPMT
C)CUMIPMT
D)PMT
Q5) If you have 3 possible outcomes in a nested IF statement, then you need ________ logical tests.
Q6) The ________ function calculates the total number of periods in a loan.
Q7) The ________ function returns the difference between 2 dates.
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Statistical Functions
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/29229
Sample Questions
Q1) When using the Function Arguments Box, Excel will ________.
A)suggest criteria
B)not enter quotation marks in text criteria
C)suggest ranges
D)enter the quotation marks in text criteria, automatically
Q2) The ________ is an add-in program that provides statistical analysis tools.
Q3) The ________ function returns the variance of a sample of numerical data
A)VARPA
B)VAR.P
C)VARA
D)VAR.S
Q4) ________ is a measure of a dataset's dispersion or the difference between the highest and lowest values.
Q5) A quartile is a value used to divide a range into five equal groups.
A)True
B)False
Q6) The FREQUENCY function determines the strength of the relationship between two data sets.
A)True
B)False
Page 10
To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Multiple-Sheet Workbook Management
Available Study Resources on Quizplus for this Chatper
89 Verified Questions
89 Flashcards
Source URL: https://quizplus.com/quiz/29230
Sample Questions
Q1) Camel Case notation capitalizes the first letter of all words except the first and removes spaces
A)True
B)False
Q2) A logic error happens mostly because a user makes a mistake by using an incorrect value or reference in a formula.
A)True
B)False
Q3) To set up a Watch Window, Click Watch Window on the Data tab.
A)True
B)False
Q4) The Fill Across Worksheets command is ________.
A)only usable on an empty workbook
B)an option on the Fill button on the Home Tab
C)applicable to formats but not contents
D)an option on the Group button on the Data Tab
Q5) Formula auditing replaces known errors with alternate values.
A)True
B)False
Q6) When worksheets are grouped, [Group} appears in the ________.
Page 11
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10: Imports, Xml, and Power Add-Ins
Available Study Resources on Quizplus for this Chatper
87 Verified Questions
87 Flashcards
Source URL: https://quizplus.com/quiz/29220
Sample Questions
Q1) The ________ is the area that contains the dashboard data visualizations in Power View.
A)slate
B)canvas
C)palette
D)surface
Q2) If you import web data directly into Power Pivot and discover there are a lot of errors and inconsistencies, use ________ to clean it up.
Q3) On which tab is the Text to Columns Wizard?
A)Insert
B)Data
C)Formula
D)Developer
Q4) ________ is a standalone desktop application that has Power View functionality outside of Excel
Q5) Tab-delimited files use tabs to separate data into new rows.
A)True
B)False
Q6) A(n)________ links two tables together for a Power Pivot PivotTable.
Q7) The ________ function will change tabitha turner to Tabitha Turner.
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 11: Collaboration and Workbook Distribution
Available Study Resources on Quizplus for this Chatper
88 Verified Questions
88 Flashcards
Source URL: https://quizplus.com/quiz/29221
Sample Questions
Q1) ________ is the cloud service integrated with Excel 2016.
Q2) Hidden comments do not print.
A)True
B)False
Q3) The default setting is all comments in a worksheet are ________ when printing.
Q4) The default setting for printing comments is ________.
A)Print in place
B)Print at end
C)not to print
D)only displayed comments
Q5) An Excel template has an .xlxb extension.
A)True
B)False
Q6) Where in the Excel Options dialog box would you add a word or phrase to AutoCorrect in Excel?
A)Proofing
B)Formulas
C)Save
D)Advanced
Q7) If a workbook ________ is lost, it cannot be recovered.
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 12: Templates, Styles, and Macros
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/29222
Sample Questions
Q1) ________ is the file extension for Macro-Enabled Workbooks.
Q2) Which of the following is false about a VBA object?
A)Contains data
B)Contains code
C)Starts with '
D)Represents a Range
Q3) A forgotten ________ in Excel is unrecoverable.
Q4) Custom Functions are recorded in the macro recorder.
A)True
B)False
Q5) On which tab is the Themes Gallery?
A)File
B)Insert
C)Page Layout
D)View
Q6) What color are comments in VBA?
A)Black
B)Green
C)Red
D)Blue
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 13: Appendix: Exploring Microsoft Office Excel 2016
Comprehensive Poatsygrauer
Available Study Resources on Quizplus for this Chatper
106 Verified Questions
106 Flashcards
Source URL: https://quizplus.com/quiz/29231
Sample Questions
Q1) Portrait orientation
A)Duplicates a selection from the original location and places a copy in the Office Clipboard
B)Removes a selection from the original location and places it in the Clipboard
C)Page that is wider than it is tall
D)Page that is taller than it is wide
E)Places a selection in the Clipboard into another location
Q2) A template is a collection of design choices that includes colors, fonts, and special effects used to give a consistent look to your work.
A)True
B)False
Q3) If you used bear instead of bare, bear would be underlined with a red wavy line.
A)True
B)False
Q4) A ________ is a subset of a tab and is used to organize similar tasks together.
A)group
B)header
C)template
D)gallery
Q5) A grammatical error is underlined with a(n)________ wavy line.
To view all questions and flashcards with answers, click on the resource link above. Page 15