microsoft excel 2010 charts

Ch-3

Microsoft Excel 2010 Charts

Class8

Short answer type questions: -

Q1. What is a chart?

Ans1. Charts a pictorial representation of large amount of data in a worksheet.

Q2. Write the advantages of a chart.

Ans2.    1) charts present data and information in an attractive manner.

            2) charts are easier to understand and compare.

Q3. What is the difference between a column chart and a bar chart?

Ans3. Column chart displays data in the form of vertical bars while bar chart displays data in the form of horizontal bars.

Q4. What is a chart title?

Ans4. It is the title given to the chart.

Q5. Name the screen elements of a chart.

Ans5. 1) chart area

2) plot area

3) data points

4) legend

5) chart and axis title

6) data label

Long answer type questions:-

Q1. Define the following chart types of Microsoft Excel 2010.

a)     Area chart

b)    Doughnut chart

c)     Stock chart

d)    Bubble chart

Ans1. 1) Area chart :- This displays quantitative data. It is used to compare two or more quantities.

2) Doughnut chart:- This compares multiple series of data.

3) Stock chart:-  This helps in tracking stock market activity.

4) Bubble chart:- This is used to show 3-D data in a flat 2-D chart.

Q2. Define the following screen elements of a chart.

a)     Chart area

b)    Plot area

c)     Data points

d)    Legend

Ans2. 1) Chart area:- this is the area surrounding the chart.

Plot area:- this is the area in which we plot our data

Data points:- it is a single value located in a worksheet cell.

Legend:- it describes colors, patterns and symbols assigned to data series.

Q3. Write the steps to create a chart in Excel.

Ans3. To create a chart: -

1)    Select the data

2)    Click on insert tab.

3)    Click on the chart type under charts group.

4)    Click the chart style we want to use.

5)    The chart will be displayed.

Q4. Write the steps to Format the chart.

Ans4. To format a chart: -

1)    Right click any area of the chart.

2)    Click on Format Chart Area.

3)    Select the desired option.

4)    Click close to see the effect.

Q5. Write the steps to print a chart.

Ans5.  To print a chart:-

1)    Select the chart to be printed

2)    Click on the file tab.

3)    Click on the print option.

4)    Give number of copies, select printer and click on print button.

connecting internet

Ch-9

Connecting Internet

Class8

Short answer type questions: -

Q1. What is internet?

Ans1. The internet is a network of the interlinked computer networking worldwide, which is available to the general public.

Q2. What is internet protocol?

Ans2. The interconnected computers work by transmitting data through a special type of packet switching which is known as IP or Internet Protocol.

Q3. Write a short note on whatsapp.

Ans3. WhatsApp messenger is very popular Instant messenger for smartphone. It was founded by Brain Acton and Jan Koum in 2009.

Q4. Write any four negative aspects of the internet.

Ans4.    1) Hackers

          2) Loss of privacy

          3) Internet Addiction

          4) spreading of rumors.

Q5.write few lines on E-greetings.

Ans5. Electronic cards is a facility of sending greetings online which is an eco-friendly way. For eg: - www.123greetings.com, archiesonline.com .

Q6. What is a web browser? Name any four popular web browsers.

Ans6. A web browser is the computer program we use to retrieve and view webpages.

Q7. Define search engine.

Ans7. A search engine is a program that searches through a database of web pages for a particular information.

Q8. Write a short note on WeChat App.

Ans8. WeChat App was designed in China for platforms like Symbian, windows phone, android and ios. It features voice messaging, broadcast messaging, photo video and location sharing.

Long answer type questions: -

Q1. Write a note on uses of internet.

Ans1. People can download songs, videos and movies over the internet and online dictionaries and translators are also available to translate different words and sentences in other languages. Internet is used in various fields :-

1)    In providing fun

2)    Networking conferences

3)    Games

4)    Entertainment

Q2. Write a note on blogging.

Ans2. A blog is a website that consists of frequently updated collection of entries. Most blogs focus on a particular topic or subject area. The entries that appear on a blog are called posts and the act of publishing a blog entry is called posting. Few of the blogging websites are :- www.blogger.com, www.typepad.com.

Q3. What do you mean by chatting on the internet?

Ans3. Chatting on internet is talking to other people who are using the internet on the same time when we are using it. Chats can be ongoing or scheduled for a particular time and duration. A chat can also be conducted using sound or video.

Q4. Write do’s and don’ts that should be followed while chatting on internet.

Ans4. Do’s

1)    Check the terms , conditions and privacy statements of the chat site.

2)    Use a chat nickname that does not give away sensitive information.

Don’ts

1)    Do not give out personal information.

2)    Do no agree to meet in person someone we have talked to.

Q5. What is video conferencing?

Ans5.video conferencing refer to a conference between two or more participants at different sites by using computer networks to transmit audio and video data. As the two participants speak to one another, their voices are carried over the network and delivered to other person.