Calculations | MCQs

Explanation

Explanation

A worksheet is an electronic spreadsheet that lets users to Calculate, Enter & Analyze data.

A spreadsheet is a computer application for computation, organization, analysis and storage of data in tabular form.

Explanation

To find the current flowing through the conductor, you can use Ohm's Law, which states:

$\text{Voltage (V)}=\text{Current (I)}\times \text{Resistance (R)}$

Given that the power (P) of the conductor is $100\text{W}$, and the voltage (V) is $250\text{V}$, you can use the formula:

Explanation

Explanation

x⁵ represents x raised to the power of 5, which is commonly formatted as a superscript in MS Office.

Explanation

Financial Functions are used to calculate depreciation, rates of return, future values and loan payment amounts.

A list of Excel Financial Functions in Excel are:

⇒Investment value functions including

1. FV

2. FVSCHEDULE

3. NPV

4. PV

5. RECEIVED

6. XNPV

⇒Internal rate of return functions including

1. IRR

2. MIRR

3. XIRR

⇒Asset depreciation functions including

1. AMORDEGRC

2. AMORLINC

3. DB

4. DDB

5. SLN

6. SYD

7. VDB

⇒Payment functions including

1. CUMIPMT

2. CUMPRINC

3. IPMT

4. ISPMT

5. PMT

6. PPMT

⇒Dollar conversion including

1. DOLLARDE

2. DOLLARFR

⇒Yield functions including

1. YIELD

2. YIELDDISC

3. YIELDMAT

4. ODDFYIELD

5. ODDLYIELD

6. TBILLEO

7. TBILLYIELD

⇒Price functions including

1. PRICE

2. PRICEDISC

3. PRICEMAT

4. ODDFPRICE

5. ODDLPRICE

6. TBILLPRICE

Explanation