Excel Test 0 votes, 0 avg 99 123456789101112131415 Excel Questions 1 / 15 1. Which function is used to return the number of cells in a range that meet a condition set forth in the formula? A. Lookup B. VLookup C. NOW D. CountIF 2 / 15 2. The NOW function calculates the difference in days between two dates. A. true B. false 3 / 15 3. 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 4 / 15 4. Which is not a Text function in MS Excel? A. CODE() B. CLEAN() C. CHAR() D. DB() 5 / 15 5. What is the extension of a Microsoft Excel file? A. msxcl B. xcl C. xlsx D. xlsm 6 / 15 6. _____ are equations that perform calculations on values in your worksheet. A. Functions B. References C. Formulas D. Constants 7 / 15 7. 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 8 / 15 8. A features that displays only the data in column (s) according to specified criteria A. Formula B. Sorting C. Filtering D. Pivot 9 / 15 9. 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) 10 / 15 10. IF Statement can be written to carry out an action A. true B. false 11 / 15 11. 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 12 / 15 12. 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 13 / 15 13. Which function will you use to enter current date and time in a worksheet cell? A. =today() B. =now() C. =time() D. =currentTime() 14 / 15 14. 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 15 / 15 15. Which programming language is used to write a Macro in MS Excel? A. C B. C++ C. Java D. Visual Basic Your score is The average score is 46% LinkedIn Facebook Twitter VKontakte Restart quiz