Excel Questions March 14, 2023 | No Comments 0 votes, 0 avg 29 123456789101112131415 Excel Questions 1 / 15 1. What is the keyboard shortcut for creating a chart from the selected cell range? A. F2 B. F4 C. F8 D. F11 2 / 15 2. Which logical function returns TRUE if all arguments evaluate TRUE; FALSE if not? A. OR B. AND C. IF D. ANDIF 3 / 15 3. The ____ function is used to convert to text in a number format in MS Excel. A. CONVERT() B. TEXT() C. NUM() D. CONVERTTEXT() 4 / 15 4. The NOW function calculates the difference in days between two dates. A. true B. false 5 / 15 5. Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used when there are more than two columns in the array A. CountIF B. NOW C. Lookup D. VLookup 6 / 15 6. 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 7 / 15 7. 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 8 / 15 8. What is the correct value of the function? =ROUND (1.9867,2) A. 1.98 B. 1.99 C. 2 D. 1 9 / 15 9. What dialog box allows you to change a field name in a PivotTable? A. Field Options B. Field Pane C. Field Settings D. Field Structure 10 / 15 10. How can we provide a dynamic range in ‘data Source’ of pivot tables? A. Create a Named range using Offset function B. Base the pivot table using the Named range created in Step 1 C. Both A and B D. None 11 / 15 11. 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 12 / 15 12. 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 13 / 15 13. 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]) 14 / 15 14. Excel is a program that is used to prepare a A. Slide presentation B. Spreadsheet C. Text document D. Database 15 / 15 15. What function displays row data in a column or column data in a row? A. Hyperlink B. Index C. Transpose D. Rows Your score is The average score is 58% LinkedIn Facebook Twitter VKontakte Restart quiz Questions, Quiz