MS-OFFICE-IV Welcome to your MS-OFFICE-IV DATE:July 27, 2026 Name of Student 1.Conditional Formating is use for formationg of those cell/row/coumns that does not satisfy the certain condition True False None 2.In MS Excel how to insert a worksheet Home ---> insert --> Insert sheet Insert ---> insert --> Insert sheet View ---> insert --> Insert sheet Review ---> insert --> Insert sheet None 3.In MS Excel we can sort the Data into 4 different field True False None 4.In MS Excel we can sort the data on only one field True False None 5.Which is not a part of General option Currency Date and Time Percent None of above None 6.In Ms Excel _____________ number of chart it can support 10 11 12 13 None 7.which is of then are the chart type in MS Excel 2007 Line Column Bar All of above None 8.Which of them are the types of chart in MS Excel XY Scatter Doughtnut Radar All of above None 9.Which of them is not a type of chart Radar Bubble Network XY Scatter None 10.In Header and Footer of a Worksheet we can insert Date and Time Page No Sheet Name All of above None 11.In MS Excel Header and Footer we not Insert any of the following Option No of Pages WorkBook Name File path None of above None 12.Print Area is available in _________________- Ribbon of MS Excel 2007 Home Page Layout Insert View None 13.Break option of the page Layout Ribbon is __________ option Page Break Remove Page Break Both Above None of above None 14.Formula in Worksheet is started by __________ = # $ * None 15.Which of them is a type/ Group of Function Maths & Trig Statastics Logical All of Above None 91.Which of them is a type of Function category in Ms Excel Logical Text Date and Time All of Above None 17.Which of them is not a category of function Relational Financial Recently used Look up and Reference None 18.Define Name option is use to give the name to the range of cells in MS Excel Worksheet True False None 19.Which of is true about Name option in Ms Excel Define the name of range of cells used in the place of cell name of range Both above We can not edit the name from the range of cells None 20.There are _______________type of Sorting in MS Excel 2 3 4 1 None 21.Sorting Order Ascending sort the element from higher to lower True False None 22.Sorting Order Ascending arrange the element in Lower to Higher value True False None 23.Sroting Order Descending order arrange the element in lower number to heigher number True False None 24.Sorting order Descending arrange the element in higher to lower numbers True False None 25.Protect Worksheet will allow to make the changes in the content of the worksheet True False None
MS-OFFICE-III Welcome to your MS-OFFICE-III DATE:July 27, 2026 Name of Student 1.To Switch to the Previous Veiw from the Full Screen ______________ shortcut is use. F12 ESP Cancel ESC None 2.Which option is use to control the appearance of the document Font Zoom Page Margin None 3._____________ will change the size of the document text only for display. Zoom Font Margin Full Screen None 4.Zoom option is avialable in ___________ ribbon View Review Insert Home None 5.Ruler can be hide or shown using rule option in __________ ribbon View Review Insert Home None 6.Thesaurus Option is use to give _____________________ Same meaning word Opposite meaning word Both Above None of above None 7.Short cut of the Spelling and Grammer checking is __________ F12 F7 Ctrl+S Ctrl+P None 8.Printer ---> Preview option is use to display the text how document will look after print. True False None 9.Print option has the ____________ option Current page All Pages All of above None 10.We can save the Word Document of 2007 in the Format of Office 97 -2003 True False None 11.MS Excel 2007 save the file with the extension of __________________ XLS XLSX DOC PPX None 12.By default the MS Excel contain ________________ no of worksheet 1 2 3 4 None 13.Name of Worksheet By default is Sheet1, sheet2, sheet3 . .. . . . . . True False None 14.The Excel File is called Worksheet. True False None 15.Excel File is called WorkBook True False None 16.The Intersection of row and column is called Workbook Worksheet Sheet Cell None 17.Intersection of Row and Column is called Cell True False None 18.In Excel worksheet column are labeled as A, B, C, D . . . . . . True False None 19.In Excel Column are Labeled as 1,2,3,4,5,6,7, . . . . . . . True False None 20.In MS Excel the Total number of rows are ______________ 256 35536 1048576 1024 None 21.MS EXCEL2007 does not support the _______________ alignment Left Right Center Justify None 22.In MS Excel 2007 Insert Row, Columns supprot in __________ Ribbon Home Insert View Review None 23.Save Workspace is to save Format Location View All of above None 24.Save Workspace save the content of file. True False None 25.Conditional Formating is use for formationg of those cell/row/coumns that satisfy the certain condition True False None
Tally-III Welcome to your Tally-III 1. Follow type of Voucher is adjustment voucher without affecting cash or bank A/c Journal Debit Note Credit Note Voucher None Time's up
Tally-25-50 QUE Welcome to your TALLY -II 1. Shut a company means Close the Company Deleting Company Removing Company All of Above None 2. What is the full form of TDS Tax Deduction at Source Tax Deleting at Source Tax Details at Source Tax Distribution at Source None 3. The automatically/ default created Group in Tally is called Reserve Group True False None 4. Income tax provision for bad debts is a common example of ___________ Sundary Creditor Provision Taxes and Duties All of Above None 5. Account of All Parties from whom you purchase goods on credit is called Sundary Creditor Sundary Debtor Loan Provider Creditor None 6. The Amount of invested by the owner in business called Loan Credit Debit Capital None 7. Good sold to Mr. Rajesh and Sons of 6000/- in cash we can make the entry in Cash Credit Purchase Sale None 8. Cash and Bank balance is Current Asset Current Liabilities Fixed Asset All of Above None 9. Impersonal Account are classified in two Real Nominal Both A and B None of A and B None 10. Account where properties and Possession are record like fixed asset and current asset is _________ Real A/c Nominal A/c Personal A/c None of Above None 11. Function key F4 is use for Copy Restore Contra Delete Company None 12. For Backup of the Tally data we can use _________ key F2 F4 Alt+F3 F3 None 13. Function Related to comparing, analyzing and opposing the performance History Managerial Manual Money None 14. Restore of the data take place by the combination of key Alt +F4 F4 Ctrl+F4 F9 None 15. System based om purely cash account is called as _____________ Single Entry Double Entry Triple Entry All of Above None 16. Account related to expenses, income profit and gain Real A/c Personal A/c Nominal A/c Credit Account None 17. Repeats the data entry in the field during Previous entry Alt+R Ctrl+R Ctrl+Alt+R Shift+Alt+R None 18. Procedure to create Stock Group Gateway to Tally -->Inventory Info --> Stock Group -->Create Gateway to Tally -->Group Info --> Stock Group -->Create Gateway to Tally -->Stock Info --> Stock Group -->Create Gateway to Tally -->Inventory Info --> Stock Group -->Make None 19. RAM is a type oe Account Nominal A/c Personal A/c Real A/c None of Above None 20. Profit and Loss is the ____________ type of account Personal A/c Nominal A/C Real A/c Credit A/c None 21. If Goodown option is not shown in the Inventory info. These will active using Features F11 F12 F10 None 22. Stock Category is offer parallel classification of Item Voucher Ledger None of above None 23. TIN stand for _______________ Tax In Number Tax Index Number Tax Identification Number Tax Individual Number None 24. Tally allow to create duplicate Master Voucher Account Company None 25. Rule of Purchase voucher is Cr Name of Seller -- Dr Purchase A/c DR Name of Saler -- Cr Purchase A/c Cr Name of Buyer --- Dr Purchase A/c Dr Name of Buyer --- Cr Purchase A/c None
MS-OFFICE-25QUE Welcome to your MS-OFFICE-II DATE:July 27, 2026 Name of Student 3.There are two indentation____________ and _________________ Left & Right Top & Bottom Up & Down All of Above None 3.There are two indentation____________ and _________________ Line Spacing Pragraph Both Above None of Above None 4.The default paper size of the Page is _____________ A4 Letter A3 Legal None 5.The Extension of MS Word 2007 file is DOCX True False None 6.The Extension of MS Word 2007 file is DOCX DOC DOCX DCX DDX None 7.Which is not a margin in MS Word 2007 Top Bottom Left Upper None 8.Short Key for Save As is _____________ Ctrl+S ALT+S F12 F10 None 9.Cut -- Paste move the text True False None 10.Copy -- Paste Move the text to new Location True False None 11.Which is not an alignment in MS Word 2007 Left Right Justify Control None 12.Justify Aligment set the Text from Left Margin to Right Margin True False None 13.Header text will appear _______________ and Footer Text will Apper at ___________ Top & Bottom Left & Right Both Above None of Above None 14.The Header is a Text will appear at _______________________ Top of the page Bottom of the page Left of the page Center of the page None 15.Which of them is not a alignement of the Text in MS Word 2007 Left Center Justify None of above None 16.The Footer will appear at _____________________ Top of the page Bottom of the page Left of the page Center of the page None 17.Page Number option is use to insert the page number at Top or Bottom Page Margin Current Position All of Above None 18.Drop Cap is use to Make the First Letter of the paragraph large in number of line True False None 19.For a Paragraph there ___________ number of Drop caps One Two As many as we want All of Above None 20.Insert Bookmark option is avialable in _________ ribbon Insert View References Home None 21.Red Underline is shown _____________ Spelling error Grammar Error Both Above None of above None 22.Green waive line is shown ____________ Grammar error Spelling error Both above None of above None 23.Which is not true about Comment Insert Additional Text Comment will not print Multiple Comment will Insert None of above None 24.Default Layut of the page is _________ Outline Page Layout Draft Web None 25.Which is not a Layout of the Page Draft Web Online Page Layout None 1.The extension of MS-PowerPoint 2013 is _____. .PPTX .PTX .PPTX .PTMX None
Tally Welcome to your TALLY-I 1. Tally is a_________________ application General Purpose Special Purpose Both A and B None of the above None 2. Tally is a Special Purpose Software True False None 3. Tally is Account Base Software True False None 4. Tally is Windows Base Software True False None 5. The Account which is related ti person is called Personal A/c Real A/c Nominal A/c All of Above None 6. Voucher entry receipt book will display by F6 F5 F2 F3 None 7. To Delete the voucher entry press Ctrl+D Shift+D Alt+D Shift+Alt+D None 8. F2 key is use for ____________ Change Financial Year Change Date Both A and B None of A and B None 9. Changing Date of the Entry we can use F2 F3 F6 F12 None 10. Total Number of function in accounting 2 3 1 Many None 11. For Creating the company We can use _______ Alt+F3 Ctrl+F3 Shift+F3 Ctrl+Alt+F3 None 12. Following is the Example of Fixed Account Building Loan Goods Libilities None 13. We can create ledger in Tally during voucher entry. Alt+C Ctrl+C Shift+C Shift+Alt+C None 14. Book Keeping is a systematic record of the following transaction Functional Monetary Final Personal None 15. The art of recording transaction in a systematic manner is called Accounting Book Keeping Account Manager Accountant None 16. To Create Rent Account which group can be selected Sale Account Expenses Indirect Purchase Indirect Home None 17. Rent paid to landlord is debited to Cash A/c Party A/c Bank Account All of Above None 18. Brief Description of the transaction is called Narration Voucher Entry Sale Entry Comment None 19. Number of Vouchers in Tally 6 8 7 5 None 20. Voucher Entry permit the user to purchase book by using F9 F8 F7 F11 None 21. We can protect the company my apply password to it True False None 22. Factory Shade is Fix assest Current Liability Current Asses Liability None 23. Financial Year Started From January March April December None 24. I start my company in 12-May-10 what is my financial year 12-05-2010 to 31-12-2010 31-03-2010 to 31-03-2011 12-05-2010 to 31-03-2010 01-04-2010 to 31-030-2011 None 25. VAT Stands For Value Added Tax Valued Added Tax Value Add Tax Valued Added Taxes None Time's up
MS-OFFICE Welcome to your MS-OFFICE -I DATE:July 27, 2026 Name of Student 1.Which of them is not a Page Break Option Continue Even Odd Column None 2.There are two indentation____________ and _________________ Left to Right Top and Bottom Up and Down All of Above None 3.MS Office is not a General Purpose Software? True False None 4.In MS office 2007 Menu is replace by Ribbon? True False None 5.MS office 2007 has the version of 12? True False None 6.Which of them is not a member of MS office Family? MS WORD MS EXCEL MS PUBLISHER MS PAINT None 7.Which of them is a member of MS Office Family? MS WORD MS EXCEL MS OUTLOOK All of the Above None 8.MS Office 2007 Has Ribbon instead of Toolbar? True False None 9.MS Office 2007 is ________________ type of Software Application System Utility General Purpose application None 10.MS Office2007 does not contain Menu? True False None 11.Which of them is an not an Applicaion of MS Word? Writing Letter Creating Report Creating manual Create balance Sheet None 12.MS Word is use for Creating report Creating logbook Creating Manual All of the Above None 13.MS Word is a Family member of MS Office 2007 True False None 14.Whichis not a Part of Home ribbon Cut Copy Paste Table None 15.For Changing Apply or change the bullet or numbering ___________ ribbon is use. Home Insert Review View None 16.Step for apply Bullet to the text which is the corrrect way Insert --> Bullet --> Select Bullet --> Ok Home --> Bullet --> Select Bullet -->OK Select Text --> Home--> Bullet --> Select Bullet Select Text --> Insert--> Bullet --> Select Bullet None 17.If we want to write the step by step procedure we can apply Bullet Numbering Both A And B None of the above None 18.If we want to aply the Background color to the Document ----------- Option is use Background Page color Apply color Document color None 19.If we want to aply the Background color to the Document ----------- Option is use Insert Home Page Layout View None 20.If we want to write the text in a page into two column then we can use _________ Ribbon Insert View Home Page Layout None 21.Which is the Page orientation Portriate Landscape Both Above None of above None 22.Which of them is Page Orientation Landscape width Horizontal Vertical None 23.Which of them is a orientation of Page Tall Portriate Wide Vertical None 24.Which of them is not a Page Orientation Tall Wide Horizontal None of avove None 25.Which of them is not a break Option Page Column Paragraph Even/odd page None
