HomeTestsSearchRankProfile
easyMCQCUET Accountancy 2025 30 May Shift 12026Accountancy
1 mark

Which of the following is NOT a valid method to create a drop-down list for data validation in Excel?

  1. A
    Typing a list of values separated by commas
  2. B
    Selecting a range of cells containing list values
  3. C
    Using a Named Range to refer to list values
  4. D
    Creating a pivot table

Solution & Step-by-step Explanation

To establish data validation drop-down lists, one can type values separated by commas, provide a spreadsheet cell coordinates range source, or reference a defined Named Range. Creating a pivot table summarizes and aggregates structured datasets and is not a data validation list creation method.

Practice this question

Try it yourself before checking the explanation above.

Which of the following is NOT a valid method to create a drop-down list for data validation in Excel?
A
Typing a list of values separated by commas
B
Selecting a range of cells containing list values
C
Using a Named Range to refer to list values
D
Creating a pivot table

Share This Question

Computerised AccountingSpreadsheetData Validation

Related Questions

easyMCQ

Which one of the following statements is true?

easyMCQ

Which of the following statements is not correct?

easyMCQ

Which one of the following statements is correct?

easyMCQ

The product formed by the reaction of an aldehyde with a primary amine is:

easyMCQ

Which part of the tobacco plant is infected by Meloidogyne incognita?

easyMCQ

The term ecosystem was coined by:

Ready for a Full Test?

Practice with timed mock tests and track your performance across Accountancy.

Browse TestsLeaderboard

Discussion