VIBS 420 Quiz 5 UPDATED ACTUAL Questions And Correct Answers
Terms in this set (31)
__________ is combinations of values and constants that Formula
define the relationship among spreadsheet cells.
Using the ________ =SUM(B10:B14) totals the contents of cells function
B10 through B14 in a worksheet.
A ___________, such as that in the accompanying figure, line chart
shows a trend during a period of time, as indicated by a
rising or falling line.
T/F T
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.
T/F F
Spreadsheet software is a rarely used type of application
software.
T/F F
All of a worksheet's columns and rows are displayed on
the screen at one time.
T/F F
In a worksheet, the intersection of column B and row 6 is
referred to as cell 6B.
When using spreadsheet software, the rows and columns worksheet
collectively are called a(n) ______ _.
A(n) __________ performs calculations on the data in a formula
worksheet and displays the resulting value in a cell.
A(n) __________ is a predefined formula that performs function
common calculations such as adding the values in a
group of cells.
T/F F
Spreadsheet software's inability to recalculate data makes
it a worthless budgeting, forecasting, and decision
making tool.
Many worksheet cells contain a number that can be used value
in a calculation, called a(n) __ _.
Terms in this set (31)
__________ is combinations of values and constants that Formula
define the relationship among spreadsheet cells.
Using the ________ =SUM(B10:B14) totals the contents of cells function
B10 through B14 in a worksheet.
A ___________, such as that in the accompanying figure, line chart
shows a trend during a period of time, as indicated by a
rising or falling line.
T/F T
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.
T/F F
Spreadsheet software is a rarely used type of application
software.
T/F F
All of a worksheet's columns and rows are displayed on
the screen at one time.
T/F F
In a worksheet, the intersection of column B and row 6 is
referred to as cell 6B.
When using spreadsheet software, the rows and columns worksheet
collectively are called a(n) ______ _.
A(n) __________ performs calculations on the data in a formula
worksheet and displays the resulting value in a cell.
A(n) __________ is a predefined formula that performs function
common calculations such as adding the values in a
group of cells.
T/F F
Spreadsheet software's inability to recalculate data makes
it a worthless budgeting, forecasting, and decision
making tool.
Many worksheet cells contain a number that can be used value
in a calculation, called a(n) __ _.
