Introduction to Spreadsheets
Final Exam Questions
Course Introduction
Introduction to Spreadsheets provides students with foundational skills in creating, managing, and utilizing spreadsheet software such as Microsoft Excel or Google Sheets. The course covers essential concepts including data entry, formatting, formula creation, and basic functions for calculations. Students will also learn to organize, analyze, and visualize data using charts, sorting, and filtering tools. By the end of the course, learners will be equipped to apply spreadsheet tools to solve real-world problems, make informed decisions, and efficiently manage data in academic, professional, or personal contexts.
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) A group of worksheet cells
A)function
B)Name box
C)worksheet
D)range
E)order of operations
F)sheet tabs
G)Ctrl
H)Normal view
I)minimize button
J)template
Answer: D
Q2) The ____________________ function will not include any cell in the range containing a non-numeric value in the final tally.
Answer: COUNT
Q3) An adjacent range is a collection of separate ranges._________________________
A)True
B)False
Answer: False
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) Changing the number of decimal places displayed in a cell does not change the value stored in the cell._________________________
A)True
B)False
Answer: True
Q2) The appearance of non-theme fonts,colors,and effects remains unchanged no matter which theme is applied to the workbook._________________________ A)True
B)False
Answer: True
Q3) If you want to print only part of a worksheet,you can set a print area,which is the region of the worksheet that is sent to the printer._________________________ A)True
B)False
Answer: True
Q4) 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.
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 Insert Function button is in the ____ group.
A) Calculation
B) Function Library
C) Sort & Filter
D) Home
Answer: B
Q2) The Fill Formatting Only option,which is the default,copies both the content and the formatting.______________
A)True
B)False
Answer: False
Q3) A(n)____________________ reference contains both relative and absolute references.
Answer: mixed
Q4) A constant is a value in a formula that doesn't change._______________
A)True
B)False
Answer: True
Q5) 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) Each data source is a collection of ____________________,which is a range of values plotted as a single unit on a chart.
Q2) The ____ identifies which data markers are associated with each data series.
A) x-axis
B) y-axis
C) chart area
D) legend
Q3) When you create sparklines,clicking any cell in the data range selects all of the sparklines in the group._________________________
A)True
B)False
Q4) Edward Tufte was concerned with what he termed as "chart ____," in which a proliferation of chart elements-chosen because they look "nice"-confuse and distract the reader.
A) espionage
B) clutter
C) confusion
D) junk
Q5) An _______ chart takes up less space than a chart sheet.
To view all questions and flashcards with answers, click on the resource link above. Page 6
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) The ____ criteria filter requires the records displayed to be since January 1 of the current year to the current date.
A) Year to Date
B) Today
C) Current
D) none of the above
Q2) In Excel,a table is a range of related data that is managed independently from the data in other ____ in the worksheet.
A) rows and headers
B) grids and columns
C) rows and columns
D) footers and grids
Q3) By default,the PivotTable report uses the ____ function for numbers in the Values area.
A) COUNT
B) AVERAGE
C) MIN
D) SUM
Q4) The second sort field in a sort is called the ____________________ field.
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
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43589
Sample Questions
Q1) Receives the information when two files are linked
A)3-D
B)hyperlink
C)worksheet group
D)source
E)destination
F)link
Q2) What are the steps to inserting a hyperlink and linking to: a file or Web page,a location in the current workbook,a new document,and an e-mail address.
Q3) Simon tells Brooke that when he attempts to open a workbook,the Edit Links dialog box appears with the message "This workbook contains one or more links that cannot be updated." Brooke suggests several possible causes of this error message.Which of the following is a possible cause?
A) one of the workbook's source files was edited
B) one of the workbook's source files was copied to a different folder
C) one of the workbook's source files was replaced with an updated file of the same name
D) the workbook was sent to him without links
Q4) ____________________ appear whenever you place the pointer over a hyperlink.
Page 8
To view all questions and flashcards with answers, click on the resource link above.
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) Every cell in a workbook has a(n)_____ property that determines whether or not changes can be made to that cell.
A) ensured
B) locked
C) security
D) changeable
Q2) One way to run a macro is to assign it to a(n)button that is placed directly on the worksheet._________________________
A)True
B)False
Q3) Input messages appear as ____________________ next to the active cell.
Q4) For cell and range names,names of 5 to 15 characters are considered practical,although names can be up to 255 characters.
A)True
B)False
Q5) A protected sheet can always be unprotected,but you can also require users to enter a(n)____________________ before the protection is removed.
To view all questions and flashcards with answers, click on the resource link above. Page 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) You cannot nest more than one IF function to test for multiple outcomes._________________________
A)True
B)False
Q2) What value is returned assuming that G2 contains the value PT and M2 contains the value 2?
A) TRUE
B) FALSE
C) PT
D) PT, 2
Q3) For a separate service recognition program,you need to calculate the length of service in complete years.What is the correct formula?
A) =DATEDIF(C2, $AE$2, "yr")
B) =DATEDIF($AE$2, C2, "year")
C) =DATEDIF($AE$2, C2, "yr")
D) =DATEDIF(C2, $AE$2, "y")
Q4) The ____________________ function searches vertically down a lookup table and is used when the compare values are stored in the first column of the lookup table.
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) Describe the steps to interpolate a series of values between starting and ending values.
Q2) Calculates the payment in each period required to pay off a loan or reach an investment goal
A)PPMT function
B)rate of return
C)IPMT function
D)IRR
E)PV function
F)RATE function
G)PMT function
H)XIRR function
I)FV function
J)NPER function
Q3) A(n)_______ arrow provides a visual clue to the relationship between two cells by pointing from the precedent cell to the dependent cell.
A) tracer
B) outline
C) index
D) key
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
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43593
Sample Questions
Q1) What are the steps to create a one-variable data table?
Q2) A(n)optimal cell is a cell that Excel changes to produce the desired result in the target cell._________________________
A)True
B)False
Q3) The result cells are the cells containing the values you want to examine._________________________
A)True
B)False
Q4) To select nonadjacent changing cells,press and hold the _______ key as you click each cell.
A) Alt
B) Shift
C) Esc
D) Ctrl
Q5) All three expense types can be classified as _______.
A) mixed, fixed, and CVP
B) variable, fixed, and mixed
C) asset-based, fixed, and mixed
D) variable, fixed, and cost-based
To view all questions and flashcards with answers, click on the resource link above. Page 12
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) The Query Editor also includes tools to:
A) create new columns
B) group data values
C) calculate summary statistics
D) All of the above
Q2) The _______ is part of an OLAP (Online Analytic Processing)database,built to optimize structured data for querying and reporting.
A) Data Cube
B) Data Model
C) Encryption Source
D) Exponential Trendline
Q3) A text file contains only text and numbers without any formulas,special fonts,graphics,or formatted text.
A)True
B)False
Q4) The connection between a workbook and a data source can be lost when one or the other is moved to a new location.
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) Explain which of the following screen elements are part of the Excel window,the workbook window,and the worksheet: formula bar,ScreenTips,chart element names on hover,horizontal and vertical scroll bars,row and column headers,sheet tabs,and gridlines.
Q2) Stored within the destination file and remains connected to the source file
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
Q3) The running conversation among users about a cell is displayed within a(n)double comment box connected to that cell._________________________
A)True
B)False
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 separate data with a:
A) Tab
B) Semicolon or comma
C) Space
D) All of the above
Q2) This symbol displays days as Sun through Sat:
A) d
B) dd
C) ddd
D) dddd
Q3) This symbol displays Months as 1 through 12:
A) m
B) mm
C) mmm
D) mmmm
Q4) The Trim function removes all characters from a string except for single spaces between words.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 15