A
Only Bar charts can be drawn in a worksheet.
False
Formulas in a worksheet must begin with > (greater than) symbol sign.
False
Arrows, flowchart elements, stars, and geometrical shapes are called auto shapes.
True
SUM(number1, number2,...)
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
Define: Line charts
- Line charts show continuous data which helps to see data trends over time.
Define:Clip art
Answer - Clip art are simple pictures and symbols made available for users to add to their documents.
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.
AVERAGE function
Answer - The AVERAGE Function ( ) helps you get the average of numbers.
Example: AVERAGE(number1, number2,...)
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
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.
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.
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.
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.
What are the different components of a chart?
Answer- The components of a chart are as follows:
Chart title: title given to the chart
X-axis title: title given to the X-axis data range
Y-axis title: title given to Y-axis data range
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.
Y axis value : data range marked to plot the data series.
Data labels: the values of the data series plotted.
Legends: specifies the color, symbol, or pattern used to mark data series.
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
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.