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 WEB SITE 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 a relative cell address will change, C4. [$B$5 will not change at all when copied as it is an absolute cell address!]
100
Using EXCEL, what does the F4 key on the KEYBOARD do to a cell address when you are typing a formula? 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 a block arrow shape to a chart can be found where?
What is Insert Tab, (Illustrations), Shapes, Arrows
200
What indicates (shows) that a chart or chart object is currrently SELECTED?
What are dots or handles 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. The same way you do it in Word.
200
$C$9 is an example of what type of cell reference?
What is an "ABSOLUTE" cell reference.
200
In Excel, the function key on the Keyboard you press 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 first swipe (select) the data series: which are the text labels and number data.
300
What is the FILL HANDLE used for in Excel?
What is copying the contents of a cell to adjacent, (nearby) cells. It saves you from keying the formula again.
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? HINT: Starts with an F
What is a FORMULA.
300
What is the function key on the keyboard that is used to quickly do a spell check?
What is F7!
300
Name an example of a web browser?
What is Google Chrome or Internet Explorer.
400
Can embedded charts be dragged an dropped to any location in the worksheet?
What is YES! An embedded chart is a chart that is created on the SAME worksheet as the data it graphically represents. Embedded means its like a picture that you can size, drag and drop anywhere.
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 Legend to a chart?
What is select the chart, then click on the plus sign to open the Chart Features and check the Legend feature.
400
What is the Excel Function used to find the highest number in a range of Numbers?
What is the MAX function? e.g.) =MAX(A1:A6)
400
Which TAB on the Excel Ribbon would you go to first, to find a callout or arrow shape 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! Everything to do with charts is located in the Design tab.
500
What kind of software is EXCEL? Word Processing, Spreadsheet, Database, or Presentation software? Pick one!
What is spreadsheet software.
500
How would you write a formula to add three cells in A1, A2 and A3 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? Hint: Begins with an E