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

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