| Sr | Student Name Semester |
Branch | Subject | Question | User Answer | Right Answer |
|---|---|---|---|---|---|---|
| 1 | SONALI RAUTHAN Semester 1 |
MGI 456 | Advance Excel | In which tab wrap text feature is present in MS Excel 2007? |
View | Home |
| 2 | SONALI RAUTHAN Semester 1 |
MGI 456 | Advance Excel | If function is used for _____ |
Apply condition formatting | Apply condition |
| 3 | SONALI RAUTHAN Semester 1 |
MGI 456 | Advance Excel | Shortcut key for Save As |
Ctrl + S | F12 |
| 4 | SONALI RAUTHAN Semester 1 |
MGI 456 | Advance Excel | Following tools are _________________ Group.
|
Style | Style |
| 5 | SONALI RAUTHAN Semester 1 |
MGI 456 | Advance Excel | Identify the Tool Name |
Sort & Filter | Sort & Filter |
| 6 | SONALI RAUTHAN Semester 1 |
MGI 456 | Advance Excel | How many tabs in Menu Bar |
7 | 7 |
| 7 | SONALI RAUTHAN Semester 1 |
MGI 456 | Advance Excel | ---------------------------- function is used to remove the extra space between two words. |
Trim | Trim |
| 8 | SONALI RAUTHAN Semester 1 |
MGI 456 | Advance Excel | ---------------------- function is used to convert unorganised data in organised way. |
Text to column | Text to column |
| 9 | SONALI RAUTHAN Semester 1 |
MGI 456 | Advance Excel | Identify the Following Tool Name? |
Merge | Merge |
| 10 | SONALI RAUTHAN Semester 1 |
MGI 456 | Advance Excel | identify the Following group name?
|
Alignment | Number |
| 11 | SONALI RAUTHAN Semester 1 |
MGI 456 | Advance Excel | What are the basic rectangular builduing blocks of a spreadsheet? |
Cells | Cells |
| 12 | SONALI RAUTHAN Semester 1 |
MGI 456 | Advance Excel | Transpose option is used for converting data |
Both A & B | Both A & B |
| 13 | SONALI RAUTHAN Semester 1 |
MGI 456 | Advance Excel | Vlookup formula is used to find data |
Vertical | Vertical |
| 14 | SONALI RAUTHAN Semester 1 |
MGI 456 | Advance Excel | Filter option is ________ group |
Style | Editing |
| 15 | SONALI RAUTHAN Semester 1 |
MGI 456 | Advance Excel | Hlookup formula is used to find data. |
Horizontal | Horizontal |
| 16 | SONALI RAUTHAN Semester 1 |
MGI 456 | Advance Excel | Which short cut key is used to make selection lock. |
F4 | F4 |
| 17 | SONALI RAUTHAN Semester 1 |
MGI 456 | Advance Excel | To insert current date |
=now() | Ctrl + ; |
| 18 | SONALI RAUTHAN Semester 1 |
MGI 456 | Advance Excel | To insert current date and time |
=Today() | =now() |
| 19 | SONALI RAUTHAN Semester 1 |
MGI 456 | Advance Excel | Counta formula is used for |
Both A & B | Both A & B |
| 20 | SONALI RAUTHAN Semester 1 |
MGI 456 | Advance Excel | Formula: =Len(B2)-Len(substitute(B2,” “,””))+1 is used to count_________ |
All of these | Words |
| 21 | SONALI RAUTHAN Semester 1 |
MGI 456 | Advance Excel | Which formula is used to combine to different words in next cell. |
Concatenate | Concatenate |
| 22 | SONALI RAUTHAN Semester 1 |
MGI 456 | Advance Excel | Number of columns in MS Excel 2007 |
16384 | 16384 |
| 23 | SONALI RAUTHAN Semester 1 |
MGI 456 | Advance Excel | Number of rows in MS Excel 2007 |
1048576 | 1048576 |
| 24 | SONALI RAUTHAN Semester 1 |
MGI 456 | Advance Excel | Last column name in MS Excel. |
FDX | XFD |
| 25 | SONALI RAUTHAN Semester 1 |
MGI 456 | Advance Excel | Which Command is used to close the window of Excel? |
Alt + F4 | Alt + F4 |
| 26 | SONALI RAUTHAN Semester 1 |
MGI 456 | Advance Excel | What is extension of saved file in MS Excel? |
.xls | .xls |
| 27 | SONALI RAUTHAN Semester 1 |
MGI 456 | Advance Excel | A (n)______ is a Series of two or more adjacent cell in a column or row or rectangular group of cells. |
Range | Range |
| 28 | SONALI RAUTHAN Semester 1 |
MGI 456 | Advance Excel | A formula is Excel always beings with an _________ |
Equal sign | Equal sign |
| 29 | SONALI RAUTHAN Semester 1 |
MGI 456 | Advance Excel | Which terms is used to join the selected cell in to one cell? |
Merge | Merge |
| 30 | SONALI RAUTHAN Semester 1 |
MGI 456 | Advance Excel | Which of the following identifies a cell in Excel? |
Formula | Address |
| 31 | SONALI RAUTHAN Semester 1 |
MGI 456 | Advance Excel | Excel is a program that is used to prepare. |
Spreadsheet | Spreadsheet |
| 32 | SONALI RAUTHAN Semester 1 |
MGI 456 | Advance Excel | Which of the following is not a term pertaining to spreadsheets? |
Browser | Browser |
| 33 | SONALI RAUTHAN Semester 1 |
MGI 456 | Advance Excel | What are the basic rectangular building blocks of a spreadsheet? |
Cells | Cells |
| 34 | SONALI RAUTHAN Semester 1 |
MGI 456 | Advance Excel | _______ appear at the bottom of tool bar in MS Excel. |
Worksheet tab | Formula bar |
| 35 | SONALI RAUTHAN Semester 1 |
MGI 456 | Advance Excel | Shortcut keys for cell edit. |
F2 | F2 |
| 36 | SONALI RAUTHAN Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Discount Allowed and Discount Received are the types of:- | Cash Discount | Cash Discount |
| 37 | SONALI RAUTHAN Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | What is the shortcut key of profit and Loss? | P | P |
| 38 | SONALI RAUTHAN 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 |
| 39 | SONALI RAUTHAN Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | The Feature of Interest | Accounting | Accounting |
| 40 | SONALI RAUTHAN Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | To activate Purchase Order/Sales Order press: | F10 | F10 |
| 41 | SONALI RAUTHAN Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | How to Delete any Master | By pressing Alt D | By pressing Alt D |
| 42 | SONALI RAUTHAN Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Wages treated as: | Direct Expense | Direct Expense |
| 43 | SONALI RAUTHAN Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Short Cut key is used to open Payroll Voucher: |
Alt + F4 | Ctrl+ F4 |
| 44 | SONALI RAUTHAN Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Drawing Account Treated as: | Capital Account | Capital Account |
| 45 | SONALI RAUTHAN Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | In Tally ERP9 to create company press: | Alt F3 | Alt F3 |
| 46 | SONALI RAUTHAN Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Which key is used to activate the calculator? | Ctrl N | Ctrl N |
| 47 | SONALI RAUTHAN Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Salary due but not paid is called: | Outstanding Salary | Outstanding Salary |
| 48 | SONALI RAUTHAN Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Return Outward stands for: | Purchase Return | Purchase Return |
| 49 | SONALI RAUTHAN 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 |
| 50 | SONALI RAUTHAN Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Key to Open Stock Journal | Alt F7 | Alt F7 |
| 51 | SONALI RAUTHAN Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Tds Stands for: | Tax Deducted at Source | Tax Deducted at Source |
| 52 | SONALI RAUTHAN Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | To Open Receipt Voucher Press: | f6 | f6 |
| 53 | SONALI RAUTHAN Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | The amount which is withdraw by the owner is called: | Drawing | Drawing |
| 54 | SONALI RAUTHAN Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | The amount which is credited by the bank called Bank Interest treated as: | Indirect Expense | Indirect Income |
| 55 | SONALI RAUTHAN 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 F5 | Alt F5 |
| 56 | SONALI RAUTHAN Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | At gateway of Tally Screen to select the company info menu | F3 | F3 |
| 57 | SONALI RAUTHAN 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 E | Alt E |
| 58 | SONALI RAUTHAN Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Which key is used to go in the Contra Voucher? | F4 | F4 |
| 59 | SONALI RAUTHAN Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Which option is used to make change in the Ledger? | Alter | Alter |
| 60 | SONALI RAUTHAN Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | What is the currency of India? | Rupees | Rupees |
| 61 | SONALI RAUTHAN Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Who has Developed the Tally Software? | Tally Solutions Pvt. Ltd. | Tally Solutions Pvt. Ltd. |
| 62 | SONALI RAUTHAN Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Which Shortcut keys are used to take print out in tally? | Ctrl P | Ctrl P |
| 63 | SONALI RAUTHAN Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | At almost all screens in TALLY To remove what you typed into a field. | ESC | ESC |
| 64 | SONALI RAUTHAN 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 |
| 65 | SONALI RAUTHAN Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | To activate the feature of Bills of Material:- | F11 | F12 |
| 66 | SONALI RAUTHAN Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Liabilities are the ......................... of the business:- | Negative Balance | Negative Balance |
| 67 | SONALI RAUTHAN Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Assets are called:- | Real Account | Real Account |
| 68 | SONALI RAUTHAN Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Short cut Key to Create any master:- | Alt C | Alt C |
| 69 | SONALI RAUTHAN Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Short cut Key to change the financial year or current period:- | Alt F2 | Alt F2 |
| 70 | SONALI RAUTHAN Semester 1 |
MGI 456 | Certificate in Tally Package (CTP) | Tally is an ........................... software? |
Typing | Accounting |
| 71 | SONALI RAUTHAN Completed |
MGI 456 | Certificate In Typing | Which finger used to press "Space"? |
Thum | Thum |
| 72 | SONALI RAUTHAN Completed |
MGI 456 | Certificate In Typing | which finger used to press "Backspace"? |
Right Pinky | Right Pinky |
| 73 | SONALI RAUTHAN Completed |
MGI 456 | Certificate In Typing | Ques20)”QWERTYUIOP” row known as? |
Upper row | Upper row |
| 74 | SONALI RAUTHAN Completed |
MGI 456 | Certificate In Typing | Ques19)Which finger used to press comma(,) |
Right middle | Right middle |
| 75 | SONALI RAUTHAN Completed |
MGI 456 | Certificate In Typing | Ques18Which finger used to press “0”? |
Right Pinky | Right Pinky |
| 76 | SONALI RAUTHAN Completed |
MGI 456 | Certificate In Typing | Ques17)The ;-finger is also known as; |
Right Pinky | Right Pinky |
| 77 | SONALI RAUTHAN Completed |
MGI 456 | Certificate In Typing | Ques16)Which method of typewriting is a method of typing without using the sense of sight to find the keys. |
Touch Method | Touch Method |
| 78 | SONALI RAUTHAN Completed |
MGI 456 | Certificate In Typing | Ques15)Touch typing can be done with ......... hand |
Both of above | Both of above |
| 79 | SONALI RAUTHAN Completed |
MGI 456 | Certificate In Typing | .Ques13).............. arrow keys available on keyboard? |
4 | 4 |
| 80 | SONALI RAUTHAN Completed |
MGI 456 | Certificate In Typing | Ques13)............... key deletes the character just to left the cursor. |
Backspace | Delete Key |
| 81 | SONALI RAUTHAN Completed |
MGI 456 | Certificate In Typing | Ques12)Which of the following keys help to type character in upper case? |
Both A and B | Both A and B |
| 82 | SONALI RAUTHAN Completed |
MGI 456 | Certificate In Typing | Ques 11)Special keys labelled F1 to F12 is called? |
Functional keys | Functional keys |
| 83 | SONALI RAUTHAN Completed |
MGI 456 | Certificate In Typing | Ques 10)Which finger is used to strike the slash? |
Right Pinky | Right Pinky |
| 84 | SONALI RAUTHAN Completed |
MGI 456 | Certificate In Typing | Ques9)The ;-finger is also known as; |
Right Pinky | Right Pinky |
| 85 | SONALI RAUTHAN Completed |
MGI 456 | Certificate In Typing | Ques8)The K-finger is also your? |
Right middle | Right middle |
| 86 | SONALI RAUTHAN Completed |
MGI 456 | Certificate In Typing | Ques7)Which finger is used to strike the apostrophe? |
Right pinky | Right pinky |
| 87 | SONALI RAUTHAN Completed |
MGI 456 | Certificate In Typing | Ques6)Which finger is used to strike the I? |
K-finger | K-finger |
| 88 | SONALI RAUTHAN Completed |
MGI 456 | Certificate In Typing | Ques5)Which finger is used to strike the apostrophe? |
Right Pinky | Right Pinky |
| 89 | SONALI RAUTHAN Completed |
MGI 456 | Certificate In Typing | Ques4)What is the character between the t and s in “It’s”? |
apostrophe | apostrophe |
| 90 | SONALI RAUTHAN Completed |
MGI 456 | Certificate In Typing | Ques3)Which finger is used to strike the comma? |
Right middle | Right middle |
| 91 | SONALI RAUTHAN Completed |
MGI 456 | Certificate In Typing | Ques 2)Which finger is used to strike the P? |
;-finger | ;-finger |
| 92 | SONALI RAUTHAN Completed |
MGI 456 | Certificate In Typing | Ques1. The K-finger is also known as; |
Right Middle | Right Middle |
| 93 | SONALI RAUTHAN Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Types of selection in Mspaint |
None of these | None of these |
| 94 | SONALI RAUTHAN Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Which of the following is not an input device?
|
Keyboard | Keyboard |
| 95 | SONALI RAUTHAN Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Collection of Rows and columns is called ............................... |
Cell | Cell |
| 96 | SONALI RAUTHAN 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 |
| 97 | SONALI RAUTHAN Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | |||
| 98 | SONALI RAUTHAN Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | |||
| 99 | SONALI RAUTHAN Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Identify the given formula =pmt(Annual Rate /12,Duration,Loan Amount ) |
Interest | Interest |
| 100 | SONALI RAUTHAN Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Save As shortcut command |
F12 | F12 |
| 101 | SONALI RAUTHAN Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | VGA cable available in which three color
|
White | White |
| 102 | SONALI RAUTHAN Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Tool Bar consist of.................... . |
Tabs | Tabs |
| 103 | SONALI RAUTHAN Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Which short cut key is used to make selection lock. |
F4 | F4 |
| 104 | SONALI RAUTHAN Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Identify the following :- .png, .jpg, .txt, .rtf, .docx, .ppt |
Application | Devices |
| 105 | SONALI RAUTHAN Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | In which tab these are present “Table, Header & Footer, WordArt and chart”? |
Insert tab | Insert tab |
| 106 | SONALI RAUTHAN Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Concatenate formula is used for ........................................ |
Combine two different words written in different - 2 cells | upper |
| 107 | SONALI RAUTHAN Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Identify the Following formula =rept("|",num)
|
Mini Chart | Mini Chart |
| 108 | SONALI RAUTHAN Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | How to find the current date |
=now() | =now() |
| 109 | SONALI RAUTHAN Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | How to find the current date and time in MS Excel? |
=now() | =now() |
| 110 | SONALI RAUTHAN Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Which tab is available in Wordpad Application |
Insert | Insert |
| 111 | SONALI RAUTHAN Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Hlookup formula is used to find valuse in ............................... form |
Verticle | Verticle |
| 112 | SONALI RAUTHAN Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | By Default No. of sheet in Ms Excel |
3 | 3 |
| 113 | SONALI RAUTHAN Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Shortcut key used for Slide Show in Powerpoint presentation. | F5 | F5 |
| 114 | SONALI RAUTHAN Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Hlookup formula is used to find data |
Horizontal | Horizontal |
| 115 | SONALI RAUTHAN Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | To remove the all changes from the selected text is knows as ____________________ |
Clear Formatting | Clear Formatting |
| 116 | SONALI RAUTHAN Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Excel is a program that is used to prepare a ................................ |
Text Documentation | Text Documentation |
| 117 | SONALI RAUTHAN Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | What are the basic rectangular building blocks of a spreadsheet? | Cells | Cells |
| 118 | SONALI RAUTHAN Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Shortcut key for New Page in current documentation |
Ctrl +M | Ctrl +M |
| 119 | SONALI RAUTHAN Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Shortcut key of superscripts |
Ctrl +shift+"+" | Ctrl +shift+"+" |
| 120 | SONALI RAUTHAN 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 |
| 121 | SONALI RAUTHAN Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Use of Format Painter |
Used to apply shading on text | Used to apply shading on text |
| 122 | SONALI RAUTHAN Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | What is the formula for inserting the Random numbers in excel
|
=Random () | =Random () |
| 123 | SONALI RAUTHAN Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | How many Groups in Insert Tab |
7 | 7 |
| 124 | SONALI RAUTHAN Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | Ctrl + Enter is shortcut key for ............................... |
New Sheet | New Sheet |
| 125 | SONALI RAUTHAN 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 |
| 126 | SONALI RAUTHAN Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | RTF Full Form |
Rich Text Format | Rich Text Format |
| 127 | SONALI RAUTHAN Semester 1 |
MGI 456 | BASIC COMPUTER COURSE (BCC) | How many Alignment are there? |
4 | 4 |
