Microsoft Excel

The basic units of a excel spreedsheet where we enter data is called?

The maximum number of rows supported by Excel 2007 spreadsheet is?

The maximum number of columns supported by Excel 2007 spreadsheet is?

A features that displays only the data in column (s) according to specified criteria

In Excel, Rows are labelled as ______

How will you graphically represent expenditure in different departments ?

What type of chart is good for single series of data ?

The basic unit of a worksheet into which you enter data in Excel is called a

What is the intersection of a column and a row on a worksheet called ?

What type of chart is useful for comparing values over categories ?

Which function in Excel tells how many numeric entries are there ?

A features that displays only the data in column (s) according to specified criteria

In Excel, which one denoted a range from B1 through E5

what is the extension of excel file?

An Excel file is generally called a / an :

It is a collection of data that is stored electronically as a series of records in a table.

What is the symbol for multiplying?

Which is an example of a function?

Which is an example of a formula?

How do you tell one cell from another?

You accidentally erased a record in the sheet. What command can be used to restore it immediately?

Which menu option can be used to split windows into two?

Concatenation of text can be done using

“Data Table” option is found under ___________

The first cell in EXCEL worksheet is labeled as

Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?

The active cell:

In Excel, a Data Series is defined as what?

Formulas in Excel start with

The cell reference for cell range of N7 to R7 is _______

What is the keyboard shortcut for creating a chart from the selected cell range?

A function inside another function is called _______

Which of the following format you can decide to apply or not in Auto Format dialog box?

How can you remove borders applied in cells?

When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply

Excel uniquely identifies cells within a worksheet with a cell name

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

MS-EXCEL can be used to automate

In order to arrange the countries from those with the highest population to those with the lowest, you need to sort on the population field in ……………

In order to perform a calculation in a spreadsheet, you need to use a:

Where a row and a column meet, what do you call that?

Give me an example of a cell address.

In MS-Excel what does SUMIF function do?

In MS-Excel which of the following is an absolute cell reference?

MS-Excel uses the _______ Function when creating a data table

The Software which contains rows and columns is called ______

You can activate a cell by

Which keys are used to Open tab in Ms Excel?

Which key is used to “Goto” tab in Ms Excel?

Which key is used to edit in Ms Excel?