Excel Practice Test

β–Ά

To insert a date picker in Excel, enable the Developer tab (File, Options, Customize Ribbon), choose Insert, More Controls, and add Microsoft Date and Time Picker Control 6.0, or install a calendar add-in from Home, Add-ins. The legacy ActiveX picker is 32-bit only and does not load in 64-bit Office, and ActiveX is disabled by default in Microsoft 365 and Office 2024 (both points rest on Microsoft Q&A answers). Practice with the free Excel practice test on PracticeTestGeeks (500+ questions with answer explanations).

Excel has no built-in calendar button, so many workbooks use Data Validation instead (Data, Data Validation, Allow: Date) to reject invalid dates. This guide shows each way to add a date picker in Excel, with exact menu paths, a linking step, and fixes for the most common failures. Every date is stored as a serial number, so the picker only changes what you see, not the underlying value.

Excel stores every date as a serial number (January 1, 1900 is 1), so a picker writes a number and the cell format decides how it looks. Mismatched regional formats such as 03/04/2026 read as March 4 or April 3, which is why controlling entry matters.

The methods below build on each other. Data Validation is the baseline that works on Windows, Mac and the web, the ActiveX control is the classic 32-bit Windows answer, an add-in from Home, Add-ins is the modern route, and a VBA UserForm is the custom option.

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

You can continue preparing with the excel latest version, which includes answer explanations for every question.

Readers who want more detail usually continue with insert date picker in excel.

Microsoft Excel: upcoming dates and official changes
  • Jun 30, 2026: Certiport retired the Microsoft Office Specialist 2016 certifications, including MOS Excel 2016, on June 30, 2026. The Microsoft 365 Apps and Office 2019 Excel exams are still available. (certiport.pearsonvue.com)
  • Updated Oct 16, 2026: Delivery is now Proctored live-in-the-application exam via Certiport Authorized Testing Centers (in-center or remote-proctored) (previously Proctored live-in-the-application exam via Certiport Authorized Testing Centers).
  • Updated Oct 16, 2026: Eligibility is now No formal prerequisites; about 150 hours of instruction and hands-on experience recommended (previously No formal prerequisites; ~150 hours of instruction and hands-on experience recommended (Associate)).
  • Updated Oct 16, 2026: Time limit is now 50 minutes (60 minutes seat time) (previously 50 minutes (60 minutes seat time)).

Facts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.

Facts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.

Microsoft Excel Exam at a Glance

ItemDetailOfficial source
Number of questions (Excel Associate (MO-210))33-37 questionscertiport.pearsonvue.com
Number of questions (Excel Expert (MO-211))23-27 questionscertiport.pearsonvue.com
Time limit50 minutes (60 minutes seat time)Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business
Passing score700 on a 1–1000 scalecertiport.pearsonvue.com
Retake policyWait 24h after 1st fail, 48h before each later retake; no annual limitMicrosoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business
ValidityValid 5 years (earned on/after Sept 23, 2025)certiport.pearsonvue.com
DeliveryProctored live-in-the-application exam via Certiport Authorized Testing Centers (in-center or remote-proctored)Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business
EligibilityNo formal prerequisites; about 150 hours of instruction and hands-on experience recommendedMicrosoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business
Score releaseScore report at end of exam; also in Certiport profilecertiport.pearsonvue.com

Facts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.

Free Excel Study Tools

Interactive Excel resources on PracticeTestGeeks, free to start:

Date Picker in Excel by the Numbers

πŸ’»
32-bit only
Legacy ActiveX picker bitness
πŸ›‘οΈ
Disabled
ActiveX default setting
πŸ—“οΈ
Allow: Date
Data Validation path
🧩
Home > Add-ins
Add-in menu path

Reference of the verified ways to insert a date picker or date control, with where each one starts:

