Excel Questions March 14, 2023 | No Comments 0 votes, 0 avg 109 123456789101112131415 Excel Questions 1 / 15 1. A function inside other function is called A. Nested Function B. Round Function C. Inner Function D. None of the above 2 / 15 2. MS-Excel uses the ______ Function when creating a data table A. Average B. Count C. Both of These D. Table 3 / 15 3. What is the collection of worksheets called? A. Ledger B. Book C. Testbook D. Workbook 4 / 15 4. An array is a systematic arrangement of similar objects, usually in rows and columns. A. true B. false 5 / 15 5. 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 6 / 15 6. 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 7 / 15 7. ____ appear at the bottom of the Excel window. A. Title bar B. Formula bar C. Work sheet tabs D. Name box 8 / 15 8. Which function returns the current date? A. Lookup B. VLookup C. CountIF D. NOW 9 / 15 9. Which symbol is used to specify the fixed columns or rows in the formula? A. = B. * C. $ D. % 10 / 15 10. Which function is used to remove extra spaces from the text in MS Excel? A. REMOVE() B. TRIM() C. TRUNC() D. All of the above 11 / 15 11. 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 12 / 15 12. You can select the current row in MS-Excel Worksheet by pressing? A. Ctrl + Space bar B. F8 + arrow key C. Shift + arrow key D. Shift + Space bar 13 / 15 13. In MS-Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the _______ menu A. Edit B. Format C. Tools D. All of the above 14 / 15 14. The intersection of a column and a row in a worksheet is called ____. A. Box B. Cell C. Range D. Page Break 15 / 15 15. Which function is used to get a date n working days in the future or past? A. WORKDAY() B. DAY() C. WORKDATE() D. DAYM() Your score is The average score is 45% LinkedIn Facebook Twitter VKontakte Restart quiz Questions, Quiz
