Microsoft Excel

Spreadsheet

A two-dimensional grid of data along with formulas that relate the data

Electronic Spreadsheet

Digital replacement for pen and ink

Lotus 1-2-3

Early spreadsheet software popular in the 1980s.

Excel v1

First version of Microsoft Excel released in 1985.

Clippy

Microsoft Office Assistant, known for its paperclip shape.

Backstage Area

Excel interface for file management and settings.

Blank Workbook

An empty spreadsheet for data entry and analysis.

Ribbon

Excel's command interface replacing traditional toolbars.

Tabs

Sections in the Ribbon organizing related commands.

Home Tab

Used for creating and formatting spreadsheets.

Insert Tab

For adding elements like images and graphs.

Page Layout Tab

Prepares spreadsheets for printing and layout adjustments.

Formula Bar

Displays and edits the content of the active cell.

Active Cell

Currently selected cell for data entry.

Quick Access Toolbar

Customizable toolbar for frequently used commands.

Zoom Slider

Adjusts the view scale of the spreadsheet.

Worksheet Tabs

Tabs for navigating between different sheets in a workbook.

Formulas Tab

Used for adding formulas in spreadsheets.

Data Tab

For importing and querying data in worksheets.

Review Tab

Used for proofing and marking up spreadsheets.

View Tab

Changes display settings of the worksheet.

Help Tab

Provides online help and training for Excel.

Ribbon Customization

Allows hiding or showing Ribbon elements.

Auto Hide

Hides the Ribbon from the screen.

Dialog Box Launchers

Open additional formatting options in Excel.

AutoCalculate

Displays AVERAGE, COUNT, and SUM of selections.

Mode Indicator

Shows current mode of Excel operations.

Selecting a Cell

Clicking on a cell to highlight it.

Multiple Cell Selection

Click and drag to select adjoining cells.

Formula Bar

Displays content entered in the selected cell.

Insert Content

Enter data into a selected cell using keyboard.

Clear Command

Removes content from selected cells in Excel.

Backspace Key

Deletes content from the selected cell.

Clear Contents

Option to remove data without deleting cells.

Text Data Type

Also known as a label in Excel.

Number Data Type

Also referred to as a numeric entry.

Character Limit

Cells have a 15-digit limit for numbers.

Scientific Notation

Used when numbers exceed 15 digits in Excel.

Column Width

Specifies the width of a column in Excel.

Row Height

Specifies the height of a row in Excel.

Manual Resizing

Drag column/row lines to resize manually.

Selected Cell Indicator

Bold borders indicate a cell is selected.

Cell Spillover

Extra characters display in adjacent blank cells.

Worksheet Area

The main area where data is displayed.

Wrap Text

Command to fit text within cell width.

AutoSum

Quickly calculates totals for selected data.

Sparklines

Tiny graphs in a single cell for trends.

Conditional Formatting

Highlights data based on specific conditions.

Variance

Measures data set's spread from the mean.

Average Monthly Sales

Calculates mean sales over a month.

Sorting

Rearranging data from smallest to largest.

Filtering

Displays specific data based on criteria.

Custom Sorting

Sorts data by multiple levels or criteria.

Cell Reference

Points to a specific cell in formulas.

Standard Operators

Symbols for basic calculations in Excel.

Equal Sign

Indicates the start of a formula.

Cell Address

Unique identifier for a cell's location.

Data Triaging

Organizing and prioritizing data for analysis.

Error Bars

Visual representation of data variability.

Highlighting

Emphasizes important data points visually.

Threshold

Specific limit for filtering data.

Table Formatting

Enhances visual appeal of data tables.

Powerful Criteria

Advanced conditions for sorting/filtering data.

Data Visualization

Graphical representation of data trends.

Column Totals

Sum of values in a specific column.

Boring Raw Data

Unprocessed data lacking visual appeal.

Impressing Boss

Creating professional-looking reports and tables.

Data Outliers

Values significantly different from the rest.

Visualizing Trends

Identifying patterns in data over time.

Cell Formatting

Adjusting cell appearance for clarity.

Mic Drop

An expression of confidence after a statement.

Cell References

Links to specific cells for dynamic formulas.

AutoSum Command

Quickly calculates totals for selected cells.

Functions Library

Contains over 475 formulas for various calculations.

Mean

Average value calculated from a data set.

Standard Error (SEM)

Indicates the accuracy of sample mean estimates.

Fill Handle

Drag tool to repeat formulas in adjacent cells.

Paste Special Command

Offers advanced options for pasting data.

Transposing Data

Rearranging data from rows to columns or vice versa.

Analysis ToolPak

Add-in for advanced statistical analysis in Excel.

AVOVA

Statistical method for comparing group means.

t-Tests

Compares means between two groups.

Correlations

Measures the relationship between two variables.

Graph Customization

Modifying visual elements of charts and graphs.

Contextual Tabs

Dynamic tabs that change based on selection.

Formatting Panel

Tool for adjusting visual aspects of data.

Right-Click Menu

Context-sensitive options for selected elements.

Data Analysis Tools

Suite of features for statistical evaluation.

Dynamic Formulas

Formulas that update automatically with data changes.

Worksheet

A single spreadsheet within an Excel workbook.

Data Arrays

Structured collections of data for analysis.

Excel Interface

User-friendly layout for navigating and entering data.

Visualizing Data

Representing data graphically for better understanding.

Publication Quality Figures

High-standard visuals not achievable in Excel.

Mathematical Functions

Basic operations like addition, subtraction, etc.

Statistical Functions

Advanced calculations for data analysis.

Logical Functions

Formulas that return TRUE or FALSE values.

Engineering Equations

Complex calculations used in engineering contexts.

When was microsoft founded?

1975

who founded microsoft?

Bill Gates and Paul Allen