MethodWhere to startSteps in shortNeeds
Data Validation, Allow: DateData > Data ValidationSelect cells, set Allow to Date, choose a rule such as between, enter start and end datesNo macros; Windows, Mac, web
Data Validation, Allow: ListData > Data ValidationSet Allow to List, point Source at a range of dates, keep In-cell dropdown checkedNo macros; Windows, Mac, web
Microsoft Date and Time Picker Control 6.0Developer > Insert > More ControlsDraw the control, open Properties, set LinkedCell, turn off Design Mode32-bit Windows Office; ActiveX enabled
Office Add-in date pickerHome > Add-insOpen More Add-ins, search for a date picker, select AddWindows and Mac documented; some add-ins are paid
VBA UserForm calendarDeveloper > Visual BasicAlt+F11, Insert UserForm, add day buttons, call the form from a sheet event.xlsm file; cannot open in Excel for the web

Sources: Apply data validation to cells, ActiveX controls are disabled by default in Microsoft 365 and Office 2024, Add or remove add-ins in Excel, Workbooks with features unsupported by Excel for the web.

Try Free Excel Practice Questions on Date Picker

Four Ways to Insert a Date Picker in Excel

βœ… Data Validation Rule or List

Use Data, Data Validation, Allow: Date to restrict entries to a range, or Allow: List with a helper range of dates for a drop-down. Microsoft documents both for Windows, Mac and the web.

πŸ› οΈ ActiveX Date Picker

The classic Microsoft Date and Time Picker Control 6.0 from Developer, Insert, More Controls. It is 32-bit only and does not load in 64-bit Office, and ActiveX is disabled by default in Microsoft 365 and Office 2024 (Microsoft Q&A answers).

πŸ“¦ Office Add-in

Find calendar add-ins under Home, Add-ins. Microsoft documents the store on Windows and Mac; features, price and platform support are set by each publisher, so read the listing.

πŸ’» VBA UserForm

Build a calendar form from buttons and open it from a worksheet event. Full control over the look, but it needs a macro-enabled .xlsm workbook, which Excel for the web cannot open.

Data Validation is the simplest way to control dates and works the same way across Windows, Mac and the web. Select the cells, go to Data, Data Validation, set Allow to Date, choose a rule such as between, and enter the start and end dates or a formula like =TODAY(). Excel then rejects anything outside your range.

For a drop-down, type a list of dates on a helper sheet, name the range (for example DatePickerList), then set Allow to List and enter =DatePickerList as the Source. Keep In-cell dropdown checked so the arrow appears. Anyone opening the workbook can use it without macros, add-ins or security prompts.

Add conditional formatting to guide users. A formula such as =WEEKDAY(A1,2)>5 shades weekend dates, and =A1<TODAY() flags dates in the past. Because these are rules, not controls, they keep working wherever the workbook is opened.

Microsoft Excel Practice Test Questions

Prepare for the Microsoft Excel exam with our free practice test modules. Each quiz covers key topics to help you pass on your first try.

