Excel Test 0 votes, 0 avg 29 123456789101112131415 Excel Questions 1 / 15 1. What is the keyboard shortcut to insert a SUM formula in MS Excel? A. CTRL + = B. ALT + = C. ALT + S D. CTRL + ALT + = 2 / 15 2. 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 3 / 15 3. Under which Tab, the chart options are available in MS Excel? A. Data B. Insert C. Review D. View 4 / 15 4. What function displays row data in a column or column data in a row? A. Hyperlink B. Index C. Transpose D. Rows 5 / 15 5. The total number of rows in a worksheet? A. Unlimited B. 65,535 C. 1,048,576 D. 1,068,576 6 / 15 6. Which option displays the total number of cells, formulas, charts, tables, sheets, etc. in a Workbook? A. Workbook Statistics B. Statistics C. Excel Statistics D. Workbook Analysis 7 / 15 7. _____ are equations that perform calculations on values in your worksheet. A. Functions B. References C. Formulas D. Constants 8 / 15 8. What is the extension of a Microsoft Excel file? A. msxcl B. xcl C. xlsx D. xlsm 9 / 15 9. Statistical calculations and preparation of tables and graphs can be done using A. Adobe Photoshop B. Excel C. Notepad D. Power Point 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. 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 12 / 15 12. The intersection of a column and a row in a worksheet is called ____. A. Box B. Cell C. Range D. Page Break 13 / 15 13. Excel is a program that is used to prepare a A. Slide presentation B. Spreadsheet C. Text document D. Database 14 / 15 14. 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 15 / 15 15. What is the correct value of the function? =ROUND (1.9867,2) A. 1.98 B. 1.99 C. 2 D. 1 Your score is The average score is 58% LinkedIn Facebook Twitter VKontakte Restart quiz