CA- 7-2 Video Tutorial: Microsoft Excel Functions & Charts

CA- 7-2 Video Tutorial: Microsoft Excel Functions & Charts 

Work along with the Excel Functions & Charts video tutorial, to add functions and a chart to your Gradebook.  

903 Views | Preview 


18 Video Interactions 


  1. 00:01:24 

    What is the difference between a function and formula in Excel? 

     ____________________________ 


  2. 00:01:45 

    Which is NOT a function? 

    • =SUM( )

       
    • =MAX( )

       
    • =AVG( )

       
    • =2 + 2

       

  3. 00:02:01 

    When I use a function in Excel (like AutoSum), what's the first step? 

    • Highlight cells you want to add

       
    • Click in cell you want your answer in

       
    • Press AutoSum

       
    • Select the whole table

       

  4. 00:02:30 

            is an example of a range of cells. 

    • A3:A7

       
    • Q8

       
    • F4 - F9

       
    • Range(L34)

       

  5. 00:03:05 

    I can only use the range that Excel gives me. 

    • True

       
    • False

       

  6. 00:03:55 

    You should include totals any time you do a function like Max/Min/Avg. 

    • True

       
    • False

       

  7. 00:05:37 

    The       copies functions or formulas from cell to cell so that I don't have to redo my functions every time. 

    • AutoSum

       
    • AutoCopy

       
    • Fill Handler

       
    • Function Copier

       

  8. 00:06:13 

    How do I know I am using the fill handler? 

    • Chunky Plus

       
    • Skinny Plus

       
    • Crosshair

       
    • Double-Arrow

       

  9. 00:06:48 

    Where do I find the fill handler if I want to copy functions/formulas from cell to cell? 

     ____________________________ 


  10. 00:07:31 

    Just like in Word, I can apply Styles to my cells in Excel. 

    • True

       
    • False

       

  11. 00:09:34 

    Where do you go to format numbers in Excel with things like $ , or %? 

    • Home > Number

       
    • Insert > Format

       
    • Home > Format

       
    • Formulas > Number

       

  12. 00:10:24 

    Which edits can I do to my Excel Sheet? 

    • Rename

       
    • Recolor

       
    • A & B

       
    • You can't edit your sheet

       

  13. 00:10:44 

    To change the name/color of an Excel sheet, I      

    • Use cell styles

       
    • Right click

       
    • Left click

       
    • Use the highlight sheet format

       

  14. 00:11:50 

    Which is NOT true about inserting a chart into Excel? 

    • Select your data first

       
    • Use the insert tab

       
    • There are many different types of charts to choose from

       
    • Include the chart title, column & row headings, and totals/max/min/avg

       

  15. 00:12:03 

    You should try to position your charts/graphs      

    • Close to the data

       
    • On a new sheet

       
    • Doesn't matter where

       
    • On top of your table of data

       

  16. 00:12:20 

    A chart cannot be resized/moved once it's put into a worksheet. 

    • True

       
    • False

       

  17. 00:13:03 

    Which is a tab under Chart Tools? 

    • Design

       
    • Format

       
    • A & B

       
    • There is no tab for Chart Tools

       

  18. 00:13:43 

    Why would a chart appear blank in Excel? 

     ____________________________ 


Click here to preview, use, or make a copy of this interactive video lesson plan (bulb).