9th Class Computers Science Microsoft Excel Developing Charts

   Developing Charts

Excel enables the Chart Wizard that helps you create and view block diagrams. Using chart you can view any analytical data in visual form that provides you easy picture.  

  To create and modify a chart: 

• Select Insert -> Chart menu option to display the Chart Wizard, as shown in the following figure:
• Select a chart type.
• Select a chart such as Bar chart and click the Next to enter a Data Range, as shown in the following figure:
• Click Data Range box, select the area you need for the chart and click Next.
• Type the chart name in the Chart title text box and values for X in the Category (X) axis text box and Y in the Value (Y) axis text box.
• Click Finish to display the chart that you selected with my chart name.
• The chart is created.  

 Which one of the following statements is true?                

Statement A: The formula begins with a # sign.                

Statement B: The formula begins with a = sign.                

(A) Statement A is correct                

(B) Statement B is correct                

(C) Both statement A and B are correct                

(D) Neither statement A nor statement B is correct                

(E) None of these                

Answer: (B)                

Explanation

Correct Option:

(B) Only statement B is true.

Incorrect Options:

Rest of the options is incorrect.    

 Using formula you can perform arithmetic and logical operation. Which one of the following functions is used to count the non blank cells?

(A) COUNT                                                         

(B) DCOUNT

(C) DCOUNTA                                                   

(D) All of these

(E) None of these

Answer: (C)

Explanation

Correct Option:

(C) DCOUNTA is used to count the non blank cells in a column of a list or database that matches the specified conditions.

Incorrect Options:

Rest of the options is incorrect.    

 .............. is used to add the numbers in a column of a list or database that matches the specified conditions.

(A) DVAR                                                            

(B) DSUM

(C) SUM                                                              

(D) All of these

(E) None of these  

Answer: (C)

Correct Option:

(C) DSUM s used to add the numbers in a column of a list or database that matches the specified conditions

Incorrect Options:

Rest of the options is incorrect.  

• Maximum numbers of columns you can enter in an Excel worksheet are 256.
• The maximum numbers of rows you can enter in worksheet are 65,536 rows.  

• Object-Oriented Spreadsheets: Allows viewing, analyzing and mapping data in different ways.
• Logical Spreadsheet: Enables logic functions rather than arithmetic functions that are used in deductive reasoning.
• GS-calc: Has some interested features, such as more than 2 million rows, over 2000 columns, password protection and encryption.  

• Worksheet environment which is used to manage numbers and calculation or provides an electronic worksheet is known as Excel.
• Lotus 1-2-3 also allows performing several mathematical calculations, such as total and average.
• GS-Calc allows 20,000 undo and redo levels.
• Various formatting styles on Text and Numbers as per requirement are permitted by Excel.
• An Excel file which contains several worksheets is referred as a workbook.
• In MS Excel the formulas begin with an equal (=) sign.  

 Abbreviations

• GUI ........................ Graphical User Interface