Answer and Explanation:
A.) Format Cells
When the format cells in an Excel then, change an appearance of the number without the changing a number itself. Apply the number formats (0.7, $0.70, 70%, etc) or other formatting (alignments, fonts, borders, etc).
1. Enter a value 0.7 into the cell B2.
By default, the Excel use the General formats (no specific numbers format) for the numbers To apply the number format, use a 'Format Cell' dialog box.
2. Then, Select the cell B2.
3. Then, Right click, then click the Format Cell (or press the shortcut key CTRL + 1).
The 'Format Cell' dialog box will appears.
4. Then, For example, if you want - select Currency.
Note: The Excel give you the life preview of how a number will formatted.
5. After that, Click OK.
The Cell B2 will still contain the number 0.7. Then you only changed an appearance of the number. Most frequently used a formatting command that are available on Home tab.
6. On Home tab, in a Number group, click percentage symbol to apply the Percentage formats.
7. On Home tab, in Alignment group, center a numbers.
8. On Home tab, in Font group, add the outside border and change the fonts color to the blue.
B). Destination cell
Destination area or Destination cell - A range of the cells that is select to hold a summarized data in the consolidations. The destination area or cell can be on same worksheets as source data or on the different worksheets. Worksheet can contains only the one consolidation.
C). Save As
If you want to save workbook with the different name use File then click on Save As dialog box or use a shortcut key (Alt + F2).
Then, Select a folder that you wants to store a workbook in using Save in the drop-down lists.
Then, Enters a new filename in the File name box at bottom.
D.) .html
Extension of the web page workbooks is .html.
E). SUM
The SUM function is the built in function in the excel which is used to add all the numbers in the range of the cells and returns its result.
F). Home Tab
A clipboard group is on far left side of a Home Tab. It is an often used in the conjunctions with Editing group, which is on far right side of the tab.
G.) .csv
CSV stands for Comma Separated Value.
CSV is the simple file format that is used to store a tabular datas, such as the spreadsheet or the database. A File in the CSV formats can be imported and exported from the programs that stores data in the tables, such as the Microsoft Excel or the OpenOffice Calc.
H). Worksheet tab
.
To Show the Sheet tabs settings is turned off.
Firstly, ensure that Show Sheet tab is enabled or not.
To do, all the other Excel version, click the File >then Options >then Advanced, in the under Display option for the workbook, then ensures that there is the check in a Show sheet tabs box.
I). AutoFit
J). Sum, Product, Power, Sqrt, Quotient, Mod and many others.
There are 300+ formulas in Excel.
