MS Excel 2016
Introduction Of MS Excel – 2016
Last Updated: March 25, 20264. Spreadsheet (स्प्रेडशीट) 4.0 Introduction (परिचय) Excel is a spreadsheet application developed and published by Microsoft. It is part of...
4.2 Elements of Spread Sheet (स्प्रेडशीट के तत्व)
Last Updated: March 25, 2026Mouse Pointer Styles (माउस प्वाइंटर स्टाइल्स) The Excel mouse pointer takes on many different appearances as you move around the...
4.3 Creating of Spread Sheet (स्प्रेडशीट तैयार करना)
Last Updated: March 25, 20264.3.1 By using Blank workbook 4.3.2 By using predesigned Template (टेम्पलेट का इस्तेमाल करते हुए)
4.4 Opening an Existing Workbook (मौजूदा वर्कबुक को खोलना)
Last Updated: March 25, 2026Note: If you’ve opened the desired workbook recently, you can browse your Recent Workbooks rather than search for the file....
4.6 Page Setup (पेज सेटअप)
Last Updated: March 25, 2026Before printing if you want to know how a printed page will appear then you can use Page Setup feature....
4.7 Printing a Worksheet (वर्कशीट को प्रिन्ट करना)
Last Updated: March 25, 2026We can print the data of a worksheet same as we do in MS Word or another applications. Unlike MS...
4.9 Entering, Editing, and Formatting Data (इन्टरिंग, एडिटिंग और फॉर्मेटिंग डाटा)
Last Updated: April 3, 20264.9.1 Entering Data [text, number, date, Time, Formula] into Worksheet (वर्कशीट में डेटा इंटर करना (टेक्स्ट, नम्बर, डेट, टाइम, फार्मूला))...
4.9.2 Editing Data (एडिटिंग डाटा)
Last Updated: April 3, 2026You can edit the data in the sheet given in the cell. Data that has been entered in a cell...
4.9.3 Formatting Data in an Excel spreadsheet (एक्सेल स्प्रेडशीट मे डाटा फॉर्मेट करना)
Last Updated: April 3, 2026We can do formatting to the cell according to our need. We can format the cell that what it is...
4.9.3.2 Changing Font, Size and Style (फ़ॉन्ट, साइज एवं स्टाईल में बदलाव)
Last Updated: April 3, 2026Excel has a number of commands and tools available to change the font face, size and its style appearance. एक्सेल...
4.9.3.3 Changing the Alignment of the data in the cell (सेल में डेटा का अलाइनमेंट बदलना)
Last Updated: April 3, 2026We can set the alignment of the text value in the cell to Left, Right, Center, Top align, Middle align...
4.9.3.5 Wrap text in a cell (सेल में टेक्स्ट रैप करें)
Last Updated: April 3, 2026If you want text to appear on multiple lines in a cell, you can format the cell so that the...
4.10 Modifying columns, Rows and cell (रो, कॉलम या सेल को बदलना)
Last Updated: April 3, 2026By default, every row and column of a new workbook is set to the same height and width. Excel allows...
4.11 Inserting, Deleting, Moving and Hiding Rows, Column(इंसर्टिंग, डिलीटिंग, मूविंग और हाइडिंग रो, कॉलम)
Last Updated: April 7, 20264.11.1 Inserting & Deleting Rows & Columns (रो एवं कॉलम को इन्सर्ट एवं डिलीट करना) Inserting Row (रो इन्सर्ट करना)...
4.11.2 Moving rows and columns (रो एवं कॉलम को मूव करना)
Last Updated: April 7, 2026Sometimes you may want to move a column or row to rearrange the content of your worksheet. कभी-कभी आप अपनी...
4.11.3 Hiding/ UnHiding Rows and Column
Last Updated: April 7, 2026(रो और कॉलम को हाईड/अनहाईड करना) At times, you may want to compare contents of certain rows or columns without...
4.12 AutoFill (ऑटोफिल)
Last Updated: April 7, 2026When you have a lot of data to enter into your Excel 2013 spreadsheet, and that data consists of some...
4.13 Sorting & Filtering (शॉर्टिंग एवं फिल्टरिंग)
Last Updated: April 8, 20264.13.1 Sorting Data (शॉर्टिंग डेटा) It is used to arrange the record of excel either in Ascending or descending order....
4.13.2 Filtering Data (फ़िल्टरिंग डेटा)
Last Updated: April 8, 2026The filter feature applies a drop down menu to each column heading, allowing you to select specific choices to narrow...
4.14 Pivot Tables and Pivot Chart (पॉयोट टेबिल्स और पॉयोट चार्ट)
Last Updated: April 8, 2026PivotTable report is an interactive way to quickly summarize large amounts of data. This Report is also used to analyze...
4.15 Cell Reference (सेल रेफरेंस)
Last Updated: April 8, 2026A cell reference refers to a cell or a range of cells on a worksheet and can be used in...
4.16.2 Absolute cell Reference (एब्सॉल्यूट सेल रेफरेंस)
Last Updated: April 8, 2026Example: To create an absolute reference to cell H3, place a $ symbol in front of the column letter and...
4.17 Formulas, Functions and Charts (फॉर्मूला, फंक्शन एवं चार्ट्स)
Last Updated: April 10, 20264.17.1 Formula and Function (फॉर्मूला और फंक्शन) A formula is an expression which calculates the value of a cell. Functions...
4.17.2 Charts (चार्ट)
Last Updated: April 10, 2026A chart is a graphical representation of data in both columns and rows. Charts are usually used to analyse trends...
4.18 Data Validation (डेटा वैलिडेशन)
Last Updated: April 10, 2026Data validation is used to restrict the cell entries within a specified range.It defines the type of contents that can...
4.19 Freezing panes (फ़्रीज़िंग पेन्स)
Last Updated: April 10, 2026Whenever you’re working with a lot of data, it can be difficult to compare information in your workbook. Fortunately, Excel...
4.20 Macros (मैक्रो)
Last Updated: April 10, 2026A Macro is an Action or a set of Actions that you can use to automate tasks. Macros are recorded...
4.21 Shortcut keys
Last Updated: April 10, 2026Key Description Ctrl + A Selects all content in the document or worksheet. Ctrl + B Applies or removes Bold...