Excel Practice Test

โ–ถ

The best tips for using Excel pivot tables are to start with clean, tabular data converted to an Excel Table, drag fields into the Rows, Columns, Values, and Filters areas, group dates and numbers, add slicers or timelines, and refresh after the data changes. These habits make summaries faster, more accurate, and easy to update. Practice with the free Excel practice test on PracticeTestGeeks (25 questions with answer explanations).

The best tips for using Excel pivot tables are to start with clean, tabular data converted to an Excel Table, drag fields into the Rows, Columns, Values, and Filters areas, group dates and numbers, add slicers or timelines, and refresh after the data changes. These habits make summaries faster, more accurate, and easy to update. Practice with the free Excel practice test on PracticeTestGeeks (25 questions with answer explanations).

Tips for Using Excel Pivot Tables: Key Facts (Updated November 2026)

FactDetailsSource
Certification that tests pivot skillsMicrosoft Office Specialist (MOS) Excel Associate (Microsoft 365 Apps), exam MO-210Microsoft Learn
Number of questions33 to 37 for Associate (MO-210); 23 to 27 for Expert (MO-211)Certiport
Exam time50 minutes of exam time, 60 minutes of total seat timeCertiport
Passing score700 on a scaled score of 1 to 1000Certiport
Retake rulesWait 24 hours before the first retake and 48 hours before each later retake; no annual attempt limitMicrosoft Learn
Certification validityFive years for MOS Excel certifications earned on or after September 23, 2025Certiport
Retired examMOS Excel 2016 was retired on June 30, 2026; Microsoft 365 Apps and Office 2019 exams remain availableCertiport

Pivot tables are the fastest way to turn thousands of rows of raw transactions into a clear summary without writing a single formula. You drag fields into four areas, and Excel recalculates totals, counts, and averages instantly. Before you build one, test your baseline with our excel fundamentals quiz, because pivot tables assume you already understand ranges, headers, and basic formulas. These tips apply to Microsoft 365, Excel 2021, and Excel 2019.

The first tip is also the most ignored: prepare the source data. A pivot table needs one header row, one record per row, and no blank rows or columns inside the range. Every column needs a unique, non-empty heading, because that heading becomes a field name. Avoid merged cells in the source. Knowing how to merge cells in Excel is a formatting skill for finished reports, not for data, since merged cells leave blanks that a pivot table treats as missing values.

Next, convert the range to an Excel Table by selecting any cell and pressing Ctrl+T. A Table expands automatically when you add rows, so your pivot table picks up new records after a refresh instead of silently ignoring them. Name the Table something meaningful, such as SalesData, on the Table Design tab. When you insert the pivot table, Excel uses that name as the source, which makes the report easier to audit and far easier to hand to a colleague.

Building the pivot table takes four moves. Click inside the data, choose Insert, then PivotTable, and place it on a new worksheet. In the field list, drag a text field such as Region into Rows, a date or category into Columns, a number such as Revenue into Values, and a broad filter such as Year into Filters. Excel defaults to Sum for numbers and Count for text, so confirm the summary matches what you need.

Layout choices matter as much as field choices. Open the Design tab and switch to Tabular Form or Outline Form if you want every row field in its own column, which is easier to copy and filter. Turn on Repeat All Item Labels so each row carries its label, and switch off grand totals you do not need. A clean layout means fewer questions from the people reading your report and fewer manual fixes afterward.

Finally, remember that a pivot table is a snapshot until you refresh it. Press Alt+F5 to refresh the selected pivot table, or Ctrl+Alt+F5 to refresh everything in the workbook. You can also tick Refresh data when opening the file in PivotTable Options. The rest of this guide covers grouping, slicers, calculated fields, dashboards, and the mistakes that cause wrong totals, with numbers and examples you can reproduce in a few minutes.

You can continue preparing with the excel practice exam free, which includes answer explanations for every question.

You can continue preparing with the microsoft excel download free, which includes answer explanations for every question.

Free Excel Study Tools

Interactive Excel resources on PracticeTestGeeks, free to start:

Excel Pivot Tables by the Numbers

๐Ÿ“
1,048,576
Maximum rows per worksheet
๐Ÿงฉ
4
Field areas
๐ŸŽš๏ธ
2010
Year slicers arrived
โฑ๏ธ
50 min
MOS Excel exam time
โœ…
700
MOS passing score
Test Your Tips for Using Excel Pivot Tables With Free Practice

