Pivot Tables & Logical Functions (IF, AND, OR, NOT)

What is being created here?

• Pivot table

• Converting a table as an excel table

• A graph

• A pivot chart

Which menu tab can you use to check this is a table?

Which pictures are showing that there are cells unprotected?

• A & B

• A & C

• B & C

• All of them

If I wanted to protect my worksheet, in which menu tab can I find "Protect Sheet" and "Protect Workbook"

• Table Design

• Review

• View

• Data

Which section of the graph tell you what each part of the chart represents (Legend)?

• Section A

• Section B

• Section C

• Section D

Which section in this graph, represents the Y axis?

• Section A

• Section B

• Section C

• Section D

Which section in this graph, represents the X axis?

• Section A

• Section B

• Section C

• Section D

If you want to select two columns that are NOT next to each other to create a chart, you hold down the ____ key on your keyboard.

• Ctrl (Control)

• Alt (Alternate)

• Shift

• Fn (Function)

The title of the graph is showing here as which section?

• Section A

• Section B

• Section C

• Section D

Section E in this graph, is refering to what?

• The Legend

• The Axis name

• The Labels

• The Title