Excel Test 0 votes, 0 avg 162 123456789101112131415 Excel Questions 1 / 15 1. 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 2 / 15 2. Which logical function returns TRUE if one or more arguments evaluates to TRUE; FALSE if all arguments evaluate to FALSE? A. OR B. AND C. IF D. ANDIF 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. What is the collection of worksheets called? A. Ledger B. Book C. Testbook D. Workbook 5 / 15 5. Press _____ to bring up search box. A. Shift + F3 B. Shift + F4 C. Shift + F5 D. Shift + F6 6 / 15 6. The total number of rows in a worksheet? A. Unlimited B. 65,535 C. 1,048,576 D. 1,068,576 7 / 15 7. Which function is used to get days, months, or years between two dates? A. DATE() B. DATEDIF() C. DATEVALUE() D. CURDATE() 8 / 15 8. Getting data from a cell located in a different worksheet is called? A. Accessing B. Referencing C. Updating D. Functioning 9 / 15 9. ____ appear at the bottom of the Excel window. A. Title bar B. Formula bar C. Work sheet tabs D. Name box 10 / 15 10. 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 11 / 15 11. IF Statement can be written to carry out an action A. true B. false 12 / 15 12. This is not a function category in Excel. A. Logical B. Text C. Financial D. Data series 13 / 15 13. A function inside other function is called A. Nested Function B. Round Function C. Inner Function D. None of the above 14 / 15 14. 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 15 / 15 15. What is the keyboard shortcut to insert a SUM formula in MS Excel? A. CTRL + = B. ALT + = C. ALT + S D. CTRL + ALT + = Your score isThe average score is 44% LinkedIn Facebook VKontakte Restart quiz By Wordpress Quiz plugin
