Intro to Computers-EXCEL ACTUAL UPDATED QUESTIONS AND CORRECT
ANSWERS
An Excel file a workbook, which is a collection of worksheets.
Each worksheet (also called a "sheet") made up of rows and columns of data on which you can perform calculations. It's
these calculations that make Excel such a powerful tool.
Some of the basic elements of a Microsoft Excel WORKSHEET
workbook include: ROW
COLUMN
CELL
CELL RANGE
FORMULA BAR
NAME BOX
STATUS BAR
Worksheet an electronic ledger in which you enter data. The worksheet appears as a grid
where you can enter and then manipulate data using functions, formulas, and
formatting. Excel workbooks have one worksheet by default named Sheet1. You
can rename, add, and delete worksheets as necessary.
Row a horizontal group of cells. Rows are identified by numbers. For example, the third
row is labeled with the number 3.
Column a vertical group of cells. Columns are identified by letters. For example, the fourth
column is labeled with the letter D.
Cell the intersection of a column and a row. A cell is identified by the cell address — its
column and row position.
Cell Range a contiguous group of cells. A cell range is 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 B3:D5 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.
Although you can type any data in the formula bar, the Insert Function button at
the left side of the formula bar was designed to make it easier to create complex
formulas.
Name Box appears at the left side of the formula bar and displays the address of the
selected cell. If a group of cells is selected, the Name box displays the address of
the first cell in the group.
, 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.
ANSWERS
An Excel file a workbook, which is a collection of worksheets.
Each worksheet (also called a "sheet") made up of rows and columns of data on which you can perform calculations. It's
these calculations that make Excel such a powerful tool.
Some of the basic elements of a Microsoft Excel WORKSHEET
workbook include: ROW
COLUMN
CELL
CELL RANGE
FORMULA BAR
NAME BOX
STATUS BAR
Worksheet an electronic ledger in which you enter data. The worksheet appears as a grid
where you can enter and then manipulate data using functions, formulas, and
formatting. Excel workbooks have one worksheet by default named Sheet1. You
can rename, add, and delete worksheets as necessary.
Row a horizontal group of cells. Rows are identified by numbers. For example, the third
row is labeled with the number 3.
Column a vertical group of cells. Columns are identified by letters. For example, the fourth
column is labeled with the letter D.
Cell the intersection of a column and a row. A cell is identified by the cell address — its
column and row position.
Cell Range a contiguous group of cells. A cell range is 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 B3:D5 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.
Although you can type any data in the formula bar, the Insert Function button at
the left side of the formula bar was designed to make it easier to create complex
formulas.
Name Box appears at the left side of the formula bar and displays the address of the
selected cell. If a group of cells is selected, the Name box displays the address of
the first cell in the group.
, 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.
