✓ Board-verified
Accountancy · 2025 · 6 marks
CBSE 2025 · Region 4 · Set 1 · Q34
State the steps to be followed to copy or import the data into required cells of Excel worksheet.
Marking-scheme solution
To import data the following steps are to be taken:
1. Create a data file using notepad.
2. A comma- separated data value in one line of this text file is a row in a spreadsheet
and each entry, separated by a comma, is a column entry for that row.
3. In the first line provide names for the column of the spreadsheet.
4. In the next line onwards start entering the data separated by comma as per the names
given in first line.
5. It may be possible that every data may not be of similar length but each data should be
separated by comma as per the names of the columns.
6. Open a new Excel Worksheet from the office button and select Data tab on the ribbon.
7. On Data tab; an option ‘Get External Data’ click on “From Text” which will allow
selecting a notepad file saved as .CVM into Excel format directly and Data will be
copied in respective columns and rows.
More from Spreadsheet
- Explain the two syntax f2024
- Explain various 'Data tables' used in 'Pivot Table.2024
- QQ Cut.11 v Wrap Text iCaliba'i I. Copy v Paste I u~ v -v A Merge 81 Center v v 1) format Painter E Clipboard…2024
- Name the error which occurs when Excel doesn't recognize a 'Text' formula. Give any two solutions to correct…2025
- What is a 'Pivot table'? State any three of its advantages. OR List eight uses of Accounting Software.2023
- Name the error which occurs when Excel doesn't recognize a 'Text' formula. Give any two solutions to correct…2025
- iCalibfi 11 'A A' I ® ' Wrap Text % Copy v Paste I Ll v; E Merge 8z Center v 'X Format Painter Clipboard Font…2024
- Give the meaning of the terms Report and Report Wizard'.2022
CBSE Class 12 Accountancy past-paper question from the 2025board exam, with the answer as CBSE’s own marking scheme gives it. Where our answers come from.