MS Excel (Important Terms Only)

Worksheet

A grid of cells that are more than 16,000 columns wide (A-Z, AA-AZ, BABZ...IV) and more than 1,000,000 rows long.

Worksheets

A workbook consists of a number of sheets, called

New Sheet

Add a new sheet button.

Search Bar

Advance search will help you find and perform tasks.

Spreadsheet

Another name for a worksheet is a

Workbook

Another name for an Excel document.

View Options

Display worksheet view mode

Ribbon

Displays groups of related commands within tabs. Each tab provides buttons for commands.

Status Bar

Displays information about the current worksheet.

Quick Access Toolbar

Displays quick access to commonly used commands.

Name Box

Displays the active cell location.

Title Bar

Displays the name of the application file.

Column and Bar Charts

Excel distinguishes between vertical and horizontal bar charts. These are useful for comparing categorical or ordinal data, for illustrating differences between sets of values, and for showing proportions or percentages of a whole

Formula Bar

Input formulas and perform calculations.

File Tab

It has replaced the Office button. It helps you to manage the Microsoft application and provide access to its options such as Open, New, Save, As Print, etc.

Microsoft Excel

It is a powerful electronic spreadsheet program you can use to automate accounting work, organize data, and perform a wide variety of tasks. It is designed to perform calculations, analyze information, and visualize data in a spreadsheet. Also this application includes database and charting features.

Microsoft Excel

It is an example of a spreadsheet program. Other types of spreadsheets are available—for example, Calc from OpenOffice, and Sheets from Google Docs.

Spreadsheet

It is used to perform mathematical calculations and financial decision making—for example, for budgets, company reports, wage sheets, cash flows—to analyze data, and for graphical representation of data. You can process, summarize, sort, extract, analyze, and store information using this.

Range

One or more adjacent cells. It is identified by its first and last cell address, separated by a colon. Example ranges are B5:B8, A1:B1 and A1:G240.

Cell

The intersection of a row and column; these are always named with the column letter followed by the row number (e.g. A1 and AB209); it may contain text, numbers and formulas.

Row

These are numbered vertically from 1 to 1,048,576 on each sheet

Column

These marked horizontally from A-Z, AA-ZZ, up to XFD—16,384 columns on each sheet.

Radar Chart

allows you to plot multiple dimensions of several data series.

Stock Chart

allows you to plot stock prices, such as the daily high, low, and close. It may also be used for scientific data such as temperature changes.

Area Chart

combines the features of a pie chart with those of line charts. It present more information than pie or line charts alone but may clutter the observer's mind with too many details if too many data series are used

Pie Chart

displays this by partitioning a circle into pie-shaped areas showing the relative proportion.

Bubble Chart

is a type of scatter chart in which the size of the data marker corresponds to the value of a third variable; consequently, it is a way to plot three variables in two dimensions.

Doughnut Chart

is similar to a pie chart but can contain more than one data series.

Line Charts

provide a useful means for displaying data over time.

Scatter Chart

show the relationship between two variables

Surface Chart

shows 3-D data.