BUS 1350 – Final Exam, Erica Ancira, Baylor University, 2026 – Comprehensive review and
practice material
What is a spreadsheet? - correct answer ✔✔ A collection of data that is organized in a row and
column format
What is a worksheet? - correct answer ✔✔ A single spreadsheet where there are a grid of
columns and rows
What is a cell? - correct answer ✔✔ The intersection of columns and rows in which data is
entered
What is a row? - correct answer ✔✔ A horizontal set of cells that encompasses all the columns
in a worksheet
What is a column? - correct answer ✔✔ A vertical set of cells that encompasses all the rows in a
worksheet
What is a formula? - correct answer ✔✔ A mathematical equation that produces a result and
may contain numbers, operators, text, and/or functions
What is a function? - correct answer ✔✔ A built-in program that performs a task such as
calculating a sum or average
What is the What-if analysis tool? - correct answer ✔✔ Allows one to examine the outcome of
the changes to values in a worksheet
What is a record? - correct answer ✔✔ All of the categories of data that pertain to one person,
place, thing, event, or idea and are formatted as a row in a worksheet.
,What is a field? - correct answer ✔✔ An item of information in a worksheet column that is
associated with something of interest
What is a workbook? - correct answer ✔✔ A file that contains one or more worksheets
How many cells are in an Excel worksheet? - correct answer ✔✔ 17,179,869,184
What is a cell reference? - correct answer ✔✔ A cell or range of cells within a formula or
function instead of a value
What is the keyboard shortcut for moving the active cell down one row? - correct answer ✔✔
"Enter"
What is the keyboard shortcut for moving the active cell up one row? - correct answer ✔✔
"Shift" + "Enter"
What is the keyboard shortcut for moving the active cell to column A of the current row? -
correct answer ✔✔ "Home"
What is the keyboard shortcut for moving the active cell to the last cell of the row that contains
data? - correct answer ✔✔ "End"
What is the keyboard shortcut for moving the active cell to A1? - correct answer ✔✔ "Ctrl" +
"Home"
What is the keyboard shortcut for moving to the last cell, highest # row and far right column
that contains information? - correct answer ✔✔ "Ctrl" + "End"
,What is the keyboard shortcut for moving up one screen? - correct answer ✔✔ "PgUp"
What is the keyboard shortcut for moving down one screen? - correct answer ✔✔ "PgDn"
What is the keyboard shortcut for moving left one screen? - correct answer ✔✔ "Alt" + "PgUp"
What is the keyboard shortcut for moving right one screen? - correct answer ✔✔ "Alt" + "PgDn"
What is the keyboard shortcut for moving one worksheet left? - correct answer ✔✔ "Ctrl" +
"PgUp"
What is the keyboard shortcut for moving one worksheet right? - correct answer ✔✔ "Ctrl" +
"PgDn"
What is the keyboard shortcut for moving one column right? - correct answer ✔✔ "Tab"
What is the keyboard shortcut for moving one column left? - correct answer ✔✔ "Shift" + "Tab"
When is the "Go To" button useful? - correct answer ✔✔ When navigating within large
worksheets
What is the keyboard shortcut for bolding a cell? - correct answer ✔✔ "Ctrl" + "B"
What is a cell note? - correct answer ✔✔ A text box, like a sticky note that is attached to a cell in
a worksheet
What does a cell comment do? - correct answer ✔✔ Allows for threaded discussions withing a
workbook cell
, What is the keyboard shortcut for placing the insertion point into cell contents? (being able to
type in the cell) - correct answer ✔✔ "F2"
What is text data? - correct answer ✔✔ Consists of any combination of printable characters
What is the default alignment for text data? - correct answer ✔✔ Left
What is numeric data? - correct answer ✔✔ Consists of numbers (0-9) in any form not
combined with letters and special characters such as the period and/or hyphen.
What is data data? - correct answer ✔✔ Takes the form of a serial number with 1 representing
Jan 1, 1900
What is time data? - correct answer ✔✔ Represented as a decimal value where .1 is 144
minutes, .01 is 14.4 minutes, and so on
What is the default alignment for time data? - correct answer ✔✔ Left
What is the keyboard shortcut to insert a line break? - correct answer ✔✔ "Alt" + "Enter"
What is a cell range? - correct answer ✔✔ Cells in the worksheet that have been selected
What is a contiguous cell range? - correct answer ✔✔ Consists of multiple selected cells, all
direclty adjacent to one another
What is a noncontiguous cell range? - correct answer ✔✔ Consists of multiple selected cells
with at least one cell not directly adjacent to other cells
practice material
What is a spreadsheet? - correct answer ✔✔ A collection of data that is organized in a row and
column format
What is a worksheet? - correct answer ✔✔ A single spreadsheet where there are a grid of
columns and rows
What is a cell? - correct answer ✔✔ The intersection of columns and rows in which data is
entered
What is a row? - correct answer ✔✔ A horizontal set of cells that encompasses all the columns
in a worksheet
What is a column? - correct answer ✔✔ A vertical set of cells that encompasses all the rows in a
worksheet
What is a formula? - correct answer ✔✔ A mathematical equation that produces a result and
may contain numbers, operators, text, and/or functions
What is a function? - correct answer ✔✔ A built-in program that performs a task such as
calculating a sum or average
What is the What-if analysis tool? - correct answer ✔✔ Allows one to examine the outcome of
the changes to values in a worksheet
What is a record? - correct answer ✔✔ All of the categories of data that pertain to one person,
place, thing, event, or idea and are formatted as a row in a worksheet.
,What is a field? - correct answer ✔✔ An item of information in a worksheet column that is
associated with something of interest
What is a workbook? - correct answer ✔✔ A file that contains one or more worksheets
How many cells are in an Excel worksheet? - correct answer ✔✔ 17,179,869,184
What is a cell reference? - correct answer ✔✔ A cell or range of cells within a formula or
function instead of a value
What is the keyboard shortcut for moving the active cell down one row? - correct answer ✔✔
"Enter"
What is the keyboard shortcut for moving the active cell up one row? - correct answer ✔✔
"Shift" + "Enter"
What is the keyboard shortcut for moving the active cell to column A of the current row? -
correct answer ✔✔ "Home"
What is the keyboard shortcut for moving the active cell to the last cell of the row that contains
data? - correct answer ✔✔ "End"
What is the keyboard shortcut for moving the active cell to A1? - correct answer ✔✔ "Ctrl" +
"Home"
What is the keyboard shortcut for moving to the last cell, highest # row and far right column
that contains information? - correct answer ✔✔ "Ctrl" + "End"
,What is the keyboard shortcut for moving up one screen? - correct answer ✔✔ "PgUp"
What is the keyboard shortcut for moving down one screen? - correct answer ✔✔ "PgDn"
What is the keyboard shortcut for moving left one screen? - correct answer ✔✔ "Alt" + "PgUp"
What is the keyboard shortcut for moving right one screen? - correct answer ✔✔ "Alt" + "PgDn"
What is the keyboard shortcut for moving one worksheet left? - correct answer ✔✔ "Ctrl" +
"PgUp"
What is the keyboard shortcut for moving one worksheet right? - correct answer ✔✔ "Ctrl" +
"PgDn"
What is the keyboard shortcut for moving one column right? - correct answer ✔✔ "Tab"
What is the keyboard shortcut for moving one column left? - correct answer ✔✔ "Shift" + "Tab"
When is the "Go To" button useful? - correct answer ✔✔ When navigating within large
worksheets
What is the keyboard shortcut for bolding a cell? - correct answer ✔✔ "Ctrl" + "B"
What is a cell note? - correct answer ✔✔ A text box, like a sticky note that is attached to a cell in
a worksheet
What does a cell comment do? - correct answer ✔✔ Allows for threaded discussions withing a
workbook cell
, What is the keyboard shortcut for placing the insertion point into cell contents? (being able to
type in the cell) - correct answer ✔✔ "F2"
What is text data? - correct answer ✔✔ Consists of any combination of printable characters
What is the default alignment for text data? - correct answer ✔✔ Left
What is numeric data? - correct answer ✔✔ Consists of numbers (0-9) in any form not
combined with letters and special characters such as the period and/or hyphen.
What is data data? - correct answer ✔✔ Takes the form of a serial number with 1 representing
Jan 1, 1900
What is time data? - correct answer ✔✔ Represented as a decimal value where .1 is 144
minutes, .01 is 14.4 minutes, and so on
What is the default alignment for time data? - correct answer ✔✔ Left
What is the keyboard shortcut to insert a line break? - correct answer ✔✔ "Alt" + "Enter"
What is a cell range? - correct answer ✔✔ Cells in the worksheet that have been selected
What is a contiguous cell range? - correct answer ✔✔ Consists of multiple selected cells, all
direclty adjacent to one another
What is a noncontiguous cell range? - correct answer ✔✔ Consists of multiple selected cells
with at least one cell not directly adjacent to other cells
