Microsoft Excel

11.The active cell:
a.
b.
c.
d.

Option “D” is correct.
An active cell is a rectangular box that highlights (a bold border around) the cell in a spreadsheet. An active cell helps identify what cell is being worked with and where data will be entered.
12.Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
a.Logical
b.
c.Statistical
d.Financial

Option “D” is correct.
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
13.B7:B9 indicates:
a.
b.
c.
d.

Option “B” is correct.
B7:B9 indicates a range of cell between Cells B7 through B9.
14.The Cancel and Enter buttons appear in the:
a.
b.
c.
d.

Option “B” is correct.
Three buttons Cancel, Enter, and Function Wizard appear in the Formula bar.
15.Which of the following methods cannot be used to enter data in a cell?
a.
b.
c.
d.

Option “C” is correct.
Pressing the Esc key while editing a cell aborts the operation and leaves the cell in it’s original state.
16.Which of the following is not a basic step in creating a worksheet?
a.
b.
c.
d.

Option “D” is correct.
Copy the worksheet is not a basic step in creating a worksheet.
17.How do you select an entire column?
a.
b.
c.
d.

Option “B” is correct.
To select an entire column in MS-EXCEL, Click the column heading letter or press CTRL + Space Bar key.
18.How can you print three copies of a workbook?
a.
b.
c.
d.

Option “B” is correct.
Select File > Print from the menu and type 3 in the Number of copies text box
19.To create a formula, you first:
a.
b.
c.
d.

Option “B” is correct.
A formula always starts with an equal sign (=), which can be followed by numbers, math operators (such as a plus or minus sign), and functions, which can really expand the power of a formula.
20.To center worksheet titles across a range of cells, you must-
a.
b.
c.
d.

Option “A” is correct.
Select the cells containing the title text plus the range over which the title text is to be centered
Pages: 1 2 3 4 5 6 7