CIS 105 93009 - CIS MyITlab 93009 Introduction to Excel:...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
CIS MyITlab 93009 Introduction to Excel: - Spreadsheets contains rows and columns of data - Excel Worksheet = spreadsheet - Excel Workbook contains multiple worksheets - Workbook components: cells; active cells, formula bar, name box, cell reference, sheet tabs - Cells contains text values and formulas Mathematics and Formula - Order of operator precedence: (), ^, * or /, + or – Formulas vs. Functions - Formulas use values, cell references, and operators - ex. A1 + A2^4 - Functions (predefined) - ex. AVERAGE (B2-B6) Special Topic – Goal Seek/Solver - Use to find solutions to sets of equations - Ex. Mortgage or stadium revenue optimization Excel QUIZ 1. The power of Excel is its functions and formulas which enable accurate and quick calc. 2. A grid of rows and columns often containing labels and numerical values is a worksheet. 3. A workbook with 12 worksheets would be saved as 1 file(s). 4. Comments should be inserted into a worksheet to explain the purpose of formulas. 5.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/16/2010 for the course CIS 105 taught by Professor Mccarthy during the Fall '10 term at University of Arizona- Tucson.

Page1 / 2

CIS 105 93009 - CIS MyITlab 93009 Introduction to Excel:...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online