Timeline slicers for dates

Name:

Date:

Class:

Quick Questions

Shade in the A or B circle for each question.

1. Which menu path adds a timeline slicer to a pivot table?

A Insert > Timeline Chart Row

B Insert > Timeline

2. A timeline slicer filters a pivot table by...

A Dragging along a date range

B Typing a formula in a cell

3. Which kind of field does a timeline slicer need?

A A text field like Name

B A date field

4. Where do you change the timeline from months to quarters?

A The time level drop-down

B The Sort A to Z button

5. Your orders column holds dates stored as text, such as 'third of Feb'. Will Insert > Timeline work?

A No, it needs real date values

B Yes, any column works

Match the Pairs

Draw a line connecting each item on the left to its match on the right.

Left column		Right column
1Insert > Timeline		AA timeline slicer filters by date ranges, not by text categories like region. Dragging along it changes the dates shown.
2Time level drop-down: Months \| Quarters \| Years		BInsert > Timeline
3A timeline slicer is added from the Insert tab and filters a pivot table by a range of dates		CA timeline slicer needs a date field. With only text and number columns there is nothing to build the timeline from.
4To view sales one quarter at a time, change the time level on the timeline		DTime level: Quarters
5Insert > Timeline on a table with a Name column and a Score column only		EChanges the size of the time steps the timeline slicer uses to filter the pivot table
6Dragging the timeline slicer bar to filter by region name		FAdds a timeline slicer to a pivot table so you can filter its data by dragging along a date range

Definitions

Insert > Timeline

Fill in the Blanks

Complete each line of code by filling in the missing parts.

Insert > ________

______ > Timeline

Time level: Months, ________, Years

A timeline needs a ____ field

Click the __________, then Insert > Timeline

Spot the Error

Shade in the letter of the line that contains an error.

Question 1

A Click inside the pivot table

B Go to Insert > Timeline

C Tick the Name field, press OK

D Drag along the timeline bar

Question 2

A Click inside the pivot table

B Insert > Timeline

C Pick Hours in time level

D Drag the bar across Jan-Mar

Question 3

A Click inside the pivot table

B Insert > Slicer

C Tick the OrderDate field

Question 4

A Click outside the pivot table

B Insert > Timeline

C Tick the OrderDate field

Question 5

A Click inside the pivot table

B Insert > Timeline, tick Date

C Type Jan-Mar into a text box

Answer Key

Timeline slicers for dates

Section A: Quick Questions

B — Insert > Timeline

A — Dragging along a date range

B — A date field

A — The time level drop-down

A — No, it needs real date values

Section B: Match the Pairs

Insert > Timeline → Adds a timeline slicer to a pivot table so you can filter its data by dragging along a date range

Time level drop-down: Months | Quarters | Years → Changes the size of the time steps the timeline slicer uses to filter the pivot table

A timeline slicer is added from the Insert tab and filters a pivot table by a range of dates → Insert > Timeline

To view sales one quarter at a time, change the time level on the timeline → Time level: Quarters

Insert > Timeline on a table with a Name column and a Score column only → A timeline slicer needs a date field. With only text and number columns there is nothing to build the timeline from.

Dragging the timeline slicer bar to filter by region name → A timeline slicer filters by date ranges, not by text categories like region. Dragging along it changes the dates shown.

Section C: Definitions

Insert > Timeline — A timeline slicer filters a pivot table by dragging along a date range. Pick months, quarters or years from the time level drop-down. It needs a date field.

Section D: Fill in the Blanks

Insert > Timeline

Time level: Months, Quarters, Years

A timeline needs a date field

Click the PivotTable, then Insert > Timeline

Section E: Spot the Error

C — A timeline slicer needs a date field. A text field like Name cannot be used. It should be 'Tick the Date field, press OK'.

C — The time level drop-down offers Years, Quarters, Months and Days. Hours is not a choice. It should be Months (or another valid level).

B — Insert > Slicer makes a normal slicer with buttons for text items. A date range bar needs Insert > Timeline.

A — Timeline needs the pivot table to be selected first. Click inside the pivot table, not outside it.

C — A timeline has no text box. You filter by dragging the bar (or its handles) along the date range.