What is Workbook
A workbook is a collection of worksheets where the user works. A workbook can contain maximum 255 sheets to work in. Whenever a workbook opens, it display three workbook by default.
What is Worksheet
a worksheet is a place where the user works and perform arithmetical and functional calculations. By default is named as sheet1,sheet2,sheet3,…etc. A sheet can renamed too.
What is Name Box
it is the box on the left of formula bar that gives the address of address of each cell.
What is Active Cell
Which cell is selected or ready to accept data known as active cell. It will display with dark outline
What is Range in Excel?
A range is a group of contiguous cell, which form the shape of rectangle . You can specify a range by writing the starting cell address followed by a colon ( : ) and the end cell address
How many Types of Cell Reference in Excel
There are 3 types of Cell Reference:
What are charts in MS-Excel?
To enable graphical representation of the data in Excel, charts are provided. A user can use any chart type, including column, bar, line, pie, scatter, etc. by selecting an option from Insert tab's Chart group.
What is the use of NameBox in MS-Excel?
Name Box is used to return to a particular area of the worksheet by typing the range name or cell address in the name box.
What is Freeze Panes in MS-Excel?
To lock any row or column, freeze panes is used. The locked row or column will be visible on the screen even after we scroll the sheet vertically or horizontally.
Explain Spreadsheet and its Basics.
Spreadsheet can be compared to a paper ledger sheet. It consists or rows and columns and their intersection called cells.
Explain Macro in MS-Excel.
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.
What is Microsoft Excel?
Microsoft Excel is an electronic worksheet or spreadsheet application which is used for organizing, storing, and manipulating and analyzing data. It is developed by Microsoft.
What are cells?
The area where data is stored is known as cell.
Does each cell have unique address?
Yes, each cell has a unique address depends on the row and column value of the cell.
What does the IF function in Excel?
IF function is used in Excel to check whether certain conditions are true or false. If the condition is true then it will give the result accordingly and if the condition is false the result or output will be different.
What are the advantages of using formula in Excel sheet?
Formula makes it easy to calculate the numbers in Excel sheet. It also calculates automatically the number replaced by another number or digit. It is used to make complex calculations easy.