CIT 105: Intro to Computers: Excel ACTUAL UPDATED QUESTIONS AND
CORRECT ANSWERS
workbook an excel file made up of a collection of worksheets
worksheet 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 a horizontal group of cells; identified by numbers; for example, the third row is
labeled with the number 3
column a vertical group of cells; identified by letters; for example, the fourth column is
labeled with the letter D
cell the intersection of a row and column in a spreadsheet
cell address 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 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 data entry area directly below the ribbon and above the worksheet grid
name box 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 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 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 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 the box with the row number at the left side of the worksheet grid; clicking this
box will select the entire row
, column selector the box with the column letter at the top of the worksheet grid; clicking this box
will select the entire column
protected view provides a read-only format that protects you computer from becoming infected
by a virus or other malware
message bar displays a warning at the top of the window, below the ribbon, when a file is
opened in protected view
trusted document A document originally displayed in Protected View that has been marked as safe
for editing.
ready mode 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 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 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 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 Displays numbers as % with zero places to the right of the decimal point.
comma style format number format similar to the accounting number format, but without the currency
symbol
number format 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 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 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).
long date format Excel date format that displays the day of the week, and then the name of the
month, the two-digit date, and the four-digit year (Monday, September 05, 2011).
AutoFill Feature used to fill a group of cells with the same data or to extend a data series.
CORRECT ANSWERS
workbook an excel file made up of a collection of worksheets
worksheet 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 a horizontal group of cells; identified by numbers; for example, the third row is
labeled with the number 3
column a vertical group of cells; identified by letters; for example, the fourth column is
labeled with the letter D
cell the intersection of a row and column in a spreadsheet
cell address 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 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 data entry area directly below the ribbon and above the worksheet grid
name box 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 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 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 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 the box with the row number at the left side of the worksheet grid; clicking this
box will select the entire row
, column selector the box with the column letter at the top of the worksheet grid; clicking this box
will select the entire column
protected view provides a read-only format that protects you computer from becoming infected
by a virus or other malware
message bar displays a warning at the top of the window, below the ribbon, when a file is
opened in protected view
trusted document A document originally displayed in Protected View that has been marked as safe
for editing.
ready mode 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 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 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 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 Displays numbers as % with zero places to the right of the decimal point.
comma style format number format similar to the accounting number format, but without the currency
symbol
number format 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 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 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).
long date format Excel date format that displays the day of the week, and then the name of the
month, the two-digit date, and the four-digit year (Monday, September 05, 2011).
AutoFill Feature used to fill a group of cells with the same data or to extend a data series.
