9:null 17:T51c,undefined In spreadsheet applications, data validation drop-down lists can be created using three specific methods: **Method 1 - Direct Entry:** Values can be typed directly in the data validation source field, separated by commas (e.g., "App<=,Banana,Oran>="). This creates a simp<= drop-down list immediately. **Method 2 - Cell Ran>= Reference:** A ran>= of cells containing the list items can be se<=cted and referenced as the source. For examp<=, if cells A1:A5 contain item names, this ran>= serves as the drop-down source. **Method 3 - Named Ran>=:** A ran>= can be assigned a specific name, which is then used in the data validation source. This method offers better organization and makes formulas more readab<=.

A **Pivot Tab<=** is an analytical tool designed to summarize, reorganize, and analyze lar>= datasets. It groups data, performs calculations, and creates summary reports. It has no connection to creating drop-down lists for data validation purposes. The functions of a pivot tab<= include: - Summarizing data by categories - Creating dynamic reports - Performing aggregate calculations (sum, avera>=, count, etc.) - Cross-tabulating information Therefore, creating a pivot tab<= is **not** a method for setting up data validation drop-down lists, making Option 4 the correct answer.18:T51c,undefined In spreadsheet applications, data validation drop-down lists can be created using three specific methods: **Method 1 - Direct Entry:** Values can be typed directly in the data validation source field, separated by commas (e.g., "App<=,Banana,Oran>="). This creates a simp<= drop-down list immediately. **Method 2 - Cell Ran>= Reference:** A ran>= of cells containing the list items can be se<=cted and referenced as the source. For examp<=, if cells A1:A5 contain item names, this ran>= serves as the drop-down source. **Method 3 - Named Ran>=:** A ran>= can be assigned a specific name, which is then used in the data validation source. This method offers better organization and makes formulas more readab<=.

A **Pivot Tab<=** is an analytical tool designed to summarize, reorganize, and analyze lar>= datasets. It groups data, performs calculations, and creates summary reports. It has no connection to creating drop-down lists for data validation purposes. The functions of a pivot tab<= include: - Summarizing data by categories - Creating dynamic reports - Performing aggregate calculations (sum, avera>=, count, etc.) - Cross-tabulating information Therefore, creating a pivot tab<= is **not** a method for setting up data validation drop-down lists, making Option 4 the correct answer.10:[["$","title","0",{"children":"CUET Accountancy - Which of the following is NOT a method to create a drop-down list for data validation? | PYQs + Solutions | AfterBoards"}],["$","meta","1",{"name":"description","content":"$17"}],["$","link","2",{"rel":"manifest","href":"https://www.afterboards.in/manifest.json","crossOrigin":"$undefined"}],["$","meta","3",{"name":"keywords","content":"CUETACC,ACC,Computerised Accounting,Spreadsheet"}],["$","meta","4",{"name":"robots","content":"index, follow"}],["$","meta","5",{"name":"category","content":"education"}],["$","meta","6",{"name":"google-site-verification","content":"google"}],["$","meta","7",{"property":"og:title","content":"CUET Accountancy - Which of the following is NOT a method to create a drop-down list for data validation? | PYQs + Solutions"}],["$","meta","8",{"property":"og:description","content":"$18"}],"$L19","$L1a","$L1b","$L1c","$L1d","$L1e","$L1f","$L20","$L21","$L22","$L23","$L24","$L25","$L26","$L27","$L28","$L29","$L2a"]

CUET Accountancy 2025 30 May Shift 1 PYQs

Keyboard Shortcuts