Dashboard Control panel | Completed Exam

Shortcut key for Save As

Following tools are _________________ Group.

Identify the Tool Name

How many tabs in Menu Bar

---------------------------- function is used to remove the extra space between two words.

---------------------- function is used to convert unorganised data in organised way.

Identify the Following Tool Name?

identify the Following group name?

What are the basic rectangular builduing blocks of a spreadsheet?

If function is used for _____

Transpose option is used for converting data

Vlookup formula is used to find data

Filter option is ________ group

Hlookup formula is used to find data.

Which short cut key is used to make selection lock.

To insert current date

To insert current date and time

Counta formula is used for

 Formula:

=Len(B2)-Len(substitute(B2,” “,””))+1

is used to count_________

Which formula is used to combine to different words in next cell.

Number of columns in MS Excel 2007

Number of rows in MS Excel 2007

Last column name in MS Excel.

Which Command is used to close the window of Excel?

What is extension of saved file in MS Excel?

A (n)______ is a Series of two or more adjacent cell in a column or row or rectangular group of cells.

A formula is Excel always beings with an  _________

Which terms is used to join the selected cell in to one cell?

Which of the following identifies a cell in Excel?

In which tab wrap text feature is present in MS Excel 2007?

Excel is a program that is used to prepare.

Which of the following is not a term pertaining to spreadsheets?

What are the basic rectangular building blocks of a spreadsheet?

_______ appear at the bottom of tool bar in MS Excel.

Shortcut keys for cell edit.