1
VIBS 420 Quiz 5 Questions with Correct
Answers | Updated (100% Correct Answers)
__________ is combinations of values and constants that define the
relationship among spreadsheet cells. Answer: Formula
Using the ________ =SUM(B10:B14) totals the contents of cells B10
through B14 in a worksheet. Answer: 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.
Answer: 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. Answer: T
T/F
Spreadsheet software is a rarely used type of application software.
Answer: F
T/F
All of a worksheet's columns and rows are displayed on the screen
at one time. Answer: F
© 2025 All rights reserved
, 2
T/F
In a worksheet, the intersection of column B and row 6 is referred
to as cell 6B. Answer: F
When using spreadsheet software, the rows and columns collectively
are called a(n) ___________. Answer: worksheet
A(n) __________ performs calculations on the data in a worksheet and
displays the resulting value in a cell. Answer: formula
A(n) __________ is a predefined formula that performs common
calculations such as adding the values in a group of cells. Answer:
function
T/F
Spreadsheet software's inability to recalculate data makes it a
worthless budgeting, forecasting, and decision making tool. Answer:
F
Many worksheet cells contain a number that can be used in a
calculation, called a(n) _______. Answer: value
A(n) ____ is the intersection of a column and row in a worksheet.
Answer: cell
The text, or ______, entered into a cell identifies the worksheet data
and helps organize the worksheet. Answer: label
© 2025 All rights reserved
VIBS 420 Quiz 5 Questions with Correct
Answers | Updated (100% Correct Answers)
__________ is combinations of values and constants that define the
relationship among spreadsheet cells. Answer: Formula
Using the ________ =SUM(B10:B14) totals the contents of cells B10
through B14 in a worksheet. Answer: 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.
Answer: 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. Answer: T
T/F
Spreadsheet software is a rarely used type of application software.
Answer: F
T/F
All of a worksheet's columns and rows are displayed on the screen
at one time. Answer: F
© 2025 All rights reserved
, 2
T/F
In a worksheet, the intersection of column B and row 6 is referred
to as cell 6B. Answer: F
When using spreadsheet software, the rows and columns collectively
are called a(n) ___________. Answer: worksheet
A(n) __________ performs calculations on the data in a worksheet and
displays the resulting value in a cell. Answer: formula
A(n) __________ is a predefined formula that performs common
calculations such as adding the values in a group of cells. Answer:
function
T/F
Spreadsheet software's inability to recalculate data makes it a
worthless budgeting, forecasting, and decision making tool. Answer:
F
Many worksheet cells contain a number that can be used in a
calculation, called a(n) _______. Answer: value
A(n) ____ is the intersection of a column and row in a worksheet.
Answer: cell
The text, or ______, entered into a cell identifies the worksheet data
and helps organize the worksheet. Answer: label
© 2025 All rights reserved
