Worksheet ➔ Is single page spreadsheet or page in Excel, where you can write, edit and manipulate
data. Is a grid composed of rows, columns, and cells.
Workbooks ➔ Is the collection of worksheets.
Quick Access Toolbar ➔ gives you fast and easy access to the tools you use most often in any given Excel
session.
ScreenTips ➔ are boxes that display descriptive text when you rest the pointer on a command or
control.
natural series ➔ is a formatted series of text or numbers that are in a normal sequence such as months,
weekdays, numbers, or times. For example, a natural series of numbers could be 1, 2, 3, or 100, 200,
300, or a natural series of text could be Monday, Tuesday, Wednesday, or January, February, March.
Flash Fill ➔ fills a column of data using an example that is based on existing data in adjacent columns.
PEMDA stands for Parenthesis, Exponents, Multiplication/Division, Addition/Subtraction.
An external reference refers to a cell or range in a worksheet in another Excel workbook, or to a
defined name in another workbook.
A named range is a group of cells, and occasionally a single cell, with a designated name. The most
common reason to name a range is to refer to it in formulas and functions.
The SUM function totals all of the cells in a range, easily and accurately. AutoSum makes that task
even easier by calculating (by default) the total from the adjacent cell up to the first nonnumeric cell,
using the SUM function in its formula.
SUM is usually the first function most people learn how to use in Excel. In fact, you already saw
it in action in Lesson 4, “Using Basic Formulas.”
Statistical functions, such as SUM and COUNT, compile and classify data to present significant
information. Use the COUNT function when you want to determine how many cells in a range
contain a number. There are other variations of the COUNT function.
The COUNTA function counts all nonblank entries in a range, whether they include text or numbers.
The COUNTBLANK function counts the number of blank cells in a range.
The AVERAGE function adds a range of cells and then divides by the number of cell entries, determining
the mean value of all values in the range.
The MIN function allows you to determine the minimum value in a range of cells. Let’s use this function
to determine what your minimum electricity and gas bills will be. Instead of entering the formula
manually, you’ll use the Function Library group on the Formulas tab to build the formula.
The MAX function returns the largest value in a set of values. The MAX function works the same way as
MIN, except MAX determines the maximum value in a range of cells. To use MAX in a formula, let’s
enter the function manually.
