062-Quiz02

True/False

1. Goal-seek in Microsoft Excel does the similar job as any formula does.

ANS: F

2. Solver and Goal-seek are basically used for the same purpose.

ANS: T

3. Sheet1!A2 is a valid cell name in Microsoft Excel.

ANS: T

4. In Microsoft Excel formulas, use of parenthesis ( ) is a must.

ANS: F

5. Suppose A1 has the value 32 in it. If the format of A1 is changed from General to Date, A1 will show the date 2^nd Feb, 1900.

ANS: F

Multiple Choice

1.= If you need to find out that how much you should spend on your books while you want your savings to be 500. The best tool is

1. Goal seek
2. Solver
3. Any one of the above
4. None of the above

ANS: C

2. In a cell of Microsoft Excel, we can enter ____________ types of entries:

1. 2
2. 3
3. 4
4. None of the above

ANS: B

3. Another name used for a cell name in Microsoft Excel is _____________

1. Cell reference
2. Cell address
3. Both A and B
4. Neither A nor B

ANS: C

4. Microsoft Excels allows us to write __________ types of formulas.

1. 2
2. 3
3. 4
4. None of the above

ANS: B

5. There are ______ types of cell addresses in Microsoft Excel.

1. 2
2. 3
3. 4
4. None of the above

ANS: B

6. $A1 is an example of ___________ cell address.

1. Mixed
2. Absolute
3. Relative
4. None of the above

ANS: A

7. Consider the formula =$C1 is written in cell A1. When the formula is copied to the cell A2, it will become:

1. $C2
2. $D1
3. $D2
4. None of the above

ANS:A

8. Which of the format settings will create the similar effects as Currency?

1. Number
2. Accounting
3. General
4. None of the above

ANS: B

9. When 3:00 PM is converted to General format, Microsoft Excel will show:

1. 0.55
2. 0.625
3. 0.75
4. None of the above

ANS: B

10. You have a long list of numbers. You want all numbers above 10 appearing as RED color. Which format option you need here?

1. Conditional Format
2. Auto Format
3. Any one of the above
4. None of the above

ANS: A