Welcome to your DFA-II DATE:February 12, 2026 Name of Student 1.'If 4/6 entered in a cell without applying any format, Excel will treat this as Fraction Number Text Date None 2.'Which of the following syntax is correct regarding the SUMfunction in Excel? . =SUM(A1,B1) . =SUM(A1:B9) . =SUM(A1:A9,B1:B9) All of the above None 3.'How to specify cell range from A9 to A99 in Excel (A9,A99) (A9:A99) (A9 to A99) (A9 - A99) None 4.Which of the following function will use to find the highest number in a series of number MAX(B1:B3) MAXIMUM(B1:B3) HIGH(B1:B3) HIGHEST(B1:B3) None 5.You accidentally erased a record in the sheet, What command can be used to restore It immediately? Insert Copy Undo Replace None 6.Where a row and a column meet, what do you call that? A Cell A Block A Box None of th above None 7.What is an example of a cell address? 11 25 911 41A A21 None 8.Which is an example of a formula? . =A1+A2 . =SUM(A1:A2) . A1+A2 None 9.MS Excel 2010 save the file with the extension of XLS XLSX EXL EXLX None 10.By default the MS Excel contain 1 2 3 4 None 11.Sorting Ascending order sort the element from higher to lower TRUE FALSE None 12.Account of all parties from whome you purchase goods on credit is called Sundry Creditor Sundry Debtor Loan Provider Creditor None 13.Protect Worksheet will not allow to make the changes in the content of the worksheet TRUE FALSE None 14.What is the full form of TDS Tax Deduction at Source Tax Deleting at Source Tax Details at Source Tax Distribution at Source None 15.Which from the following is a valid email address? joe.bloggs@freemail.com joe.bloggs. freemail.com joe.bloggs.@www@freemail.com @freemail.com None 16.Software, such as Internet Explorer and Mozilla Firefox, are referred to as Systems software Utility software Browsers Internet tools None 17.What is E-mail? Engineering mailing Electronic mailing Entry mailing Internet mailing None 18.What is the purpose of the refresh button in Internet Explorer? Search for web pages Remove your favorite websites Display the home page Reload the current page None 19.You are searching information over the internet and found the page having information about "Online Learning". Referring tothe above scenario, identify the type of web site you are viewing? Shopping Communicating Entertainment e-learning None 20.What does the abbreviation "WWW" in Internet stand for ? World Wide Web Wide Wide Web World Width Web World With Web None 21.The first version of Tally is Window base. TRUE FALSE None 22.ERP stands for . Enterprises Resource Planning Entry Resource Planning Export Resource Planning Enterprises Report Planning None 23.Balance sheet can be exported from Tally. TRUE FALSE None 24.Key is use to export Balance Sheet from Tally. Alt+M Alt+E Alt+P Alt+D None 25.Total Number of Voucher in Tally. 7 6 8 5 None
Add a Comment