Ms Excel notes for computer students.....

 Microsoft Excel

Qno:1 What is a Microsoft Excel in simple definition?

Ans: Microsoft Excel:

 Microsoft Excel enables users to format organize and calculate data in a spread sheet by organizing data using software like Excel ,data analysts and other users can make information easier to view as data is added or changed.

Qno:2 What is advantage of using  Microsoft Excel ?

•        i.          Collection and verification of business data.
•       ii.          Business analysis
•     iii.          Data analysis.
•     iv.          Performance reporting.
•      v.          Strategic analysis.
•     vi.          Accounting and Budgeting.
•   vii.          Administrative and managerial   .    management.
•  viii.          Account management.
•     ix.          Project management.
•      x.          Office administration.

Qno:3 What is a Microsoft Excel Terminologies and Components in simple definition?

Excel has its own terminologies for its components, which new users may not immediately find understand  some of these term and components include the following:

  i.          Cell:

A user enters data into a cell, which is the intersection of a column and row.

  ii.          Cell Reference:

This is the set of coordinates where a cell is located. Rows are horizontal and

Columns are vertical and assign a letter:

 iii.          Active cell:

This is the currently selected cell, outline by a green box.

 iv.          Work Book:

This is an excel file that contains one or more worksheets.

   v.          Worksheet:

These are the different documents nested within a workbook.

 vi.          Worksheet tab:

These these are the tabs at the bottom left of the spreadsheet.

vii.          Column and Row headings:

These are the numbered and lettered cell located just outside of the columns and rows.

viii.          Formula:

Formula are mathematical equations, cell reference of functions that can be placed inside a cell to product a value formulas must start with an equal”=” sign.

 ix.          Formula Bar:

This is the long input bar that is used to enter values or formulas in cells. It is located at the top of the work sheet, next to the “FX” label.

   x.          Address bar:

This bar located to the left of the formula bar shows the number and letter coordinates of an active cell.

 xi.          Filter:

These  are rules a users can employ to select what rows in a worksheet to display. This option is located on the top right of the home bar under “short and filter”. An auto filter option can be selected to show row that match specific values.

xii.          AutoFill:

This feature enables the user to copy data to more than one cell automatically. With two or more cells in a series, a user can select both cells and drag the bottom right corner down to autofill the rest of the cells.

xiii.          Auto Sum:

This feature enables users to add multiple values. Users can select the cells they want to add and press the Alt and Equal keys. There is also a button to enable this feature on the top right of the home page, above ‘Fill’ and to the left of ‘Sort and Filter’

xiv.          Pivot Table:

This data summarization, tool sorts and calculate data automatically.

Qno:3 Name the title ribbons of Ms excel and describe it.

1.     Ribbon tab:

It contains multiple commands logically subdivided into groups.

2.     Ribbon group:

A set of closely related commands normally performed as part of a larger task.

3.     Dialog launcher:

A small arrow in the lower right corner of a group brings up more related commands.

4.     Command button:

It is the button you click to perform a particular action.

Qno:3 Name the tabs of Ms excel and describe it.

1.     File:

It allow you to jump into the backstage view that contains the essential file-related commands and excel option.

2.     Home tab:

It contains the most frequently used commands such as copying and pasting, sorting and filtering, formatting ,etc.

3.     Insert tab:

It is used for adding different objects in a worksheet such as images, charts, pivot table, hyperlinks, special symbols, equations, headers, footers, etc.

4.     Draw tab:

It depends on the device type you are using. It lets you draw with a digital pen, mouse, or finger. This tab is available in excel 2013 and later.

5.     Page layout:

It provides tools to manage the worksheet appearance, both on screen and printed ,these tools control theme settings, gridline, page margins, object aligning, and print area.

6.     Formula tab:

It contains tools for inserting functions, defining names, and controlling the calculating options.

7.     Data tab:

It holds the commands for managing the worksheet data as well as connecting to external data.

8.     Review:

It allows you to check spelling, track changes, add comments and notes, protect worksheet and workbooks.

9.     View tab:

It provides commands for switching between worksheet views, freezing panes, viewing, and arranging multiple windows.

10. Developer tab:

It provides access to advanced features such form controls and XML command. This tab is hidden by default, and you have to enable it first.

ADD-INS:

It appears when you open an older worksheet or lead an add-in that customizes the toolbars or menu 

Help:

It only appears in Excel 2019 and OFFICE 365. These tab provides quick access to the help Task pane and allow you to contact Microsoft Support Send Feedback suggest as feature and get quick access to training video.

By clicking the link below you are able to 

download the note in PDF form.....

Or scroll down to view online.....