UNIT NO.2
Microsoft Excel
(Solved Exercise)
C. Answer the following short questions:
1. What is the difference between workbook and worksheet?
Worksheet
A worksheet is simply a grid of rows and columns. It is a large table with 1,048,576 rows and 16,384 columns. Each column in a worksheet is identified by an alphabet starting with the letter A and each row is identified by a number, starting from 1.
Workbook
A collection of related worksheets, saved in a single file is called a Workbook. A workbook typically contains one or more worksheets. Each worksheet in a workbook may include similar or different data.
2. How can you resize a column in MS Excel?
1. Choose a column or a selection of columns.
2. Choose Format > Column Width from the Home menu (or Row Height).
3. Enter the column width, then click OK.
3. Give examples of any three built-in functions.
Examples of Simple Built-in Functions:
SUM
The SUM formula for adding four numbers from cell B2 to B6 will be written as
=SUM(B2:B6)
AVERAGE
It provides the mean average of the values falling within the given range.
=AVERAGE(A1:A10)
MIN/MAX
MIN function returns the lowest value discovered in a group of values.
=MIN(A1:A5)
4. What are some ways formatting is used in MS Excel?
Once you have entered information into a spreadsheet, you can format it with the help some formatting elements.
Formatting iChange the font style of your text.
s used to:
Change the size of your text.
Make your text appear in BOLD.
Give the italics effect to your text.
Underline your text.
Fill the cell with different colours.
5. Perform a calculation using SUM and AVERAGE functions.
SUM
To calculate the total number of students, use the sum function. Write =SUM (C7:F7) in cell H7 and press Enter.
AVERAGE
To calculate the average number of students in a class, we can use the average function. Write the formula =AVERAGE (C7:F7) in cell G7 and press Enter
6. Create a chart in MS Excel to show the sales of a store per month.
1. Open Microsoft Excel.
2. Enter your sales data in two columns: one for months and the other for sales amount.
3. Select the data range (both months and sales) by clicking and dragging over them.
4. Go to the “Insert” tab on the Excel ribbon.
5. In the “Charts” group, click on the “Bar Chart” icon.
Excel will generate a bar chart based on your data.
D. Answer the following long questions:
1. Define all Ribbon Tabs.
Home Tab
It is used to apply formats to worksheet cells which include editing, clipboard, font, alignment, number, and cells) It is used to carry out common commands like bold, underline, copy, and paste.
Insert Tab
Insert Tab is used to insert different objects. These objects might include images, hyperlinks, symbols, headers, footers, etc.
Draw Tab
This tab lets you draw with the help of a mouse, digital pen, etc. depending on what device you are using.
Page Layout
It helps in changing the appearance of the worksheet. It is done in both onscreen and printed form. It includes gridlines, margins, theme settings, etc.
Formulas Tab
Formulas Tab contains practical features for adding different calculations to the worksheet. It is used to insert functions specify names, establish name ranges, review formulas, etc.
Data Tab
Options for filtering, sorting, and modifying data are mostly found on the data tab.
Review Tab
it helps in reviewing the information like checking the spellings, translation, adding comments, etc. it also helps to protect and share the worksheet and workbook.
View Tab
It includes commands that help in switching between the view of workbooks, freezing panes, adding macros, etc.
2. Explain the main components of the MS Excel interface.
1.Quick Access Toolbar
Frequently used commands of Excel are available here. You can add or delete different tools in Quick Access Toolbar.
2.Ribbon
The ribbon contains the icons (or toolbars) for commands. These commands are grouped in different tabs based on their functionality. A brief introduction of these tabs is as under.
3.Formula Bar
Right above the spreadsheet is the formula bar. When you enter a formula or function in the cell, it appears here in the formula bar. The result of the calculation is shown in the cell.
4. Status Bar
It is used to display information. Different function e.g. sum, count, average of the cells, etc. may be displayed in the status bar. A lot of other information may be displayed in Status bar by right clicking and choosing the options.
5.Spreadsheet Work Area
It is the place where the main work is done on the data in Excel.