# Connexions

You are here: Home » Content » Engineering Computation with Spreadsheets » Anatomy of a Spreadsheet

### Recently Viewed

This feature requires Javascript to be enabled.

Inside Collection (Textbook):

Textbook by: Serhat Beyenir. E-mail the author

Module by: Serhat Beyenir. E-mail the author

Summary: Definitions and basic operations.

## Definitions

Definition 1: Workbook
A workbook is a spreadsheet file. By default, each workbook in Excel contains three sheets. Spreadsheet file names use .xls or .xlsx suffixes (i.e. file extension).
Definition 2: Worksheet
A worksheet is a single sheet in a workbook. By default, a workbook contains three worksheets.
Definition 3: Column
A column is a vertical block in a worksheet. Each column is identified by a letter in the column header.
Definition 4: Row
A row is a horizontal block in a worksheet. Each row is identified by a number in the row header.
Definition 5: Cell
A cell is the intersection of a column and a row. Cells are the basic building blocks of a worksheet. Each cell is assigned an address (e.g. cell reference, A1 means column A and row 1).
Definition 6: Range
A range is block of cells in a worksheet.
Definition 7: Formula
A mathematical formula that is run to compute results. Formulae are made up of standard arithmetic operations (e.g. +, -, *, /, ^).
Definition 8: Function
Functions are pre-constructed formulae that perform common calculations (e.g. summation and average). We can combine many functions and arithmetic operations in a single formula to carry out complex engineering computations.

## Arithmetic Operators

To perform basic mathematical operations, use the following arithmetic operators.

Table 1: Arithmetic Operators
Arithmetic Operator Meaning (example)
- (Minus sign) Subtraction (3-1) or negation (-1)
* (Asterisk) Multiplication (3*3)
/ (Forward slash) Division (3/3)
% (Percent sign) Percent (20%)
^ (Caret) Exponentiation (3^2)

## Comparison Operators

We can compare two values with the following operators, the result is a logical value either TRUE or FALSE.

Table 2: Comparison Operators
Comparison operator Meaning (example)
= (Equal sign) Equal to (A1=B1)
> (Greater than sign) Greater than (A1>B1)
(Less than sign) Less than
>= (Greater than or equal to sign) Greater than or equal to (A1>=B1)
Less than or equal to sign) Less than or equal to
(Not equal to sign) Not equal to

Depending on the type and version of spreadsheet application you are using workbook window will contain many elements. Some of the major elements are illustrated below.

## Content actions

PDF | EPUB (?)

### What is an EPUB file?

EPUB is an electronic book format that can be read on a variety of mobile devices.

PDF | EPUB (?)

### What is an EPUB file?

EPUB is an electronic book format that can be read on a variety of mobile devices.

#### Collection to:

My Favorites (?)

'My Favorites' is a special kind of lens which you can use to bookmark modules and collections. 'My Favorites' can only be seen by you, and collections saved in 'My Favorites' can remember the last module you were on. You need an account to use 'My Favorites'.

| A lens I own (?)

#### Definition of a lens

##### Lenses

A lens is a custom view of the content in the repository. You can think of it as a fancy kind of list that will let you see content through the eyes of organizations and people you trust.

##### What is in a lens?

Lens makers point to materials (modules and collections), creating a guide that includes their own comments and descriptive tags about the content.

##### Who can create a lens?

Any individual member, a community, or a respected organization.

##### What are tags?

Tags are descriptors added by lens makers to help label content, attaching a vocabulary that is meaningful in the context of the lens.

| External bookmarks

#### Module to:

My Favorites (?)

'My Favorites' is a special kind of lens which you can use to bookmark modules and collections. 'My Favorites' can only be seen by you, and collections saved in 'My Favorites' can remember the last module you were on. You need an account to use 'My Favorites'.

| A lens I own (?)

#### Definition of a lens

##### Lenses

A lens is a custom view of the content in the repository. You can think of it as a fancy kind of list that will let you see content through the eyes of organizations and people you trust.

##### What is in a lens?

Lens makers point to materials (modules and collections), creating a guide that includes their own comments and descriptive tags about the content.

##### Who can create a lens?

Any individual member, a community, or a respected organization.

##### What are tags?

Tags are descriptors added by lens makers to help label content, attaching a vocabulary that is meaningful in the context of the lens.

| External bookmarks