Welcome to your DFA-II DATE:January 17, 2025 Name of Student 1.'If 4/6 entered in a cell without applying any format, Excel will treat this as Fraction Number Text Date 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 3.'How to specify cell range from A9 to A99 in Excel (A9,A99) (A9:A99) (A9 to A99) (A9 - A99) 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) 5.You accidentally erased a record in the sheet, What command can be used to restore It immediately? Insert Copy Undo Replace 6.Where a row and a column meet, what do you call that? A Cell A Block A Box None of th above 7.What is an example of a cell address? 11 25 911 41A A21 8.Which is an example of a formula? . =A1+A2 . =SUM(A1:A2) . A1+A2 9.MS Excel 2010 save the file with the extension of XLS XLSX EXL EXLX 10.By default the MS Excel contain 1 2 3 4 11.Sorting Ascending order sort the element from higher to lower TRUE FALSE 12.Account of all parties from whome you purchase goods on credit is called Sundry Creditor Sundry Debtor Loan Provider Creditor 13.Protect Worksheet will not allow to make the changes in the content of the worksheet TRUE FALSE 14.What is the full form of TDS Tax Deduction at Source Tax Deleting at Source Tax Details at Source Tax Distribution at Source 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 16.Software, such as Internet Explorer and Mozilla Firefox, are referred to as Systems software Utility software Browsers Internet tools 17.What is E-mail? Engineering mailing Electronic mailing Entry mailing Internet mailing 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 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 20.What does the abbreviation "WWW" in Internet stand for ? World Wide Web Wide Wide Web World Width Web World With Web 21.The first version of Tally is Window base. TRUE FALSE 22.ERP stands for . Enterprises Resource Planning Entry Resource Planning Export Resource Planning Enterprises Report Planning 23.Balance sheet can be exported from Tally. TRUE FALSE 24.Key is use to export Balance Sheet from Tally. Alt+M Alt+E Alt+P Alt+D 25.Total Number of Voucher in Tally. 7 6 8 5
Add a Comment