Show:
A
B
C
D
E
100

Only Bar charts can be drawn in a worksheet.

False

100

Formulas in a worksheet must begin with > (greater than) symbol sign. 

False

100

Arrows, flowchart elements, stars, and geometrical shapes are called auto shapes.

True

100
Formula of Sum

  •  SUM(number1, number2,...)

 

200

Define- SUM function   

  • The SUM ( ) function adds all the numbers in a range of cells.

  • Example: SUM(number1, number2,...)

  • SUM function has different forms which you can choose as per your need. Example: SUMIF

200

Define: Line charts

- Line charts show continuous data which helps to see data trends over time.

200

Define:Clip art

Answer  - Clip art are simple pictures and symbols made available for users to add to their documents.

200

Define: Charts 

Charts allow you to present data in a visual format using a variety of graph types. Before you can make a chart, you must enter the data into a worksheet. Examples of components of a chart are Chart title X- axis, Y- axis, etc. 

200

AVERAGE function

Answer -   The AVERAGE Function ( ) helps you get the average of numbers.

 Example: AVERAGE(number1, number2,...)



300

What are the elements of a formula?

Answer - A formula can have the following elements:

  • Begins with = sign

  • Mathematical operators like + (for addition), / (for division), * (for multiplication)

  • Cell range (A1:D8)

  • Text or numbers

  • Functions like SUM, AVERAGE, etc 



300

Difference between MIN function and MAX function  

MIN Function-Helps you get the minimum number from the range of cells.

Max Function-Helps you get the maximum number from the range of cells.


300

Explain SmartArt Graphics 

  • SmartArt Graphics are a visual representation of information and ideas.

  • It can be used to quickly, easily and effectively communicate a message.

  • You can copy and paste SmartArt graphics as images into other programs like Word and Powerpoint.

300

Difference between Formulas and functions

Formulas are used to calculate the value of cells in a worksheet.

Functions are predefined formulas and are already available in Excel. 


300

Explain the purpose of column charts and bar charts.

Column charts - It is used to compare values across categories or groups.

 Bar Charts - It is used to show comparison between individual items.

400

What are the different components of a chart? 

   Answer- The components of a chart are as follows:

  1. Chart title: title given to the chart

  2. X-axis title: title given to the X-axis data range

  3. Y-axis title: title given to Y-axis data range

  4. X-axis category: categories of the data which have been plotted. These are taken from the first column or first row of your data range.

  5. Y axis value : data range marked to plot the data series.

  6. Data labels: the values of the data series plotted.

  7. Legends: specifies the color, symbol, or pattern used to mark data series.

400

Give steps to create SmartArt graphics in Excel

Answer - Steps to create a SmartArt:

Step 1-Click on Insert Tab

Step 2 - From the Illustration group, click SmartArt

Step 3 - Choose a Category 

Step 4 - Click Ok

400

Write the steps to insert a clipart in a worksheet.  

Answer - The steps to insert a Clip Art are as follows:

Step 1 - Click on Insert Tab

Step 2 - From Illustrations group, click on Clip Art

Step 3 - Select a Collection

Step 4 - Press Go Button

Step 5 - Click on a Clip from the collection.