Microsoft Excel Excel Basic and Advance
Microsoft Excel Exam Questions covering Excel Basic and Advance. Master Microsoft Excel Test concepts for certification prep.
Microsoft Excel Excel Formulas
Free Microsoft Excel Practice Test featuring Excel Formulas. Improve your Microsoft Excel Exam score with mock test prep.
Microsoft Excel Excel Functions
Microsoft Excel Mock Exam on Excel Functions. Microsoft Excel Study Guide questions to pass on your first try.
Microsoft Excel Excel MCQ
Microsoft Excel Test Prep for Excel MCQ. Practice Microsoft Excel Quiz questions and boost your score.
Microsoft Excel Excel
Microsoft Excel Questions and Answers on Excel. Free Microsoft Excel practice for exam readiness.
Microsoft Excel Excel Trivia
Microsoft Excel Mock Test covering Excel Trivia. Online Microsoft Excel Test practice with instant feedback.
Microsoft Excel Advanced Data Analysis Tools
Free Microsoft Excel Quiz on Advanced Data Analysis Tools. Microsoft Excel Exam prep questions with detailed explanations.
Microsoft Excel Advanced Formula and Macro...
Microsoft Excel Practice Questions for Advanced Formula and Macro Creation. Build confidence for your Microsoft Excel certification exam.
Microsoft Excel Advanced Formulas and Macros
Microsoft Excel Test Online for Advanced Formulas and Macros. Free practice with instant results and feedback.
Microsoft Excel Basic and Advance Question...
Microsoft Excel Study Material on Basic and Advance Questions and Answers. Prepare effectively with real exam-style questions.
Microsoft Excel Creating and Managing Charts
Free Microsoft Excel Test covering Creating and Managing Charts. Practice and track your Microsoft Excel exam readiness.
Microsoft Excel Data Visualization with Ch...
Microsoft Excel Exam Questions covering Data Visualization with Charts. Master Microsoft Excel Test concepts for certification prep.
Microsoft Excel Formulas and Functions
Free Microsoft Excel Practice Test featuring Formulas and Functions. Improve your Microsoft Excel Exam score with mock test prep.
Microsoft Excel Formulas and Functions App...
Microsoft Excel Mock Exam on Formulas and Functions Application. Microsoft Excel Study Guide questions to pass on your first try.
Microsoft Excel Formulas Questions and Ans...
Microsoft Excel Test Prep for Formulas Questions and Answers. Practice Microsoft Excel Quiz questions and boost your score.
Microsoft Excel Functions Questions and An...
Microsoft Excel Questions and Answers on Functions Questions and Answers. Free Microsoft Excel practice for exam readiness.
Microsoft Excel Managing Data Cells and Ra...
Microsoft Excel Mock Test covering Managing Data Cells and Ranges. Online Microsoft Excel Test practice with instant feedback.
Microsoft Excel Managing Tables and Data
Free Microsoft Excel Quiz on Managing Tables and Data. Microsoft Excel Exam prep questions with detailed explanations.
Microsoft Excel Managing Tables and Table ...
Microsoft Excel Practice Questions for Managing Tables and Table Data. Build confidence for your Microsoft Excel certification exam.
Microsoft Excel Managing Worksheets and Wo...
Microsoft Excel Test Online for Managing Worksheets and Workbooks. Free practice with instant results and feedback.
Microsoft Excel MCQ Questions and Answers
Microsoft Excel Study Material on MCQ Questions and Answers. Prepare effectively with real exam-style questions.
Microsoft Excel Questions and Answers
Free Microsoft Excel Test covering Questions and Answers. Practice and track your Microsoft Excel exam readiness.
Microsoft Excel Trivia Questions and Answers
Microsoft Excel Exam Questions covering Trivia Questions and Answers. Master Microsoft Excel Test concepts for certification prep.
Microsoft Excel Workbook and Worksheet Man...
Free Microsoft Excel Practice Test featuring Workbook and Worksheet Management. Improve your Microsoft Excel Exam score with mock test prep.

ActiveX Date Picker vs Modern Alternatives

πŸ“‹ ActiveX Date Picker

Enable the Developer tab through File, Options, Customize Ribbon, then click Insert, More Controls and choose Microsoft Date and Time Picker Control 6.0. Draw it on the sheet, turn off Design Mode, and set LinkedCell in Properties so the picked date lands in a cell.

Limits: according to Microsoft Q&A answers the control is 32-bit only and does not load in 64-bit Office, and ActiveX is disabled by default in Microsoft 365 and Office 2024. Use it only when you control every user’s Office setup.

πŸ“‹ Office Add-in

On the Home tab choose Add-ins, then More Add-ins on Windows, and search for a date picker. Select Add and follow the prompts. Microsoft documents this for Windows and Mac, and notes some add-ins must be purchased.

Features, pricing and platform support are set by each publisher, so check the listing. An add-in avoids ActiveX and macros, which makes it easier for IT teams to review than a macro-enabled workbook.

πŸ“‹ VBA UserForm

Open the editor with Alt+F11, insert a UserForm, and build a month grid from CommandButtons. Call the form from Worksheet_BeforeDoubleClick, and write the chosen date back to the clicked cell.

