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

74 views27 pages
6 Feb 2017
School
Course
Professor

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

UT-Austin
CHE 210
MIDTERM EXAM
STUDY GUIDE
Unlock document

This preview shows pages 1-3 of the document.
Unlock all 27 pages and 3 million more documents.

Already have an account? Log in
Unlock document

This preview shows pages 1-3 of the document.
Unlock all 27 pages and 3 million more documents.

Already have an account? Log in
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
Unlock document

This preview shows pages 1-3 of the document.
Unlock all 27 pages and 3 million more documents.

Already have an account? Log in
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
Unlock document

This preview shows pages 1-3 of the document.
Unlock all 27 pages and 3 million more documents.

Already have an account? Log in

Get access

Grade+
$10 USD/m
Billed $120 USD annually
Homework Help
Class Notes
Textbook Notes
40 Verified Answers
Study Guides
1 Booster Class