Sr | Student Name Semester |
Branch | Subject | Question | User Answer | Right Answer |
---|---|---|---|---|---|---|
1 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | ....................................... to splite the unoragnised data into organised format |
Text to column | Text to column |
2 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | If function is used for .............................................. |
Apply conditions | Apply conditions |
3 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Counta formula is used for .................................................... |
Both (A) and (B) | Both (A) and (B) |
4 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Number of Rows in Ms Excel |
1048576 | 1048576 |
5 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Last Column name in Ms Excel |
XFD | XFD |
6 | Sagar Chauhan 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. |
Range | Range |
7 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Types of scripts |
Both (A) and (B) | Both (A) and (B) |
8 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | VGA cable available in which three color
|
Above All three Color | Above All three Color |
9 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Concatenate formula is used for ........................................ |
Combine two different words written in different - 2 cells | Combine two different words written in different - 2 cells |
10 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | How to find the current date |
=today() | =today() |
11 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Shortcut key used for Slide Show in Powerpoint presentation. | F5 | F5 |
12 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Excel is a program that is used to prepare a ................................ |
Spreadsheet | Spreadsheet |
13 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Shortcut key of superscripts |
Ctrl +shift+"+" | Ctrl +shift+"+" |
14 | Sagar Chauhan 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 |
15 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | How many Groups in Insert Tab |
7 | 7 |
16 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Filter option is availabe in ......................... group |
Editing | Editing |
17 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | A Formula in excel always begins with an ......................................... |
Equal Sign | Equal Sign |
18 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Which term is used to join the selected cell in to one cell? |
Merge | Merge |
19 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Which of the following identifies a cell in Excel |
Address | Address |
20 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Excel is a program that is used to prepare .................................. |
Spreadsheet | Spreadsheet |
21 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | which of the following term is not a term pretaining to spreadsheets? |
Browser | Browser |
22 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | ......................... appear at the bottom of tool bar in Ms Excel |
Formula Bar | Formula Bar |
23 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Smallest Fobt size in font box |
8 | 8 |
24 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | CPU stand for ............................................... |
Central Processing Unit. | Central Processing Unit. |
25 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Which of the following is not an input device?
|
None | Speaker |
26 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Collection of Rows and columns is called ............................... |
Table | Table |
27 | Sagar Chauhan 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 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Identify the given formula =pmt(Annual Rate /12,Duration,Loan Amount ) |
Monthly EMI | Monthly EMI |
29 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Save As shortcut command |
Ctrl +S | F12 |
30 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Tool Bar consist of.................... . |
Groups | Groups |
31 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Which short cut key is used to make selection lock. |
F4 | F4 |
32 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | In which tab these are present “Table, Header & Footer, WordArt and chart”? |
Insert tab | Insert tab |
33 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Identify the Following formula =rept("|",num)
|
Mini Chart | Mini Chart |
34 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | How to find the current date and time in MS Excel? |
=now() | =today() |
35 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Identify the following :- .png, .jpg, .txt, .rtf, .docx, .ppt |
Extensions | Extensions |
36 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Which tab is available in Wordpad Application |
view | view |
37 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Hlookup formula is used to find valuse in ............................... form |
Horizontal | Horizontal |
38 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | By Default No. of sheet in Ms Excel |
3 | 3 |
39 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Hlookup formula is used to find data |
Horizontal | Horizontal |
40 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | To remove the all changes from the selected text is knows as ____________________ |
Clear Formatting | Clear Formatting |
41 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | What are the basic rectangular building blocks of a spreadsheet? | Cells | Cells |
42 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Shortcut key for New Page in current documentation |
Ctrl +Enter | Ctrl +Enter |
43 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Use of Format Painter |
Used to apply same format on selected text | Used to apply same format on selected text |
44 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | What is the formula for inserting the Random numbers in excel
|
=Randbetween (Bottom,Top) | =Randbetween (Bottom,Top) |
45 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Ctrl + Enter is shortcut key for ............................... |
New Page | New Page |
46 | Sagar Chauhan 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 |
47 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Types of selection in Mspaint |
Rectangular Selection | Both (A) and (B) |
48 | Sagar Chauhan Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | RTF Full Form |
Rich Text Format | Rich Text Format |