Vocabulary: Excel week 8 Flashcards
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. For example, the cell at the intersection of column D and row 3 has a cell address of D3.
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:B5 includes cells B3, B4, and B5. A cell range can incorporate multiple columns and rows as long as the cells are all contiguous. The 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.
