Sr | Student Name Semester |
Branch | Subject | Question | User Answer | Right Answer |
---|---|---|---|---|---|---|
1 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Identidy the Following tool |
Word Art | Shadow |
2 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Identify Following Tool Name |
Wrap text | Layout |
3 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Identify the following tools name |
Line spacing | Wrap Text |
4 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Identify the following Group Name |
Header Footer | Illustrations |
5 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Identify the Following
|
Highlighter | Shading |
6 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Clear Formatting Shortcut command |
Ctrl + Backspace | Ctrl + Space |
7 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | shortcut key to rename file/ Folder |
F2 | F2 |
8 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Path of Saving File in a particular program is known as ........................ |
Programm | Extension |
9 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | ....................................... to splite the unoragnised data into organised format |
Text to column | Text to column |
10 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | If function is used for .............................................. |
Apply conditional Formatting | Apply conditions |
11 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Filter option is availabe in ......................... group |
Editing | Editing |
12 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Counta formula is used for .................................................... |
Both (A) and (B) | Both (A) and (B) |
13 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Number of Rows in Ms Excel |
1048578 | 1048576 |
14 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Last Column name in Ms Excel |
FDX | XFD |
15 | Charu 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. |
Area | Range |
16 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | A Formula in excel always begins with an ......................................... |
Space | Equal Sign |
17 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Which term is used to join the selected cell in to one cell? |
Pivot | Merge |
18 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Which of the following identifies a cell in Excel |
Label | Address |
19 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Excel is a program that is used to prepare .................................. |
Spreadsheet | Spreadsheet |
20 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | which of the following term is not a term pretaining to spreadsheets? |
Browser | Browser |
21 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | ......................... appear at the bottom of tool bar in Ms Excel |
Formula Bar | Formula Bar |
22 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Types of scripts |
Only (A) | Both (A) and (B) |
23 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Smallest Fobt size in font box |
8 | 8 |
24 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | CPU stand for ............................................... |
Central Programing Unit | Central Processing Unit. |
25 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Which of the following is not an input device?
|
Mouse | Speaker |
26 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Collection of Rows and columns is called ............................... |
Table | Table |
27 | Charu 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 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Identify the given formula =pmt(Annual Rate /12,Duration,Loan Amount ) |
Principal Amount | Monthly EMI |
29 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Save As shortcut command |
Ctrl +S | F12 |
30 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | VGA cable available in which three color
|
Above All three Color | Above All three Color |
31 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Tool Bar consist of.................... . |
Both A and B | Groups |
32 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Which short cut key is used to make selection lock. |
F5 | F4 |
33 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | In which tab these are present “Table, Header & Footer, WordArt and chart”? |
Home tab | Insert tab |
34 | Charu 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 |
35 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Identify the Following formula =rept("|",num)
|
Bullets | Mini Chart |
36 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | How to find the current date |
Ctrl+Shift+: | =today() |
37 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | How to find the current date and time in MS Excel? |
=current date() | =today() |
38 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Identify the following :- .png, .jpg, .txt, .rtf, .docx, .ppt |
Devices | Extensions |
39 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Which tab is available in Wordpad Application |
Insert | view |
40 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Hlookup formula is used to find valuse in ............................... form |
Horizontal | Horizontal |
41 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | By Default No. of sheet in Ms Excel |
2 | 3 |
42 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Shortcut key used for Slide Show in Powerpoint presentation. | F2 | F5 |
43 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Hlookup formula is used to find data |
vertical | Horizontal |
44 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | To remove the all changes from the selected text is knows as ____________________ |
Clear Formatting | Clear Formatting |
45 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Excel is a program that is used to prepare a ................................ |
Spreadsheet | Spreadsheet |
46 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | What are the basic rectangular building blocks of a spreadsheet? | Cells | Cells |
47 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Shortcut key for New Page in current documentation |
Ctrl +Enter | Ctrl +Enter |
48 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Shortcut key of superscripts |
Ctrl +shift+"+" | Ctrl +shift+"+" |
49 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | ILLUSTRATION group contains ________, _________, _________, ________, ________. | Picture, clip art, symbols, shapes, chart | Picture, clip art, shapes, smart art, chart |
50 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Use of Format Painter |
Both (A) and (B) | Used to apply same format on selected text |
51 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | What is the formula for inserting the Random numbers in excel
|
=Random () | =Randbetween (Bottom,Top) |
52 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | How many Groups in Insert Tab |
6 | 7 |
53 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Ctrl + Enter is shortcut key for ............................... |
New Sheet | New Page |
54 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Use of Clear Formatting |
To remove all italic changes in Document | To Remove all Change made in document |
55 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Types of selection in Mspaint |
Both (A) and (B) | Both (A) and (B) |
56 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | RTF Full Form |
Random Text Formation | Rich Text Format |
57 | Charu Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | How many Alignment are there? |
2 | 4 |
58 | Charu Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | To activate Purchase Order/Sales Order press: | F12 | F10 |
59 | Charu Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | How to Delete any Master | By pressing Alt D | By pressing Alt D |
60 | Charu Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Wages treated as: | Commission | Direct Expense |
61 | Charu Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Short Cut key is used to open Payroll Voucher: |
Ctrl + F5 | Ctrl+ F4 |
62 | Charu Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Drawing Account Treated as: | Capital Account | Capital Account |
63 | Charu Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | The Feature of Interest | Company Feature | Accounting |
64 | Charu Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | In Tally ERP9 to create company press: | Alt F3 | Alt F3 |
65 | Charu Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Which key is used to activate the calculator? | Ctrl N | Ctrl N |
66 | Charu Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Salary due but not paid is called: | Not Paid Salary | Outstanding Salary |
67 | Charu Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Return Outward stands for: | Sales Return | Purchase Return |
68 | Charu Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Stock Journal is used to: | To transfer the stock one godown to other | To transfer the stock one godown to other |
69 | Charu Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Key to Open Stock Journal | Alt F7 | Alt F7 |
70 | Charu Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Tds Stands for: | Tax Deductive at Source | Tax Deducted at Source |
71 | Charu Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | To Open Receipt Voucher Press: | f6 | f6 |
72 | Charu Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | The amount which is withdraw by the owner is called: | Capita Income | Drawing |
73 | Charu Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | The amount which is credited by the bank called Bank Interest treated as: | Indirect Income | Indirect Income |
74 | Charu Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | At Accounting / Inventory Voucher creation and alteration screen To select the Debit Note Voucher Type. | Alt F10 | Alt F5 |
75 | Charu Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | At gateway of Tally Screen to select the company info menu | F3 | F3 |
76 | Charu Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | At all reports screens in TALLY to export the report in ASCII, SDF, HTML or XML format | Alt R | Alt E |
77 | Charu Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Which key is used to go in the Contra Voucher? | F4 | F4 |
78 | Charu Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | At accounting/Inventory Voucher creation and alteration screen which key to select the Journal Voucher | F7 | F7 |
79 | Charu Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Which option is used to make change in the Ledger? | Alter | Alter |
80 | Charu Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | What is the currency of India? | Rupees | Rupees |
81 | Charu Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | What is the shortcut key of profit and Loss? | P | P |
82 | Charu Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Who has Developed the Tally Software? | Tally Solutions Pvt. Ltd. | Tally Solutions Pvt. Ltd. |
83 | Charu Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Which Shortcut keys are used to take print out in tally? | Ctrl P | Ctrl P |
84 | Charu Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | At almost all screens in TALLY To remove what you typed into a field. | Enter | ESC |
85 | Charu Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Debit All Expenses, Credit All Income is the golden rule based on | Nominal Account | Nominal Account |
86 | Charu Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | To activate the feature of Bills of Material:- | F12 | F12 |
87 | Charu Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Liabilities are the ......................... of the business:- | Negative Balance | Negative Balance |
88 | Charu Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Assets are called:- | Real Account | Real Account |
89 | Charu Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Discount Allowed and Discount Received are the types of:- | Cash Discount | Cash Discount |
90 | Charu Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Short cut Key to Create any master:- | Alt C | Alt C |
91 | Charu Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Short cut Key to change the financial year or current period:- | Alt F2 | Alt F2 |
92 | Charu Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Tally is an ........................... software? |
Accounting | Accounting |