Anatomy of MS Excel Review

Run vertically on the sheet and are identified by alphabets or you can also say English letters such as A, B, C, etc., at the top of the sheet. Represents a unique vertical data set.

• Columns

• Rows

• Cells

• Cell Content

Horizontal lines or we can say row of boxes that runs horizontally on the Excel sheet are called rows. Represented by Numerical values such as 1, 2,3, etc.

• Columns

• Rows

• Cells

• Cell Content

Individual rectangular boxes formed by the intersection of rows and columns. Has its unique address which is Column Alphabet and Row Number.

• Name Box

• Rows

• Cells

• Cell Content

The values you supply to the cell are called ___. The content of a cell can be of various types of data, it could be numbers, text, dates, formulas, or functions. You can enter, edit, or delete cell content.

• cell types
• cell values
• cell formulas
• cell content

The __ represents the location of the active cell, which means

• active range
• cell reference
• cell identifier
• name box

The __ located just below the toolbar, displays the contents of the active cell. It will display the contents or values of the selected cell. In case formulas are applied to any cell and when you place the cursor over it, means when you select it, it will give the entire formula.

• status bar
• formula bar
• navigation pane
• menu bar

At the left bottom of the Excel window, you will find __. This tab shows the names of sheets present in the Excel workbook.

• Workbook tabs
• Data tabs
• worksheet tabs

• Formula tabs

The __ is the cell you are working on or you have placed your cursor on.

• active cell
• current cell
• highlighted cell
• selected cell

The top column of the sheet containing all the column names that as A, B, C… etc., is called as __.

• footer
• body
• title
• column header

The left-most vertically arranged row numbers 1, 2, 3, etc., serve as __ in the Excel spreadsheet. They help in identifying the location of specific data in the sheet.

• cell references
• data labels
• column headers
• row headers