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

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

____ 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

____ 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

___ 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

The actual charted values, which are usually rows or columns of the source data is called

The horizontal axis of graph is often referred to as the

The vertical axis of graph is often referred to as the

The vertical and horizontal part of a chart is called

The chart key, which identifies what each color on the chart represents is

The title of the chart is Called

The range of cells that make up a chart is called

Change chart type, switch row/column data change chart layout, change chart style, move chart command are available in

____ Command will rotate the data displayed on the X&Y axes

Which of the following is only visible when the chart is selected

Scatter charts also known as

___ Charts compare pairs of values

____ Charts emphasize differences between several sets of data over a period of time.

____ Charts are the best chart type for comparing multiple values

____ charts are used to display the contribution of each item to the total

____ charts are used to show trends for categories or over a period of time such as days, months or years

____ Chart used to visually compare values across a few categories