Excel Test 0 votes, 0 avg 118 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. What is the keyboard shortcut to display the Format Cells dialog box in MS Excel? A. CTRL + F B. ALT + 1 C. CTRL + SHIFT + F D. CTRL + 1 3 / 15 3. Steps for protecting a sheet by password in MS Excel? A. Under the Review Tab, Click on Protect Current Sheet B. Under Insert Tab, Click on Protect Sheet C. Under Data Tab, Click on Protect Sheet D. Under the Review Tab, Click on Protect Sheet 4 / 15 4. MS-Excel uses the ______ Function when creating a data table A. Average B. Count C. Both of These D. Table 5 / 15 5. Which of the following is an example of text in a spreadsheet? A. 2763 B. Sales 1994 1995 C. =A1+A2+A3 D. .=sum (A1+A2+A3) 6 / 15 6. What is the default file name of Microsoft Excel file? A. Workbook.xlsx B. Workbook1.xlsx C. Worksheet.xlsx D. Worksheet1.xlsx 7 / 15 7. What is the correct value of the function? =ROUND (1.9867,2) A. 1.98 B. 1.99 C. 2 D. 1 8 / 15 8. 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 9 / 15 9. _____ are equations that perform calculations on values in your worksheet. A. Functions B. References C. Formulas D. Constants 10 / 15 10. 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 11 / 15 11. This is not a function category in Excel. A. Logical B. Text C. Financial D. Data series 12 / 15 12. What function will result in the total number of entries in the cell range B5 to B14 A. Count B. MAX C. MIN D. SUM 13 / 15 13. 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 14 / 15 14. 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 15 / 15 15. In ______ tab you will find AutoSum button. A. Formatting tab B. Formulas tab C. Standard tab D. Clipboard tab Your score is The average score is 45% LinkedIn Facebook Twitter VKontakte Restart quiz