MS EXCEL MCQs

Ms Excel

Total Questions : 506 | Page 49 of 51 pages
Question 481. . To convert a column of data into row, which command will you choose
1.    Edit -> Paste Special -> Transpose
2.    Cut and Paste
3.    Both of above
4.    None of above
Answer: Option A. -> Edit -> Paste Special -> Transpose
Question 482. . In Paste Special dialog box, which of the following option is not available ?
1.    Divide
3.    Subtract
4.    Square root
Answer: Option D. -> Square root
Question 483. What is the intersection of a column and a row on a worksheet called ?
1.    Column
2.    Value
4.    Cell
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 484. Which functionin Excel tells how many numeric entries are there ?
1.    NUM
2.    COUNT
3.    SUM
4.    CHKNUM
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 485. What type of chart is useful for comparing values over categories ?
1.    Pie Chart
2.    Column Chart
3.    Line Chart
4.    Dot Graph
Answer: Option B. -> Column Chart
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 486. Functions in MS Excel must begin with ___
1.    An () sign
2.    An Equal Sign
3.    A Plus Sign
4.    A > Sign
Answer: Option B. -> An Equal Sign
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 487. Statistical calculations and preparation of tables and graphs can be done using
2.    Excel
4.    Power Point
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 488. Which one is not a Function in MS Excel ?
1.    SUM
2.    AVG
3.    MAX
4.    MIN
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 489. 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
Answer: Option B. -> Line Chart
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 490. A features that displays only the data in column (s) according to specified criteria
1.    Formula
2.    Sorting
3.    Filtering
4.    Pivot