Below information help to improve your Microsoft Excel Knowledge.
Microsoft Excel is full of spreadsheet programming application. It is used to calculate budgets, graphs, simple and complex calculations. Microsoft Excel is workbook preparation used by sheets, it has many sheets. Microsoft Excel is fully based on table. It has many rows (1, 2, 3, ...1048576) and columns (A, B, C, ...). It is given name to each row and column merge (Name is shown in name box). Click the box shows the name of the box.
Type the word in the table box content is larger, then increase the column width or row height. Easy to increase and decrease the row height and column width, which row height is increase just click the row then show the double side arrow then drag the arrow (Same as increase the column width). Otherwise, click the home tab to select the wrap text. Otherwise, select two or more rows or columns then click home tab select merge & center.
In Microsoft Excel sheet click the cell that shows different symbols (arrow, plus) that are used to different tasks (move, select, fill handle). The four side arrow used to move the cell to any place in the sheet. The plus symbol used to select the rows and columns. The little plus symbol (shows in click the cell right side corner cube) is used to fill the cell horizontal and vertical format. It is used same content in many cells in easy way. It is also used to fill the number series, months, date (based on computer date format) and days (click autofill options select fill series).
Insert and delete row in Microsoft Excel select entire row then click home tab select insert symbol to create new row shows in top of the selected row and select delete symbol selected row will be deleted. Insert and delete column in Microsoft Excel select entire column then click home tab select insert symbol to create new column shows in left of the selected column and select delete symbol selected column will be deleted. Insert and delete one cell then click the cell then click home tab select insert to insert new cell in top of the selected cell, select delete symbol selected cell will be deleted.
Microsoft Excel has many sheets (sheet1, sheet2, ....) it is allowed to give different name in sheets based on content of the sheet. Give name to sheet right click of the sheet then select rename then give the content related name then click enter. Otherwise, double click sheet, then sheet shows rename mode type the content related name then click enter sheet name is changed.
Microsoft Excel used to simple and complex calculations in many ways. Add two numbers in Excel select one cell then type equal symbol (=) then put plus (+) between two numbers (=9+8) then shows the calculation of two numbers in selected cell. It is called number based calculation, it is not used for different number calculations. Mostly used cell based calculations. Top of the sheet shows the formula bar that is shows each cell content, formula, equation which is placed on the cell. Cell based calculation in used cell name and used arithmetic operators. Add two numbers select the cell (total) type equal symbol (=) then put name of the add two number cells (=D4+D5). In this calculation change, many numbers' calculation is done. In same calculation is used in entire row or column drag the cell right corner small plus symbol then each has same calculation formula. Many numbers' calculation used to function of the Microsoft Excel. Add many numbers then select the cell then type the formula bar (=sum(num1, num2,...)) =sum(K2:K9) that is calculated easily. Otherwise, used auto sum to select given numbers then click home tab to select auto sum that is calculated.
You must be logged in to post a comment.