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.