Spreadsheet (Microsoft Excel)
Write Very Short answer of the following question.
a) Is Ms-Excel word processing software?
Ans: No, Ms-Excel is not word processing software.
b) Which was the first electronic spreadsheet software?
Ans: VisiCalc was the first electronic spreadsheet software.
c) Where does status bar lie at Ms-Excel screen?
Ans: Status bar lie in the bottom of Ms-Excel screen window.
d) Which symbol is used to begin formula in Ms-Excel?
Ans: An equal to (=) symbol is used to begin formula in Ms-Excel.
e) Which shortcut keys are used to save and close the worksheet?
Ans: Ctrl+s shortcut key to save and Ctrl+w shortcut key is used close in the worksheet
f) How can you select an entire worksheet?
Ans: We can select an entire worksheet by pressing Ctrl+A keys from the keyboard.
g) Write the reference operators used in MS-Excel?
Ans: Range operator and Union operator are the reference operators used in MS-Excel.
h) Name the functions that are used to enter data in the cell.
Ans: To enter the data in the cell first you have to select that cell by clicking on it.
i) What is the extension of Excel worksheet?
Ans: The extension of Excel worksheet is dot xls or dot xlsx (.xls or .xlsx)
Write short answer of the following questions:
a) What is an electronic spreadsheet? Give some examples of electronic spreadsheet?
Ans: An electronic spreadsheet is a software that stores data in tabular form that i.e. rows and columns and allows you to calculate and manipulate them according to your requirement. Example: Ms-Excel, VisiCalc, Lotus 1-2-3 etc.
b) What is Microsoft Excel? Write different components of Ms-Excel 2016 window.
Ans: Ms-Excel is one of the popular and widely used spreadsheet software developed by Microsoft Corporation USA.
The different components of Ms-Excel 2016 window are :
File Tab, Quick Access toolbar, Title bar, Ribbon, Formula Bar, Working Area, Status Bar, Sheet Tabs, Worksheet view buttons, Tell me, Zoom control etc.
c) What are different methods of selecting data in the worksheet.
Ans The different methods of selecting data in the worksheet are given below:
d) What is the fill handle? Write its uses.
Ans: Fill handle is a small black square that appears at the bottom right corner of the selected cell. It is used to auto fill list items, to fill custom list etc.
e) What is the use of Auto fill feature?
Ans: Auto fill feature in Ms-Excel is used to automatically copy cells and fill them with a series without using copy command.
f) What are different operators used in Excel?
Ans: The different operators used in Excel are:
i) Arithmetic Operators ii) Relational or Comparison Operators
iii) Reference Operators iv) Logical Operators
v) Text Operators
g) What are the rules of using formula in Excel?
Ans: Rules for using formula in Excel are given below:
i) The formula always must begin with an equal sign (=)
ii) After inserting formula, press Enter key to confirm it.
iii) The formula are not case sensitive.
iv) The cell address also can be used in the formula. Eg. (A2+B2)*F5
v) The references, constants, operators and functions can be used in formula.
h) What is chart? Write its importance.
Ans: Charts are graphical presentation of numeric data in the worksheet. Charts are based on data contained in worksheets and it helps to observe and compare different data in the worksheet.
Write Very Short answer of the following question.
a) Is Ms-Excel word processing software?
Ans: No, Ms-Excel is not word processing software.
b) Which was the first electronic spreadsheet software?
Ans: VisiCalc was the first electronic spreadsheet software.
c) Where does status bar lie at Ms-Excel screen?
Ans: Status bar lie in the bottom of Ms-Excel screen window.
d) Which symbol is used to begin formula in Ms-Excel?
Ans: An equal to (=) symbol is used to begin formula in Ms-Excel.
e) Which shortcut keys are used to save and close the worksheet?
Ans: Ctrl+s shortcut key to save and Ctrl+w shortcut key is used close in the worksheet
f) How can you select an entire worksheet?
Ans: We can select an entire worksheet by pressing Ctrl+A keys from the keyboard.
g) Write the reference operators used in MS-Excel?
Ans: Range operator and Union operator are the reference operators used in MS-Excel.
h) Name the functions that are used to enter data in the cell.
Ans: To enter the data in the cell first you have to select that cell by clicking on it.
i) What is the extension of Excel worksheet?
Ans: The extension of Excel worksheet is dot xls or dot xlsx (.xls or .xlsx)
Write short answer of the following questions:
a) What is an electronic spreadsheet? Give some examples of electronic spreadsheet?
Ans: An electronic spreadsheet is a software that stores data in tabular form that i.e. rows and columns and allows you to calculate and manipulate them according to your requirement. Example: Ms-Excel, VisiCalc, Lotus 1-2-3 etc.
b) What is Microsoft Excel? Write different components of Ms-Excel 2016 window.
Ans: Ms-Excel is one of the popular and widely used spreadsheet software developed by Microsoft Corporation USA.
The different components of Ms-Excel 2016 window are :
File Tab, Quick Access toolbar, Title bar, Ribbon, Formula Bar, Working Area, Status Bar, Sheet Tabs, Worksheet view buttons, Tell me, Zoom control etc.
c) What are different methods of selecting data in the worksheet.
Ans The different methods of selecting data in the worksheet are given below:
d) What is the fill handle? Write its uses.
Ans: Fill handle is a small black square that appears at the bottom right corner of the selected cell. It is used to auto fill list items, to fill custom list etc.
e) What is the use of Auto fill feature?
Ans: Auto fill feature in Ms-Excel is used to automatically copy cells and fill them with a series without using copy command.
f) What are different operators used in Excel?
Ans: The different operators used in Excel are:
i) Arithmetic Operators ii) Relational or Comparison Operators
iii) Reference Operators iv) Logical Operators
v) Text Operators
g) What are the rules of using formula in Excel?
Ans: Rules for using formula in Excel are given below:
i) The formula always must begin with an equal sign (=)
ii) After inserting formula, press Enter key to confirm it.
iii) The formula are not case sensitive.
iv) The cell address also can be used in the formula. Eg. (A2+B2)*F5
v) The references, constants, operators and functions can be used in formula.
h) What is chart? Write its importance.
Ans: Charts are graphical presentation of numeric data in the worksheet. Charts are based on data contained in worksheets and it helps to observe and compare different data in the worksheet.
No comments:
Post a Comment