Ans. The main features of MS Excel include **inserting a pivot table, sorting of tabulated data, adding formulas to the sheet, and calculating large data**.

What is a column in Excel? **Columns are denoted and identified by a unique alphabetical header letter, which is located at the top of the worksheet**. Column headers range from A-XFD, as Excel spreadsheets can have 16,384 columns in total. Columns run vertically in the worksheet, and the data goes from up to down.

If you have tasks in Microsoft Excel that you do repeatedly, you can record a macro to automate those tasks. A macro is **an action or a set of actions that you can run as many times as you want**. When you create a macro, you are recording your mouse clicks and keystrokes.

Microsoft Excel **enables users to identify trends and organize and sort data into meaningful categories**. Excel also performs Human Resources functions, such as sorting worked hours and organizing employee profiles and expenses, which help businesses better understand the structure and activities of their workforce.

Generally, there are **four** data types in Excel, and these are number, text, logical, and error data.

**The key topics covered are:**

- Understanding Data Editing.
- Overwriting Cell Contents.
- Editing Longer Cells.
- Editing Formulas.
- Clearing Cells.
- Deleting Data.
- Using Undo and Redo.

A sparkline is **a very small line chart, typically drawn without axes or coordinates**. It presents the general shape of the variation (typically over time) in some measurement, such as temperature or stock market price, in a simple and highly condensed way.

**6 advanced Excel skills to look for**

- VLOOKUP. VLOOKUP (vertical lookup) is a function to look up a value in a table and retrieve data from a specific column.
- INDEX MATCH.
- Advanced conditional formatting.
- Pivot tables and reporting.
- Macros and VBA.
- Data simulations.

A pivot table is **a powerful data summarization tool that can automatically sort, count, and sum up data stored in tables and display the summarized data**.

Adding a Header in Excel**To add a header title, click the “Insert” tab at the top left of the workbook.** Click the “Text” menu toward at the right side of the ribbon and click the “Header & Footer” option. You'll be zoomed out from the workbook, allowing you to see all of your data on one page.

Ans. MS Excel is **a spreadsheet program where one can record data in the form of tables**. This gives the user a more systematic display of data.

Examples

Data | ||
---|---|---|

=A2+A3 | Adds the values in cells A1 and A2 | =A2+A3 |

=A2-A3 | Subtracts the value in cell A2 from the value in A1 | =A2-A3 |

=A2/A3 | Divides the value in cell A1 by the value in A2 | =A2/A3 |

=A2*A3 | Multiplies the value in cell A1 times the value in A2 | =A2*A3 |

Generally, there are four data types in Excel, and these are **number, text, logical, and error data**.

The father of the spreadsheet. Published December 22, 2015 This article is more than 2 years old. You may not know Dan Bricklin, but you are almost certainly familiar with his work.

In its simplest form, the VLOOKUP function says: =VLOOKUP(What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE).

05. MS Excel stands for _______ **Microsoft Excel**. Microsoft Excess. Management Excel.

The active cell is also referred to as a cell pointer or selected cell. An active cell refers to **a cell in an Excel spreadsheet that is currently selected by clicking the mouse pointer or keyboard keys**. Remember only one cell can be an active cell at a time.

**Excel Topics**

- Formula Basics.
- Formula Examples.
- Formula Criteria.
- Formula Errors.
- Dynamic Arrays.
- Formula Challenges.
- Formula Training.

**You can use Microsoft Office apps for free**. You'll likely need access to a Microsoft Word document, a PowerPoint presentation or the product of another basic tool from Microsoft 365 at least once in 2022 for work, school or personal use.

Excel lets you create spreadsheets with multiple pages of data, each of which can conveniently exchange information with other pages. Each page is called a worksheet, and a collection of one or more worksheets is called a workbook (which is also sometimes called a **spreadsheet file**).

**To get started with building a survey, follow these steps:**

- Sign in to Microsoft 365 with your school or work credentials.
- Click New, and then select Forms for Excel to begin creating your survey.
- Enter a name for your survey, and then click Create.
- Click Add Question to add a new question to the survey.

Dated : 14-May-2022

Category : Education