| 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 |