Excel Questions March 14, 2023 | No Comments 0 votes, 0 avg 41 123456789101112131415 Excel Questions 1 / 15 1. In MS Excel, ‘Merge and Center’ is used to ____. A. Combine and centre the content of the selected cell B. Combine and centre the content of the current row C. Concatenate the text of the two cells and returns the text D. None of the above 2 / 15 2. Which function is used to create a date with year, month, and day? A. DATE() B. DATEDIF() C. DATEVALUE() D. CURDATE() 3 / 15 3. The NOW function calculates the difference in days between two dates. A. true B. false 4 / 15 4. Which function is used to get the location of text in a string in MS Excel? A. FIND() B. INDEX() C. SEARCH() D. STRINGSEARCH() 5 / 15 5. Which option allows you to display all numbers which are less than 0 (negative numbers) in red color in MS Excel? A. Styling B. Conditional Formatting C. Compare Formatting D. Special Formatting 6 / 15 6. How can you remove borders applied in cells? A. Choose None on Border tab of Format cells B. Open the list on Border tool in Formatting toolbar then choose first tool C. Both of above D. None 7 / 15 7. What is the keyboard shortcut to insert a SUM formula in MS Excel? A. CTRL + = B. ALT + = C. ALT + S D. CTRL + ALT + = 8 / 15 8. Which of following functions MS-Excel have 1 SUM 2 CONCATENATE? A. Only 1 B. Only 2 C. None of 1 and 2 D. Both 1 and 2 9 / 15 9. Which function returns the current date? A. Lookup B. VLookup C. CountIF D. NOW 10 / 15 10. A function inside other function is called A. Nested Function B. Round Function C. Inner Function D. None of the above 11 / 15 11. Which function is used to trap and handle errors? A. IFERROR() B. ERROR() C. IFNA() D. IFTRAP() 12 / 15 12. How can we provide a dynamic range in ‘data Source’ of pivot tables? A. Create a Named range using Offset function B. Base the pivot table using the Named range created in Step 1 C. Both A and B D. None 13 / 15 13. IF Statement can be written to carry out an action A. true B. false 14 / 15 14. Advanced Functions are used in higher-level operations such as in conditional and comparison equations to compute interest rates, due dates and payment terms, and financial projections. A. true B. false 15 / 15 15. What is the correct value of the function? =ROUND (1.2345,2) A. 1.24 B. 1.23 C. 1. 25 D. 2 Your score is The average score is 57% LinkedIn Facebook Twitter VKontakte Restart quiz Questions, Quiz
