Computer CourceMS EXCEL 100+ MCQ & Answer MS-EXCEL | page-09 | Computer Course MCQ And Answer January 29, 2025 DSN MARATHI 81. To select the entire column, press A. Tab + C B. Tab + E C. Alt + Space D. Ctrl + Space Answer Option : D 82. What is a valid version of MS Excel? A. MS Excel 2007 B. MS Excel 20.16 C. MS Excel XP D. MS Excel 20.0.1 Answer Option : A 83. In A3 cell edit = A1 + A2 refers to A. Addition of A1 and A3 will display in A2 B. Addition of A1 and A2 will display in A3 C. Addition of A1 and A2 will not display in A3 D. Addition of A2 and A3 will display in A1 Answer Option : B 84. ______ specify the type of calculation that you want to perform on the elements of a formula. A. Constants B. References C. Operators D. All of these Answer Option : C 85. When you enter text in a cell in Excel. It also appears in the A. Status bar B. Formula bar C. Row heading D. Name box Answer Option : B 86. The view that puts a blue line around each page that would be printed is the A. Split view B. Page break preview C. Print preview D. Normal view Answer Option : B 87. Cuts the selected cells A. Ctrl + X B. Ctrl + C C. Ctrl + V D. Ctrl + B Answer Option : A 88. Press the ______ key to move the insertion point to the first cell in a row in Excel. A. Page Up B. Page Down C. Home D. Tab Answer Option : C 89. ______ of the worksheet appear vertically and are identified by letters at the top of the worksheet window. A. Columns B. Cells C. Rows D. Headings Answer Option : A 90. Press _____ to select all rows and columns in the worksheet. A. Ctrl + A B. Ctrl + B C. Ctrl + C D. Ctrl + D Answer Option : A
81. To select the entire column, press A. Tab + C B. Tab + E C. Alt + Space D. Ctrl + Space Answer Option : D
82. What is a valid version of MS Excel? A. MS Excel 2007 B. MS Excel 20.16 C. MS Excel XP D. MS Excel 20.0.1 Answer Option : A
83. In A3 cell edit = A1 + A2 refers to A. Addition of A1 and A3 will display in A2 B. Addition of A1 and A2 will display in A3 C. Addition of A1 and A2 will not display in A3 D. Addition of A2 and A3 will display in A1 Answer Option : B
84. ______ specify the type of calculation that you want to perform on the elements of a formula. A. Constants B. References C. Operators D. All of these Answer Option : C
85. When you enter text in a cell in Excel. It also appears in the A. Status bar B. Formula bar C. Row heading D. Name box Answer Option : B
86. The view that puts a blue line around each page that would be printed is the A. Split view B. Page break preview C. Print preview D. Normal view Answer Option : B
88. Press the ______ key to move the insertion point to the first cell in a row in Excel. A. Page Up B. Page Down C. Home D. Tab Answer Option : C
89. ______ of the worksheet appear vertically and are identified by letters at the top of the worksheet window. A. Columns B. Cells C. Rows D. Headings Answer Option : A
90. Press _____ to select all rows and columns in the worksheet. A. Ctrl + A B. Ctrl + B C. Ctrl + C D. Ctrl + D Answer Option : A
