Lab Quiz 4 Study Guide

Question 1

What keys do you press to make an array formula?

Answer 1

Control + shift + enter
Make sure everything is in {} brackets

Question 2

Sorting data

Answer 2

Data > Sort icon from Sort and Filter group > Custom sort

Question 3

Filtering data

Answer 3

Data > Filter icon from Sort and Filter group

Question 4

Create pivot table

Answer 4

Insert > Pivot table on top left