CIT 105: INTRO TO COMPUTERS: EXCEL
workbook - Answers -an excel file made up of a collection of worksheets
worksheet - Answers -an electronic ledger where you enter data in excel (also called a
sheet); appears as a grid made up of rows and columns where you can enter and then
manipulate data using functions, formulas, and formatting
row - Answers -a horizontal group of cells; identified by numbers; for example, the third
row is labeled with the number 3
column - Answers -a vertical group of cells; identified by letters; for example, the fourth
column is labeled with the letter D
cell - Answers -the intersection of a row and column in a spreadsheet
cell address - Answers -the column and row position that defines a cell; for example,
the cell at the intersection of column B and row 4 has a cell address of B4
cell range - Answers -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 the address of the cell
in the lower right corner of the range; the cell range B3D5 includes cells B3, B4, B5, C3,
C4, C5, D3, D4, and D5
formula bar - Answers -data entry area directly below the ribbon and above the
worksheet grid
name box - Answers -appears at the left side of the formula bar and displays the
address of the selected cell or the name of a named range
status bar - Answers -appears at the bottom of the worksheet grid and can display
information about the selected data, including the number of cells selected that contain
data (count) and the average and sum (total) of the selected values (when appropriate)
vertical scroll bar - Answers -the scrollbar located along the right side of the window;
click the arrows at the ends of the scroll bars to move up and down to see more cells in
an individual worksheet
horizontal scroll bar - Answers -the scrollbar located at the bottom of the window; click
the arrows at the ends of the scroll bars to move left and right to see more cells in an
individual worksheet
row selector - Answers -the box with the row number at the left side of the worksheet
grid; clicking this box will select the entire row
, column selector - Answers -the box with the column letter at the top of the worksheet
grid; clicking this box will select the entire column
protected view - Answers -provides a read-only format that protects you computer from
becoming infected by a virus or other malware
message bar - Answers -displays a warning at the top of the window, below the ribbon,
when a file is opened in protected view
trusted document - Answers -A document originally displayed in Protected View that
has been marked as safe for editing.
ready mode - Answers -the data entry method used in excel to change to change the
contents of the entire cell by clicking the cell once and then typing the data
edit mode - Answers -the data entry method used in excel to change only part of the
cell data by double-clicking the cell, and then moving the cursor within the cell to insert
or delete data
general number format - Answers -Number format that right-aligns numbers in the cells
but does not maintain a consistent number of decimal places (43.00 will appear as 43,
while 42.25 appears as 42.25) and does not display commas (so 1,123,456 appears as
1123456).
accounting number format - Answers -Aligns the $ at the left side of the cell, displays
two places after the decimal, and aligns all numbers at the decimal point. Zero amounts
are displayed as dashes.
percent style format - Answers -Displays numbers as % with zero places to the right of
the decimal point.
comma style format - Answers -number format similar to the accounting number format,
but without the currency symbol
number format - Answers -An Excel cell format that stores data as numbers and shows
two decimal places by default (so 43 displays as 43.00) but does not include commas.
currency format - Answers -Number format that places the $ immediately to the left of
the number, so columns of numbers do not align at the $ and at the decimal as they do
with Accounting Number Format.
short date format - Answers -Excel number format that displays the one- or two-digit
number representing the month, followed by the one- or two-digit number representing
the day, followed by the four-digit year (9/5/2011).
workbook - Answers -an excel file made up of a collection of worksheets
worksheet - Answers -an electronic ledger where you enter data in excel (also called a
sheet); appears as a grid made up of rows and columns where you can enter and then
manipulate data using functions, formulas, and formatting
row - Answers -a horizontal group of cells; identified by numbers; for example, the third
row is labeled with the number 3
column - Answers -a vertical group of cells; identified by letters; for example, the fourth
column is labeled with the letter D
cell - Answers -the intersection of a row and column in a spreadsheet
cell address - Answers -the column and row position that defines a cell; for example,
the cell at the intersection of column B and row 4 has a cell address of B4
cell range - Answers -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 the address of the cell
in the lower right corner of the range; the cell range B3D5 includes cells B3, B4, B5, C3,
C4, C5, D3, D4, and D5
formula bar - Answers -data entry area directly below the ribbon and above the
worksheet grid
name box - Answers -appears at the left side of the formula bar and displays the
address of the selected cell or the name of a named range
status bar - Answers -appears at the bottom of the worksheet grid and can display
information about the selected data, including the number of cells selected that contain
data (count) and the average and sum (total) of the selected values (when appropriate)
vertical scroll bar - Answers -the scrollbar located along the right side of the window;
click the arrows at the ends of the scroll bars to move up and down to see more cells in
an individual worksheet
horizontal scroll bar - Answers -the scrollbar located at the bottom of the window; click
the arrows at the ends of the scroll bars to move left and right to see more cells in an
individual worksheet
row selector - Answers -the box with the row number at the left side of the worksheet
grid; clicking this box will select the entire row
, column selector - Answers -the box with the column letter at the top of the worksheet
grid; clicking this box will select the entire column
protected view - Answers -provides a read-only format that protects you computer from
becoming infected by a virus or other malware
message bar - Answers -displays a warning at the top of the window, below the ribbon,
when a file is opened in protected view
trusted document - Answers -A document originally displayed in Protected View that
has been marked as safe for editing.
ready mode - Answers -the data entry method used in excel to change to change the
contents of the entire cell by clicking the cell once and then typing the data
edit mode - Answers -the data entry method used in excel to change only part of the
cell data by double-clicking the cell, and then moving the cursor within the cell to insert
or delete data
general number format - Answers -Number format that right-aligns numbers in the cells
but does not maintain a consistent number of decimal places (43.00 will appear as 43,
while 42.25 appears as 42.25) and does not display commas (so 1,123,456 appears as
1123456).
accounting number format - Answers -Aligns the $ at the left side of the cell, displays
two places after the decimal, and aligns all numbers at the decimal point. Zero amounts
are displayed as dashes.
percent style format - Answers -Displays numbers as % with zero places to the right of
the decimal point.
comma style format - Answers -number format similar to the accounting number format,
but without the currency symbol
number format - Answers -An Excel cell format that stores data as numbers and shows
two decimal places by default (so 43 displays as 43.00) but does not include commas.
currency format - Answers -Number format that places the $ immediately to the left of
the number, so columns of numbers do not align at the $ and at the decimal as they do
with Accounting Number Format.
short date format - Answers -Excel number format that displays the one- or two-digit
number representing the month, followed by the one- or two-digit number representing
the day, followed by the four-digit year (9/5/2011).
