Excel Test 0 votes, 0 avg 148 123456789101112131415 Excel Questions 1 / 15 1. Which function is used to create a date with year, month, and day? A. DATE() B. DATEDIF() C. DATEVALUE() D. CURDATE() 2 / 15 2. In ______ tab you will find AutoSum button. A. Formatting tab B. Formulas tab C. Standard tab D. Clipboard tab 3 / 15 3. IF Statement can be written to carry out an action A. true B. false 4 / 15 4. Which function is used to get days, months, or years between two dates? A. DATE() B. DATEDIF() C. DATEVALUE() D. CURDATE() 5 / 15 5. ____ appear at the bottom of the Excel window. A. Title bar B. Formula bar C. Work sheet tabs D. Name box 6 / 15 6. MS-Excel uses the ______ Function when creating a data table A. Average B. Count C. Both of These D. Table 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. The total number of rows in a worksheet? A. Unlimited B. 65,535 C. 1,048,576 D. 1,068,576 9 / 15 9. What is the keyboard shortcut for creating a chart from the selected cell range? A. F2 B. F4 C. F8 D. F11 10 / 15 10. Which function is used to trap and handle errors? A. IFERROR() B. ERROR() C. IFNA() D. IFTRAP() 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 get the location of text in a string in MS Excel? A. FIND() B. INDEX() C. SEARCH() D. STRINGSEARCH() 13 / 15 13. 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 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. Excel is a program that is used to prepare a A. Slide presentation B. Spreadsheet C. Text document D. Database Your score isThe average score is 43% LinkedIn Facebook VKontakte Restart quiz By Wordpress Quiz plugin
