MS OFFICE EXCEL-II

Presenting data in a form of graph, we use

How does a reference to a range appear in the Consolidate dialog box?

A function inside another function is known as ?

The cell reference for cell range of G2 to M12 is _______

One can find “Merge & Center” option under

Getting data from a cell located in a different sheet is called …

Predict the output of the follwing function: power(5,2)

MAX Function is used for

Vlookup operation present in

Which of the following formulas will Excel Not be able to calculate?

To protect a worksheet, you can choose Protection and the Protect Sheet from the_______tab

How can you remove borders applied in cells?

You can check the conditions against __________ when applying conditional formatting

In Microsoft Office 2007 version, an Excel sheet contain _________ no of rows

How do you rearrange the data in ascending or descending order?

You can create hyperlinks from the Excel workbook to

You can use the horizontal and vertical scroll bars to

The concatenate(), combine

By Formatting a cell in Currency format, you can specify ?

Excel uniquely identifies cells within a worksheet with a cell name

Red triangle at the top right corner of a cell indicates

$A$2 is an example of :

Excel is a

Which of the following formulas will Excel Not be able to calculate?

Which of the following is not the correct method of editing the cell content?

Getting data from a cell located in a different sheet is called …

A quick way to return to a specific area of a worksheet is to type in the _____

What is the shortcut key to hide entire row?

Which of the following is correct?

Excel probably considers the cell entry January 1, 2000 to be a

To select all of the boxes of an organization chart