Sarita in her project wants to show market share occupied by different companies in laptop sales.Which
type of chart should she use and why?
Answers
Question:⤵
Sarita in her project wants to show market share occupied by different companies in laptop sales. Which type of chart should she use and why?
Answer:⤵
The document contains the answers for the question asked in the Computer curriculum books by Navdeep
Publications, and provides the summarized answers to the different parts based on Microsoft Office Suite. The
document is made exclusively for a summarized revision of the contents asked and does not reproduce any of the
learning-from-scratch material.
MICROSOFT OFFICE EXCEL
1. INTRODUCING MS OFFICE EXCEL
VSA
1. What does a worksheet consist of?
It consists of cells arranged with columns and rows.
2. What is a workbook?
It is a spreadsheet document used to perform numeric and logical calculations quickly.
3. How is a cell address formed?
By writing its column-header followed by row-header.
4. When does a cell become active?
When it is selected, it becomes active.
5. What does (A1:A7) mean?
It means cell range from A1 to A7.
SA
1. Write about electronic spreadsheets.
An electronic spreadsheet is a program used to perform numeric and logical calculations quickly
and accurately.
2. What is MS Excel?
It is the spreadsheet part of Microsoft Office Suite and is used to perform numeric and logical
calculations quickly and accurately.
3. What do you understand by AutoSUm?
It is a feature in Excel under Formulas tab and is used to calculate sum of numbers.
4. What is Sorting?
It is a feature in Excel under Home tab. It is used to arrange data in a specific order.
SAS
1. Ravi has to sort data entered in the worksheet. Write down the steps.
i) He should select the data.
ii) Under Home tab, click on Sort and Filter option.
iii) Choose the desired arrangement.
2. Shalini has made wrong entries in a cell. How can she edit it using the Formula bar?
MICROSOFT OFFICE EXCEL
AZAMGARH PUBLIC SCHOOL Page 3
She should select that cell; its formula will be displayed in the Formula bar. Then she should click on
the Formula bar and edit the formula.
3. Sohail has to calculate sum of numbers entered in a worksheet. Write down the steps so he can
do it.
i) Select the numbers.
ii) Go to Formulas tab.
iii) Click on AutoSum.
2. WORKING IN MS EXCEL
VSA
1. What is the spreadsheet part of MS Office suite 2007 called?
Microsoft Office Excel 2007.
2. How a cell is formed in a worksheet?
It is formed by intersection of rows and columns.
3. Name the extension of workbook in MS Excel 2007.
.xlsx
4. What is the data which include numbers from 0-9 and characters +,-,e,% etc. called?
Numeric Data.
SA
sWhat is Absolute Referencing?
1. What is Relative Referencing?
SAS
c) Logical Function: are used to make decision making operation.
4. What is the Goal Seek option and how is it useful?
It is an option in MS Excel which manipulates the previous results using new inputs. It is useful
because it automatically performs the necessary calculation.
5. What is the use of Conditional Formatting?
It is a feature in Excel which is used to apply formatting into cells with specific criteria.
SAS
4. Harish is making a project report on rainfall in the last four years in his state. He has to display
maximum, minimum and average rainfall. What should he do so that all can be conveniently
calculated?
He should use max( ), min( ) and average( ) functions respectively.
5. Class 7th teacher is creating merit list of students. She has to find all those students who have
scored more than 80 marks. Which options in Excel she can use to find this?
By using Conditional Formatting.
Explanation:⤵
Hope this answer will help you.✌
Answer:
Question:⤵
Sarita in her project wants to show market share occupied by different companies in laptop sales. Which type of chart should she use and why?
Answer:⤵
The document contains the answers for the question asked in the Computer curriculum books by Navdeep
Publications, and provides the summarized answers to the different parts based on Microsoft Office Suite. The
document is made exclusively for a summarized revision of the contents asked and does not reproduce any of the
learning-from-scratch material.
MICROSOFT OFFICE EXCEL
1. INTRODUCING MS OFFICE EXCEL
VSA
1. What does a worksheet consist of?
It consists of cells arranged with columns and rows.
2. What is a workbook?
It is a spreadsheet document used to perform numeric and logical calculations quickly.
3. How is a cell address formed?
By writing its column-header followed by row-header.
4. When does a cell become active?
When it is selected, it becomes active.
5. What does (A1:A7) mean?
It means cell range from A1 to A7.
SA
1. Write about electronic spreadsheets.
An electronic spreadsheet is a program used to perform numeric and logical calculations quickly
and accurately.
2. What is MS Excel?
It is the spreadsheet part of Microsoft Office Suite and is used to perform numeric and logical
calculations quickly and accurately.
3. What do you understand by AutoSUm?
It is a feature in Excel under Formulas tab and is used to calculate sum of numbers.
4. What is Sorting?
It is a feature in Excel under Home tab. It is used to arrange data in a specific order.
SAS
1. Ravi has to sort data entered in the worksheet. Write down the steps.
i) He should select the data.
ii) Under Home tab, click on Sort and Filter option.
iii) Choose the desired arrangement.
2. Shalini has made wrong entries in a cell. How can she edit it using the Formula bar?
MICROSOFT OFFICE EXCEL
AZAMGARH PUBLIC SCHOOL Page 3
She should select that cell; its formula will be displayed in the Formula bar. Then she should click on
the Formula bar and edit the formula.
3. Sohail has to calculate sum of numbers entered in a worksheet. Write down the steps so he can
do it.
i) Select the numbers.
ii) Go to Formulas tab.
iii) Click on AutoSum.
2. WORKING IN MS EXCEL
VSA
1. What is the spreadsheet part of MS Office suite 2007 called?
Microsoft Office Excel 2007.
2. How a cell is formed in a worksheet?
It is formed by intersection of rows and columns.
3. Name the extension of workbook in MS Excel 2007.
.xlsx
4. What is the data which include numbers from 0-9 and characters +,-,e,% etc. called?
Numeric Data.
SA
sWhat is Absolute Referencing?
1. What is Relative Referencing?
SAS
c) Logical Function: are used to make decision making operation.
4. What is the Goal Seek option and how is it useful?
It is an option in MS Excel which manipulates the previous results using new inputs. It is useful
because it automatically performs the necessary calculation.
5. What is the use of Conditional Formatting?
It is a feature in Excel which is used to apply formatting into cells with specific criteria.
SAS
4. Harish is making a project report on rainfall in the last four years in his state. He has to display
maximum, minimum and average rainfall. What should he do so that all can be conveniently
calculated?
He should use max( ), min( ) and average( ) functions respectively.
5. Class 7th teacher is creating merit list of students. She has to find all those students who have
scored more than 80 marks. Which options in Excel she can use to find this?
By using Conditional Formatting.
Explanation:⤵
Please mark Brainliest