Here is the MCQs guide for the topic of Excel. you will find various types of questions along with there answers in this
| Q. | A features that displays only the data in column (s) according to specified criteria A.
Sorting B.
Pivot C.
Formula D.
Filtering Show Answer |
| Q. | Which function in Excel tells how many numeric entries are there ? A.
NUM B.
COUNT C.
CHKNUM D.
SUM Show Answer |
| Q. | What type of chart is useful for comparing values over categories ? A.
Pie Chart B.
Line Chart C.
Column 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.
Cell D.
Address Show Answer |