Enter to Study the Microsoft Excel MCQs for FPSC, PPSC, SPSC, KPSC, BPSC, NTS, and PTS Job Test Preparation.
Microsoft Excel MCQs Test. Microsoft Excel is a spreadsheet software designed by Microsoft. In this test we added important MCQs related to MS Excel Application. This MS Excel MCQs Online Test will be helpful for competitive exams like FPSC, PPSC, SPSC, KPSC, BPSC, NTS, and PTS. Most of the MCQs will be applicable to Office XP, Office 97-2003, Office 2010, Office 2013, Office 2016, and other versions of MS Office. MS Office is a collection of application programs developed by Microsoft corporation that includes MS Word, MS Excel, PowerPoint and MS Access.
- [message]
- Instructions:
- Choose your answer carefully on the basis of previous knowledge. Click on the Option (A, B, C, D) to Choose your Answer. Then Click on Show Answer for Correct Option.
Q. How many sheets are there, by default, when we create a new Excel file ?A. 1 B. 3 C. 5 D. 10 Show Answer |
Q. In Excel, which one denoted a range from B1 through E5A. B1 - E5 B. B1:E5 C. B1 to E5 D. B1$E5 Show Answer |
Q. An Excel file is generally called a / an :A. E-Spreadsheet B. Woorksheet C. Workbook D. Sheet Show Answer |
Q. It is a collection of data that is stored electronically as a series of records in a table.A. spreadsheet B. presentation C. database D. MS Word Show Answer |
Q. What type of chart will you use to compare performance of sales of two products ?A. Column Chart B. Line Chart C. Pie Chart D. Both A and B Show Answer |
Q. The Greater Than sign (>) is an example of _____ operator.A. Arithmatic B. Logical C. Conditional D. Greater Show Answer |
Q. What type of chart is useful for showing trends or changes over time ?A. Pie Chart B. Column Chart C. Line Chart D. Dot Graph Show Answer |
Q. The process of arrenging the items of a column in some sequence or order is known as :A. Arrengin B. Autofill C. Sorting D. Filtering Show Answer |
Q. The ____ feature of MS Excel quickly completes a series of dataA. Auto Complete B. Auto Fill C. Fill Handle D. Sorting Show Answer |
Q. What type of chart is useful for comparing parts of a whole ?A. Pie Chart B. Column Chart C. Line Chart D. Dot Graph Show Answer |
Q. What is the intersection of a column and a row on a worksheet called ?A. Column B. Value C. Address D. Cell Show Answer |
Q. What type of chart is useful for comparing values over categories ?A. Pie Chart B. Column Chart C. Line Chart D. Dot Graph Show Answer |
Q. Which functionin Excel tells how many numeric entries are there ?A. NUM B. COUNT C. SUM D. CHKNUM Show Answer |
Q. A features that displays only the data in column (s) according to specified criteriaA. Formula B. Sorting C. Filtering D. Pivot Show Answer |
Q. Statistical calculations and preparation of tables and graphs can be done usingA. Adobe Photoshop B. Excel C. Notepad D. Power Point Show Answer |
Q. In Excel, Rows are labelled as ______A. A, B, C, etc B. 1,2,3 etc C. A1, A2, etc. D. $A$1, $A$2, etc. Show Answer |
Q. What do you use to create a chart?A. Pie Wizard B. Excel Wizard C. Data Wizard D. Chart Wizard Show Answer |
Q. How will you graphically represent expenditure in different departments ?A. Column Chart B. Line Chart C. Pie Chart D. Dot Chart Show Answer |
Q. What type of chart is good for single series of data ?A. Column Chart B. Line Chart C. Pie Chart D. Cone Chart Show Answer |
Q. The basic unit of a worksheet into which you enter data in Excel is called aA. cell B. table C. box D. column Show Answer |
Q. What type of chart will you use to compare performance of two employees in the year 2016 ?A. Column Chart B. Line Chart C. Pie Chart D. Dot Chart Show Answer |
Q. Which one is not a Function in MS Excel ?A. SUM B. AVG C. MAX D. MIN Show Answer |
Q. Functions in MS Excel must begin with ___A. An () sign B. An Equal Sign C. A Plus Sign D. A > Sign Show Answer |
Q. Which functionin Excel checks whether a condition is true or not ?A. SUM B. COUNT C. IF D. AVERAGE Show Answer |
Q. In Excel, Columns are labelled as ___A. A, B, C, etc B. 1,2,3 etc C. A1, A2, etc. D. $A$1, $A$2, etc. Show Answer |
COMMENTS