Excel Questions March 14, 2023 | No Comments 0 votes, 0 avg 154 123456789101112131415 Excel Questions 1 / 15 1. Which function returns the current date? A. Lookup B. VLookup C. CountIF D. NOW 2 / 15 2. What is the keyboard shortcut for creating a chart from the selected cell range? A. F2 B. F4 C. F8 D. F11 3 / 15 3. An array is a systematic arrangement of similar objects, usually in rows and columns. A. true B. false 4 / 15 4. The total number of rows in a worksheet? A. Unlimited B. 65,535 C. 1,048,576 D. 1,068,576 5 / 15 5. 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 6 / 15 6. In ______ tab you will find AutoSum button. A. Formatting tab B. Formulas tab C. Standard tab D. Clipboard tab 7 / 15 7. MS-Excel uses the ______ Function when creating a data table A. Average B. Count C. Both of These D. Table 8 / 15 8. 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 9 / 15 9. The ____ function is used to convert to text in a number format in MS Excel. A. CONVERT() B. TEXT() C. NUM() D. CONVERTTEXT() 10 / 15 10. The currently selected cell address is displayed in ____. A. Name Box B. Formula Bar C. Both A and B D. None of the above 11 / 15 11. What command allows you to highlight the cell(s) in a data table that matches your set-up information? A. Cell Styles B. Conditional Formatting C. AutoFormatting D. Data Table Styles 12 / 15 12. Advanced Functions are used in higher-level operations such as in conditional and comparison equations to compute interest rates, due dates and payment terms, and financial projections. A. true B. false 13 / 15 13. Which function is used to get the location of text in a string in MS Excel? A. FIND() B. INDEX() C. SEARCH() D. STRINGSEARCH() 14 / 15 14. Which function is used to remove extra spaces from the text in MS Excel? A. REMOVE() B. TRIM() C. TRUNC() D. All of the above 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 isThe average score is 44% LinkedIn Facebook VKontakte Restart quiz By WordPress Quiz plugin Questions, Quiz
