BUS 1350 – Final Exam (Old Tests), 2026 – Review and practice
material
formulas and functions begin with an ____ sign - correct answer ✔✔ =
which of the following is NOT a type of data that can be contained in a cell
a. formulas
b. functions
c. text
d. recordings - correct answer ✔✔ d. recordings
In a worksheet, the keyboard shortcut to move to cell A1 is - correct answer ✔✔ Ctrl + Home
The base date for serial date and time data in Excel 2019 is ________. - correct answer ✔✔
January 1, 1900
Which of the following data types is NOT automatically right-aligned by Excel?
a. numberic
b. date
c. text
d. time - correct answer ✔✔ c. text
The keyboard shortcut for Undo is ________. - correct answer ✔✔ Ctrl Z
To insert a line break or hard return in a cell, you would press ________. - correct answer ✔✔
ALT + ENTER
,If a numerical value is too narrow to be displayed in a cell, a series of ________ characters is
displayed. - correct answer ✔✔ #
active worksheet - correct answer ✔✔ Tab has a white background with bold letters and a thick
bottom border
workbook - correct answer ✔✔ An Excel file that contains one or more worksheets
active cell - correct answer ✔✔ Identified by the thick green border
cell reference - correct answer ✔✔ A reference within a formula or function instead of a value
keyboard shortcut - correct answer ✔✔ Eliminates the need to use a mouse
When applying a fill color, it is best practice to use ________ colors. - correct answer ✔✔ muted
or pastel
Which of the following is NOT true about formatting worksheets? - correct answer ✔✔
background colors should be bright colors
________ can set the font, font size and color, number format, background color, borders, and
alignment. - correct answer ✔✔ a built-in cell style
All of the following are valid cell ranges EXCEPT:
a. A1:B3
b. 12E
c. C2
d. C1:C25 - correct answer ✔✔ b. 12E
, A(n) ________ cell reference is the default reference in a formula to a cell address will
automatically adjust when the formula is copied or extended to other cells. - correct answer
✔✔ relative
Which of the following is NOT true about working with formulas?
a. OptionIn Excel, formulas always begin with an equal sign.
b. When a formula that contains cell references is copied to another cell, the cell reference will
change to reflect the destination cell relative to the original cell.
c. To copy a formula and not change relative references, select the formula in the formula bar,
click Shift + Esc, select the destination cell, and then click Insert.
d. Cells that contain formulas can be treated like any other worksheet cell. - correct answer ✔✔
c. To copy a formula and not change relative references, select the formula in the formula bar,
click Shift + Esc, select the destination cell, and then click Insert.
If you want to see how many cells in a specified range contain numbers, you would use the
________ function. - correct answer ✔✔ count
________ formatting is a way to dynamically change the visual presentation of information in a
manner that adds information to the worksheet. - correct answer ✔✔ conditional
Accounting format - correct answer ✔✔ DOLLAR SIGN IS ON THE OUTSIDE FURTHER AWAY
function - correct answer ✔✔ Built-in program that performs operations on data
argument - correct answer ✔✔ Variables or values a function requires in order to calculate a
solution
material
formulas and functions begin with an ____ sign - correct answer ✔✔ =
which of the following is NOT a type of data that can be contained in a cell
a. formulas
b. functions
c. text
d. recordings - correct answer ✔✔ d. recordings
In a worksheet, the keyboard shortcut to move to cell A1 is - correct answer ✔✔ Ctrl + Home
The base date for serial date and time data in Excel 2019 is ________. - correct answer ✔✔
January 1, 1900
Which of the following data types is NOT automatically right-aligned by Excel?
a. numberic
b. date
c. text
d. time - correct answer ✔✔ c. text
The keyboard shortcut for Undo is ________. - correct answer ✔✔ Ctrl Z
To insert a line break or hard return in a cell, you would press ________. - correct answer ✔✔
ALT + ENTER
,If a numerical value is too narrow to be displayed in a cell, a series of ________ characters is
displayed. - correct answer ✔✔ #
active worksheet - correct answer ✔✔ Tab has a white background with bold letters and a thick
bottom border
workbook - correct answer ✔✔ An Excel file that contains one or more worksheets
active cell - correct answer ✔✔ Identified by the thick green border
cell reference - correct answer ✔✔ A reference within a formula or function instead of a value
keyboard shortcut - correct answer ✔✔ Eliminates the need to use a mouse
When applying a fill color, it is best practice to use ________ colors. - correct answer ✔✔ muted
or pastel
Which of the following is NOT true about formatting worksheets? - correct answer ✔✔
background colors should be bright colors
________ can set the font, font size and color, number format, background color, borders, and
alignment. - correct answer ✔✔ a built-in cell style
All of the following are valid cell ranges EXCEPT:
a. A1:B3
b. 12E
c. C2
d. C1:C25 - correct answer ✔✔ b. 12E
, A(n) ________ cell reference is the default reference in a formula to a cell address will
automatically adjust when the formula is copied or extended to other cells. - correct answer
✔✔ relative
Which of the following is NOT true about working with formulas?
a. OptionIn Excel, formulas always begin with an equal sign.
b. When a formula that contains cell references is copied to another cell, the cell reference will
change to reflect the destination cell relative to the original cell.
c. To copy a formula and not change relative references, select the formula in the formula bar,
click Shift + Esc, select the destination cell, and then click Insert.
d. Cells that contain formulas can be treated like any other worksheet cell. - correct answer ✔✔
c. To copy a formula and not change relative references, select the formula in the formula bar,
click Shift + Esc, select the destination cell, and then click Insert.
If you want to see how many cells in a specified range contain numbers, you would use the
________ function. - correct answer ✔✔ count
________ formatting is a way to dynamically change the visual presentation of information in a
manner that adds information to the worksheet. - correct answer ✔✔ conditional
Accounting format - correct answer ✔✔ DOLLAR SIGN IS ON THE OUTSIDE FURTHER AWAY
function - correct answer ✔✔ Built-in program that performs operations on data
argument - correct answer ✔✔ Variables or values a function requires in order to calculate a
solution
