Excel Test 0 votes, 0 avg 172 123456789101112131415 Excel Questions 1 / 15 1. 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) 2 / 15 2. What is the extension of a Microsoft Excel file? A. msxcl B. xcl C. xlsx D. xlsm 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. Which function will you use to enter current date and time in a worksheet cell? A. =today() B. =now() C. =time() D. =currentTime() 5 / 15 5. An array is a systematic arrangement of similar objects, usually in rows and columns. A. true B. false 6 / 15 6. What is the collection of worksheets called? A. Ledger B. Book C. Testbook D. Workbook 7 / 15 7. In ______ tab you will find AutoSum button. A. Formatting tab B. Formulas tab C. Standard tab D. Clipboard tab 8 / 15 8. The intersection of a column and a row in a worksheet is called ____. A. Box B. Cell C. Range D. Page Break 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. 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 11 / 15 11. Which function is used to get a date n working days in the future or past? A. WORKDAY() B. DAY() C. WORKDATE() D. DAYM() 12 / 15 12. Which logical function returns TRUE if all arguments evaluate TRUE; FALSE if not? A. OR B. AND C. IF D. ANDIF 13 / 15 13. _____ are equations that perform calculations on values in your worksheet. A. Functions B. References C. Formulas D. Constants 14 / 15 14. ____ appear at the bottom of the Excel window. A. Title bar B. Formula bar C. Work sheet tabs D. Name box 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 43% LinkedIn Facebook VKontakte Restart quiz By Wordpress Quiz plugin