How Do You Create a Pivot Table in Excel Step by Step?

๐Ÿงน 1. Prepare the Source Data

Give every column a unique header, remove blank rows, avoid merged cells, and press Ctrl+T to turn the range into a named Table. A clean Table grows with your data and keeps the pivot source accurate.

๐Ÿ“‹ 2. Insert the PivotTable

Click any cell in the Table, choose Insert, then PivotTable, and pick a new worksheet. Using a separate sheet prevents the pivot from overwriting data when it expands after a refresh.

๐Ÿงฉ 3. Arrange the Fields

Drag text fields to Rows, categories or dates to Columns, numbers to Values, and broad selectors such as Year to Filters. Change Sum to Average, Count, or Max through Value Field Settings when needed.

๐ŸŽจ 4. Format and Name It

Apply a number format through Value Field Settings so it survives refreshes, choose Tabular Form on the Design tab, and rename the pivot on the PivotTable Analyze tab so formulas and slicers are easy to identify.

๐Ÿ”„ 5. Refresh and Share

Press Alt+F5 after any data change, or enable refresh on open. Before sharing, check that totals match the source with a quick SUM, and save the workbook to OneDrive so collaborators see the latest version.

How Do Excel Tables and Data Validation Make Pivot Tables Better?

Clean input is what separates a trustworthy pivot table from a misleading one. Data validation, found under Data and then Data Validation, restricts what people can type into a column. Learning how to create a drop down list in Excel takes under a minute: choose List, then type values such as East, West, North, South, or point to a range. Consistent labels prevent the classic problem of North and North with a trailing space appearing as two separate rows.

Excel Tables and validation work well together. If you keep the drop-down source list in its own Table, the list grows as you add items, and every validated cell updates automatically. Create a defined name that points to the Table column, then type that name into the Source box of the validation dialog. When a new region opens, you add one row to the list and every data entry sheet offers the new choice immediately.

Check that dates are real dates. A cell that is left-aligned by default is usually text, even if it looks like 03/15/2026. Pivot grouping only works when every cell in the date column is a true date, and a single text entry triggers the error message Cannot group that selection. Fix stubborn dates with Data, Text to Columns, then Finish, or wrap the cell in DATEVALUE and paste the results back as values.

Numbers stored as text cause quieter damage. When a Revenue column contains text numbers, the pivot table defaults to Count instead of Sum, and your report shows 412 instead of $86,350. Look for green triangles in the corner of cells, select the column, and choose Convert to Number. If the triangles are missing, type 1 in a blank cell, copy it, select the column, and use Paste Special with Multiply to force conversion.

Helper columns inside the Table make pivot tables dramatically more useful. Add a Profit column with the formula =[@Revenue]-[@Cost], a Month column with =MONTH([@Date]), or a Size Band column with a nested IF. Table formulas fill down automatically for new rows. Because the pivot reads the Table, each helper column appears in the field list as a new field you can drag into Rows, Columns, or Values the next time you refresh.

Lookup columns solve the common problem of an orders list that has product IDs but no categories. A VLOOKUP Excel formula such as =VLOOKUP([@ProductID],Products,3,FALSE) pulls the category from a reference Table, and XLOOKUP does the same job with fewer arguments. Which functions you can use depends on your version of ms excel, since XLOOKUP ships with Microsoft 365 and Excel 2021 but not Excel 2016. Doing the lookup in the source keeps the pivot simple.

Finally, make the source readable while you work. Learning how to freeze a row in Excel helps: on the data sheet, choose View, then Freeze Panes, then Freeze Top Row, so the headers stay visible as you scroll through 20,000 records. Also save a backup copy before cleaning, because find-and-replace and text conversions are difficult to undo once you have saved. Ten minutes of preparation usually saves an hour of troubleshooting later.

EXCEL Practice Test: Video 1 Answers (25 Questions)
Check core Excel skills like formulas, formatting, and data entry with 25 answered questions.
EXCEL Practice Test: Video 2 Answers (25 Questions)
Practice intermediate Excel tasks and review explained answers across 25 realistic questions.

How Do You Group, Filter, and Slice Pivot Table Data?

๐Ÿ“‹ Grouping Dates and Numbers

