Computer CourceMS EXCEL 100+ MCQ & Answer MS-EXCEL | page-10 | Computer Course MCQ And Answer January 29, 2025 DSN MARATHI 91. Repeats the last command or action A. Ctrl + C B. Ctrl + R C. Ctrl + U D. Ctrl + Y Answer Option : D 92. _____ are equations that perform calculations on values in your worksheet. A. Functions B. References C. Formulas D. Constants Answer Option : C 93. Press _____ to bring up search box. A. Shift + F3 B. Shift + F4 C. Shift + F5 D. Shift + F6 Answer Option : C 94. In ______ tab you will find AutoSum button. A. Formatting tab B. Formulas tab C. Standard tab D. Clipboard tab Answer Option : B 95. Press _____ to create a chart. A. F1 B. F5 C. F11 D. F12 Answer Option : C 96. While selecting multiple worksheets in Excel, the following key must also be used when clicking the sheet tab. A. Alt B. Ctrl C. Shift D. Insert Answer Option : B 97. This dialog box specifies or modifies the worksheet cell range containing data to be charted. A. Chart Location B. Chart Style C. Chart Options D. Chart Source Data Answer Option : D 98. Which of the following is the purpose of AutoSum? A. Display the sum of the selected cells directly after the selected cells B. Display the sum of the selected cells directly before the selected cells C. Don’t add the grand total D. All of these Answer Option : A 99. The default file extension of MS Excel is A. Xlr B. Exe C. Xls D. Exl Answer Option : C 100. By default the cell content alignment is A. Text left aligned and number right alignment B. Text right aligned and numbers left alignment C. Left aligned D. Centrally aligned Answer Option : A
91. Repeats the last command or action A. Ctrl + C B. Ctrl + R C. Ctrl + U D. Ctrl + Y Answer Option : D
92. _____ are equations that perform calculations on values in your worksheet. A. Functions B. References C. Formulas D. Constants Answer Option : C
93. Press _____ to bring up search box. A. Shift + F3 B. Shift + F4 C. Shift + F5 D. Shift + F6 Answer Option : C
94. In ______ tab you will find AutoSum button. A. Formatting tab B. Formulas tab C. Standard tab D. Clipboard tab Answer Option : B
96. While selecting multiple worksheets in Excel, the following key must also be used when clicking the sheet tab. A. Alt B. Ctrl C. Shift D. Insert Answer Option : B
97. This dialog box specifies or modifies the worksheet cell range containing data to be charted. A. Chart Location B. Chart Style C. Chart Options D. Chart Source Data Answer Option : D
98. Which of the following is the purpose of AutoSum? A. Display the sum of the selected cells directly after the selected cells B. Display the sum of the selected cells directly before the selected cells C. Don’t add the grand total D. All of these Answer Option : A
100. By default the cell content alignment is A. Text left aligned and number right alignment B. Text right aligned and numbers left alignment C. Left aligned D. Centrally aligned Answer Option : A
