Microsoft Excel is a spreadsheet program. It’s mainly used to create grids of text, numbers, and formulas specifying calculations. MCQs on MS Excel section, you will find a collection of Multiple Choice Questions to test your knowledge on Microsoft Excel with answers. All these ms excel MCQs are applicable for all versions of Excel ( Excel 97-2003, 2007, 2010,2013, 2016, etc.). Furthermore, the questions present in the MS Excel MCQs section will be beneficial for competitive examinations and tests (PPSC Test, FPSC Test, SPSC Test, KPPSC Test, BPSC Test, and other Test) as well. Most of the time, these types of questions are asked in the basic computer awareness and computer operation section. Also, check MS Word MCQs here.

1.In Ms Excel, which of the following special function keys allow the content in cell? 

A. Shift
B. Esc
C. Tab
D. Space

2.  Which of the following is the latest version of MS Excel? 

A. Excel 2016
B. Excel 2017
C. Excel 2019
D. Office 365

3.  Which shortcut key is used for calculating current sheet in Ms Excel?

A. Ctrl+F9
B. Shift+F9
C. F9
D. F7

4. Title bar in MS-Excel displays name of the __________ ? 

A. Worksheet
B. Workbook
C. Formula
D. Location

5. In MS-Excel__________ short cut key is used for hiding rows. 

A. Ctrl+H
B. Ctrl+7
C. Ctrl+9
D. None of the above

6. User developed instruction for excel are called__________?

A. Progrms
B. Macros
C. Procedured
D. All of these

7. How many rows are in one Microsoft Excel sheet?

A. 65,536
B. 16,384
C. 1,048,576
D. None of Above

8. How many columns are in one Microsoft Excel sheet? 

A. 65,536
B. 16,384
C. 1,048,576
D. None of Above

9. With which of the following all formulas in excel starts ? 

A. /
B. *
C. $
D. =

10. Title bar in MS-Excel displays name of the __________ ? 

A. Worksheet
B. Workbook
C. Formula
D. Location

Leave a Reply