Grouping turns raw detail into meaningful buckets. Right-click any date in Rows, choose Group, and select Months, Quarters, and Years together. A column with 1,095 daily dates becomes 12 months per year, which reads far better. Number grouping works the same way: group Age or Price into steps of 10 or 100 to build a histogram-style summary. Every cell in the field must be a real date or number, so fix text entries first.

To group text items, such as combining East and West into a Coastal bucket, hold Ctrl, click each item, right-click, and choose Group. Rename the new group directly in the cell. Use this sparingly, because manual groups do not update when new regions appear. For anything permanent, add a Region Group column to the source Table with a lookup, then drop that field into Rows. It survives refreshes and is easy to explain to the next person.

๐Ÿ“‹ Slicers and Timelines

Slicers are clickable filter buttons, available since Excel 2010. Select the pivot table, choose PivotTable Analyze, then Insert Slicer, and tick fields such as Region or Product. Click a button to filter instantly, and hold Ctrl to pick several. Slicers show the current filter state at a glance, which a drop-down in the Filters area never does. On the Slicer tab, set columns to two or three to keep a dashboard compact.

For dates, insert a Timeline instead, which gives a draggable bar showing months, quarters, or years. One slicer can control several pivot tables: right-click it, pick Report Connections, and tick every pivot table that should respond. All of them must share the same pivot cache, so copy and paste an existing pivot table to create the next one. That guarantees the connection list includes every report you want filtered together.

๐Ÿ“‹ Calculated Fields and Show Values As

Calculated fields add a formula that works on summed values. Choose PivotTable Analyze, Fields Items and Sets, then Calculated Field, and enter something like =Revenue-Cost named Profit. Excel sums Revenue and Cost first, then subtracts, so a field such as Margin =Profit/Revenue works at every level of the report. Calculated fields cannot reference single cells or use lookup functions, so anything row-specific belongs in a helper column inside the source Table instead.

Show Values As is often faster than a formula. Right-click a value, choose Show Values As, and pick percent of grand total, percent of column total, running total, or difference from the previous month. Drop Revenue into Values twice: one copy as Sum, one as percent of grand total. If sales were $48,000 in March and $60,000 in April, the difference-from setting shows a $12,000 increase without a single cell reference or formula.

Are Pivot Tables Better Than Formulas for Summarizing Data?

Pros

  • Summarize 100,000 rows in seconds by dragging fields instead of writing SUMIFS formulas
  • Change the layout instantly by moving a field from Rows to Columns
  • Group dates into months, quarters, and years with two clicks
  • Slicers and timelines give non-technical readers interactive filtering
  • Refreshing updates every total from the source without rebuilding anything
  • PivotCharts stay linked to the pivot table and update with it

Cons

  • Pivot tables do not update automatically; you must refresh them
  • Messy source data produces wrong totals without any visible error
  • Calculated fields cannot use lookups or reference individual cells
  • Cell formatting can reset after a refresh unless Preserve cell formatting is on
  • Very large pivot caches increase file size and slow down saving
  • Formulas give more control over exact placement in a fixed report layout
EXCEL Practice Test: Video 3 Answers (23 Questions)
Work through 23 Excel questions with answers covering functions, tables, and data analysis.
EXCEL Practice Test: Video 4 Answers (24 Questions)
Build confidence with 24 Excel questions and answers on charts, filters, and summaries.

What Is the Best Checklist for Using Excel Pivot Tables?

Give every source column a unique header and remove blank rows.
Convert the data range to a named Table with Ctrl+T.
Confirm dates and numbers are real values, not text.
Insert the pivot table on a new worksheet.
Check each value field uses Sum, Count, or Average on purpose.
Switch to Tabular Form and repeat item labels on the Design tab.
Apply number formats through Value Field Settings.
Add slicers or a timeline for interactive filtering.
Compare the grand total with a SUM of the source column.
Refresh with Alt+F5 and save the workbook before sharing.
Turn On Refresh Data When Opening the File

Right-click the pivot table, choose PivotTable Options, open the Data tab, and tick Refresh data when opening the file. Readers then always see current numbers, which prevents the most common pivot table complaint: a report that looks right but shows last month's totals.

What Are the Best Tips for Using Power Query in Excel With Pivot Tables?

Power Query is the best companion to a pivot table because it cleans data before the pivot ever sees it. Open Data, then Get Data, and import from a workbook, CSV file, folder, or database. The Query Editor records every step you take, from removing columns to changing types, and replays those steps on each refresh. Our guide to best tips for using power query in excel: import, clean, merge, and build refresh-proof queries covers the full workflow.

