| Sr | Student Name Semester |
Branch | Subject | Question | User Answer | Right Answer |
|---|---|---|---|---|---|---|
| 1 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Identidy the Following tool |
Word Art | Shadow |
| 2 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Identify Following Tool Name |
New slide | Layout |
| 3 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Identify the following tools name |
Wrap Text | Wrap Text |
| 4 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Identify the following Group Name |
Table | Illustrations |
| 5 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Identify the Following
|
Highlighter | Shading |
| 6 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Clear Formatting Shortcut command |
Ctrl + Shift + Space | Ctrl + Space |
| 7 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | shortcut key to rename file/ Folder |
F4 | F2 |
| 8 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Path of Saving File in a particular program is known as ........................ |
Programm | Extension |
| 9 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | ....................................... to splite the unoragnised data into organised format |
Text to column | Text to column |
| 10 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | If function is used for .............................................. |
Apply conditional Formatting | Apply conditions |
| 11 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Filter option is availabe in ......................... group |
Alignemtn | Editing |
| 12 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Counta formula is used for .................................................... |
count alphabetic values | Both (A) and (B) |
| 13 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Number of Rows in Ms Excel |
1048578 | 1048576 |
| 14 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Last Column name in Ms Excel |
DFX | XFD |
| 15 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | A (n) ......................... is a series of two or more adjacent cell in a column or row and rectangular group of cells. |
Section | Range |
| 16 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | A Formula in excel always begins with an ......................................... |
Colon | Equal Sign |
| 17 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Which term is used to join the selected cell in to one cell? |
Wrap | Merge |
| 18 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Which of the following identifies a cell in Excel |
Label | Address |
| 19 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Excel is a program that is used to prepare .................................. |
Text Document | Spreadsheet |
| 20 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | which of the following term is not a term pretaining to spreadsheets? |
Formula | Browser |
| 21 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | ......................... appear at the bottom of tool bar in Ms Excel |
Worksheet Tab | Formula Bar |
| 22 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Types of scripts |
Only (A) | Both (A) and (B) |
| 23 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Smallest Fobt size in font box |
7 | 8 |
| 24 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | CPU stand for ............................................... |
Central Programing Unit | Central Processing Unit. |
| 25 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Which of the following is not an input device?
|
Mouse | Speaker |
| 26 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Collection of Rows and columns is called ............................... |
Table | Table |
| 27 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | A device that allows users to feed data into a computer for analysis and storage and to give commands to the computer is called |
Input | Input |
| 28 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Identify the given formula =pmt(Annual Rate /12,Duration,Loan Amount ) |
Monthly EMI | Monthly EMI |
| 29 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Save As shortcut command |
Ctrl +S | F12 |
| 30 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | VGA cable available in which three color
|
Above All three Color | Above All three Color |
| 31 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Tool Bar consist of.................... . |
Both A and B | Groups |
| 32 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Which short cut key is used to make selection lock. |
F5 | F4 |
| 33 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | In which tab these are present “Table, Header & Footer, WordArt and chart”? |
Insert tab | Insert tab |
| 34 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Concatenate formula is used for ........................................ |
upper | Combine two different words written in different - 2 cells |
| 35 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Identify the Following formula =rept("|",num)
|
Mini Chart | Mini Chart |
| 36 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | How to find the current date |
=today() | =today() |
| 37 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | How to find the current date and time in MS Excel? |
=date and time() | =today() |
| 38 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Identify the following :- .png, .jpg, .txt, .rtf, .docx, .ppt |
program | Extensions |
| 39 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Which tab is available in Wordpad Application |
Insert | view |
| 40 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Hlookup formula is used to find valuse in ............................... form |
Both (a) and (b) | Horizontal |
| 41 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | By Default No. of sheet in Ms Excel |
5 | 3 |
| 42 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Shortcut key used for Slide Show in Powerpoint presentation. | F4 | F5 |
| 43 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Hlookup formula is used to find data |
None of these | Horizontal |
| 44 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | To remove the all changes from the selected text is knows as ____________________ |
Format painter | Clear Formatting |
| 45 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Excel is a program that is used to prepare a ................................ |
Text Documentation | Spreadsheet |
| 46 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | What are the basic rectangular building blocks of a spreadsheet? | Help button | Cells |
| 47 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Shortcut key for New Page in current documentation |
Ctrl +Alt + Enter | Ctrl +Enter |
| 48 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Shortcut key of superscripts |
Ctrl +shift+"+" | Ctrl +shift+"+" |
| 49 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | ILLUSTRATION group contains ________, _________, _________, ________, ________. | Picture, chart, shapes, equation, smart art | Picture, clip art, shapes, smart art, chart |
| 50 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | What is the formula for inserting the Random numbers in excel
|
All of these | =Randbetween (Bottom,Top) |
| 51 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | How many Groups in Insert Tab |
8 | 7 |
| 52 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Ctrl + Enter is shortcut key for ............................... |
New Slide | New Page |
| 53 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Use of Clear Formatting |
None of These | To Remove all Change made in document |
| 54 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Types of selection in Mspaint |
Both (A) and (B) | Both (A) and (B) |
| 55 | Komal Khan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | RTF Full Form |
Right to Formation | Rich Text Format |
