Chapter 8 Spreadsheet Software
Answer the following questions:
a. What is Microsoft excel? Write its features.
Ans: Microsoft Excel is a spreadsheet program created by Microsoft Corporation.
Some features of Ms-Excel are:
i) It helps to work with simple and complex calculations.
ii) It helps to work with different excel charts.
iii) It helps to sort and filter data.
iv) It helps to format and edit data from the home tab.
b. Name the components of Excel Windows.
Ans: The components of Excel windows are: File tab, Ribbon, Help, Zoom Control, View buttons, Sheet area, Row bar, column bar, etc.
c. Name the various options available on the spell check dialog box.
Ans: The different options available on the spell check dialog box are:
i) Ignore Once
ii) Ignore All
iii) Add to Dictionary
iv) Chane
v) Change all
vi) Auto Correct
d. What are the differences between Zoom in and Zoom out?
Ans: Zoom In means making zoom or enlarging the workbook up to 400% by moving the slider to the right.
Zoom out means making zoom out or reducing the workbook up to 10% by moving the slider to the left.
e. Define the cell.
Ans: Cells are the boxes you see in the grid of an Excel worksheet.
f. What is formatting a cell?
Ans: Cell formatting means changing the way of cell data appears in the spreadsheet like numbers, currency, dates, etc.
g. What are the various tab of format cells?
Ans: The various tab of format cells are: Number, Alignment, Font, Border, fill, and Protection.
h. What is meant by merging cells?
Ans: You can merge two or more than two cells or combine a group of cells into a single cell in Excel which is known as merging cells.
i. What is a function? Name some functions used by Excel.
Ans: Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure.
Excel includes many common functions that can be used to quickly find the sum, average, count, maximum value, and minimum value for a range of cells.
j. What are the parts of function? Explain.
Answer the following questions:
a. What is Microsoft excel? Write its features.
Ans: Microsoft Excel is a spreadsheet program created by Microsoft Corporation.
Some features of Ms-Excel are:
i) It helps to work with simple and complex calculations.
ii) It helps to work with different excel charts.
iii) It helps to sort and filter data.
iv) It helps to format and edit data from the home tab.
b. Name the components of Excel Windows.
Ans: The components of Excel windows are: File tab, Ribbon, Help, Zoom Control, View buttons, Sheet area, Row bar, column bar, etc.
c. Name the various options available on the spell check dialog box.
Ans: The different options available on the spell check dialog box are:
i) Ignore Once
ii) Ignore All
iii) Add to Dictionary
iv) Chane
v) Change all
vi) Auto Correct
d. What are the differences between Zoom in and Zoom out?
Ans: Zoom In means making zoom or enlarging the workbook up to 400% by moving the slider to the right.
Zoom out means making zoom out or reducing the workbook up to 10% by moving the slider to the left.
e. Define the cell.
Ans: Cells are the boxes you see in the grid of an Excel worksheet.
f. What is formatting a cell?
Ans: Cell formatting means changing the way of cell data appears in the spreadsheet like numbers, currency, dates, etc.
g. What are the various tab of format cells?
Ans: The various tab of format cells are: Number, Alignment, Font, Border, fill, and Protection.
h. What is meant by merging cells?
Ans: You can merge two or more than two cells or combine a group of cells into a single cell in Excel which is known as merging cells.
i. What is a function? Name some functions used by Excel.
Ans: Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure.
Excel includes many common functions that can be used to quickly find the sum, average, count, maximum value, and minimum value for a range of cells.
j. What are the parts of function? Explain.
Ans: The different parts of the function are: Equal sign, Function name, and Argument.
k. Explain Arguments.
Ans: Arguments are the values that functions use to perform calculations.
No comments:
Post a Comment