# You can open the consolidate dialog box by choosing Consolidate from the ……. menu.

1.  Insert

2.  Format

3.  Tools

4.  Data

5.  None of these

5

Data

Explanation :
No Explanation available for this question

# Each excel file is called a workbook because:

1.  It can contain text and data

2.  It can be modified

3.  It can contain many sheets including worksheets and chart sheets

4.  You have to work hard to create it

5.  None of these

5

It can contain many sheets including worksheets and chart sheets

Explanation :
No Explanation available for this question

# Which types of charts can excel produce

1.  Line graphs and pie charts only

2.  Only line graphs

3.  Bar charts, line graphs and pie charts

4.  Bar charts and line graphs only

5.  None of these

5

Bar charts, line graphs and pie charts

Explanation :
No Explanation available for this question

# How are data organized in a spreadsheet

1.  Lines and spaces

2.  Layers and planes

3.  Rows and columns

4.  Height and width

5.  None of these

5

Rows and columns

Explanation :
No Explanation available for this question

# What does the VLOOKUP function do

1.  looks up text that contain ‘v’

2.  Checks whether text is the same in one cell as in the next

3.  Finds related records

4.  All of these

5.  None of these

5

Finds related records

Explanation :
No Explanation available for this question

# Gridlines:

1.  May be turned off for display but turned on for printing

2.  May be turned on or off for printing

3.  The be turned off for display and printing

4.  A, B and C

5.  None of these

5

A, B and C

Explanation :
No Explanation available for this question

# You can print only an embedded chart by

1.  Moving the chart to a chart sheet before you print.

2.  Formatting the chart before you print

3.  Selecting the chart before you print

4.  A and C

5.  None of these

5

A and C

Explanation :
No Explanation available for this question

# Which of the following is a correct order of precedence in a formula calculation

1.  Multiplication and division, exponential positive and negative value

2.  Multiplication and division, positive and negative values, addition and subtraction

3.  Addition and subtraction, positive and negative values, exponentiation

4.  All of these

5.  None of these

5

None of these

Explanation :
No Explanation available for this question

# A function inside another function is called a ……function.

1.  Nested

2.  Round

3.  Sum

4.  Text

5.  None of these

5

Nested

Explanation :
No Explanation available for this question

# How should you print a selected area of a worksheet, if you’ll want to print a different area next time

1.  On the file menu, point to print area, and then click set print area.

2.  On the file menu, click print, and then click selection under print what

4.  All of these

5.  None of these

5