Dashboard Control panel | Completed Exam

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

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

 Formula:

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

is used to count_________

Filter option is ________ group

Following tools are _________________ Group.

How many tabs in Menu Bar

Last column name in MS Excel.

Which of the following identifies a cell in Excel?

Shortcut key for Save As

Identify the Tool Name

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

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

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

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

Which Command is used to close the window of Excel?

A formula is Excel always beings with an  _________

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

What are the basic rectangular building blocks of a spreadsheet?

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

What is extension of saved file in MS 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?

Shortcut keys for cell edit.