Dashboard Control panel | Completed Exam

Sr Student Name
Semester
Branch Subject Question User Answer Right Answer
1 Monu
Semester 1
MGI-456 Advance Excel

How many tabs in Menu Bar

7 7
2 Monu
Semester 1
MGI-456 Advance Excel

Number of columns in MS Excel 2007

16384 16384
3 Monu
Semester 1
MGI-456 Advance Excel

Number of rows in MS Excel 2007

1048576 1048576
4 Monu
Semester 1
MGI-456 Advance Excel

Last column name in MS Excel.

FDX XFD
5 Monu
Semester 1
MGI-456 Advance Excel

What is extension of saved file in MS Excel?

.xls .xls
6 Monu
Semester 1
MGI-456 Advance Excel

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

Range Range
7 Monu
Semester 1
MGI-456 Advance Excel

Shortcut keys for cell edit.

F2 F2
8 Monu
Semester 1
MGI-456 Advance Excel

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

Formula bar Formula bar
9 Monu
Semester 1
MGI-456 Advance Excel

What are the basic rectangular building blocks of a spreadsheet?

Cells Cells
10 Monu
Semester 1
MGI-456 Advance Excel

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

Browser Browser
11 Monu
Semester 1
MGI-456 Advance Excel

Excel is a program that is used to prepare.

Spreadsheet Spreadsheet
12 Monu
Semester 1
MGI-456 Advance Excel

Which of the following identifies a cell in Excel?

Address Address
13 Monu
Semester 1
MGI-456 Advance Excel

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

Home Home
14 Monu
Semester 1
MGI-456 Advance Excel

Following tools are _________________ Group.

 

Editing Style
15 Monu
Semester 1
MGI-456 Advance Excel

Which Command is used to close the window of Excel?

Alt + F4 Alt + F4
16 Monu
Semester 1
MGI-456 Advance Excel

If function is used for _____

Apply condition Apply condition
17 Monu
Semester 1
MGI-456 Advance Excel

What are the basic rectangular builduing blocks of a spreadsheet?

Cells Cells
18 Monu
Semester 1
MGI-456 Advance Excel

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

Text to column Text to column
19 Monu
Semester 1
MGI-456 Advance Excel

Identify the Tool Name

Sort & Filter Sort & Filter
20 Monu
Semester 1
MGI-456 Advance Excel

Shortcut key for Save As

F12 F12
21 Monu
Semester 1
MGI-456 Advance Excel

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

Trim Trim
22 Monu
Semester 1
MGI-456 Advance Excel

Identify the Following Tool Name?

Merge Merge
23 Monu
Semester 1
MGI-456 Advance Excel

identify the Following group name?

 

Number Number
24 Monu
Semester 1
MGI-456 Advance Excel

Transpose option is used for converting data

Both A & B Both A & B
25 Monu
Semester 1
MGI-456 Advance Excel

Vlookup formula is used to find data

Vertical Vertical
26 Monu
Semester 1
MGI-456 Advance Excel

Filter option is ________ group

Editing Editing
27 Monu
Semester 1
MGI-456 Advance Excel

Hlookup formula is used to find data.

Horizontal Horizontal
28 Monu
Semester 1
MGI-456 Advance Excel

Which short cut key is used to make selection lock.

F4 F4
29 Monu
Semester 1
MGI-456 Advance Excel

To insert current date

Both A & B Ctrl + ;
30 Monu
Semester 1
MGI-456 Advance Excel

To insert current date and time

=Today() =now()
31 Monu
Semester 1
MGI-456 Advance Excel

Counta formula is used for

Both A & B Both A & B
32 Monu
Semester 1
MGI-456 Advance Excel

 Formula:

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

is used to count_________

All of these Words
33 Monu
Semester 1
MGI-456 Advance Excel

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

Concatenate Concatenate
34 Monu
Semester 1
MGI-456 Advance Excel

A formula is Excel always beings with an  _________

Equal sign Equal sign
35 Monu
Semester 1
MGI-456 Advance Excel

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

Merge Merge