Excel Questions March 14, 2023 | No Comments 0 votes, 0 avg 135 123456789101112131415 Excel Questions 1 / 15 1. What is the keyboard shortcut to switch between open Excel windows? A. CTRL + TAB B. ALT + TAB C. CTRL + ALT + TAB D. None of the above 2 / 15 2. 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 3 / 15 3. Getting data from a cell located in a different worksheet is called? A. Accessing B. Referencing C. Updating D. Functioning 4 / 15 4. Steps for protecting a sheet by password in MS Excel? A. Under the Review Tab, Click on Protect Current Sheet B. Under Insert Tab, Click on Protect Sheet C. Under Data Tab, Click on Protect Sheet D. Under the Review Tab, Click on Protect Sheet 5 / 15 5. Which function is used to trap and handle errors? A. IFERROR() B. ERROR() C. IFNA() D. IFTRAP() 6 / 15 6. 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 7 / 15 7. Which function is used to create a date with year, month, and day? A. DATE() B. DATEDIF() C. DATEVALUE() D. CURDATE() 8 / 15 8. Which of the following is NOT a box in the PivotTable Fields List? A. Column Labels B. Report Filter C. Values D. Formulas 9 / 15 9. What is the keyboard shortcut to insert a SUM formula in MS Excel? A. CTRL + = B. ALT + = C. ALT + S D. CTRL + ALT + = 10 / 15 10. Which function is used to get the location of text in a string in MS Excel? A. FIND() B. INDEX() C. SEARCH() D. STRINGSEARCH() 11 / 15 11. Which function is used to get a date n working days in the future or past? A. WORKDAY() B. DAY() C. WORKDATE() D. DAYM() 12 / 15 12. Which function is used to remove extra spaces from the text in MS Excel? A. REMOVE() B. TRIM() C. TRUNC() D. All of the above 13 / 15 13. Under which tab and in which function group will you find the option to insert a Pivot Table? A. Under the Insert tab in the Tables group B. Under the Formulas tab in the Data Analysis group C. In the Data group in the Pivot Tables group D. In the Data group in the Tables group 14 / 15 14. What is the correct syntax of IF() function? A. =IF (logical_test, {[value_if_true]}, {[value_if_flse]}) B. =IF (logical_test, TRUE([value_if_true]), FALSE([value_if_false])) C. =IF (logical_test: [value_if_true], [value_if_false]) D. =IF (logical_test, [value_if_true], [value_if_false]) 15 / 15 15. 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 Your score is The average score is 44% LinkedIn Facebook Twitter VKontakte Restart quiz Questions, Quiz