Excel 4 Quiz 1

Which of the following is a type of chart?

• Pie
• Column
• Line
• All are charts

A graphical representation of data is a

• Chart
• column
• cell
• X-axis

The PMT function is in which catagory of functions?

• Financial
• text
• logical
• Lookup & Reference

James has created a spreadsheet containing student grades. Which function would he use to return the current date in cell A1?

• COUNT
• IF
• NOW
• TODAY

When you create a graph, you...

• select all the data.
• select what you want to affect.
• select the first cell only.
• select the entire spreadsheet.

Hal has used two different colors in his column chart to show the revenue and expenses for the year.  What will Hal use to explain the different column colors?

• X axis 
• Y axis
• Legend
• Chart Title

Amanda has created multiple charts for each product sold. How will her manager know the name of each chart?

• X axis
• Y axis 
• Legend
• Chart Title

Greg has created a pie chart.  Beside each pie piece is a number used to identify the amount of that part of the graph.  What are those numbers called?

• tick marks
• grids
• labels
• legend

The lines that extend from the y axis  to make it easier to see data values are called 

• gridlines
• scale
• labels
• legend

Numbers on the Y- or X-axis representing quantities.

• tick marks
• scale
• labels
• legend