Excel Test 0 votes, 0 avg 75 123456789101112131415 Excel Questions 1 / 15 1. Excel is a program that is used to prepare a A. Slide presentation B. Spreadsheet C. Text document D. Database 2 / 15 2. You can select the current row in MS-Excel Worksheet by pressing? A. Ctrl + Space bar B. F8 + arrow key C. Shift + arrow key D. Shift + Space bar 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. This is not a function category in Excel. A. Logical B. Text C. Financial D. Data series 5 / 15 5. The ____ function is used to convert to text in a number format in MS Excel. A. CONVERT() B. TEXT() C. NUM() D. CONVERTTEXT() 6 / 15 6. 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]) 7 / 15 7. Which of the following is an example of text in a spreadsheet? A. 2763 B. Sales 1994 1995 C. =A1+A2+A3 D. .=sum (A1+A2+A3) 8 / 15 8. What command allows you to highlight the cell(s) in a data table that matches your set-up information? A. Cell Styles B. Conditional Formatting C. AutoFormatting D. Data Table Styles 9 / 15 9. What is the correct value of the function? =ROUND (1.9867,2) A. 1.98 B. 1.99 C. 2 D. 1 10 / 15 10. 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 11 / 15 11. Which function is used to trap and handle errors? A. IFERROR() B. ERROR() C. IFNA() D. IFTRAP() 12 / 15 12. What is the keyboard shortcut to insert a SUM formula in MS Excel? A. CTRL + = B. ALT + = C. ALT + S D. CTRL + ALT + = 13 / 15 13. 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 14 / 15 14. 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 15 / 15 15. MS-Excel uses the ______ Function when creating a data table A. Average B. Count C. Both of These D. Table Your score is The average score is 49% LinkedIn Facebook Twitter VKontakte Restart quiz
