Excel Test 0 votes, 0 avg 151 123456789101112131415 Excel Questions 1 / 15 1. 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 2 / 15 2. Which function returns the current date? A. Lookup B. VLookup C. CountIF D. NOW 3 / 15 3. Which option is used to quickly convert a range of cells to a table with its own style converted in MS Excel? A. Table Styles B. Stylish Cells C. Format as Table D. Cells as Table 4 / 15 4. Under which Tab, the chart options are available in MS Excel? A. Data B. Insert C. Review D. View 5 / 15 5. 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 6 / 15 6. _____ are equations that perform calculations on values in your worksheet. A. Functions B. References C. Formulas D. Constants 7 / 15 7. Statistical calculations and preparation of tables and graphs can be done using A. Adobe Photoshop B. Excel C. Notepad D. Power Point 8 / 15 8. The NOW function calculates the difference in days between two dates. A. true B. false 9 / 15 9. Excel is a program that is used to prepare a A. Slide presentation B. Spreadsheet C. Text document D. Database 10 / 15 10. 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 11 / 15 11. Which function will you use to enter current date and time in a worksheet cell? A. =today() B. =now() C. =time() D. =currentTime() 12 / 15 12. Which bar show the used formula of selected active cell? A. Formula bar B. Ribbon C. Menu bar D. Scroll bar 13 / 15 13. The intersection of a column and a row in a worksheet is called ____. A. Box B. Cell C. Range D. Page Break 14 / 15 14. An array is a systematic arrangement of similar objects, usually in rows and columns. A. true B. false 15 / 15 15. 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]) Your score isThe average score is 43% LinkedIn Facebook VKontakte Restart quiz By Wordpress Quiz plugin