MS-Excel Questions Mcq’s

Computer Education

Q:1What is the intersection of a column and a row on a worksheet called ?
Ans:1   a.) Column   b.) Value   c.) Address   d.) Cell
Q:2What type of chart is useful for comparing values over categories ?
Ans:2   a.) Pie Chart   b.) Column Chart   c.) Line Chart   d.) Dot Chart
Q:3Which functionin Excel tells how many numeric entries are there ?
Ans:3   a.) NUM   b.) COUNT   c.) SUM   d.) CHKNUM
Q:4A features that displays only the data in column (s) according to specified criteria
Ans:4   a.) Formula   b.) Sorting   c.) Filtering   d.) Pivot
Q:5Statistical calculations and preparation of tables and graphs can be done using
Ans:5   a.) Adobe Photoshop   b.) Excel   c.) Notepad   d.) Power Point
Q:6What type of chart will you use to compare performance of two employees in the year 2016 ?
Ans:6   a.) Column Chart   b.) Line Chart   c.) Pie Chart   d.) Dot Chart
Q:7Which one is not a Function in MS Excel ?
Ans:7   a.) SUM   b.) AVG   c.) MAX   d.) MIN
Q:8Functions in MS Excel must begin with ___
Ans:8   a.) An () sign   b.) A Plus Sign   c.) An Equal Sign   d.) A > Sign
Q:9Which functionin Excel checks whether a condition is true or not ?
Ans:9   a.) SUM   b.) COUNT   c.) IF   d.) AVERAGE
Q:10In Excel, Columns are labelled as ___
Ans:10   a.) A, B, C, etc   b.) 1,2,3 etc   c.) A1, A2, etc.   d.) $A$1, $A$2, etc.
Q:11The Greater Than sign (>) is an example of _____ operator.
Ans:11   a.) Arithmatic   b.) Logical   c.) Conditional   d.) Greater
Q:12What type of chart is useful for showing trends or changes over time ?
Ans:12   a.) Pie Chart   b.) Column Chart   c.) Line Chart   d.) Dot Graph
Q:13The process of arrenging the items of a column in some sequence or order is known as :
Ans:13   a.) Arrengin   b.) Autofill   c.) Sorting   d.) Filtering
Q:14The ____ feature of MS Excel quickly completes a series of data
Ans:14   a.) Auto Complete   b.) Auto Fill   c.) Fill Handle   d.) Sorting
Q:15What type of chart is useful for comparing parts of a whole ?
Ans:15   a.) Pie Chart   b.) Column Chart   c.) Line Chart   d.) Dot Graph
Q:16In Excel, Rows are labelled as ______
Ans:16   a.) A, B, C, etc   b.) 1,2,3 etc   c.) A1, A2, etc   d.) $A$1, $A$2, etc.
Q:17What do you use to create a chart?
Ans:17   a.) Pie Wizard   b.) Excel Wizard   c.) Data Wizard   d.) Chart Wizard
Q:18How will you graphically represent expenditure in different departments ?
Ans:18   a.) Column Chart   b.) Line Chart   c.) Pie Chart   d.) Dot Chart
Q:19What type of chart is good for single series of data ?
Ans:19   a.) Column Chart   b.) Line Chart   c.) Pie Chart   d.) Cone Chart
Q:20The basic unit of a worksheet into which you enter data in Excel is called a
Ans:20   a.) cell   b.) table   c.) box   d.) column
Q:21How many sheets are there, by default, when we create a new Excel file ?
Ans:21   a.) 1   b.) 3   c.) 5   d.) 10
Q:22In Excel, which one denoted a range from B1 through E5
Ans:22   a.) B1 – E5   b.) B1:E5   c.) B1 to E5   d.) B1$E5
Q:23An Excel file is generally called a / an :
Ans:23   a.) E-Spreadsheet   b.) Woorksheet   c.) Workbook   d.) Sheet
Q:24It is a collection of data that is stored electronically as a series of records in a table.
Ans:24   a.) spreadsheet   b.) presentation   c.) database   d.) MS Word
Q:25What type of chart will you use to compare performance of sales of two products ?
Ans:25   a.) Column Chart   b.) Line Chart   c.) Pie Chart   d.) Both A and B

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.