Excel Test 0 votes, 0 avg 173 123456789101112131415 Excel Questions 1 / 15 1. Excel is a program that is used to prepare a A. Slide presentation B. Spreadsheet C. Text document D. Database 2 / 15 2. Excel is a ____ program developed by Microsoft. A. Spreadsheet B. Document C. Data management D. All of the above 3 / 15 3. 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 4 / 15 4. The currently selected cell address is displayed in ____. A. Name Box B. Formula Bar C. Both A and B D. None of the above 5 / 15 5. 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 6 / 15 6. The ____ function is used to convert to text in a number format in MS Excel. A. CONVERT() B. TEXT() C. NUM() D. CONVERTTEXT() 7 / 15 7. An array is a systematic arrangement of similar objects, usually in rows and columns. A. true B. false 8 / 15 8. What is the collection of worksheets called? A. Ledger B. Book C. Testbook D. Workbook 9 / 15 9. 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 10 / 15 10. A worksheet range is a A. A command used for data modeling B. A range of values such as from 23 to 234 C. A group of cells D. A group of worksheets 11 / 15 11. Statistical calculations and preparation of tables and graphs can be done using A. Adobe Photoshop B. Excel C. Notepad D. Power Point 12 / 15 12. Which option allows you to display all numbers which are less than 0 (negative numbers) in red color in MS Excel? A. Styling B. Conditional Formatting C. Compare Formatting D. Special Formatting 13 / 15 13. Which function will you use to enter current date and time in a worksheet cell? A. =today() B. =now() C. =time() D. =currentTime() 14 / 15 14. Which bar show the used formula of selected active cell? A. Formula bar B. Ribbon C. Menu bar D. Scroll bar 15 / 15 15. 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 Your score isThe average score is 43% LinkedIn Facebook VKontakte Restart quiz By Wordpress Quiz plugin
