Which chart type is the most appropriate to show percentages, such as how much of your total monthly budget you spend on rent?
What is a PIE CHART?
100
A hyperlink provides what?
What is a link or reference to another website or email address. It usually has blue underline on it....
100
In the formula =$B$4*C4, which cell address will change when the cell is copied?
What is only the cell address that is NOT an absolute cell address will change, that means C4 would change. [$B$5 will not change at all when copied. ]
100
Using EXCEL, what does the F4 key do to a cell address. e.g.) C5 ?
What is makes the cell an absolute address. eg) C5 would now become $C$5 after you pressed the F4 key!
100
The icon to add an arrow to a chart can be found where?
What is Insert Tab, Shapes, Arrows
200
What indicates (shows) that a chart or chart object is currrently SELECTED?
What is dots around the edge of the chart.
200
How do you create a hyperlink on a spreadsheet/worksheet?
What is click on Insert Tab, Hyperlink! Key the website address or the email address you want.
200
$C$9 is an example of what type of cell reference?
What is an "ABSOLUTE" cell reference.
200
The function key you press in Excel to quickly edit a cell's content in a worksheet is what?
What is F2!
200
A graphic representation of data in a worksheet is called a?
What is a CHART!
300
Name the FIRST step when creating a CHART?
What is swipe (select) the data series: labels and number data.
300
What is the fill handle used for?
What is copying the contents of a cell to adjacent, (nearby) cells.
300
Pointing refers to using the mouse to click on another cell to grab cell references instead of keying the cell reference by hand to use in a?
What is a FORMULA.
300
What is the function key used to quickly do a spell check?
What is F7!
300
Name an example of a web browser?
What is Internet Explorer.
400
Can embedded charts be dragged an dropped to any location in the worksheet?
What is YES!
400
What is the easiest way to delete a chart from a worksheet?
What is click on the chart, press the DELETE key.
400
How do you add a CHART TITLE to a chart?
What is apply a Chart Layout to the chart.
400
Which tab would you go to first, to find a callout to add to a chart?
What is Insert Tab
500
Where is the icon to change the chart type from Cluster Bar to Pie chart located on which TAB?
What is the Design Tab!
500
What kind of software is EXCEL?
What is spreadsheet software.
500
How would you write a formula to add three cells together using the SUM function?
What is =sum(A1:A3)
500
The tiny black square that appears in the lower right hand corner of a selected cell is called the?
What is fill handle
500
If you create a chart on the same sheet as the worksheet that you selected the data ranges from to make the chart, what would this chart be called?