excel

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.

worksheet

A worksheet or sheet is a single page in a file created with an electronic spreadsheet program such as Microsoft Excel or Google Sheets. A workbook is the name given to an Excel file and contains one or more worksheets.

relative cell reference

By default, a cell reference is a relative reference, which means that the reference is relative to the location of the cell. If, for example, you refer to cell A2 from cell C2, you are actually referring to a cell that is two columns to the left (C minus A)—in the same row (2).

formulas

Formula. ... Using formulas in spreadsheets can allow you to quickly make calculations and get totals of multiple cells, rows, or columns in a spreadsheet. In the picture below is an example of a Microsoft Excel formula =SUM(A$1:A$3), which adds the total of cells A1, A2, and A3.

cell range

Image result for cell range definition in microsoft excel In Excel, a 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.

fill handle

Image result for fill handle definition in microsoft excel In Microsoft Excel, a fill handle is a feature that allows the user to extend (and fill) a series of numbers, dates, or even text to a desired number of cells. In the active cell of the spreadsheet, the fill handle is a small black box at the bottom right corner, as shown in the image to the right.

flash fill

Image result for flash fill definition in microsoft excelwww.teachucomp.com Flash Fill automatically fills your data when it senses a pattern. For example, you can use Flash Fill to separate first and last names from a single column, or combine first and last names from two different columns. Note: Flash Fill is only available in Excel 2013 and later.

workbook

In Microsoft Excel a workbook is a collection of one or more spreadsheets, also called worksheets, in a single file. Below is an example of a spreadsheet called Sheet1 in an Excel workbook file called Book.

fill

In Microsoft Excel, fill handle is a command that lets you fill data in to your spreadsheet cells, that is based on a pattern you establish. For example, you can use this command to continue a series of numbers, text combinations, or dates.

wrap text

In a worksheet, select the cells that you want to format. On the Home tab, in the Alignment group, click Wrap Text . Notes: Data in the cell wraps to fit the column width, so if you change the column width, data wrapping adjusts automatically.

cell

MS Excel: Cells. In Microsoft Excel, a cell is a rectangular box that occurs at the intersection of a vertical column and a horizontal row in a worksheet. ... A cell can only store 1 piece of data at a time. You can store data in a cell such as a formula, text value, numeric value, or date value.

Mathematical operators

Operators are symbols used in a formula to define the relationship between two or more cell references, or between two or more values. They cause Excel to perform some action

point and click

Point and click are the actions of a computer user moving a pointer to a certain location on a screen (pointing) and then pressing a button on a mouse, usually the left button (click), or other pointing device.

merge

This document explains how to merge cells within all versions of Microsoft Excel. Merging cells is often used when a title is to be centered over a particular section of a spreadsheet. When a group of cells is merged, only the text in the upper-leftmost box is preserved.

Page Layout View

To change page orientation: Click the Page Layout tab on the Ribbon. Select the Orientation command, then choose either Portrait or Landscape from the drop-down menu.

absolute cell reference

Unlike relative references, absolute references do not change when copied or filled. You can use an absolute reference to keep a row and/or column constant. An absolute reference is designated in a formula by the addition of a dollar sign ($). It can precede the column reference, the row reference, or both.

cell address

cell address. A combination of a letter and a number that specifies the column and row in which a cell is located on a spreadsheet.

Spreadsheet program

noun. The definition of a spreadsheet is a piece of paper or a computer program used for accounting and recording data using rows and columns into which information can be entered. Microsoft Excel, a program in which you enter data into columns, is an example of a spreadsheet program.