| Sr | Student Name Semester |
Branch | Subject | Question | User Answer | Right Answer |
|---|---|---|---|---|---|---|
| 1 | Simarjeet Kaur Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Shortcut key of superscripts |
Ctrl +shift+"+" | Ctrl +shift+"+" |
| 2 | Simarjeet Kaur Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Identify the Following formula =rept("|",num)
|
Mini Chart | Mini Chart |
| 3 | Simarjeet Kaur Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Use of Format Painter |
Used to apply same format on selected text | Used to apply shading on text |
| 4 | Simarjeet Kaur Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Excel is a program that is used to prepare a ................................ |
Text Documentation | Text Documentation |
| 5 | Simarjeet Kaur Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Hlookup formula is used to find data |
Horizontal | Horizontal |
| 6 | Simarjeet Kaur Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Identify the given formula =pmt(Annual Rate /12,Duration,Loan Amount ) |
Commission | Interest |
| 7 | Simarjeet Kaur Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Which of the following is not an input device?
|
None | Keyboard |
| 8 | Simarjeet Kaur Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Collection of Rows and columns is called ............................... |
Row | Cell |
| 9 | Simarjeet Kaur 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 |
| 10 | Simarjeet Kaur Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | |||
| 11 | Simarjeet Kaur Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | |||
| 12 | Simarjeet Kaur Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Save As shortcut command |
Ctrl+Space | F12 |
| 13 | Simarjeet Kaur Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | VGA cable available in which three color
|
Black | White |
| 14 | Simarjeet Kaur Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Tool Bar consist of.................... . |
Groups | Tabs |
| 15 | Simarjeet Kaur Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | In which tab these are present “Table, Header & Footer, WordArt and chart”? |
Home tab | Insert tab |
| 16 | Simarjeet Kaur Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Which short cut key is used to make selection lock. |
F4 | F4 |
| 17 | Simarjeet Kaur Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Concatenate formula is used for ........................................ |
remove extra space | upper |
| 18 | Simarjeet Kaur Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | How to find the current date |
=now() | =now() |
| 19 | Simarjeet Kaur Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Identify the following :- .png, .jpg, .txt, .rtf, .docx, .ppt |
Devices | Devices |
| 20 | Simarjeet Kaur Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | How to find the current date and time in MS Excel? |
=now() | =now() |
| 21 | Simarjeet Kaur Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Which tab is available in Wordpad Application |
view | Insert |
| 22 | Simarjeet Kaur Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Hlookup formula is used to find valuse in ............................... form |
Both (a) and (b) | Verticle |
| 23 | Simarjeet Kaur Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | By Default No. of sheet in Ms Excel |
2 | 3 |
| 24 | Simarjeet Kaur Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Shortcut key used for Slide Show in Powerpoint presentation. | F2 | F5 |
| 25 | Simarjeet Kaur Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | To remove the all changes from the selected text is knows as ____________________ |
Clear Formatting | Clear Formatting |
| 26 | Simarjeet Kaur Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | What are the basic rectangular building blocks of a spreadsheet? | Cells | Cells |
| 27 | Simarjeet Kaur Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Shortcut key for New Page in current documentation |
Ctrl +M | Ctrl +M |
| 28 | Simarjeet Kaur Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | ILLUSTRATION group contains ________, _________, _________, ________, ________. | Picture, chart, shapes, equation, smart art | Picture, clip art, shapes, smart art, chart |
| 29 | Simarjeet Kaur Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | What is the formula for inserting the Random numbers in excel
|
=Rand () | =Random () |
| 30 | Simarjeet Kaur Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | How many Groups in Insert Tab |
8 | 7 |
| 31 | Simarjeet Kaur Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Ctrl + Enter is shortcut key for ............................... |
New Slide | New Sheet |
| 32 | Simarjeet Kaur Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Use of Clear Formatting |
None of These | To Remove all Change made in document |
| 33 | Simarjeet Kaur Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Types of selection in Mspaint |
Rectangular Selection | None of these |
| 34 | Simarjeet Kaur Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | RTF Full Form |
Right to Formation | Rich Text Format |
| 35 | Simarjeet Kaur Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | How many Alignment are there? |
4 | 4 |
