IT APPLICATION 2-3

Microsoft Excel

a spreadsheet program used to organize, calculate, and analyze data.

Workbook

The entire Excel file, this contains one or more worksheets.

1,048,576

the amount of rows in a worksheet

16,348

the amount of columns in a worksheet

Tabs

switch between different groups of commands

Ribbon

contains buttons for various Excel commands

Tell me Box

works like a search bar to quickly find tools or commands

Worksheet

a single grid, or tab, within a workbook (also called a sheet)

Cell

the box formed where a column and row meet, such as B3

Range

A group of two or more cells, such as B2:B10

Active Cell

The currently selected cell, outlined in green

Cell Reference

The address that identifies a cells location such as A1

AutoFill

extends a pattern (numbers, dates, days, or months) by dragging the fill handle

Fill handle

the small green square at the bottom-right corner of a selected cell

Flash Fill

recognizes a pattern you started typing and completes the rest of the column

Ctrl E

shortcut for Flash Fill

Tables

automatically apply consistent formatting and filter arrows

Structured References

use a table and a column name, such as Table1[Price]. Formulas become easier to read compared to ranges like B2:B10

Slicers

a visual filter that lets you click buttons instead of using dropdown menus.