Excel Q1 Review

Multiple Choice

Which of the following graphs displays its information in a horizontal position

• Column Graph

• Bar graph

• Pie graph

Multiple Choice

What is the correct order for how to find the average of this data?

• Select Cells C3:C18

  Copy

  Select Cell E2

  Type =AVERAGE

  Paste

  Enter

• Select Cell E2

  Type =AVERAGE

  Open Parenthesis

  Select Cells C3:C18

  Close Parenthesis

  Enter

• Select Cells C3:C18

  Type =AVERAGE

  Open Parenthesis

  Select Cell E2

  Close Parenthesis

  Enter

Multiple Choice

What does this do?

• Inserts another row

• Inserts another column

• Merges and centers the cells

• Automatically Adjusts Column Width

Draw

Draw a box around the data you would select for the Average function

Fill in the Blanks

What would the function to find the average of only female students be?

Poll

According to this data, are you above or below these average heights?

• Above average

• Below average

Multiple Choice

What order is this data sorted?

• By gender

• Alphabetically by name

• By height in ascending order

• By height in descending order

Open Ended

What is your favorite excel graph?

Multiple Choice

Which of the following graphs CANNOT be used for comparison over various categories?

• Clustered Bar Graph

• Stacked Line Graph

• 3-D Column Graph

Multiple Choice

True or False: You must always type in the function you wish to use.

• True

• False

Poll

What type of chart would be best to display this information?

• Bar Graph

• Column Graph

• Pie Graph

• Line Graph