Day 7 (Adv Apps)


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
  5. Create patterned text with Flash Fill
  6. Add cell borders and change font size
  7. Change worksheet views
  8. Prepare a workbook for printing
  9. Save a workbook with a new filename


    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. Using Flash Fill
    1. Open your book to page 47–read about Flash Fill
    2. Read and do page 48–SHOW ME
    3. Quick Quiz:
      1. When does Flash Fill work best?
      2. True/False: Flash Fill enters formulas, not text.
  5. Formatting a Worksheet
    1. Open your book to page 48 and watch this video
    2. Read and do pages 49-50–SHOW ME
    3. Quick Quiz:
      1. _____ changes a workbook’s appearance so that the content of a worksheet is easier to read.
      2. True/False: The default font size for worksheets is 12 points.
      3. What is the purpose of adding borders around cells that contain content?
  6. Printing a Workbook
    1. Open your book to page 50 and watch this video
    2. Read and do pages 50 to 55–SHOW ME
      1. Remember that switching views does not change the information in the workbooks, just the way you view it on the screen.
      2. The Landscape orientation is often used when printing a worksheet because there are often many columns. Printing in landscape allows you to see more columns at once.
    3. Page 55 #6–PRINT
    4. Quick Quiz:
      1. What are the three ways to view a spreadsheet?
      2. _______ a printout reduces the width and the height of the printout to fit the number of pages you specify by shrinking the text size as needed.
      3. What is the difference between portrait orientation and landscape orientation?
  7. Viewing Worksheet Formulas
    1. Open your book to page 55 and watch this video
    2. Read and do pages 55 to 56–Show me
      1. Printing the formulas is usually done to check formulas. You will print your formulas along with any worksheets you turn in.
    3. Quick Quiz:
      1. To toggle in and out of formula view, press the ________ keys.
      2. Why would you want to display the formulas?
  8. Saving a Workbook with a New Filename
    1. Open your book to page 56 and watch this video
    2. Quick Quiz:
      1. To save a copy of a workbook with a new filename or to a different location, you need to use the ________ command.
      2. How does the Save As command differ from the Save command?
  9. End of Module Material
    1. Review AssignmentRead and do pages 58 to 59, #1-21
      1. #19 & 20–PRINT with your name in the header
    2. Case Problem 1: Read and do pages 59 to 60–PRINT as instructed with your name in the header
    3. Case Problem 2: Read and do pages 60 to 61–DO NOT PRINT–SHOW ME
    4. Case Problem 3 & 4: EXTRA CREDIT