Computer Science Quiz Test 4

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.

Instructions:

Choose your answer carefully on the basis of previous knowledge. Click on the Option (A, B, C, D) to Choose your Answer. For Next Question Click on “Next” Button and For Previous Question Click on “Prev” Button.

Start your test

Q1. How many sheets are there, by default, when we create a new Excel file?
Q2. In Excel, which one denoted a range from B1 through E5
Q3. An Excel file is generally called a / an:
Q4. It is a collection of data that is stored electronically as a series of records in a table.
Q5. What type of chart will you use to compare performance of sales of two products?
Q6. The Greater Than sign (>) is an example of _____ operator.
Q7. What type of chart is useful for showing trends or changes over time?
Q8. The process of arrenging the items of a column in some sequence or order is known as:
Q9. The ____ feature of MS Excel quickly completes a series of data
Q10. What type of chart is useful for comparing parts of a whole?
Q11. What is the intersection of a column and a row on a worksheet called?
Q12. What type of chart is useful for comparing values over categories?
Q13. Which functionin Excel tells how many numeric entries are there?
Q14. A features that displays only the data in column (s) according to specified criteria
Q15. Statistical calculations and preparation of tables and graphs can be done using
Q16. In Excel, Rows are labelled as ______
Q17. What do you use to create a chart?
Q18. How will you graphically represent expenditure in different departments?
Q19. What type of chart is good for single series of data?
Q20. The basic unit of a worksheet into which you enter data in Excel is called a
Q21. What type of chart will you use to compare performance of two employees in the year 2016?
Q22. Which one is not a Function in MS Excel?
Q23. Functions in MS Excel must begin with ______.
Q24. Which functionin Excel checks whether a condition is true or not?
Q25. In Excel, Columns are labelled as ______.

You might also like