Question

Kips
Son P
ASSIGNMENT - II (2020-2021)
CLASS-VII
SUBJECT: COMPUTER
CHAPTER-3, ADVANCED FEATURES OF EXCEL
//2020
vi.
No. of Page: 5 to 8
vii.
worksheets facilitate in editing multiple worksheets at the same time
To
a chart element like a chart title, simply double click the
placeholder and begin typing
From the
tab, select the Switch Row/Column command to change
the way charts group your data
Date of Submission:
vii.
Topk Covered:
Components of a Chart
Commonly used Chart types
Creating a Chart
Chart Elements
Formatting a Chart
Combo Charts and Sparklines
Using Goal Seek
Grouping Worksheets
Consolidating Data
Learning Outcomes:
Insert Chart
Types of Chart
Different Elements of Chart and format
Combining the Data
Q.2. Multiple choice questions.
i. What are the headings given to X-axis and Y-axis known as?
a. Data series
b. Axes Titles
c. Legends
Which function key is used to insert a chart instantly in a worksheet?
a. F6
b. F8
C. F11
iii. Which chart type displays data in the form of a circle?
a, Line
b. Pie
Bar
iv.
Which key is used to group multiple worksheets?
a. Shift
b. Ctrl
C.
Enter
.
v.
Which of the following is not type of chart in MS Excel :-
a,
When you move the mouse pointer over a chart oleject,
Enod display a screen tip with the component name.
vi.
Pyramid
b. Doughnut
c. igloo
Which chart is used to combine two or more chart type in a single chart?
a. Scatter
b. Goal Seek
C. Combo
Charts and graphs are simple and easier to
data.
a.
Understand
b. Compare
C.
None of these
vii.
ters Recall
Q.3. State True or False and correct the false statement (rewrite the correct
statement):-
We can format data series. By changing the bar colors, line, slices and shifting its
position.
i.
Q.1. Complete the following.
i
describes the aim and contents of the chart.
it.
chart displays data in the form of vertical bars.
А
is a mini chart placed inside a single cell of worksheet.
iv.
shapes on a chart
Bar charts are used to show
between individual items.
ii.
We can also add, remove or change chart elements.
X-axis is the vertical axis.
V.
5 Page
are the values from cells on worksheets display as bars, lines or other​

Answer 1

Answer:

bbiub. kjv. ougv bihv bjuv. mj9