Computer CourceMS EXCEL 100+ MCQ & Answer MS-EXCEL | page-06 | Computer Course MCQ And Answer January 29, 2025 DSN MARATHI 51. The fill series dialog box in Excel has ____ sections. A. 1 B. 2 C. 3 D. 4 Answer Option : D 52. Which of the following is an active cell in excel? A. Cell address B. Range C. Formula D. Current cell Answer Option : D 53. What is the pictorial representation of worksheet data? A. Chart B. Clipart C. WordArt D. All of these Answer Option : A 54. Which function displays row data in a column or column data in a row? A. Rows B. Transpose C. Hyperlink D. Index Answer Option : B 55. ___ operator, combines multiple references into one reference. A. Ampersand B. Space C. Comma D. Colon Answer Option : C 56. ______ inserts a new worksheet. A. Alt + Shift + F1 B. Alt + Shift + F2 C. Alt + Shift + F3 D. Alt + Shift + F4 Answer Option : A 57. _____ creates a chart of the data in the current range. A. Alt + F1 B. Ctrl + F1 C. Ctrl + Alt + F1 D. Esc + F1 Answer Option : A 58. Which sign is used for absolute addressing? A. @ B. $ C. & D. * Answer Option : B 59. Press ______ to open the Excel formula window. A. Shift + F3 B. Shift + F4 C. Shift + F5 D. Shift + F6 Answer Option : A 60. A spreadsheet is a sheet which is spread in such a way that it divides itself into the various _____ and ______ A. Horizontal columns, vertical row B. Horizontal table, vertical cell C. Horizontal cell, vertical table D. Horizontal row, vertical columns Answer Option : D
52. Which of the following is an active cell in excel? A. Cell address B. Range C. Formula D. Current cell Answer Option : D
53. What is the pictorial representation of worksheet data? A. Chart B. Clipart C. WordArt D. All of these Answer Option : A
54. Which function displays row data in a column or column data in a row? A. Rows B. Transpose C. Hyperlink D. Index Answer Option : B
55. ___ operator, combines multiple references into one reference. A. Ampersand B. Space C. Comma D. Colon Answer Option : C
56. ______ inserts a new worksheet. A. Alt + Shift + F1 B. Alt + Shift + F2 C. Alt + Shift + F3 D. Alt + Shift + F4 Answer Option : A
57. _____ creates a chart of the data in the current range. A. Alt + F1 B. Ctrl + F1 C. Ctrl + Alt + F1 D. Esc + F1 Answer Option : A
59. Press ______ to open the Excel formula window. A. Shift + F3 B. Shift + F4 C. Shift + F5 D. Shift + F6 Answer Option : A
60. A spreadsheet is a sheet which is spread in such a way that it divides itself into the various _____ and ______ A. Horizontal columns, vertical row B. Horizontal table, vertical cell C. Horizontal cell, vertical table D. Horizontal row, vertical columns Answer Option : D
