{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

CIS 105 93009

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

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

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. If the active cell is A1, the cell address A1 displays in the

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### 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
Ask a homework question - tutors are online