Chapter 7 | Spreadsheet | Microsoft Excel (Ms Office 2016)

 

Write Very Short answer of the following question.

a) Is Ms-Excel word processing software?

Ans: No, Ms-Excel is not word processing software.

b) Which was the first electronic spreadsheet software?

Ans: VisiCalc was the first electronic spreadsheet software.

c) Where does status bar lie at Ms-Excel screen?

Ans: Status bar lie in the bottom of Ms-Excel screen window.

d) Which symbol is used to begin formula in Ms-Excel?

Ans: An equal to (=) symbol is used to begin formula in Ms-Excel.

e) Which shortcut keys are used to save and close the worksheet?

Ans: Ctrl+s shortcut key to save and Ctrl+w shortcut key is used close in the worksheet

f) How can you select an entire worksheet?

Ans: We can select an entire worksheet by pressing Ctrl+A keys from the keyboard.

g) Write the reference operators used in MS-Excel?

Ans: Range operator and Union operator are the reference operators used in MS-Excel.

h) Name the functions that are used to enter data in the cell.

Ans: To enter the data in the cell first you have to select that cell by clicking on it.

i) What is the extension of Excel worksheet?

Ans: The extension of Excel worksheet is dot xls or dot xlsx (.xls or .xlsx)

Write short answer of the following questions:

a)    a) What is an electronic spreadsheet? Give some examples of electronic spreadsheet?

Ans: An electronic spreadsheet is a software that stores data in tabular form that i.e. rows and columns and allows you to calculate and manipulate them according to your requirement. Example: Ms-Excel, VisiCalc, Lotus 1-2-3 etc.

b)    b) What is Microsoft Excel? Write different components of Ms-Excel 2016 window.

Ans: Ms-Excel is one of the popular and widely used spreadsheet software developed by Microsoft Corporation USA.

The different components of Ms-Excel 2016 window are :

File Tab, Quick Access toolbar, Title bar, Ribbon, Formula Bar, Working Area, Status Bar, Sheet Tabs, Worksheet view buttons, Tell me, Zoom control etc.

c)    c) What are different methods of selecting data in the worksheet.

Ans The different methods of selecting data in the worksheet are given below:

·        Single Cell: Click on the desired cell.

·        Range of Cells: Click and drag across the cells you want to select, or click the first cell, hold down the Shift key, and click the last cell in the range.

·        Entire Row or Column: Click the row number or column letter to select the entire row or column.

·        Multiple Rows or Columns: Click and drag across multiple row numbers or column letters to select multiple rows or columns.

d)    d) What is the fill handle? Write its uses.

Ans: Fill handle is a small black square that appears at the bottom right corner of the selected cell. It is used to auto fill list items, to fill custom list etc.

e)   e)   What is the use of Auto fill feature?

Ans: Auto fill feature in Ms-Excel is used to automatically copy cells and fill them with a series without using copy command.

f)      f) What are different operators used in Excel?

Ans: The different operators used in Excel are:

i) Arithmetic Operators                   ii) Relational or Comparison Operators

iii) Reference Operators                  iv) Logical Operators

v) Text Operators

g)     g) What are the rules of using formula in Excel?

Ans: Rules for using formula in Excel are given below:

i) The formula always must begin with an equal sign (=)

ii) After inserting formula, press Enter key to confirm it.

iii) The formula are not case sensitive.

iv) The cell address also can be used in the formula. Eg. (A2+B2)*F5

v) The references, constants, operators and functions can be used in formula.

h)    h) What is chart? Write its importance.

Ans: Charts are graphical presentation of numeric data in the worksheet. Charts are based on data contained in worksheets and it helps to observe and compare different data in the worksheet.

Write down the step to perform the following tasks:

a) To Start MS Excel 2016:

1. Click on the "Start" menu.
2. Type "Excel" in the search bar.
3. Press Enter.

b) To Create a New Workbook:

1. Go to the "File" tab.
2. Click "New."
3. Select "Blank Workbook."

c) To Enter Data into Worksheet:

1. Click on the cell where you want to enter data.
2. Type the data.
3. Press Enter.

d) To Enter Date and Time:

1. For the current date: Press Ctrl + ;
2. For the current time: Press Ctrl + Shift + ;

e) To Change the Data in a Cell:

1. Double-click the cell to edit.
2. Make the changes.
3. Press Enter.

f) To Copy/Move a Range of Cells:

1. Select the range of cells.
2. Right-click and choose "Copy" or "Cut."
3. Right-click the destination cell and select "Paste."

g) To Find and Replace Text:

1. Press Ctrl + H.
2. Enter the text to find and the replacement text.
3. Click "Replace" or "Replace All."

h) To Format the Data:

1. Select the cells you want to format.
2. Right-click and choose "Format Cells."
3. Adjust the formatting options and click "OK."

i) To Copy a Formula:

1. Click on the cell with the formula.
2. Drag the fill handle across the range where you want to copy the formula.

j) To Create a Chart:

1. Select the data range.
2. Go to the "Insert" tab.
3. Choose a chart type from the "Charts" group.

k) To Change the Style of a Chart:

1. Click on the chart.
2. Go to the "Design" tab.
3. Select a style from the "Chart Styles" group.

l) To Save Workbook:

1. Go to the "File" tab.
2. Click "Save As."
3. Choose the location, enter the file name, and click "Save."