Which of the following is not a valid Excel 2007 function for text manipulation?

Which Excel 2007 feature is used to create a formula that adjusts its cell references relative to the position of the formula in the worksheet?

Which of the following chart types in Excel 2007 is best suited for displaying trends over time?

Which of the following Excel 2007 features is used to analyse data by creating tables and charts based on it?

Which of the following options allows you to Freeze Panes in Excel 2007?

In Excel 2007, what is the keyboard shortcut to delete a selected row ?

In Excel 2007, what is the maximum number of rows in a worksheet ?

Which of the following functions can be used to find the highest value in a range of cells in Excel 2007 ?

Which of the following tabs contains the option to create charts in Excel 2007 ?

Filter in MS-Excel is used for

i. Calculating formulas

ii. Extracting data that meets the defined criteria

iii. Sorting data in ascending/descending order

iv. Analyzing and managing relevant data

Which of the following function in MS-Excel is used to count cells in a range that meets specific criteria ?

എക്സൽ 2010-ൽ കണക്കുകൂട്ടലുകൾ നടത്തുമ്പോൾ സെൽ റഫറൻസ് തെറ്റായി കൊടുക്കുന്നത് മൂലം കാണിക്കുന്ന സന്ദേശം എന്ത്?

കൂട്ടത്തിൽ ഒറ്റപ്പെട്ടത് :

Which function in MS EXCEL is used to count the number of cells that meet a criterion?

The symbol used to lock the cell reference, in MS - Excel is :

Excel displays the current cell address in the :

Which chart can be created in EXCEL?

In which function return the remainder after a number is divided by a divisor in EXCEL?

AND, OR, NOT and IF are ____ functions

NPER, PMT, PV etc are ____ functions

Here is where to go when you want to change the view in any way, including displaying or turning off grid lines and the formula bar, zooming in and out, Splitting and hiding pane

Protect sheet, protect workbook, tracking changes etc. are available in ____ group of review tab

___ tab lets you protect worksheets and workbooks, and share workbooks

___ tab is used to check spelling and grammar, use the thesaurus, track changes, review other people’s changes or compare documents.

____ command combine value from multiple ranges into one new range.

_____ is used to prevent invalid data from being entered into cell.

Shortcut key used to filter is

___ tab helps to import data from a wide variety of sources, the web, access, SQL server and so on

ABS, MAX, MIN etc are ____ functions.

Shortcut key used to auto sum is ____

To insert a function, shortcut key used is

SUM, Average, Square root etc. are ____ functions.

CHAR(), LEN() etc are ____ functions

A formula always starts with

____ are equations that perform calculations on values in your worksheet

____ command is used to flip the selected object

___ Is used to group objects together so that they can be treated like a single object

____ Is used to see a list of all your object. this helps to select individual objects and to change their order and visibility.

Command used to send the selected object back one level or to the back of all objects

Command used to bring the selected object in front of all other object

Cell references of last cell in excel 2007 is

____ makes numbers in columns or row easier to read or edit.

_____ Specify where a new page will begin in the printed copy

____ Are used to change the overall design of the entire document, including colors fonts and effects

____ Tab enables you to change margins page size and orientation define your print area set page breaks and specify which rows and columns will print on each page and so on.

____ Tool helps you to insert decorative text to your document

In office 2007 you can also create a text box by using the ___ feature on the home tab.

Keyboard shortcut to create a hyperlink is called

___ is used to create a link to a web page, a picture, a file, an e-mail address or another program

The axis identifying each data series is called