Excel Questions March 14, 2023 | No Comments 0 votes, 0 avg 75 123456789101112131415 Excel Questions 1 / 15 1. 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 2 / 15 2. This is not a function category in Excel. A. Logical B. Text C. Financial D. Data series 3 / 15 3. Which function is used to create a date with year, month, and day? A. DATE() B. DATEDIF() C. DATEVALUE() D. CURDATE() 4 / 15 4. A features that displays only the data in column (s) according to specified criteria A. Formula B. Sorting C. Filtering D. Pivot 5 / 15 5. What is the keyboard shortcut to display the Format Cells dialog box in MS Excel? A. CTRL + F B. ALT + 1 C. CTRL + SHIFT + F D. CTRL + 1 6 / 15 6. The currently selected cell address is displayed in ____. A. Name Box B. Formula Bar C. Both A and B D. None of the above 7 / 15 7. 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 8 / 15 8. Which symbol is used to specify the fixed columns or rows in the formula? A. = B. * C. $ D. % 9 / 15 9. Which function is used to trap and handle errors? A. IFERROR() B. ERROR() C. IFNA() D. IFTRAP() 10 / 15 10. An array is a systematic arrangement of similar objects, usually in rows and columns. A. true B. false 11 / 15 11. What is the extension of a Microsoft Excel file? A. msxcl B. xcl C. xlsx D. xlsm 12 / 15 12. Which function is used to get the location of text in a string in MS Excel? A. FIND() B. INDEX() C. SEARCH() D. STRINGSEARCH() 13 / 15 13. You can select the current Column in MS-Excel Worksheet by pressing? A. Ctrl + Space bar B. F8 + arrow key C. Shift + arrow key D. Shift + Space bar 14 / 15 14. Shortcut key CTRL + D is used to ____. A. Open font dialog box B. Open format cells dialog box C. Shift current cell’s value in the right cell D. Fill down in the selection 15 / 15 15. A worksheet range is a A. A command used for data modeling B. A range of values such as from 23 to 234 C. A group of cells D. A group of worksheets Your score is The average score is 49% LinkedIn Facebook Twitter VKontakte Restart quiz Questions, Quiz
