CIS 105 Excel Exam
Verified Exam Questions and Answers Latest update 2026/2027
Question:
workbook -
Answer:
an excel file which is a collection of worksheets
also known as a "sheet"; made up of rows & columns of data on which you can perform
calculations
Question:
worksheet -
Answer:
electronic ledger in which you enter data
appears as a grid where you enter & then manipulate data using functions, formatting, &
formulas
Question:
row -
Answer:
a horizontal group of cells in a worksheet identified by
numbers
Question:
column -
Answer:
a vertical group of cells identified by letters
Question:
cell -
Answer:
the intersection of a column & a row
Question:
cell address -
,Answer:
the column and row position that defines a cell
ex. column b, row 4= B4
Question:
cell range -
Answer:
a contiguous group of cells
identified by the address of the cell in the upper left corner of the range followed by a colon, and
then address of cell in the lower right corner
Question:
formula bar -
Answer:
data entry area directly below the ribbon & above
worksheet grid
Question:
insert function button -
Answer:
located on left side of formula bar;
designed to make it easier to create complex formulas
Question:
name box -
Answer:
this appears at the left side of the formula bar &
displays address of selected cell
Question:
status bar -
Answer:
appears at the bottom of the worksheet grid & can
display info about the selected data, including the number of cells selected that contain data
(count) & average / sum (total) of selected values
Question:
vertical scroll bar -
, Answer:
scrollbar located along right side of the
window
click arrows at the ends of the scroll bars to move up & down to see more cells in an individual
worksheet
Question:
horizontal scroll bar -
Answer:
scrollbar located at the bottom of the
window
click arrows at the ends of the scroll bars to move left & right to see more cells in an individual
worksheet
Question:
row selector -
Answer:
box with the row number at the left side of the
worksheet grid; clicking this box will select the entire row
Question:
column selector -
Answer:
box with the column letter at the top of the
worksheet grid; clicking this box will select the entire column
Question:
internet
email messages
network locations -
Answer:
potential unsafe locations include?
Question:
message bar -
Verified Exam Questions and Answers Latest update 2026/2027
Question:
workbook -
Answer:
an excel file which is a collection of worksheets
also known as a "sheet"; made up of rows & columns of data on which you can perform
calculations
Question:
worksheet -
Answer:
electronic ledger in which you enter data
appears as a grid where you enter & then manipulate data using functions, formatting, &
formulas
Question:
row -
Answer:
a horizontal group of cells in a worksheet identified by
numbers
Question:
column -
Answer:
a vertical group of cells identified by letters
Question:
cell -
Answer:
the intersection of a column & a row
Question:
cell address -
,Answer:
the column and row position that defines a cell
ex. column b, row 4= B4
Question:
cell range -
Answer:
a contiguous group of cells
identified by the address of the cell in the upper left corner of the range followed by a colon, and
then address of cell in the lower right corner
Question:
formula bar -
Answer:
data entry area directly below the ribbon & above
worksheet grid
Question:
insert function button -
Answer:
located on left side of formula bar;
designed to make it easier to create complex formulas
Question:
name box -
Answer:
this appears at the left side of the formula bar &
displays address of selected cell
Question:
status bar -
Answer:
appears at the bottom of the worksheet grid & can
display info about the selected data, including the number of cells selected that contain data
(count) & average / sum (total) of selected values
Question:
vertical scroll bar -
, Answer:
scrollbar located along right side of the
window
click arrows at the ends of the scroll bars to move up & down to see more cells in an individual
worksheet
Question:
horizontal scroll bar -
Answer:
scrollbar located at the bottom of the
window
click arrows at the ends of the scroll bars to move left & right to see more cells in an individual
worksheet
Question:
row selector -
Answer:
box with the row number at the left side of the
worksheet grid; clicking this box will select the entire row
Question:
column selector -
Answer:
box with the column letter at the top of the
worksheet grid; clicking this box will select the entire column
Question:
internet
email messages
network locations -
Answer:
potential unsafe locations include?
Question:
message bar -
