# [CHE 210] - Midterm Exam Guide - Comprehensive Notes for the exam (27 pages long!)

For unlimited access to Study Guides, a Grade+ subscription is required.

UT-Austin

CHE 210

MIDTERM EXAM

STUDY GUIDE

Lecture 1 August 29, 2016

1

Spreadsheets mimic the business ledgers that used to be employed by

businesses to keep track of inventory and accounts. VisiCalc (Apple)

was possibly the first spreadsheet software for use on small

computers. It was quickly replaced by IBM’s first “killer app” for

PC’s, Lotus 1-2-3. Eventually Lotus 1-2-3 gave way to the graphical

user interface Microsoft introduced with Windows 3.0 and applications

like Word and Excel.

Coming from the business world early spreadsheet applications lacked

the ability to do scientific calculations and produce technical plots.

Eventually though, applications like Excel matured into complete

engineering and scientific calculation packages.

In this lecture we began to prepare a worksheet in a workbook (Excel

document) to calculate pressures of a gas using the Ideal Gas Law as

well as the Dieterici equation of state. The goal of the exercise is

to understand Excel basics.

Once the document is open, we can see that a basic Excel worksheet is

comprised of a grid of rows and columns. The rows are identified by

numbers and the columns are identified by letters. The intersection

of a row and column is called a cell. Cells are identified by the

column letter first followed by the row number. For instance cell E12

is highlighted in the following figure.

find more resources at oneclass.com

find more resources at oneclass.com

Lecture 1 August 29, 2016

2

Cells can contain three types of information:

1) Labels

2) Data – Mostly numbers but sometimes text

3) Formulas

Labels are used just for that purpose, to label things. Mostly labels

are just text. Data are usually numbers that will be used in

calculations. Formulas are mathematical calculations that are

performed on data.

Referring to the figure cells A1, A2, D8, etc. are labels. Cells B3,

B5, and B8 are examples of cells that contain data. Both labels and

data are entered into a cell the same way. Click on the desired cell,

type the text or number, and then enter it by moving to another cell

by clicking an “arrow” key or by hitting the enter key. A third way

is to click the check-mark that appears in the editing box when you

start typing. The editing box (more properly called the formula bar)

is the white area next to f

x

.

That leaves formulas. An Excel formula is entered by first typing an

= sign in a cell. The simplest formula might be =1. This just sets

the value of that cell to be one. Not very interesting! The next

simplest might be of the form =A1. This simply copies the value

contained in A1 into the cell in which the formula is entered.

More complex formulas that do more elaborate calculations are, of

course more useful. Look at the formula for cell G5 of our worksheet:

find more resources at oneclass.com

find more resources at oneclass.com