CIS 105: Excel UPDATED ACTUAL
Questions and CORRECT Answers
workbook - CORRECT 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
worksheet - CORRECT ANSWER - electronic ledger in which you enter data
appears as a grid where you enter & then manipulate data using functions, formatting, &
formulas
row - CORRECT ANSWER - a horizontal group of cells in a worksheet identified by
numbers
column - CORRECT ANSWER - a vertical group of cells identified by letters
cell - CORRECT ANSWER - the intersection of a column & a row
cell address - CORRECT ANSWER - the column and row position that defines a cell
ex. column b, row 4= B4
cell range - CORRECT 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
formula bar - CORRECT ANSWER - data entry area directly below the ribbon & above
worksheet grid
, insert function button - CORRECT ANSWER - located on left side of formula bar;
designed to make it easier to create complex formulas
name box - CORRECT ANSWER - this appears at the left side of the formula bar &
displays address of selected cell
status bar - CORRECT 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
vertical scroll bar - CORRECT 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
horizontal scroll bar - CORRECT 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
row selector - CORRECT ANSWER - box with the row number at the left side of the
worksheet grid; clicking this box will select the entire row
column selector - CORRECT ANSWER - box with the column letter at the top of the
worksheet grid; clicking this box will select the entire column
internet
email messages
network locations - CORRECT ANSWER - potential unsafe locations include?
Questions and CORRECT Answers
workbook - CORRECT 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
worksheet - CORRECT ANSWER - electronic ledger in which you enter data
appears as a grid where you enter & then manipulate data using functions, formatting, &
formulas
row - CORRECT ANSWER - a horizontal group of cells in a worksheet identified by
numbers
column - CORRECT ANSWER - a vertical group of cells identified by letters
cell - CORRECT ANSWER - the intersection of a column & a row
cell address - CORRECT ANSWER - the column and row position that defines a cell
ex. column b, row 4= B4
cell range - CORRECT 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
formula bar - CORRECT ANSWER - data entry area directly below the ribbon & above
worksheet grid
, insert function button - CORRECT ANSWER - located on left side of formula bar;
designed to make it easier to create complex formulas
name box - CORRECT ANSWER - this appears at the left side of the formula bar &
displays address of selected cell
status bar - CORRECT 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
vertical scroll bar - CORRECT 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
horizontal scroll bar - CORRECT 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
row selector - CORRECT ANSWER - box with the row number at the left side of the
worksheet grid; clicking this box will select the entire row
column selector - CORRECT ANSWER - box with the column letter at the top of the
worksheet grid; clicking this box will select the entire column
internet
email messages
network locations - CORRECT ANSWER - potential unsafe locations include?
