Day 6 (Adv Apps)

AT THE END OF EVERY CLASS, WRITE IN THE WORD FILE YOU SHARED WITH ME LAST CLASS TELLING ME HOW FAR YOU GOT AND WHAT YOU LEARNED. Be sure to click SHARE again.

EXCEL SESSION 1.1

GOAL: Before you leave today you will know how to:

  1. Resize columns and rows

PICK UP WHERE YOU LEFT OFF:

  1. WATCH & DO THIS VIDEO–Pages EX 24 to EX 29–SHOW ME WHEN YOU ARE DONE–Your’s should look like Figure 1-21 on page EX 28.
      1. Quick Quiz: (you can put the answers in your Word Online file for this class if you want–it will not be graded–it is for your understanding & learning)
        1. A(n) ______ is a single point on a computer monitor or printout.
        2. What is the default column width?
        3. ______ changes the column width or row height to display the longest or tallest entry within the column or row.
        4. True/False: When text wraps within a cell, the row height increases.
  2. In your Word Online file for this class, answer the questions on page EX 29 and share it with me. You can work with a partner.

BEGIN TODAY IF TIME PERMITS:

EXCEL SESSION 1.2

When you are done with this session you will be able to:

  1. Enter formulas and the SUM and COUNT functions
  2. Copy and paste formulas
  3. Move or copy cells and ranges
  4. Insert and delete rows, columns, and ranges

RIGHT NOW:

  1. PERFORMING CALCULATIONS WITH FORMULAS
    1. Open your book to page EX30 and WATCH THIS VIDEO EXPLANATION
      1. Formulas always begin with an = sign.
    2. Read and do pages EX30 to EX35--SHOW ME
      1. Review Figure 1-22
        1. It is very important that you understand the kinds of operations used in worksheets.
        2. The order of operations is very important. You need to understand that if you do not follow the rules of the order of operations, you will receive unexpected results.
    3. Quick Quiz:
      1. In the order of operation rules, Excel first calculates the value of any operation within parentheses, and then it applies _____.
        1. exponentiation
        2. addition
        3. multiplication and division
        4. subtraction
      2. A(n) _____ is a mathematical expression that calculates a value.
      3. True/False: A worksheet can contain the following type of data: text, numeric values, dates, and calculated values.
      4. If you forget to put an = sign at the beginning of a formula, what will appear in the cell?
      5. What is the result of the formula =40+10*4?
      6. What is the result of the formula =(40+10)*4
      7. What is the result of the formula =40/10-4
  2. Simplifying Formulas with Functions
    1. Open your book to page 36 and WATCH THIS VIDEO
    2. Read and do pages 36 to 39–SHOW ME
      1. A function is a predefined, or built-in, formula for a commonly used calculation. Each Excel function has a name and syntax. The syntax specifies the order in which you must enter the different parts of the function and the location in which you must insert commas, parentheses, and other punctuation.
      2. The AutoSum feature allows you to quickly enter a sum in a cell. The SUM function is the most widely used function and the AutoSum allows you to automate the process. When you choose the AutoSum feature, Excel will “guess” which cells should be included in the sum. Be sure to check the AutoSum range to make sure it is really what you want.
      3. You use the AutoSum button to insert any function into the active cell. To select a function, click the AutoSum button and then click More Functions and choose the function from the Insert Function dialog box. Excel will automatically insert the cell reference of the row or column into the function (if appropriate).
    3. Quick Quiz:
      1. Every function follows a set of rules, or _____.
        1. operations
        2. arguments
        3. reference
        4. syntax
      2. True/False: Functions are used to simplify formulas.
    4. EXTRA CREDIT: Use the help available in the dialog box to research a function. Learn what the function does, what data is needed, and provide an example of how to use the function. In addition, think of a situation in which you would use the function.
  3. Modifying a Worksheet
    1. Open your book to page 39 and WATCH THIS VIDEO
    2. Read and do pages 39 to 47–SHOW ME
    3. Worksheets in a workbook are much like sheets or pages within a book. Think of them as being stacked on top of one another and you just peruse through them like you flip the pages of a book. As with other features in Excel, there is more than one way to move, copy, and work with worksheets.
    4. Quick Quiz:
      1. The _____ function calculates how many unique items are include in a range?
        1. NUMBER
        2. SUM
        3. COUNT
        4. ITEMS
      2. True/False: Deleting a column or row is not the same as clearing a column or row.
      3. To insert a column or row in Excel, what are the steps to follow?
  4. In your Word Online file for this class, record the answers to the questions in today’s lesson above for review.