MS EXCEL

MS Excel Questions Answers (MCQ -Multiple Choice, Objective Type) Online test : Microsoft Excel is a spreadsheet software and is part of the widely used MS Office Package. Here you will find a great collection of Multiple Choice (MCQ)Questions in the category of Microsoft Excel with answer. Most of the questions are applicable to all […]

01. ____ appear at the bottom of the Excel window. A. Title bar B. Formula bar C. Work sheet tabs D. Name box Answer Option : C 02. What are the basic rectangular building blocks of a spreadsheet? A. Cells B. Zoom slider C. Help button D. All of these Answer Option : A 03.

11. When the CPU detects an interrupt, then it saves its A. Previous state B. Next state C. Current state D. All of the above Answer Option : C 12. A(n) ____ is a series of two or more adjacent cells in a column or row or rectangular group of cells. A. List B. Section

21. What is the default row height of MS Excel? A. 10 B. 12 C. 13 D. 15 Answer Option : D 22. Excel documents are stored as files called A. Workgroups B. Worktables C. Worksheets D. Workforce Answer Option : C 23. What refers to the horizontal cells which can contain information? A. Ribbon

31. ____ is a powerful tool used to create and format spreadsheets. A. Adobe Photoshop CS B. Mozilla Firefox C. Microsoft Office PowerPoint D. Microsoft Office Excel Answer Option : D 32. Workbook is a collection of A. Worksheets B. Page set-up C. Buttons D. Diagrams Answer Option : A 33. The worksheet names appear

41. ____ is rectangular grid of rows and columns used to enter data. A. Cell B. Spreadsheet C. Worksheet D. Workspace Answer Option : B 42. How many rows are there in old version of MS Excel? A. 65536 B. 65535 C. 65534 D. 65533 Answer Option : A 43. ____ was the first spreadsheet

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

61. DOS based spreadsheet package is A. Smartsheet B. Excel C. Spread PRO D. Lotus 1-2-3 Answer Option : D 62. When we can create a chart on a separate sheet in the same workbook, it is called a A. Chart sheet B. Embedded chart C. View sheet D. View chart Answer Option : A

71. Press ___ to close an open menu or submenu, dialog box, or message window. A. Tab+ctrl+6 B. Esc C. Alt+ 5 D. Ctrl+ 1 Answer Option : B 72. To insert nonadjacent columns, hold down ____ while you select nonadjacent columns. A. Space B. Ctrl C. Tab D. Alt Answer Option : B 73.

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 :

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