FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Two of the more powerful aspects of Excel are its wide array of functions and its capability of organizing answers to what-if questions. Excel is case sensitive with respect to names of cells. You cannot use column and row titles within formulas when you want to refer to the related data by name.

Detailed explanation-2: -The PMT function uses the following arguments: Rate (required argument) – The interest rate of the loan. Nper (required argument) – Total number of payments for the loan taken. Pv (required argument) – The present value or total amount that a series of future payments is worth now.

Detailed explanation-3: -The Rows command on the Insert menu or the Insert command on the shortcut menu allow rows to be inserted between rows that already contain data. 36. When rows are inserted into a worksheet, if rows that are shifted down include any formulas, Excel adjusts the cell references to the new locations.

Detailed explanation-4: -The dollar sign in an Excel cell reference affects just one thing-it instructs Excel how to treat the reference when the formula is moved or copied to other cells. In a nutshell, using the $ sign before the row and column coordinates makes an absolute cell reference that won’t change.

Detailed explanation-5: -In order to ungroup a cell range, the range will need to be selected. Explanation: Excel will not be able to ungroup any grouped data that is not selected. Data is ungrouped in the same area it is grouped.