> > >

Google Sheets MCQs

Given is an image of a pie chart depicting prices of three cars as percentage of the total in a Google Sheets spreadsheet. If you want to represent the actual values of car prices instead of the percentages, which of the following options will allow you to make that change?

Select the pie chart and click on the small arrow button on the upper right corner of the chart >

Click Advanced Edit... option > Click Chart types tab > Click Doughnut chart option under the Pie Label.

Select the pie chart and click on the formula bar and write function = VALUE (B2, B3, B4) where 82. 83 and B4 are the f‌ields containing sales of cars ABC. NEW and BEE respectively.

Select the pie chart and click on the small arrow button on the upper right corner of the chart >

Click Advanced Edit... option > Click Chart types tab > Select Values option from the drop-down box.

Select the pie chart and click on the small arrow button on the upper right corner of the chart >

Click Advanced Edit... option > Click Customization tab > Select Value option in the drop-down box in front of the Slice label.

Answer

Correct Answer:

Select the pie chart and click on the small arrow button on the upper right corner of the chart >

Click Advanced Edit... option > Click Customization tab > Select Value option in the drop-down box in front of the Slice label.

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Google Sheets Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it