Creating Cross-Tabulations in Excel: Steps & Examples


Choose an answer and hit 'next'. You will receive your score and answers at the end.

question 1 of 3

A crosstab is different from a simple spreadsheet because it _____.

Create Your Account To Take This Quiz

As a member, you'll also get unlimited access to over 79,000 lessons in math, English, science, history, and more. Plus, get practice tests, quizzes, and personalized coaching to help you succeed.

Try it risk-free
Try it risk-free for 30 days. Cancel anytime
Already registered? Log in here for access

1. In Microsoft Excel, _____ is the command that corresponds to a total. _____ is the command that corresponds to an average.

2. To create a crosstab in Excel, use the _____ and the _____ menu items.

Create your account to access this entire worksheet
A Premium account gives you access to all lesson, practice exams, quizzes & worksheets
Access to all video lessons
Quizzes, practice exams & worksheets
Certificate of Completion
Access to instructors
Create an account to get started Create Account

About This Quiz & Worksheet

See how much you know about Excel crosstabs with this short multiple-choice quiz. The quiz allows you to quickly test your knowledge of the parameters, commands and benefits of this particular Excel function.

Quiz & Worksheet Goals

The quiz/worksheet will ask you questions about:

  • The difference between crosstabs and simple spreadsheets
  • The Excel commands that correspond to an average and a total
  • The process of creating a crosstab in Excel
  • PivotCharts parameters
  • The main benefit of displaying data through crosstabs

Skills Practiced

  • Information recall - access the knowledge you've gained regarding entering parameters for PivotCharts
  • Knowledge application - apply your understanding of crosstabs to answer questions about their functions and benefits
  • Distinguishing differences - determine why a crosstab is different from a simple spreadsheet

Additional Learning

To further enhance your understanding of this Excel function, review the lesson called Creating Cross-Tabulations in Excel: Steps & Examples. The lesson is designed to help you:

  • Learn how crosstabs can be used in real-world business situations
  • Assess the level of detail that can be displayed in a crosstab
  • Explain how crosstabs can be adjusted