Textbook Notes (369,100)
Canada (162,379)
Dr.Hurst (18)
Chapter

Excel Session 1.docx

5 Pages
47 Views

Department
Computer Science
Course Code
COMPSCI 1BA3
Professor
Dr.Hurst

This preview shows pages 1 and half of page 2. Sign up to view the full 5 pages of the document.
Description
Comp Sci Session 1.1: Excel Table Understanding Spreadsheets (pg. 6)  Spreadsheets is a collection of text and numbers laid out o Often used in business for budgeting, inventory management and decision making Navigating Between Worksheets (pg. 7)  Workbook contains two kinds of sheets o Worksheets o Chart Sheets  Worksheets o Contains grid of rows and column. Users enter data values and formulas into these rows and columns o Data and charts are embedded in within worksheets  Chart Sheet o Provides a representation of worksheet data in excel Navigating Within a Worksheet (pg. 8)  Each cell within a worksheet is identified as a CELL REFERENCE o Indicates the location of an individual worksheet cell  To find a cell use CONTROL & G button Entering Text, Numbers and Dates (pg. 11)  Worksheets can contain Text, Numbers and Dates  Text data is any combination of letters, numbers and symbols o Referred to as TEXT STRING  Numbering data is any numerical value that can be calculated Comp Sci Session 1 1 Comp Sci Session 1.2: Worksheet Data Working with Cell and Ranges  Range reference indicates the location and size of a cell range  For ADJCENT RANGES, the range reference includes the cell reference of the upper-left and lower-right cells in the rectangular block separated by a colon o Ex. A1:G5 – refers to all cells from A1 to A5  For NON-ADJACENT RANGES separates each adjacent range reference by a semicolon o Ex. A1:A5; F1:G5 – Part 1 covers cells from A1- A5 and then Part 2 covers cells from F1 – G5 Selecting a Range (pg. 26)  Selecting a range enables you to work with all of the cells in the range as a group o You move the group of cells, delete them or clear all their contents Moving and Copying a Range  You can copy and paste a range  Drag and drop o Dragging the cell and dropping it in a new location Working with Formulas Entering a Formula (pg. 32)  Every excel formula begins with an equal sign (=) followed by an expression describing the operation that returns the value  A formula is written using OPERATORS that combine different values, resulting in a single value that is then displayed within the cell  There are four different types of calculation operators o Arithmetic Operators (Main focus) ARITHMETIC OPERATOR MEANING (EXAMPLE) + (plus sign) Addition (3+3) – (minus sign) Subtraction (3–1) Negation (–1) * (asterisk) Multiplication (3*3) / (forward slash) Division (3/3) Comp Sci Session 1 2 % (percent sign) Percent (20%) ^ (caret) Exponentiation (3^2)  Comparison Operator COMPARISON OPERATOR MEANING (EXAMPLE) = (equal sign) Equal to (A1=B1) > (greater than sign) Great
More Less
Unlock Document

Only pages 1 and half of page 2 are available for preview. Some parts have been intentionally blurred.

Unlock Document
You're Reading a Preview

Unlock to view full version

Unlock Document

Log In


OR

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


OR

By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.


Submit