Spreadsheet map
Cell नै spreadsheet को आधार हो
Cell address, formula र reference राम्रोसँग आएपछि sorting, filtering, subtotal र chart सजिलो हुन्छ।
Syllabus Focus
- Concept of electronic spreadsheet.
- Cells, rows, columns, worksheet, workbook and workspace.
- Create, open, save, page setup, preview and print workbook.
- Edit, copy, move and delete cell contents.
- Format cells, rows, columns and sheets.
- Relative and absolute cell reference.
- Basic functions, series, sorting, filtering and subtotals.
- Charts, headers, footers, spell checking and data import/export.
- Familiarity with Devanagari fonts.
Standard definitions
Spreadsheet
Standard definition: A spreadsheet is an electronic worksheet made of rows and columns used to store, calculate, analyse and present data.
Simple meaning: Table जस्तो sheet जहाँ data राखेर formula, chart र analysis गर्न मिल्छ।
Cell
Standard definition: A cell is the intersection of a row and a column in a spreadsheet where data or formulas are entered.
Simple meaning: Row र column भेटिएको सानो box, जस्तै A1।
Formula
Standard definition: A formula is an expression entered in a cell to perform calculation using values, operators, functions or cell references.
Simple meaning: Calculation गर्न cell मा लेखिने expression, जस्तै =A1+B1।
Relative Reference
Standard definition: A relative reference is a cell reference that changes automatically when copied to another cell.
Simple meaning: Formula copy गर्दा address आफैँ बदलिन्छ।
Absolute Reference
Standard definition: An absolute reference is a fixed cell reference that does not change when copied, usually written with dollar signs such as $A$1.
Simple meaning: $A$1 जस्तो fixed address, copy गर्दा पनि नबदलिने।
Filtering
Standard definition: Filtering displays only records that meet selected conditions while temporarily hiding other records.
Simple meaning: चाहिएको condition मिल्ने rows मात्र देखाउने।
Worksheet
Standard definition: A worksheet is a single spreadsheet page made up of rows, columns and cells.
Simple meaning: Workbook भित्रको एउटा sheet/page।
Workbook
Standard definition: A workbook is a spreadsheet file that can contain one or more worksheets.
Simple meaning: धेरै worksheets राख्न सकिने spreadsheet file।
Sorting
Standard definition: Sorting arranges data in a specified order such as ascending, descending or alphabetical order.
Simple meaning: Data लाई सानो-ठूलो, A-Z वा Z-A क्रममा मिलाउने।
Subtotal
Standard definition: Subtotal is a spreadsheet feature or calculation that summarises grouped data before the final total.
Simple meaning: Group अनुसार बीच-बीचमा total निकाल्ने सुविधा।
Chart
Standard definition: A chart is a graphical representation of spreadsheet data used for comparison, trend analysis and presentation.
Simple meaning: Data लाई graph/visual रूपमा देखाउने।
Formula memory
Relative reference
A1 copy गर्दा row/column अनुसार बदलिन्छ।
Absolute reference
$A$1 copy गर्दा पनि fixed रहन्छ।
Function
SUM, AVERAGE, MAX, MIN जस्ता ready-made formula।
Chart
Table data लाई visual comparison मा देखाउने tool।
१५ मिनेट spreadsheet drill
- ५ जना विद्यार्थीको marks table बनाउनुहोस्।
- Total, average, highest र lowest निकाल्नुहोस्।
- Percentage अनुसार sort गर्नुहोस् र pass/fail filter लगाउनुहोस्।
- Simple column chart बनाउनुहोस्।
- Print preview मा page fit गरेर header/footer राख्नुहोस्।