# MS Excel

- Excel is a computer program used to create electronic spreadsheets.
- Within excel users can organize data ,create charts and perform calculations.
- Excel is a convenient program because it allows users to create large spreadsheets, reference information, and it allows for better storage of information.
- Excels operates like other Microsoft(MS) office programs and has many of the same functions and shortcuts of other MS programs.

Shortcuts:

**Ctrl + C =** Copies highlighted Items

**Ctrl + V = **Pastes highlighted items

**Ctrl + X = **Cuts highlighted text or selected image

**Ctrl + A =** Select all

**Ctrl + N =** Create a new workbook

**Ctrl + F =** Find anything in the workbook

**Ctrl + U=** To underline the highlighted text

**Ctrl + P= **To print a Workbook

**Ctrl + W=** To close the current workbook

**Ctrl + K= **To insert a link in a cell

**Ctrl + H =** To find and replace all cell contents

**Excel Interface: **

Let us understand the Excel Interface:

Home Tab : Just like MS Word & MS PPT, it is the default tab when you open a new file with all the text editing tools and features.

Insert Tab: Here you get all the additional features like tables, Graphs, Pictures, Links to insert in your excel workbook.

Draw Tab: This is the same as you get in MS PPT with features of drawing and highlighting text.

Page Layout: This tab gives you the liberty to change the height, width, background etc of your workbook page.

Formulas Tab: This is the feature exclusive of MS Excel where you get several mathematical formulas through which you can work upon your mathematical data.

Date Tab: Again a unique feature of MS Excel. As we know excel is all about numbers and its analysis. Data tab helps us to sort, analyse, group, ungroup and many more.

Review Tab: This is a common tab in MS Doc, MS PPT & MS Excel. We can check for spellings and grammar and proofread our data in excel.

View: As the name suggests this tab helps us to view our data in various orientations and formats.

Row: All the horizontal blocks are called rows. They are marked in numeric order.

Column: All the vertical blocks are called columns. They are marked in Alphabetical order.

Cell: The box where a Row and Column meets is called a Cell.

Formula Bar: It is a tab which displays all our inputs.

Note: A file in excel is often called as Workbook

**Activity: Discuss and Draw a table**

**When: during session**

**How: Read this situation and draw a table at the blank space**

You are the manager of a store, it is your job to keep a note of the amount of sales and expenses that takes place day to day . To keep account of this you decide to maintain an excel sheet. Which are the columns you are interested in and why?

Draw the table you want to see here:-

**Activity: Create table**

**When: during session**

**How: Under trainer’s guidance, create a table in excel using the following specifications:**

- Create tables in excel with months as rows and Sales, Cost as columns.
- Fill dummy data
- perform arithmetic
- summation , =SUM
- subtraction, = sales-cost
- adding percentages
- formula = revenue-cost/ revenue

Answer/Outcome of this activity will be discussed in the session

**Activity: Use SmartArt**

**When: during session**

**How: Make the following graphics in excel sheet**

**Activity: Create Dashboard**

**When: during session**

**How: Create a dashboard consisting pie chart, donut chart, line graph and bar graph to present a dashboard basis the given table:**

**Outcomes of Activities**

**Activity: Discuss and Draw a table**

**Activity: create a table**

**Activity: create dashboard**

**MS Excel Quiz:**

- The box where a row and a column intersects is called?

- Worksheet
- Sum
- Cell
- Tab

2) What is the name of the bar that allows you to perform mathematical functions?

- Math bar
- Number bar
- Calculation bar
- Formula bar

3) Under which option of the ribbon tab can you use the function of sorting in ascending or descending manner?

- Insert
- Home
- Data
- Page Layout

4) The selected portion in the below image is __________?

- Row
- Column
- Shelf
- Cell Cluster

5) Which of the following mathematical symbols, when added in a cell, acts as a shortcut for any formula in MS Excel?

- +
- –
- =
- X