Quiz 3: Tables And Pivot Tables

8 Questions  I  By Enzanblaze
This quiz tests the basics of tables and pivot tables in Excel 2010. This was created primarily for students from Cal Poly Pomona. .?

  
Changes are done, please start the quiz.


Question Excerpt

Removing question excerpt is a premium feature

Upgrade and get a lot more done!
1.  Tables created through Excel's table feature allow users to filter columns by different values.
A.
B.
2.  Pivot tables allow filtering through different values.
A.
B.
C.
3.  Creating tables is as easy as highlighting cells that have already been filled in appropriately and then clicking on the insert tab and then clicking on the table button.
A.
B.
C.
D.
E.
4.  Once data in a table gets filtered, you cannot unfilter the table nor get the table back to the original settings.
A.
B.
C.
D.
5.  Which pivot table layout allows dragging fields to the grid in a spreedsheet.
A.
B.
C.
D.
6.  For a table to work properly, the top row should have column headings.
A.
B.
C.
7.  Check all that are true.
A.
B.
C.
D.
8.  Pivot tables that have been created can easily be turned into graphs or charts by simply highlighting the whole pivot table and choosing a graph or chart that you want to create.
A.
B.
C.
Back to top


to post comments.

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz