VIBS 420 Quiz 5 Questions with Correct Answers Latest Update 2025/2026
__________ is combinations of values and constants that define the relationship among
spreadsheet cells. - Answers Formula
Using the ________ =SUM(B10:B14) totals the contents of cells B10 through B14 in a worksheet.
- Answers function
A ___________, such as that in the accompanying figure, shows a trend during a period of time, as
indicated by a rising or falling line. - Answers line chart
T/F
Because of the logical approach that spreadsheet software has for organizing data, many
people use this software to organize and present non-financial data, as well as financial data. -
Answers T
T/F
Spreadsheet software is a rarely used type of application software. - Answers F
T/F
All of a worksheet's columns and rows are displayed on the screen at one time. - Answers F
T/F
In a worksheet, the intersection of column B and row 6 is referred to as cell 6B. - Answers F
When using spreadsheet software, the rows and columns collectively are called a(n) ___________.
- Answers worksheet
A(n) __________ performs calculations on the data in a worksheet and displays the resulting
value in a cell. - Answers formula
A(n) __________ is a predefined formula that performs common calculations such as adding the
values in a group of cells. - Answers function
T/F
Spreadsheet software's inability to recalculate data makes it a worthless budgeting, forecasting,
and decision making tool. - Answers F
Many worksheet cells contain a number that can be used in a calculation, called a(n) _______. -
Answers value
A(n) ____ is the intersection of a column and row in a worksheet. - Answers cell
__________ is combinations of values and constants that define the relationship among
spreadsheet cells. - Answers Formula
Using the ________ =SUM(B10:B14) totals the contents of cells B10 through B14 in a worksheet.
- Answers function
A ___________, such as that in the accompanying figure, shows a trend during a period of time, as
indicated by a rising or falling line. - Answers line chart
T/F
Because of the logical approach that spreadsheet software has for organizing data, many
people use this software to organize and present non-financial data, as well as financial data. -
Answers T
T/F
Spreadsheet software is a rarely used type of application software. - Answers F
T/F
All of a worksheet's columns and rows are displayed on the screen at one time. - Answers F
T/F
In a worksheet, the intersection of column B and row 6 is referred to as cell 6B. - Answers F
When using spreadsheet software, the rows and columns collectively are called a(n) ___________.
- Answers worksheet
A(n) __________ performs calculations on the data in a worksheet and displays the resulting
value in a cell. - Answers formula
A(n) __________ is a predefined formula that performs common calculations such as adding the
values in a group of cells. - Answers function
T/F
Spreadsheet software's inability to recalculate data makes it a worthless budgeting, forecasting,
and decision making tool. - Answers F
Many worksheet cells contain a number that can be used in a calculation, called a(n) _______. -
Answers value
A(n) ____ is the intersection of a column and row in a worksheet. - Answers cell
