Microsoft excel fully
solved & updated
1) What is Microsoft Excel? - answer Microsoft Excel is an electronic
spreadsheet application that enables users to store, organize,
calculate and manipulate the data with formulas using a
spreadsheet system broken up by rows and columns. It also
provides the flexibility to use an external database to do analysis,
make reports, etc. thus saving lots of time.
What is ribbon? - answer Ribbon refers to the topmost area of the
application that contains menu items and toolbars available in MS-
Excel. Ribbon can be shown/hidden using CTRL+F1. The ribbon runs
on the top of the application and is the replacement for the toolbars
and menus. The ribbons have various tabs on the top, and each tab
has its own group of commands
Explain Spreadsheet and its Basics. - answer Spreadsheet can be
compared to a paper ledger sheet. It consists or rows and columns
and their intersection called cells.
How many data formats are available in Excel? Name some of them.
- answer Eleven data formats are available in Microsoft Excel for
data Storage. Example:
Number - Stores data as a number
Currency - Stores data in the form of currency
Date - Data is stored as dates
, Percentage - Stores numbers as a percentage
Text Formats - Stores data as string of texts
Specify the order of operations used for evaluating formulas in
Excel. - answer Parentheses or Brackets
Exponent
Multiplication
Division
Addition
Subtraction
How can you wrap the text within a cell? - answer You must select
the text you want to wrap, and then click wrap text from the home
tab and you can wrap the text within a cell.
Explain Macro in MS-Excel - answer Macros are used for iterating
over a group of tasks. Users can create macros for their customized
repetitive functions and instructions. Macros can be either written
or recorded depending on the user.
Which are the two macro languages in MS-Excel? - answer XLM and
VBA (Visual Basic Applications). Earlier versions of Excel used XLM.
VBA was introduced in Excel 5 and mostly used now.
Is it possible to prevent someone from copying the cell from your
worksheet? - answer Yes, it is possible. To protect your worksheet
from getting copied, you need to go into Menu bar >Review >
Protect Sheet > Password. By entering a password, you can secure
your sheet from getting copied by others.
solved & updated
1) What is Microsoft Excel? - answer Microsoft Excel is an electronic
spreadsheet application that enables users to store, organize,
calculate and manipulate the data with formulas using a
spreadsheet system broken up by rows and columns. It also
provides the flexibility to use an external database to do analysis,
make reports, etc. thus saving lots of time.
What is ribbon? - answer Ribbon refers to the topmost area of the
application that contains menu items and toolbars available in MS-
Excel. Ribbon can be shown/hidden using CTRL+F1. The ribbon runs
on the top of the application and is the replacement for the toolbars
and menus. The ribbons have various tabs on the top, and each tab
has its own group of commands
Explain Spreadsheet and its Basics. - answer Spreadsheet can be
compared to a paper ledger sheet. It consists or rows and columns
and their intersection called cells.
How many data formats are available in Excel? Name some of them.
- answer Eleven data formats are available in Microsoft Excel for
data Storage. Example:
Number - Stores data as a number
Currency - Stores data in the form of currency
Date - Data is stored as dates
, Percentage - Stores numbers as a percentage
Text Formats - Stores data as string of texts
Specify the order of operations used for evaluating formulas in
Excel. - answer Parentheses or Brackets
Exponent
Multiplication
Division
Addition
Subtraction
How can you wrap the text within a cell? - answer You must select
the text you want to wrap, and then click wrap text from the home
tab and you can wrap the text within a cell.
Explain Macro in MS-Excel - answer Macros are used for iterating
over a group of tasks. Users can create macros for their customized
repetitive functions and instructions. Macros can be either written
or recorded depending on the user.
Which are the two macro languages in MS-Excel? - answer XLM and
VBA (Visual Basic Applications). Earlier versions of Excel used XLM.
VBA was introduced in Excel 5 and mostly used now.
Is it possible to prevent someone from copying the cell from your
worksheet? - answer Yes, it is possible. To protect your worksheet
from getting copied, you need to go into Menu bar >Review >
Protect Sheet > Password. By entering a password, you can secure
your sheet from getting copied by others.
