Excel 2016 Assessment UPDATED Actual Exam Questions and CORRECT Answers

Excel 2016 Assessment UPDATED Actual
Exam Questions and CORRECT Answers
How would you add a chart "in a cell" to show sales data from last 12months? - CORRECT
ANSWER✔✔- a.Add image of the chart in the cell
b. Add comment & add chart to that
c.Hyperlink to the chart on another sheet
d.Add sparkline,a graphic that shows on cell graphics


Answer= d


Which option can we use,if the text in cell is being cut off &we want to see all text without
increasing the width of the column? - CORRECT ANSWER✔✔- a.Wrap Text
b.Wrap Column
c.Change Alignment
d.Fill Handle


Answer= A Wrap Text


Which chart among the options is best for showing time based data? - CORRECT
ANSWER✔✔- A.Column Chart
B.Bar Chart
C.Radar Chart
D. Line Chart


Answer = D Line Chart


One of the options is not like the others,find the odd one out. - CORRECT ANSWER✔✔- A
= SUM (B2:B6)
B = SUM ( B2,B5,B4,B1,B6)
C = b2+b3+b4+b5+B6