Start with the standard cleaning steps. Use Transform, then Format, then Trim to strip stray spaces, set each column to the right data type, and remove duplicates and blank rows. Setting the type to Date or Decimal Number inside Power Query solves the text-date and text-number problems from earlier permanently. If next month's export arrives with the same layout, you simply replace the file and press Refresh All, and the cleaning repeats automatically.

Merging queries replaces many lookup formulas. If an Orders query has a ProductID and a Products query holds the category, choose Home, then Merge Queries, select the matching columns, and pick Left Outer as the join. Expand the category column and you have the same result as a VLOOKUP Excel formula, only it runs on 200,000 rows without slowing the worksheet, and it does not break when someone inserts a column.

Append queries when your data arrives in pieces. Twelve monthly sheets with identical columns can be stacked into one query through Home, then Append Queries, or you can import a whole folder and combine every file in it. The pivot table then reads a single, complete dataset. When January through December become January through the following March, you drop the new file into the folder and refresh, with no copying and pasting.

Decide where to load the result. Choose Close and Load To, then Only Create Connection if you want a staging query that feeds other queries without cluttering a worksheet. For the final query, load it to a Table or directly to a PivotTable Report. Loading to the Data Model also lets you relate several Tables and build pivots across them, which handles one-to-many relationships that a single flat Table cannot express cleanly.

Keep queries refresh-proof by avoiding hard-coded assumptions. Do not filter on a fixed date typed into a step, because next quarter it will be wrong. Reference a parameter or a cell in a small settings Table instead. Give each step a clear name, and use column names rather than positions wherever possible. If a source column is renamed, the query will show an error that you can fix in one step rather than quietly returning wrong numbers.

After a refresh, remember the order of operations: Refresh All updates queries first, then pivot tables that depend on them. If a pivot is built on a query, one click refreshes the entire chain. For scheduled updates, store the workbook on OneDrive or SharePoint and open it regularly. Combined with a Table-based source, a Power Query pipeline gives you a reporting file that stays accurate with almost no manual effort each month.

How Do You Build a Pivot Table Dashboard in Excel?

A pivot table dashboard combines several summaries on one sheet that updates with a single refresh. Start by deciding on four to six measures, such as revenue, orders, average order value, and top products. Build one pivot table for each measure on a separate calculation sheet, then place PivotCharts and slicers on a clean dashboard sheet. Keeping calculations apart from presentation makes the file easier to maintain and prevents readers from accidentally moving fields around.

Create each pivot table from the same Table so they share one pivot cache. Build the first one, then copy and paste it to make the others, and change the fields in each copy. Sharing a cache keeps the workbook smaller, makes refreshes faster, and, most importantly, lets one slicer filter every pivot at once. Right-click the slicer, choose Report Connections, and tick all of the dashboard pivots in the list.

PivotCharts turn each pivot table into a visual. Select the pivot, choose Insert, then PivotChart, and pick a column chart for comparisons, a line chart for trends over time, or a bar chart for ranked lists. Right-click the chart and choose Hide All Field Buttons to remove the clutter. Because the chart is tied to the pivot, adding a slicer filter or refreshing the data updates both together.

Use GETPIVOTDATA when you need a single number in a formula. When you click a pivot value from another cell, Excel writes =GETPIVOTDATA("Revenue",$A$3,"Region","East") for you, which follows the value even if the pivot layout changes. Use this for KPI cards at the top of the dashboard, such as total revenue or the current month's orders. It is far more reliable than pointing to a cell address that can shift after a refresh.

Formatting makes a dashboard readable. Set column widths and turn off Autofit column widths on update in PivotTable Options so refreshes do not resize your layout. Use consistent number formats, such as $#,##0 for currency, and a limited color palette. Hide gridlines through the View tab, and lock the sheet with a password if you do not want readers dragging fields. Freeze the title row so the headline figures remain visible while scrolling.

Watch the pivot cache as your dashboard grows. Every pivot stores a copy of the source data, and over time old deleted items can linger in slicers and drop-downs. Set Number of items to retain per field to None in PivotTable Options, then refresh to remove them. Our guide to clear excel cache explains how to clean cached files, pivot caches, and AutoComplete data when a workbook slows down or shows stale entries.

