quizz

How do you display current date only in MS Excel?

• Date ()

• Today ()

• Now ()

• Time ()

How do you wrap the text in a cell?

• A. Format cells font

• B. Format cells protection

• C. Format cells number

• D. Format cells alignment

3. What does COUNTA () function do?

• A. Counts cells having alphabets

• B. Counts empty cells

• C. Counts cells having number

• D. Counts non-empty cells

4. What is the short cut key to highlight the entire column?

• A. Ctrl + C

• B. Ctrl + Enter

• C. Ctrl + Page Up

• D. Ctrl + Space Bar

5. In the formula, which symbol specifies the fixed columns or rows?

• A. $

• B. *

• C. %

• D. ;

6. You can convert existing excel worksheet data an charts to an HTML document by using

• A. FTP wizard

• B. Internet assistant wizard

• C. Intranet wizard

• D. Import wizard

7. A circular reference is

• A. Geometric modeling tool

• B. A cell that points to a drawing object

• C. A formula that either directly or indirectly depends on itself

• D. Always erroneous

8. Which of following is Not one of Excel’s what-if function?

• A. Goal seek

• B. Solver

• C. Scenario manager

• D. Auto Outline

9. When you insert an excel file into a word document. The data are

• A. Hyperlinked placed in a word table

• B. Linked

• C. Embedded

• D. Use the word menu bar and toolbars

10. Which of the following is not information you can specify using the solver?

• A. Input cells

• B. Constraints

• C. Target cell

• D. Changing cells