Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
Give this quiz to my class
Q 1/9
Score 0
Tables include ________________________ by default. This is shown by the drop down arrows in the column headings.
30
a total row
number formatting
sorting
filtering
Q 2/9
Score 0
What is the purpose of a pivot table?
30
To summarize large quantities of data into a meaningful and useful form
To confuse poor, unsuspecting students
To flip the rows and columns
To create a chart that you can use in reports
9 questions
Q.
Tables include ________________________ by default. This is shown by the drop down arrows in the column headings.
1
30 sec
Q.
What is the purpose of a pivot table?
2
30 sec
Q.
One of the benefits of formatting your data as a table is that it lets you easily sort and filter your data.
3
30 sec
Q.
When you want to sort on more than one column in your worksheet you must
4
30 sec
Q.
You always have to print your entire worksheet.
5
30 sec
Q.
If you have a spreadsheet that is more than one page long, you can use _________________ to have the column headings print on all pages
6
30 sec
Q.
_________________________ lets you print a subsection of your spreadsheet
7
30 sec
Q.
If you want to pull a subset of data from a column of data that is formatted consistently (for example last name from a column of email addresses), you can use ___________________________________.
8
30 sec
Q.
Once you set a Pivot Table up you can't change the fields that it is based on.
