Spreadsheet Fundamentals Test Bank
Course Introduction
Spreadsheet Fundamentals introduces students to the essential concepts and skills required to effectively use spreadsheet software such as Microsoft Excel or Google Sheets. The course covers basic operations like data entry, formatting, and cell referencing, as well as foundational techniques for organizing, analyzing, and visualizing data through formulas, functions, charts, and graphs. Students will also explore data management practices, error checking, and the use of templates to streamline tasks. By the end of the course, learners will be equipped to confidently create, modify, and manage spreadsheets for academic, personal, or professional purposes.
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
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(n)____________________ of the original range is placed in the new location without removing the original range from the worksheet.
Answer: copy
Q2) You can move to the previous or next sheet by pressing the ____ keys.
A) Alt + Page Up or Alt + Page Down
B) Ctrl + Page Up or Ctrl + Page Down
C) Tab + Page Up or Tab + Page Down
D) F4 + Page Up or F4 + Page Down
Answer: B
Q3) The formula used to multiply cell A1 by cell C1 is ____.
A) =A1*C1
B) C1*A1
C) =A1/C1
D) A1*C1
Answer: A
Q4) Keyboard ____________________ can help you work faster and more efficiently because you can keep your hands on the keyboard.
Answer: shortcuts
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) The _____ command searches through the current worksheet or workbook for the content or formatting you want to locate.
A) Seek
B) Find
C) Locate
D) Search
Answer: B
Q2) Use the ____________________ button in the Alignment group on the Home tab to increase the size of the indention used in a cell.
Answer: Increase Indent
Q3) By default,Excel displays text in a black font color._________________________
A)True
B)False
Answer: True
Q4) Ten ____________________ colors-dark red,red,orange,yellow,light green,green,light blue,blue,dark blue,and purple-are always available regardless of the workbook's theme.
Answer: standard
To view all questions and flashcards with answers, click on the resource link above. Page 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) Optional arguments are always placed first in the argument list._______________
A)True
B)False
Answer: False
Q2) Use ____ references when you want different formulas to refer to the same cell.
A) mixed
B) relative
C) absolute
D) fixed
Answer: C
Q3) In "SUM(number1 [,number2,number3,...])",number 1,number 2,and number 3 may be numbers or ____.
A) letters
B) cell references
C) symbols
D) operators
Answer: B
Q4) A(n)____________________ function is a function that works with statements that are either true or false.
Page 5
Answer: logical
To view all questions and flashcards with answers, click on the resource link above.
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) A chart that combines two or more chart types into a single graph is called a(n)____________________ chart.
Q2) Each data source is a collection of ____________________,which is a range of values plotted as a single unit on a chart.
Q3) The _______ displays the data series in separate columns side-by-side so that you can compare the relative heights of the columns in the three series.
A) clustered column chart
B) stacked column chart
C) 100% stacked column chart
D) column chart
Q4) In the figure above,fv and type are ____.
A) financial functions
B) required arguments
C) comparison operators
D) optional arguments
Q5) A(n)____________________ chart shows patterns or relationships between two or more sets of values,much like an XY chart,except the size of the data marker is determined by a third value.
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) You can drag one field to the Filters area of the PivotTable Fields pane to change what values are displayed in the PivotTable.
A)True
B)False
Q2) Which of the following is true about Excel tables (as opposed to structured ranges of data)?
A) You cannot format quickly using a table style.
B) You cannot enter a formula in one table cell that is automatically copied to all other cells in that table column.
C) You cannot add new rows and columns that automatically expand the range.
D) You cannot freeze the top row of the worksheet.
Q3) You cannot change data directly in the PivotTable.Instead,you must edit the Excel table,and then ____,or update,the PivotTable to reflect the updated data.
A) reset
B) refresh
C) renew
D) change
Q4) The entry 20000 is the ____________________ for the first condition.
Page 7
To view all questions and flashcards with answers, click on the resource link above.
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) A workbook based on a specific template always displays the name of the template followed by the date.
A)True
B)False
Q2) Formulas created using the point-and-click method contain ____ references.
A) absolute
B) mixed
C) relative
D) relational
Q3) If the destination file is closed when you make a change in the source file,you choose whether to update the link to display the current values when you open the destination file or continue to display the older values from the destination file.
A)True
B)False
Q4) Using multiple worksheets makes it more difficult for you to group your data.
A)True
B)False
Q5) ____________________ appear whenever you place the pointer over a hyperlink.
To view all questions and flashcards with answers, click on the resource link above. Page 8
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) Validation rules come into play only during data entry.
A)True
B)False
Q2) Range names must begin with _____.
A) a letter or an underscore
B) a number
C) a hash tag
D) an asterisk
Q3) When Excel creates a macro button,the Assign Macro dialog box opens with the button's default name showing._________________________
A)True
B)False
Q4) When you ____________________ a workbook,you control the ability users have to make changes to the file.
Q5) _____ messages appear as ScreenTips next to the active cell.
A) Value
B) Input
C) Key
D) User
Q6) Input messages appear as ____________________ next to the active cell.
Page 9
To view all questions and flashcards with answers, click on the resource link above.
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 implement the VLOOKUP formula at your colleague's suggestion,but you get the #VALUE! error as the result of the formula.Which of the following is likely true?
A) You might have entered a table name for the table_array value instead of the cell reference of the lookup table.
B) You might have indicated that the compare values are a range of values instead of an exact match.
C) You might have entered a number for the col_index_num instead of a letter.
D) You might have entered a letter for the col_index_num instead of a number.
Q2) On a lark,for a year-end trivia contest,your boss wants you to calculate the length of service in complete days.What is the correct formula?
A) =DATEDIF(C2, $AE$2, "today")
B) =DATEDIF($AE$2, C2, "dy")
C) =DATEDIF($AE$2, C2, "day")
D) =DATEDIF(C2, $AE$2, "d")
Q3) The ____________________ function is used to change the orientation of a range-that is,return a vertical range of cells as a horizontal range,or vice versa.
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) If in Charles's sheet,cell A4 is a precedent cell for cell B7,what kind of a cell is B7?
A) contingent cell
B) dependent cell
C) antecedent cell
D) indicated cell
Q2) In a(n)_______ trend,the values change by a constant amount.
A) linear
B) growth
C) periodic
D) orthogonal
Q3) Which of the following shows the syntax of the NPER function?
A) =NPER(pmt, pv, [fv=0], [type=0])
B) =NPER(rate, pmt, [fv=0], [type=0])
C) =NPER(rate, pmt, pv [, fv=0] [, type=0])
D) =NPER(pmt, rate, pv, [fv=0], [type=0])
Q4) The tracer arrow provides a visual clue to the source of the error.
A)True
B)False
Q5) How do you determine which method of depreciation is most appropriate?
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) You can switch from one scenario to another by clicking the _______ button in the Scenario Manager dialog box.
A) Display
B) View
C) Show
D) Effect
Q2) Searches for the optimal solution of a problem involving several variables
A)Solver
B)changing
C)constraint
D)add-in
E)answer report
F)nonbinding
G)Goal Seek
H)slack
I)limits report
J)result
Q3) CVP analysis is sometimes called breakthrough analysis._________________________
A)True
B)False
Page 12
To view all questions and flashcards with answers, click on the resource link above.
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) Power Map is an add-in that presents data geographically on a virtual 3-D globe.
A)True
B)False
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 data connection is like a pipeline from a data source to two or more locations in the workbook.
A)True
B)False
Q4) Columns in delimited text files are always vertically aligned as they would be in a spreadsheet.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above.
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) _______ displays an object in the destination file,but only stores the location of the source file.
A) Copy and Paste
B) Linking
C) Embedding
D) Inserting
Q2) Marking a workbook as final makes the workbook _______,discouraging a user from making any changes to it.
A) write-only
B) read-only
C) locked
D) protected
Q3) Shared workbooks are usually stored in shared folders located on either a local network or the _______.
A) sky
B) cloud
C) external drive
D) satellite
Q4) Describe the steps to review tracked changes in a shared workbook.
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) Another work for edit is clean or:
A) Wipe
B) Wash
C) Scrub
D) Polish
Q2) Text contains one or more characters and can include:
A) Spacers
B) Symbols
C) Numbers
D) All of the above
Q3) This symbol displays days as Sun through Sat:
A) d
B) dd
C) ddd
D) dddd
Q4) To have access to all the latest features and tools in Excel 2016,you must convert the workbook to the current file format,which has the .xlsx file extension.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 15