You control the appearance and can restrict selectable dates. The trade-off is that recipients must enable macros and the file must be .xlsm, and workbooks with VBA projects cannot be opened in Excel for the web.

ActiveX Picker or a Modern Alternative?

Pros

  • Data Validation needs no macros, controls or add-ins
  • Data Validation is documented for Windows, Mac and the web
  • Add-ins from Home, Add-ins avoid ActiveX and VBA
  • A UserForm gives full control over layout and allowed dates
  • Any method can write real date serial numbers that formulas can use

Cons

  • The ActiveX picker is 32-bit only per Microsoft Q&A answers
  • ActiveX is disabled by default in Microsoft 365 and Office 2024
  • Data Validation shows no calendar, only a rule or a list
  • Some add-ins must be purchased and vary by publisher
  • VBA workbooks cannot be opened in Excel for the web

How to Insert a Date Picker in Excel: Checklist

Check whether Office is 32-bit or 64-bit under File, Account, About Excel
Show the Developer tab through File, Options, Customize Ribbon
Pick a method: Data Validation, ActiveX, add-in, or VBA UserForm
For ActiveX, confirm it is enabled under File, Options, Trust Center, Trust Center Settings, ActiveX Settings
Click Insert, More Controls and choose Microsoft Date and Time Picker Control 6.0
Draw the control, open Properties, and set LinkedCell to your target cell
For add-ins, use Home, Add-ins, then More Add-ins on Windows and search for a date picker
Format the linked cell as a date so it does not show a serial number
Save as .xlsm if you use ActiveX or VBA so the code is preserved
Test on a colleague’s machine, including their bitness, before sharing
Use a hybrid approach for cross-platform workbooks

When the file will be opened on Windows, Mac and Excel for the web, skip ActiveX and VBA. Use Data Validation (Allow: Date or Allow: List) as the baseline that every platform can use, and treat an add-in as an optional extra for users who install it.

A VBA UserForm calendar is the most flexible option. Press Alt+F11, choose Insert, UserForm, and add a label for the month and year, navigation buttons, and a grid of CommandButtons for the days. Name them systematically, for example btnDay01 to btnDay42.

On open, the code uses DATE and WEEKDAY to find the weekday of the first day of the month, then assigns day numbers to the buttons and hides the rest. Previous and next buttons change the month.

To wire the form to a sheet, add a Worksheet_BeforeDoubleClick event in the sheet module. If the double-clicked cell is in your date range, cancel the default edit and show the form. The day button’s Click event writes the date into that cell and unloads the form.

Keyboard support is worth adding with the UserForm_KeyDown event, so users can move with arrow keys and confirm with Enter. For distribution, save as .xlsm and expect recipients to click Enable Content, or package the code as an .xlam add-in or sign the project. Workbooks with VBA projects cannot be opened in Excel for the web.

Missing from More Controls: this almost always means 64-bit Office. Confirm the bitness under File, Account, About Excel. The control does not load in 64-bit Office (Microsoft Q&A answers), so use an add-in from Home, Add-ins, a UserForm, or Data Validation.

Control inactive or cannot be inserted: ActiveX is disabled by default in Microsoft 365 and Office 2024. You can change it under File, Options, Trust Center, Trust Center Settings, ActiveX Settings, but Microsoft strongly encourages leaving it disabled unless necessary.

A serial number instead of a date: the linked cell needs a date format. Right-click it, choose Format Cells, select Date, and pick a format. The value is a serial number, so formulas work regardless of the display format.

Day and month swapped: store the serial number and apply the display format separately, because regional settings decide how typed text such as 03/04/2026 is read. Data Validation with Allow: Date also rejects text entries.

Picker does not respond: turn off Design Mode on the Developer tab. If macros are blocked, the file may show a security warning until the user clicks Enable Content.

Many controls slow the sheet: use one shared picker or a UserForm opened by an event instead of one control per row.

Practice Excel Formulas and Date Functions Free