Test the dashboard before sharing it. Change a slicer, add a test row to the source Table, refresh, and confirm every chart and KPI moves as expected. Then check the file size, since a workbook with ten pivots on 500,000 rows can reach 50 MB or more. Save as a standard xlsx file, store it on OneDrive for version history, and document the refresh steps in a Notes sheet so anyone can maintain the dashboard.

Practice Excel Summary and Analysis Skills With Video 2 Questions

What Are the Best Practices for Pivot Tables Before an Excel Exam?

If you are preparing for the Microsoft Office Specialist Excel exam, practice pivot tables inside the application, because the exam is delivered live in Excel rather than as multiple-choice screens. The Associate exam (MO-210) has 33 to 37 questions in 50 minutes, so you have roughly 80 to 90 seconds per task. Pivot table tasks usually combine two or three actions, such as inserting a pivot, adding a field, and applying a style.

Memorize the shortcuts that save seconds. Ctrl+T creates a Table, Alt+N+V opens the PivotTable dialog, Alt+F5 refreshes, and Ctrl+Z undoes a field drag that landed in the wrong area. Knowing where the Design and PivotTable Analyze tabs sit prevents hunting through menus. Practice until opening Value Field Settings, Group, and Insert Slicer feels automatic, because every second you spend searching reduces time for later questions.

Read each task carefully before touching the mouse. Exam instructions often specify exact details: place the pivot table on a new worksheet, show averages instead of sums, or sort Region from largest to smallest. Missing one detail can cost the whole task. Complete every requested change in order, then re-read the instruction once to confirm. If a task is taking more than two minutes, flag it, move on, and return if time permits.

Build a practice routine around small datasets you invent. Create a 200-row sales list with Date, Region, Product, Units, and Price, then answer ten questions with pivot tables: top region by revenue, monthly trend, average units per order, and percent of total by product. Repeat with different fields until each answer takes under a minute. Hands-on repetition builds speed far more effectively than reading about features.

Learn the most common errors and how to fix them quickly. A pivot showing Count when you expected Sum means the numbers are stored as text. A date field that refuses to group means a text value is hiding in the column. A pivot that ignores new rows means the source range was fixed rather than a Table. Recognizing these three patterns solves most real-world problems and many exam scenarios.

Know the scoring and retake rules so you can plan. The passing score is 700 on a scale of 1 to 1000, and you see your score report as soon as you finish. If you do not pass, you wait 24 hours before the first retake and 48 hours before later ones, with no annual limit on attempts. Certifications earned on or after September 23, 2025 stay valid for five years.

Finally, combine practice tests with real projects. Take a free practice test to find weak spots, then build a pivot table from your own budget, inventory, or class gradebook to reinforce what you missed. Review mistakes the same day while the details are fresh. Two or three focused sessions of 45 minutes each week usually build exam-ready pivot skills within a month, and the same skills pay off immediately at work.

Free Excel Basic and Advance Questions and Answers
Test beginner through advanced Excel knowledge with free questions and clear explanations for every answer.
Free Excel Formulas Questions and Answers
Sharpen your SUM, IF, lookup, and text formula skills with free questions and answers.

Sample Excel Practice Questions

Try these questions from our free Excel practice tests. The correct answer and an explanation follow each question.

  1. A user has finished their analysis using an Excel table and now needs to send the worksheet to a colleague who is using a much older version of Excel that does not support table features. The user wants to remove the table functionality (e.g., structured references, automatic expansion) but keep all the data and cell formatting. What is the most direct way to do this?

    • A. Select the table and use the 'Clear Formats' button on the Home tab.
    • B. Delete the table's name from the Name Manager.
    • C. On the 'Table Design' tab, in the 'Tools' group, click 'Convert to Range'.
    • D. Copy the table and use 'Paste Special' with the 'Values' option.

    Answer: C. On the 'Table Design' tab, in the 'Tools' group, click 'Convert to Range'.

    The 'Convert to Range' command is the designated feature for removing the underlying table object and its functionality while preserving the data and the visual formatting that was applied by the table style.

  2. What is the correct syntax to look up a value in the first column of a table and return a value from another column using VLOOKUP?

    • A. VLOOKUP(value, range, row_num, match)
    • B. VLOOKUP(value, table_array, col_index_num, range_lookup)
    • C. VLOOKUP(col_index, value, table_array, match)
    • D. VLOOKUP(value, col_index_num, table_array, match)

    Answer: B. VLOOKUP(value, table_array, col_index_num, range_lookup)

    VLOOKUP syntax is =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).

  3. You are using the XLOOKUP function to find an employee's salary in a table. The formula is `=XLOOKUP(E2, A2:A100, D2:D100, "Not Found", 0, -1)`. What does the final argument, `-1`, specify?

    • A. An exact match is required.
    • B. The search will start from the bottom of the lookup array and go up.
    • C. If an exact match isn't found, it will return the next smaller item.
    • D. The search will be performed horizontally instead of vertically.

    Answer: B. The search will start from the bottom of the lookup array and go up.

    The sixth argument in the XLOOKUP function is `[search_mode]`. A value of -1 specifies that the search should be conducted in reverse order, from the last item to the first. The default is 1, which searches from first to last.

  4. Which of the following allows you to create relationships between multiple tables and build complex calculations using Data Analysis Expressions (DAX) to overcome the limitations of traditional PivotTables on a single flat table?

    • A. Power Pivot
    • B. Power Query Editor
    • C. Analysis ToolPak
    • D. Scenario Manager

    Answer: A. Power Pivot

    Power Pivot is an Excel add-in that enables you to perform powerful data analysis and create sophisticated data models. It allows you to import millions of rows of data from multiple sources, create relationships between heterogeneous data, and write complex formulas using the DAX language.

