FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -with a dollar sign to the left of the number, inserts a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent. the values that you use with a function are called arguments.

Detailed explanation-2: -The comma style format adds a comma and a dollar sign to a cell value.

Detailed explanation-3: -On the Home tab, click the Dialog Box Launcher next to Number. Tip: You can also press Ctrl+1 to open the Format Cells dialog box. In the Format Cells dialog box, in the Category list, click Currency or Accounting. In the Symbol box, click the currency symbol that you want.

Detailed explanation-4: -Absolute cell references In an absolute reference, each part of the reference (the letter that refers to the row and the number that refers to the column) is preceded by a “$” – for example, $A$1 is an absolute reference to cell A1.

Detailed explanation-5: -This style format is used to instruct Excel to display numbers with commas and no dollar signs. It can be assigned to a range of cells by clicking the Comma Style button. This inserts a comma every three positions to the left of the decimal point and causes number to be displayed to the nearest hundredths.