| Sr | Student Name Semester |
Branch | Subject | Question | User Answer | Right Answer |
|---|---|---|---|---|---|---|
| 1 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Hlookup formula is used to find data |
vertical | Horizontal |
| 2 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Tool Bar consist of.................... . |
Groups | Tabs |
| 3 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | CPU stand for ............................................... |
Central Processing Unit. | Central Processing Unit. |
| 4 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Which of the following is not an input device?
|
Mouse | None |
| 5 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Collection of Rows and columns is called ............................... |
Column | Cell |
| 6 | Jyoti 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 |
Output | Output |
| 7 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | |||
| 8 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | |||
| 9 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Identify the given formula =pmt(Annual Rate /12,Duration,Loan Amount ) |
Principal Amount | Commission |
| 10 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Save As shortcut command |
Ctrl +S | Ctrl+Space |
| 11 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | VGA cable available in which three color
|
Above All three Color | Black |
| 12 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Identify the Following formula =rept("|",num)
|
Age | Mini Chart |
| 13 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Which short cut key is used to make selection lock. |
F3 | F3 |
| 14 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | In which tab these are present “Table, Header & Footer, WordArt and chart”? |
View tab | Insert tab |
| 15 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Concatenate formula is used for ........................................ |
remove extra space | upper |
| 16 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | How to find the current date |
=now() | =now() |
| 17 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | How to find the current date and time in MS Excel? |
=current date() | =now() |
| 18 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Identify the following :- .png, .jpg, .txt, .rtf, .docx, .ppt |
Extensions | Devices |
| 19 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Which tab is available in Wordpad Application |
Insert | Insert |
| 20 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Hlookup formula is used to find valuse in ............................... form |
None | Verticle |
| 21 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | By Default No. of sheet in Ms Excel |
3 | 3 |
| 22 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Shortcut key used for Slide Show in Powerpoint presentation. | F4 | F5 |
| 23 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | To remove the all changes from the selected text is knows as ____________________ |
Format painter | Format painter |
| 24 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Excel is a program that is used to prepare a ................................ |
Text Documentation | Text Documentation |
| 25 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Which shortcut keys is used for Cell Edit in MS Excel |
Ctrl+F4 | Ctrl +T |
| 26 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | What are the basic rectangular building blocks of a spreadsheet? | Cells | Cells |
| 27 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Shortcut key of superscripts |
Ctrl +shift+; | Ctrl +shift+"+" |
| 28 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Shortcut key for New Page in current documentation |
Ctrl +M | Ctrl +M |
| 29 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | ILLUSTRATION group contains ________, _________, _________, ________, ________. | Picture, clip art, shapes, smart art, chart | Picture, clip art, shapes, smart art, chart |
| 30 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Use of Format Painter |
Used to apply shading on text | Used to apply shading on text |
| 31 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | What is the formula for inserting the Random numbers in excel
|
=Rand () | =Rand () |
| 32 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Ctrl + Enter is shortcut key for ............................... |
New Page | New Document |
| 33 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | How many Groups in Insert Tab |
7 | 7 |
| 34 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Use of Clear Formatting |
To Remove all Change made in document | To Remove all Change made in document |
| 35 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Types of selection in Mspaint |
None of these | None of these |
| 36 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | How many Alignment are there? |
2 | 4 |
| 37 | Jyoti Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | RTF Full Form |
Rich Text Format | Rich Text Format |
| 38 | Jyoti Semester 2 |
MGI 456 | Diploma in Computer Application (DCA) | The Feature of Interest Calculation is the feature of | Inventory | Accounting |
| 39 | Jyoti Semester 2 |
MGI 456 | Diploma in Computer Application (DCA) | Which of these is a search engine? | ||
| 40 | Jyoti Semester 2 |
MGI 456 | Diploma in Computer Application (DCA) | Special keys labelled F1 to F12 is called | Function key | Function key |
| 41 | Jyoti Semester 2 |
MGI 456 | Diploma in Computer Application (DCA) | Which of the following keys help to type character in upper case | Caps lock | Both of the above |
| 42 | Jyoti Semester 2 |
MGI 456 | Diploma in Computer Application (DCA) | ............... arrow keys available on keyboard. | 4 | 4 |
| 43 | Jyoti Semester 2 |
MGI 456 | Diploma in Computer Application (DCA) | ............... key deletes the character just to left the cursor. | Backspace | Backspace |
| 44 | Jyoti Semester 2 |
MGI 456 | Diploma in Computer Application (DCA) | Numeric keypad can be locked or unlocked by | Num lock | Num lock |
| 45 | Jyoti Semester 2 |
MGI 456 | Diploma in Computer Application (DCA) | Which of the following is an input device. | Mouse | All of the above |
| 46 | Jyoti Semester 2 |
MGI 456 | Diploma in Computer Application (DCA) | Touch typing can be done with ......... hand. | Both of the above | Both of the above |
| 47 | Jyoti Semester 2 |
MGI 456 | Diploma in Computer Application (DCA) | Which method of typewriting is a method of typing without using the sense of sight to find the keys | Touch method | Touch method |
| 48 | Jyoti Semester 2 |
MGI 456 | Diploma in Computer Application (DCA) | The "desktop" of a computer refers to | The visible screen | The visible screen |
| 49 | Jyoti Semester 2 |
MGI 456 | Diploma in Computer Application (DCA) | Short Cut key is used to open Payroll Voucher: | Alt F4 | Ctrl F4 |
| 50 | Jyoti Semester 2 |
MGI 456 | Diploma in Computer Application (DCA) | Computers calculate numbers in what mode? | Binary | Binary |
| 51 | Jyoti Semester 2 |
MGI 456 | Diploma in Computer Application (DCA) | How many bits is a byte? | 8 | 8 |
| 52 | Jyoti Semester 2 |
MGI 456 | Diploma in Computer Application (DCA) | To activate Purchase Order/Sales Order press: | F11 | F10 |
| 53 | Jyoti Semester 2 |
MGI 456 | Diploma in Computer Application (DCA) | Drawing Account Treated as: | Capital Account | Capital Account |
| 54 | Jyoti Semester 2 |
MGI 456 | Diploma in Computer Application (DCA) | Wages treated as: | Direct Expense | Direct Expense |
| 55 | Jyoti Semester 2 |
MGI 456 | Diploma in Computer Application (DCA) | How to Delete any Master in Tally | By pressing Alt D | By pressing Alt D |
| 56 | Jyoti Semester 2 |
MGI 456 | Diploma in Computer Application (DCA) | Wpm stands for | Word per minute | Word per minute |
| 57 | Jyoti Semester 2 |
MGI 456 | Diploma in Computer Application (DCA) | Which finger is used to strike the slash? | Right Pinky | Right Pinky |
| 58 | Jyoti Semester 2 |
MGI 456 | Diploma in Computer Application (DCA) | The ;-finger is also known as; | Right Pinky | Right Pinky |
| 59 | Jyoti Semester 2 |
MGI 456 | Diploma in Computer Application (DCA) | The K-finger is also your; | Right middle | Right middle |
| 60 | Jyoti Semester 2 |
MGI 456 | Diploma in Computer Application (DCA) | Which finger is used to strike the I? | K-finger | K-finger |
| 61 | Jyoti Semester 2 |
MGI 456 | Diploma in Computer Application (DCA) | Which finger is used to strike the apostrophe? | Right Pinky | Right Pinky |
| 62 | Jyoti Semester 2 |
MGI 456 | Diploma in Computer Application (DCA) | What is the character between the t and s in “It’s”? |
apostrophe | apostrophe |
| 63 | Jyoti Semester 2 |
MGI 456 | Diploma in Computer Application (DCA) | Which finger is used to strike the comma? | Right Middle | Right Middle |
| 64 | Jyoti Semester 2 |
MGI 456 | Diploma in Computer Application (DCA) | Which finger is used to strike the P? | ;-finger | ;-finger |
| 65 | Jyoti Semester 2 |
MGI 456 | Diploma in Computer Application (DCA) | “Debit All Expenses, Credit All Income” is the golden rule based on | Nominal Account | Nominal Account |
| 66 | Jyoti Semester 2 |
MGI 456 | Diploma in Computer Application (DCA) | In Voucher Screen How to change the “Dr/ Cr” feature to “To and By” | By Pressing F11 | By Pressing F12 |
| 67 | Jyoti Semester 2 |
MGI 456 | Diploma in Computer Application (DCA) | 7.To activate the feature of Bills of Material:- | i)F11 | iii)F12 |
| 68 | Jyoti Semester 2 |
MGI 456 | Diploma in Computer Application (DCA) | Liabilities are the ......................... of the business:- | Negative Balance | Negative Balance |
| 69 | Jyoti Semester 2 |
MGI 456 | Diploma in Computer Application (DCA) | Assets are called:- | Real Account | Real Account |
| 70 | Jyoti Semester 2 |
MGI 456 | Diploma in Computer Application (DCA) | Short cut Key to Create any master:- | Alt C | Alt C |
| 71 | Jyoti Semester 2 |
MGI 456 | Diploma in Computer Application (DCA) | Short cut Key to change the financial year or current period:- | Alt F2 | Alt F2 |
| 72 | Jyoti Semester 2 |
MGI 456 | Diploma in Computer Application (DCA) | Tally is an ...................... software | Accounting | Accounting |
