An Excel document which contains three worksheets by default but can have more than three
A single sheet contained in an Excel workbook
In a spreadsheet, these are the vertical spaces. Columns are headed with letters. There are a total of 256 columns on one worksheet.
In a spreadsheet the row is the horizontal group of cells. Rows are named with numbers, i.e. 1, 2, 3. There are total of 35,536 rows on a worksheet.
This is the place where information is held in a spreadsheet.
Named using the letter and number where the column and row intersect.
This is the cell in a spreadsheet where information will be placed. It is the cell that has been selected.
Labels located at the bottom of the workbook window indicating the worksheets.
Displays the cell reference, which is the location of the active cell in the worksheet. It is located on the left side of the formula bar.
Function that automatically adds selected cells.
Function that changes the contents of a cell to currency, adding a dollar sign and decimal places.
A mathematical formula typed into a cell.
The toolbar on the Microsoft Excel window that shows the text or formulas.
A function that allows the user to change the value of a cell to a percent.
In a database this function puts the records into a specific order.
Upgrade to remove ads