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.
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.
it is the box on the left of formula bar that gives the address of address of each cell.
Which cell is selected or ready to accept data known as active cell. It will display with dark outline
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
There are 3 types of Cell Reference:
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.
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.
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.
Spreadsheet can be compared to a paper ledger sheet. It consists or rows and columns and their intersection called cells.
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.
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.
The area where data is stored is known as cell.
Yes, each cell has a unique address depends on the row and column value of the cell.
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.
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.
The selected cell in the worksheet; indicated with a dark border.
The worksheet currently displayed in the workbook window.
A single rectangular block that includes a group of contiguous cells.
A symbol, such as +, - , *, or /, used in a formula to perform arithmetic calculations.
The feature that helps make entering repetitive text easier. As you enter text in a worksheet, text that begins with the same letters as a previous entry in the same column is displayed.
To eliminate empty space by matching the column width to the longest cell entry or the row height to the tallest cell entry.
A button that quickly inserts Excel functions that summarize all the values in a column or row using a single statistic
The intersection of a column or row in a worksheet.
A group of worksheet cells, which can be adjacent or nonadjacent. (Example - A2:G19)
The address of a cell indicating its column and row location.
In Excel, the part of the worksheet that identifies each column by a different letter.
To remove data from a cell and place it on the Office Clipboard.
A value in a recognized date format.
To move an item (either text or a graphic) by selecting it and dragging it with the mouse.