Introduction to Spreadsheets Practice Exam
Course Introduction
This course offers a comprehensive introduction to spreadsheet software, focusing on foundational skills necessary for data organization, analysis, and visualization. Students will learn to input, format, and manage data; construct formulas and functions for calculations; and create charts to represent information effectively. The course also covers essential techniques such as sorting, filtering, and using built-in tools for basic data analysis. By the end of the course, students will be able to confidently use spreadsheets to support academic, personal, and professional tasks.
Recommended Textbook
New Perspectives on Microsoft Excel 2010 Comprehensive 1st Edition by June Jamrich Parsons
Available Study Resources on Quizplus
14 Chapters
2100 Verified Questions
2100 Flashcards
Source URL: https://quizplus.com/study-set/1597 Page 2
Chapter 1: Getting Started With Excel
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31705
Sample Questions
Q1) A text string contains a string of text ____________________.
Answer: characters
Q2) The default column width is 8.43 standard-sized ____.
A) letters
B) pixels
C) characters
D) numbers
Answer: C
Q3) To change the order of operations,enclose part of the formula in ____.
A) brackets
B) italics
C) parentheses
D) quotation marks
Answer: C
Q4) In the formula,=2+6*2,addition would be calculated after multiplication._________________________
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Formatting a Workbook
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31706
Sample Questions
Q1) One of the benefits of conditional ____________________ is that it helps you analyze data by highlighting significant trends in data.
Answer: formatting
Q2) In the above figure,table styles are shown above the following group label: ____.
A) Tools
B) Table Styles
C) Table Style Options
D) External Table Data
Answer: B
Q3) By default,numbers appear in the ____ and generally display values exactly as you type them.
A) Home tab
B) General number format
C) General number toolbar
D) currency format
Answer: B
Q4) ____________________ are the 12 colors that belong to the workbook's theme.
Answer: Theme colors
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: Working With Formulas and Functions
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31707
Sample Questions
Q1) Which category of Excel functions returns information about the format,location,or contents of worksheet cells? ____
A) Location
B) Information
C) Reference
D) Description
Answer: B
Q2) The small black plus sign in the lower-right corner of a selected cell or range is called the ____________________.
Answer: fill handle
Q3) The mode is most often used with data that has only a few possible values,such as the number of bedrooms in a house._________________________
A)True
B)False
Answer: True
Q4) The ____________________ dialog box organizes all of the functions by category and allows you to search for functions that perform particular calculations.
Answer: Insert Function
To view all questions and flashcards with answers, click on the resource link above.
Page 5
Chapter 4: Enhancing a Workbook With Charts and Graphs
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31708
Sample Questions
Q1) Often used to show trends and changes over time
A)Bubble
B)Column
C)XY
D)Line
E)Radar
F)Pie
G)Doughnut
H)Bar
I)Surface
J)Area
K)Stock
L)Scatter
Q2) A chart sheet can contain ____,enabling you to display several charts at once within a single sheet.
A) multiple graphics
B) only one data set
C) only a single chart
D) embedded charts
Q3) ___________________ identify the main units on the chart axis.
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Working With Excel Tables, Pivot-tables, and Pivot-charts
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31709
Sample Questions
Q1) The ____ condition requires that only one of the selected criteria be true for a record to be displayed.
A) NAND
B) OR
C) AND
D) IF
Q2) Press ____ to return to cell A1 in a worksheet.
A) Ctrl+Home
B) Ctrl+Esc
C) F1
D) Alt+Esc
Q3) The ____ criteria filter requires the records displayed to start with the specified text string.
A) Origin
B) Begins With
C) Initial
D) Start
Q4) In addition to data fields,a PivotTable uses ____________________ fields to groups values such as department,model,year,and vehicle type in an automobile-related sheet,for example.
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Managing Multiple Worksheets and Workbooks
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31710
Sample Questions
Q1) The default template contains the default formatting you start out with in every new workbook,including the ____ number format.
A) Number
B) Currency
C) Integer
D) General
Q2) A(n)____________________ is a connection between two files allowing information to be transferred from one file to the other.
Q3) The interface for the Excel Web App is similar to the interface of the full-featured program on your computer;however,only a limited number of ________________ are available.
Q4) When the destination file is closed,and the source files are closed,the complete file path is included as part of the external reference formula that appears in the formula bar._________________________
A)True
B)False
Q5) A 3-D cell ____________________ specifies not only the rows and columns of a cell range,but also the range of worksheet names that the cells appear on.
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Using Advanced Functions and Conditional Formatting
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31711
Sample Questions
Q1) Assuming that G2 contains the value FT and M2 contains the value 2,evaluate the formula and tell what value is returned: =AND(G2="FT",M2>=1).
A) TRUE
B) FALSE
C) PT
D) PT,2
Q2) To change the duplicate values background fill color,in the ____ group on the Home tab,click the Conditional Formatting button,and then click Manage Rules.
A) Format
B) Options
C) Styles
D) Tools
Q3) According to the dialog box in the accompanying figure,the user is not looking for an exact match.
A)True
B)False
Q4) Nesting IF functions will allow for three or more outcomes.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Developing an Excel Application
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31712
Sample Questions
Q1) The least severe error alert is the ____ alert.
A) Stop
B) Security
C) Information
D) Warning
Q2) In the Allow list box in the Data Validation dialog box,the ____ option means that the cell will accept only text of a specified number of characters.
A) Custom
B) Text Length
C) Any Value
D) Specified Text
Q3) Most ____ are not harmful and do not affect data in any way.
A) viruses
B) macro viruses
C) Trojan horses
D) all of the above
Q4) In the Allow list box in the Data Validation dialog box,the ____________________ option means that the cell will accept only dates.
Q5) A digital ____________________ is typically issued by a certificate authority.
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Working With Financial Tools and Functions
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31713
Sample Questions
Q1) FV is used to calculate the ____ of a fund.
A) future value
B) fixed value
C) forecast value
D) first value
Q2) Financial functions format calculated values as currency,with ____.
A) positive cash flow appearing in red font
B) positive cash flow enclosed in parentheses
C) negative cash flow appearing in green font
D) negative cash flow appearing in red font
Q3) The function DDB is used to calculate a declining balance depreciation._________________________
A)True
B)False
Q4) If you don't include an fv value,Excel assumes a future value of 1._________________________
A)True
B)False
Q5) The item marked ____________________ in the accompanying figure is the annual interest rate.
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Performing What-If Analyses
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31714
Sample Questions
Q1) In traditional what-if analysis,you change result values in worksheet cells._________________________
A)True
B)False
Q2) Two-variable data tables are often used to explore the impact of changing two values on a single result.
A)True
B)False
Q3) In the dialog box in the accompanying figure,you select the ____ cell in the By changing cell box.
A) changing
B) result
C) input
D) advance
Q4) The ____________________ input cell is the cell on which you base values placed in the first row of the data table.
Q5) Click the Scenario PivotTable ____________________ option button to create a PivotTable describing the scenarios.
Q6) What are the steps to create a one-variable data table?
Page 12
To view all questions and flashcards with answers, click on the resource link above.
Chapter 11: Connecting to External Data
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31715
Sample Questions
Q1) Microsoft supports a library of built-in Web queries.
A)True
B)False
Q2) Text files are rarely used for storing data.
A)True
B)False
Q3) A question you ask about the data in a database
A)delimiter
B)database
C)record
D)field
E)table
F)query
G)criteria
H)common field
I)element
J)Rich Text
K)data map
L)schema
Q4) A(n)____________________ is a collection of data arranged in rows and columns.
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 12: Expanding Excel With Visual Basic for Applications
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31716
Sample Questions
Q1) A(n)____ is a named element in a program that can be used to store and retrieve information.
A) object
B) component
C) key
D) variable
Q2) If a control structure has more than two possible outcomes,you will have to use a(n)____ control structure.
A) If-Then
B) If-Then-Else
C) If-Then-ElseIf
D) If-Then-If
Q3) ____ errors occur when the program is executing.
A) Syntax
B) Run-time
C) Logical
D) Type-based
Q4) A(n)____________________ is a statement that describes the behavior or purpose of a procedure.
Q5) What are the seven comparison operators in VBA?
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 13: Managing Your Files
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31703
Sample Questions
Q1) ____ makes it easy to navigate from one location to another within the file hierarchy.
A) Microsoft Internet Explorer
B) Windows Explorer
C) The Computer window
D) Folders Manager
Q2) When you start Windows Explorer,it displays the contents of the default ____.
A) search expression
B) drive
C) libraries
D) favorites
Q3) Each part of a file path is separated by a ____.
A) /
B) |
C) \
D) _
Q4) When you compress the folders in a folder,the original folders are stored in the new compressed folder.
A)True
B)False
Page 15
To view all questions and flashcards with answers, click on the resource link above.
Chapter 14: Getting Started With Microsoft Office 2010
Available Study Resources on Quizplus for this Chatper
150 Verified Questions
150 Flashcards
Source URL: https://quizplus.com/quiz/31704
Sample Questions
Q1) The Help system has a(n)Table of Contents pane organized by subjects and topics._________________________
A)True
B)False
Q2) Most often,you'll want to ____________________ the program window and workspace to take advantage of the full screen size you have available.
Q3) A branching tab is a Ribbon tab that contains commands related to the selected object so you can manipulate,edit,and format that object.
A)True
B)False
Q4) ____________________ enable you to quickly access commands that you're most likely to need in the context of the task you're performing without using the tabs on the Ribbon.
Q5) The Return to Default sizing button returns a program window to a predefined size._________________________
A)True
B)False
Q6) You find the Save As command in the ____________________ bar of Backstage view.
To view all questions and flashcards with answers, click on the resource link above. Page 16