Excel Test 0 votes, 0 avg 159 123456789101112131415 Excel Questions 1 / 15 1. 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 2 / 15 2. Which is not a Text function in MS Excel? A. CODE() B. CLEAN() C. CHAR() D. DB() 3 / 15 3. The currently selected cell address is displayed in ____. A. Name Box B. Formula Bar C. Both A and B D. None of the above 4 / 15 4. What is the keyboard shortcut to insert a new sheet in the current workbook in MS Excel? A. Shift + F9 B. Shift + F10 C. Shift + F12 D. Shift + F11 5 / 15 5. Which of the following is NOT a box in the PivotTable Fields List? A. Column Labels B. Report Filter C. Values D. Formulas 6 / 15 6. A features that displays only the data in column (s) according to specified criteria A. Formula B. Sorting C. Filtering D. Pivot 7 / 15 7. 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 8 / 15 8. Which function is used to get days, months, or years between two dates? A. DATE() B. DATEDIF() C. DATEVALUE() D. CURDATE() 9 / 15 9. When you insert an Excel file into a Word document, the data are A. Hyperlinked B. Placed in a word table C. Linked D. Embedded 10 / 15 10. Getting data from a cell located in a different worksheet is called? A. Accessing B. Referencing C. Updating D. Functioning 11 / 15 11. The ____ function is used to convert to text in a number format in MS Excel. A. CONVERT() B. TEXT() C. NUM() D. CONVERTTEXT() 12 / 15 12. 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 13 / 15 13. In ______ tab you will find AutoSum button. A. Formatting tab B. Formulas tab C. Standard tab D. Clipboard tab 14 / 15 14. 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 15 / 15 15. ____ appear at the bottom of the Excel window. A. Title bar B. Formula bar C. Work sheet tabs D. Name box Your score isThe average score is 44% LinkedIn Facebook VKontakte Restart quiz By Wordpress Quiz plugin
