## MS EXCEL MCQs

### Ms Excel

Total Questions : 506 | Page 50 of 51 pages
Question 491. Which functionin Excel checks whether a condition is true or not ?
1.    SUM
2.    COUNT
3.    IF
4.    AVERAGE
Answer: Option C. -> IF
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 492. 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.
Answer: Option A. -> A, B, C, etc
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 493. What type of chart is useful for showing trends or changes over time ?
1.    Pie Chart
2.    Column Chart
3.    Line Chart
4.    Dot Graph
Answer: Option C. -> Line Chart
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 494. The Greater Than sign (>) is an example of _____ operator.
1.    Arithmatic
2.    Logical
3.    Conditional
4.    Greater
Answer: Option B. -> Logical
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 495. How will you graphically represent expenditure in different departments ?
1.    Column Chart
2.    Line Chart
3.    Pie Chart
4.    Dot Chart
Answer: Option C. -> Pie Chart
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 496. What type of chart is good for single series of data ?
1.    Column Chart
2.    Line Chart
3.    Pie Chart
4.    Cone Chart
Answer: Option C. -> Pie Chart
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 497. In Excel, Rows are labelled as ______
1.    A, B, C, etc
2.    1,2,3 etc
3.    A1, A2, etc.
4.    $A$1, $A$2, etc.
Answer: Option B. -> 1,2,3 etc
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 498. What type of chart is useful for comparing parts of a whole ?
1.    Pie Chart
2.    Column Chart
3.    Line Chart
4.    Dot Graph
Answer: Option A. -> Pie Chart
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 499. The ____ feature of MS Excel quickly completes a series of data
1.    Auto Complete
2.    Auto Fill
3.    Fill Handle
4.    Sorting
Answer: Option B. -> Auto Fill
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 500. The process of arrenging the items of a column in some sequence or order is known as :
1.    Arrengin
2.    Autofill
3.    Sorting
4.    Filtering
Answer: Option C. -> Sorting
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!