Excel Questions March 14, 2023 | No Comments 0 votes, 0 avg 139 123456789101112131415 Excel Questions 1 / 15 1. IF Statement can be written to carry out an action A. true B. false 2 / 15 2. Excel is a program that is used to prepare a A. Slide presentation B. Spreadsheet C. Text document D. Database 3 / 15 3. The intersection of a column and a row in a worksheet is called ____. A. Box B. Cell C. Range D. Page Break 4 / 15 4. 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 5 / 15 5. The currently selected cell address is displayed in ____. A. Name Box B. Formula Bar C. Both A and B D. None of the above 6 / 15 6. An array is a systematic arrangement of similar objects, usually in rows and columns. A. true B. false 7 / 15 7. 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 8 / 15 8. 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 9 / 15 9. What is the correct value of the function? =ROUND (1.2345,2) A. 1.24 B. 1.23 C. 1. 25 D. 2 10 / 15 10. What is the correct syntax of IF() function? A. =IF (logical_test, {[value_if_true]}, {[value_if_flse]}) B. =IF (logical_test, TRUE([value_if_true]), FALSE([value_if_false])) C. =IF (logical_test: [value_if_true], [value_if_false]) D. =IF (logical_test, [value_if_true], [value_if_false]) 11 / 15 11. What function displays row data in a column or column data in a row? A. Hyperlink B. Index C. Transpose D. Rows 12 / 15 12. The total number of columns in a worksheet? A. 26 B. 256 C. 12,834 D. 16,384 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 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 15 / 15 15. 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 Your score isThe average score is 43% LinkedIn Facebook VKontakte Restart quiz By WordPress Quiz plugin Questions, Quiz