BUS 1350 – Exam 2, 2026 – Study guide and practice material
Profit and Loss Statement (P&L) - correct answer ✔✔ Also called an income statement, is a
financial statement summarizing income and expenses incurred during a specified interval. They
are usually released monthly, quarterly, and annually. Useful in tracking expenditures and
locating how the business might be able to operate more efficiently.
Link - correct answer ✔✔ A connection between a source workbook containing the data and
the destination workbook receiving the data.
Source Workbook - correct answer ✔✔ One of the linked workbooks--it contains the data.
Destination Workbook - correct answer ✔✔ The secondary of the linked workbooks--it is the
destination for the data.
Path - correct answer ✔✔ Indicated the location of the file on your computer or network.
Indirect Referencing - correct answer ✔✔ Being able to change a cell reference without having
to rewrite a formula--the range reference itself is a calculated value.
Header Row - correct answer ✔✔ The first row of a data range
Data Definition Table - correct answer ✔✔ It describes each data range, including a list of the
fields in the data range, the type of data stored in each field, and any notes that would assist
others in data entry.
Freeze - correct answer ✔✔ In a pane, the contents are locked on the screen though you can
scroll within it.
Profit and Loss Statement (P&L) - correct answer ✔✔ Also called an income statement, is a
financial statement summarizing income and expenses incurred during a specified interval. They
are usually released monthly, quarterly, and annually. Useful in tracking expenditures and
locating how the business might be able to operate more efficiently.
Link - correct answer ✔✔ A connection between a source workbook containing the data and
the destination workbook receiving the data.
Source Workbook - correct answer ✔✔ One of the linked workbooks--it contains the data.
Destination Workbook - correct answer ✔✔ The secondary of the linked workbooks--it is the
destination for the data.
Path - correct answer ✔✔ Indicated the location of the file on your computer or network.
Indirect Referencing - correct answer ✔✔ Being able to change a cell reference without having
to rewrite a formula--the range reference itself is a calculated value.
Header Row - correct answer ✔✔ The first row of a data range
Data Definition Table - correct answer ✔✔ It describes each data range, including a list of the
fields in the data range, the type of data stored in each field, and any notes that would assist
others in data entry.
Freeze - correct answer ✔✔ In a pane, the contents are locked on the screen though you can
scroll within it.