Take the full Excel practice test

Excel Questions and Answers

How do you share Excel tables in OneDrive?

Save the workbook to OneDrive, then select Share in the top-right corner of Excel. Enter email addresses or copy a link, and choose Can edit or Can view. Tables live inside the workbook, so everyone you share with sees them. For co-authoring, collaborators should use Excel for the web or a current Microsoft 365 desktop version.

What are the best tips for using Excel pivot tables?

Start with clean data in an Excel Table, one header row, and no merged cells. Drag fields into Rows, Columns, Values, and Filters, then group dates, add slicers, and use Show Values As for percentages. Always refresh with Alt+F5 after changing the source, and compare the grand total with a SUM of the original column.

Why does my pivot table show Count instead of Sum?

Excel shows Count when the value column contains text, blanks, or numbers stored as text. Convert the column to numbers by selecting it and choosing Convert to Number, or use Paste Special with Multiply by 1. Then refresh the pivot and drag the field again, or change it to Sum in Value Field Settings.

How do you refresh a pivot table in Excel?

Click inside the pivot table and press Alt+F5, or choose PivotTable Analyze and then Refresh. Use Ctrl+Alt+F5 to refresh every pivot table and query in the workbook. You can also tick Refresh data when opening the file in PivotTable Options so the report always updates automatically when someone opens it.

Why will my pivot table not group dates?

Grouping fails when the date column contains text, blanks, or errors. Check that every cell is a true date, which usually right-aligns by default. Fix text dates with Text to Columns or DATEVALUE, fill or remove blanks, refresh, and then right-click a date and choose Group again to select Months, Quarters, or Years.

Can a pivot table use a VLOOKUP in Excel?

Not inside the pivot itself, but you can add a VLOOKUP or XLOOKUP column to the source Table and then use the new field in the pivot. This is the best approach for adding categories or prices. Power Query merge queries can do the same lookup more efficiently on very large datasets.

What is the difference between a slicer and a filter?

A filter is a drop-down in the Filters area or a field header, while a slicer is a visible button panel that shows which items are selected. Slicers work with several pivot tables at once through Report Connections, and timelines add date-range sliders. Both reduce the data shown, but slicers are clearer for dashboards.

How do I stop column widths changing after a refresh?

Right-click the pivot table, choose PivotTable Options, and on the Layout and Format tab, untick Autofit column widths on update. Also keep Preserve cell formatting on update ticked. Apply number formats through Value Field Settings rather than formatting cells directly, so currency and percentage formats remain after every refresh.

Do I need Power Query to use pivot tables?

No, pivot tables work fine on any clean Excel Table. Power Query becomes valuable when your data arrives in messy or repeated exports, because it records cleaning steps and reapplies them on refresh. It is also helpful when you must combine several files or merge lists before summarizing them.

How many questions are on the MOS Excel Associate exam?

The MOS Excel Associate exam (MO-210) has 33 to 37 questions, and you have 50 minutes of exam time within a 60-minute seat time. The Expert exam (MO-211) has 23 to 27 questions. The passing score is 700 on a scale of 1 to 1000, and you receive your score report immediately.
โ–ถ Start Quiz