ms excel coma

8/2/2019 Ms Excel Coma

1/4

MS EXCEL (15 Marks)

1) Mention any two types of chart that can be used for representing Worksheetdata in MS-Excel. (2)

Ans: Column, Bar, Line, Pie, Area char can be used for representing Worksheet data

in MS-Excel.

2) What is a cell in a spreadsheet? (2)Ans: The rectangular box identified by a unique letter - number combination is called

cell. We would type our number or text into this box.A cell is combination of one row and one column.

3) Name any 2 (two) contents of a cell in Excel. (2)Ans: Contents of a cell in Excel is Number, Text, Date, Time and Currency.

4) What is the function of count() in Excel? (2)

Ans: Excel's COUNT function is one of a group of Count Functions that can be usedwhen you need to total the number of cells in a selected range.The COUNT function will add up the number of cells in a selected range thatcontains numbers.The function is written as follows:=COUNT(argument)The argument for this function is the range of cells to be totaled.

5) Briefly describe the method of creating a workbook in MS-Excel. (4)Ans: To create work book in MS-Excel we need to perform the following steps:

a) Click on Start button.

b) Then choose All Programs and also choose Microsoft Office option.c) Click on Microsoft Office Excel 2003. Then new work book namedbook1 is opened.

6) Explain the difference between absolute and relative referencing in MS-Excelwith the help of an example. (4)

Ans: Absolute referencingIf we don't want Excel to adjust references when we copy a formula to adifferent cell, use an absolute reference. For example, if our formula multipliescell A5 with cell C1 (=A5*C1) and we copy the formula to another cell, Excel willadjust both references. We can create an absolute reference to cell C1 byplacing a dollar sign ($) before the parts of the reference that do not change. Tocreate an absolute reference to cell C1, for example, add dollar signs to theformula as follows:=A5*$C$1Relative referencingWhen we create a formula, references to cells or ranges are usually based ontheir position relative to the cell that contains the formula. In the following


2/4

example, cell B6 contains the formula =A5; Microsoft Excel finds the value onecell above and one cell to the left of B6. This is known as a relative reference.

When we copy a formula that uses relative references, Excel automaticallyadjusts the references in the pasted formula to refer to different cells relative tothe position of the formula

7) What types of data can be entered in a cell in MS-Excel? Using formula in MS-Excel, show by an example how the contents of two cells can be added up. (4)

Ans: In a spreadsheet there are three basic types of data that can be entered.labels - (text with no numerical value)constants - (just a number -- constant value)

formulas * - (a mathematical equation used to calculate)You can use a formula with the ampersand (&) operator to combine text frommultiple cells into one cell.The contents of two cells can be added up we need to perform the followingsteps:a) Select the cell in which you want to combine the contents of other cells.b) To start the formula, type =(c) Select the first cell that contains the text that you want to combine, type &"

"& (with a space between the quotation marks), and then select the next cellthat contains the text that you want to combine.

d) To finalize the formula, type )

e) To see the results of the formula, press ENTER.

8) How do you save a document in MS-Excel? How can you save the document inany other name or in any other drive using MS-Excel? (4)

Ans: To save a document in MS-Excel we need to perform the following steps:a) In Excel, click on File menu under menu bar.b) Click on Save option. Then Save As dialog box is displayed.c) Choose drive and folder under Save in option and type the file nameunder file name text box.d) At last click on Save button. Then file is saved.

To save a document in another name and another drive in MS-Excel we need

to perform the following steps:a) At first open Excel file which we want to new nameb) In Excel, click on File menu under menu bar.c) Click on Save As option. Then Save As dialog box is displayed.d) Choose another drive and folder under Save in option and type thenew file name under file name text box.e) At last click on Save button. Then file is saved in new name and newlocation.


3/4

9) How can you sort data in MS-Excel a) Row-wise, b) Column-wise? (4)

Ans: To sort data in MS-Excel we need to perform the following steps:

a) Start Microsoft Excel and open the file we want to change.b) Drag over the two or more columns or rows that we want to sort.c) Open the Data menu and select Sort. The Sort dialog boxappears.d) Select the Continue with the Current Selection option to sort asingle column or row.e) Select the Expand the Selection option to sort a series of columnsor rows.f) Choose Ascending or Descending to determine the sort order.g) Click the Options button in the Sort dialog box.h) Select "Sort top to bottom" in the Sort Options dialog box to sort a

column.i) Select "Sort left to right" in the Sort Options dialog box to sort arow.

j) Click OK in the Sort Options dialog box.k) Click OK in the Sort dialog box.

10) How are columns and rows identified in MS-Excel? Write the steps to copy thecontents of Column A to another Column B. (4)

Ans:

11) In a MS-Excel spreadsheet, Column A and Column B contain the x and y co-

ordinates. Write the steps to plot the co-ordinates with column A along x-axisand column B along y-axis. (4)Ans:

13) How will you sort any numeric field in ascending or descending order in excel?Ans:

14) Write down the steps to make column chart in a spreadsheet. (4)Ans:

15) Electronic spreadsheet is advantageous than manual worksheet explain. (4)Ans:

16) How many rows and columns are in a worksheet of excel? What will be theaddress of 29th column and 14th row? (4)

Ans:17) What is function in Excel? Give any four function name. (4)

Ans:


4/4

18) Write the steps to insert column in column C and D in Excel. (4)Ans:

19) What is conditional formatting? Describe with an example. What is the use ofmacro? (6)

Ans: Conditional Formatting is a tool that allows you to apply formats to a cell orrange of cells, and have that formatting change depending on the value of thecell or the value of a formula. For example, you can have a cell appearboldonly when the value of the cell is greater than 100. When the value of the cellmeets the format condition, the format you select is applied to the cell. If thevalue of the cell does not meet the format condition, the cell's default formattingis used.Macros are a very useful feature of Excel, especially if you find yourselfconstantly repeating the same tasks on different cells, or worksheets.They enable you to record the repetitive actions and then repeat the actions atthe click of a button

ms excel coma

Documents