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
-
00:01:24
What is the difference between a function and formula in Excel?
____________________________
-
00:01:45
Which is NOT a function?
=SUM( )
=MAX( )
=AVG( )
=2 + 2
-
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
-
00:02:30
is an example of a range of cells.
A3:A7
Q8
F4 - F9
Range(L34)
-
00:03:05
I can only use the range that Excel gives me.
True
False
-
00:03:55
You should include totals any time you do a function like Max/Min/Avg.
True
False
-
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
-
00:06:13
How do I know I am using the fill handler?
Chunky Plus
Skinny Plus
Crosshair
Double-Arrow
-
00:06:48
Where do I find the fill handler if I want to copy functions/formulas from cell to cell?
____________________________
-
00:07:31
Just like in Word, I can apply Styles to my cells in Excel.
True
False
-
00:09:34
Where do you go to format numbers in Excel with things like $ , or %?
Home > Number
Insert > Format
Home > Format
Formulas > Number
-
00:10:24
Which edits can I do to my Excel Sheet?
Rename
Recolor
A & B
You can't edit your sheet
-
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
-
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
-
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
-
00:12:20
A chart cannot be resized/moved once it's put into a worksheet.
True
False
-
00:13:03
Which is a tab under Chart Tools?
Design
Format
A & B
There is no tab for Chart Tools
-
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).