Excel Lesson 1

Worksheet

The term Worksheet used in Excel documents is a collection of cells organized in rows and columns. ... Each worksheet contains 1048576 rows and 16384 columns and serves as a giant table that allows you to organize information.

Paste

By default when you copy (or cut) and paste in Excel, everything in the source cell or range - data, formatting, formulas, validation, comments - is pasted to the destination cell(s). This is what happens when you press CTRL+V to paste.

Cell

A cell is the intersection of a row and a column. Columns are identified by letters (A, B, C), while rows are identified by numbers (1, 2, 3). A cell. Each cell has its own name—or cell address—based on its column and row.

Formula

A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel. For example, cell A3 below contains a formula which adds the value of cell A2 to the value of cell A1.

Autosum

A function in a spreadsheet program that inserts a formula in the selected cell that adds the numbers in the column above it. It sets the range of cells by looking for numeric data above the selected cell. The Autosum Function.

Function

A function is a predefined formula that performs calculations using specific values in a particular order. Excel includes many common functions that can be used to quickly find the sum, average, count, maximum value, and minimum value for a range of cells.

Copy

Copy takes the information from one location and duplicates it. plus), you can drag the cell or range of cells to the new location. locations.

Autofit

Excel's AutoFit feature is designed to automatically resize cells in a worksheet to accommodate different sized data without having to manually change the column width and row height.Mar 16, 2017

Cut

In Excel, cutting data is defined as moving the data from one location to another, either to a different spot in the same worksheet, a separate worksheet in the same workbook, a different Excel workbook, or even a different application. Copying data means taking a copy of the data to another location.

Column

In Microsoft Excel, a column runs vertically in the grid layout of a worksheet. Vertical columns are numbered with alphabetic values such as A, B, C. Horizontal rows are numbered with numeric values such 1, 2, 3.

Row

In Microsoft Excel, a row runs horizontally in the grid layout of a worksheet. Horizontal rows are numbered with numeric values such as 1, 2, 3. Each row in the worksheet has its own row number which is used as part of a cell reference such as A1, A2, or M16.

Range

In a spreadsheet a cell range is a collection of selected cells. ... A cell range can be referred to in a formula. In a spreadsheet, a cell range is defined by the reference of the upper left cell (minimum value) of the range and the reference of the lower right cell (maximum value) of the range.