MS Excel Mcqs

MCQ: What is the intersection of a column and a row on a worksheet called ?

1. Column
2. Value
3. Address
4. Cell

MCQ: What type of chart is useful for comparing values over categories ?

1. Pie Chart
2. Column Chart
3. Line Chart
4. Dot Graph

MCQ: Which functionin Excel tells how many numeric entries are there ?

1. NUM
2. COUNT
3. SUM
4. CHKNUM

MCQ: A features that displays only the data in column (s) according to specified criteria

1. Formula
2. Sorting
3. Filtering
4. Pivot

MCQ: Statistical calculations and preparation of tables and graphs can be done using

1. Adobe Photoshop
2. Excel
3. Notepad
4. Power Point

MCQ: What type of chart will you use to compare performance of two employees in the year 2016 ?

1. Column Chart
2. Line Chart
3. Pie Chart
4. Dot Chart

MCQ: Which one is not a Function in MS Excel ?

1. SUM
2. AVG
3. MAX
4. MIN

MCQ: Functions in MS Excel must begin with ___

1. An () sign
2. An Equal Sign
3. A Plus Sign
4. A > Sign

MCQ: Which functionin Excel checks whether a condition is true or not ?

1. SUM
2. COUNT
3. IF
4. AVERAGE

MCQ: In Excel, Columns are labelled as ___

1. A, B, C, etc
2. 1,2,3 etc
3. A1, A2, etc.
4. $A$1, $A$2, etc.