To choose a method, start from the platform. For a small team on 32-bit Windows Office with ActiveX enabled, the Date and Time Picker is quick to insert. For mixed environments, Data Validation is the dependable baseline because Microsoft documents it for Windows, Mac and the web.

If you want a calendar pane, look under Home, Add-ins and read each listing for platform and pricing. If you need full control, build a VBA UserForm and accept the .xlsm requirement.

Always test on a clean machine before distributing, with attention to macro warnings, bitness and cell formats. Pair the picker with conditional formatting and protected cells so entries stay consistent.

Excel Questions and Answers

How do I insert a date picker in Excel?

Show the Developer tab under File, Options, Customize Ribbon. Then choose Insert, More Controls, select Microsoft Date and Time Picker Control 6.0, and draw it on the sheet. This works only in 32-bit Windows Office with ActiveX enabled. If the control is missing, use Home, Add-ins to find a calendar add-in, or Data, Data Validation, Allow: Date to restrict entries to valid dates.

Why is the Microsoft Date and Time Picker missing from More Controls?

According to Microsoft Q&A answers, the control is a 32-bit ActiveX component, so it does not load in 64-bit Office and you may see a "Cannot load object" style error. Check your bitness under File, Account, About Excel. On 64-bit Office, switch to an Office Add-in from Home, Add-ins, a VBA UserForm, or Data Validation instead.

How do I turn ActiveX back on in Microsoft 365?

Microsoft states ActiveX is disabled by default in Microsoft 365 and Office 2024. To change it, go to File, Options, Trust Center, Trust Center Settings, ActiveX Settings, and choose the prompt option, then click OK twice. Microsoft strongly encourages leaving ActiveX disabled unless it is necessary, because the setting applies across Office apps and carries security risk.

How do I link the date picker to a cell?

Turn on Design Mode in the Developer tab, right-click the picker, and choose Properties. Type a cell address such as B2 into the LinkedCell property, then switch Design Mode off. Picking a date now writes to that cell. Format the cell as a date; otherwise you see the serial number, for example 46163 for May 21, 2026, instead of a readable date.

How do I show the Developer tab in Excel?

Go to File, Options, Customize Ribbon, tick the Developer check box in the right-hand list, and click OK. The tab then appears in the ribbon and holds Visual Basic, Macros and the Insert button for controls. It is hidden by default. You need it for the ActiveX picker and for building a VBA UserForm calendar.

How do I add a date picker add-in from the Office store?

On the Home tab, choose Add-ins. On Windows, open More Add-ins, search for a date picker, and select Add; on Mac, use the search or category field and select Add. Microsoft notes that some add-ins must be purchased. Features, pricing and supported platforms are set by each publisher, so read the listing before installing.

How do I stop people entering invalid dates without a picker?

Select the cells, go to Data, Data Validation, and set Allow to Date. Pick a rule such as between, then enter start and end dates or a formula like =TODAY(). Excel then rejects other entries. Microsoft documents this for Windows, Mac and the web. It adds no calendar, but it blocks text and out-of-range values.

How can I make the picker open when a cell is clicked?

Use a VBA event in the sheet module, such as Worksheet_SelectionChange or Worksheet_BeforeDoubleClick. Test whether the target cell is inside your date column with Intersect, then show your UserForm and write the chosen date back to that cell. Save the file as .xlsm, and remember that workbooks with VBA projects cannot be opened in Excel for the web.

How many questions are on the Microsoft Excel?

The MOS Excel (Microsoft 365 Apps) exam has 33 to 37 questions. (Verified Oct 17, 2026 against certiport.pearsonvue.com.)

How long is the Microsoft Excel?

Microsoft Office Specialist Excel exams last 50 minutes, with 60 minutes of total seat time. (Verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business.)

What is the passing score for the Microsoft Excel?

The passing score for Microsoft Office Specialist Excel exams is always 700 on Certiport's 1 to 1000 scaled score. (Verified Oct 17, 2026 against certiport.pearsonvue.com.)
β–Ά Start Quiz