Day 9 (Adv Apps)

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

EXCEL SESSION 1.2

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

  1. Create patterned text with Flash Fill
  2. Add cell borders and change font size
  3. Change worksheet views
  4. Prepare a workbook for printing
  5. Save a workbook with a new filename

RIGHT NOW:

  1. 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.
  2. 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?
  3. 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–TWO COPIES–1 SHOWING THE ANSWERS & 1 SHOWING THE FORMULAS
    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?
  4. 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?
  5. 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?
  6. In your Word Online file for this class, record the answers to the questions in today’s lesson above for review.