Excel Part-4 1 / 50 Excel में apply chart style from table chart path? Chart Tools → Design → Chart Styles Layout → Chart → Styles Right-click → Apply Style Home → Format → Styles 2 / 50 Excel में change chart type from table chart path? Chart Tools → Design → Change Chart Type Home → Format → Chart Type Right-click → Change Chart Type Layout → Chart → Change Type 3 / 50 Excel में insert chart from table path? Home → Format → Chart Layout → Insert → Chart Insert → Recommended Charts Table Design → Chart 4 / 50 Excel में delete slicer for table path? Select slicer → Delete Right-click → Delete Table Design → Remove Slicer Layout → Table → Delete Slicer 5 / 50 Excel में insert slicer for table path Table Design → Insert Slicer Right-click → Insert Slicer Layout → Table → Insert Slicer Home → Insert → Slicer 6 / 50 Excel में remove table formatting path? Layout → Table → Remove Table Design → Convert to Range Right-click → Clear Table Home → Format → Remove Table 7 / 50 Excel में convert range to table path? Right-click → Convert to Table Layout → Format → Table Insert → Table → Convert Home → Format as Table 8 / 50 Excel में insert table path? Insert → Table Home → Format → Table Layout → Insert → Table Data → Table 9 / 50 Excel में auto sum shortcut? Alt + = Ctrl + Shift + = Ctrl + = Alt + S 10 / 50 Excel में insert function shortcut? Shift + F3 Ctrl + Shift + F3 Alt + I → F Ctrl + F3 11 / 50 Excel में clear conditional formatting path? Right-click → Clear Rules Tools → Conditional Formatting → Clear Layout → Format → Clear Formatting Home → Conditional Formatting → Clear Rules 12 / 50 Excel में apply conditional formatting path? Data → Conditional Formatting Layout → Format → Conditional Formatting Home → Conditional Formatting Tools → Format → Conditional Formatting 13 / 50 Excel में text orientation path? Home → Alignment → Orientation Layout → Format → Orientation Right-click → Format Cells → Orientation Tools → Cell → Orientation 14 / 50 Excel में unmerge cells path? Home → Alignment → Merge & Center → Unmerge Right-click → Unmerge Cells Layout → Format → Unmerge Tools → Cell → Unmerge 15 / 50 Excel में merge cells path? Layout → Merge → Cells Home → Format → Merge Home → Alignment → Merge & Center Right-click → Merge Cells 16 / 50 Excel में wrap text in cell path? Tools → Cell → Wrap Text Home → Alignment → Wrap Text Layout → Format → Wrap Text Right-click → Format → Wrap 17 / 50 Excel में remove hyperlink shortcut/path? Right-click → Remove Hyperlink Ctrl + Shift + K Home → Edit → Remove Link Alt + H → E → R 18 / 50 Excel में insert hyperlink shortcut/path? Ctrl + K Ctrl + H Alt + I → H Shift + F2 19 / 50 Excel में fill series path? Home → Fill → Series Layout → Fill → Series Insert → Fill → Series Data → Fill → Series 20 / 50 Excel में किसी सेल में date autofill shortcut? Ctrl + ; Ctrl + Shift + ; Alt + D Ctrl + D 21 / 50 Excel में refresh pivot table shortcut/path? Alt + F5 F5 Ctrl + R Shift + F5 22 / 50 Excel में ungroup dates in pivot table path? Right-click → Ungroup Layout → Pivot → Ungroup Home → Format → Ungroup PivotTable Tools → Analyze → Ungroup 23 / 50 Excel में group dates in pivot table path? Right-click → Group PivotTable Tools → Analyze → Group Home → Format → Group Layout → Pivot → Group 24 / 50 Excel में delete timeline path? Select timeline → Delete PivotTable Tools → Analyze → Remove Timeline Right-click → Delete Home → Delete → Timeline 25 / 50 Excel में insert timeline for pivot table path? PivotTable Tools → Analyze → Insert Timeline Right-click → Insert Timeline Home → Insert → Timeline Layout → Pivot → Insert Timeline 26 / 50 Excel में delete slicer path? Select slicer → Delete Home → Delete → Slicer PivotTable Tools → Analyze → Remove Slicer Right-click → Delete 27 / 50 Excel में insert slicer for pivot table path? Home → Insert → Slicer PivotTable Tools → Analyze → Insert Slicer Right-click → Insert Slicer Layout → Pivot → Insert Slicer 28 / 50 Excel में apply chart style path? Chart Tools → Design → Chart Styles Home → Format → Chart Styles Layout → Chart → Styles Tools → Chart → Styles 29 / 50 Excel में change chart color path? Layout → Chart → Colors Tools → Chart → Change Colors Chart Tools → Design → Change Colors Home → Format → Chart Color 30 / 50 Excel में insert combo chart path? Insert → Combo Chart Chart Tools → Design → Change Chart Type → Combo Right-click → Change Chart Type → Combo Home → Insert → Combo Chart 31 / 50 Excel में remove secondary axis path? Right-click → Format Data Series → None Chart Tools → Design → Remove Secondary Axis Home → Format → Delete Secondary Axis Layout → Chart → Remove Secondary Axis 32 / 50 Excel में insert secondary axis path? Right-click → Format Data Series → Series Options → Secondary Axis Chart Tools → Design → Add Chart Element → Secondary Axis Home → Format → Axis Layout → Chart → Secondary Axis 33 / 50 Excel में remove axes titles path Right-click → Delete Axis Titles Chart Tools → Design → Remove Axis Titles Home → Format → Delete Axis Titles Layout → Chart → Remove Axis Titles 34 / 50 Excel में insert axes titles path? Right-click → Add Axis Titles Home → Format → Axis Titles Chart Tools → Design → Add Chart Element → Axis Titles Layout → Chart → Insert Axis Titles 35 / 50 Excel में remove error bars in chart path? Right-click → Delete Error Bars Chart Tools → Design → Remove Error Bars Home → Format → Delete Error Bars Layout → Chart → Remove Error Bars 36 / 50 Excel में insert error bars in chart path? Home → Format → Error Bars Right-click → Add Error Bars Chart Tools → Design → Add Chart Element → Error Bars Layout → Chart → Insert Error Bars 37 / 50 Excel में remove data table in chart path? Right-click → Delete Data Table Chart Tools → Design → Remove Data Table Home → Format → Delete Data Table Layout → Chart → Remove Data Table 38 / 50 Excel में insert data table in chart path? Right-click → Insert Data Table Chart Tools → Design → Add Chart Element → Data Table Home → Format → Data Table Layout → Chart → Insert Data Table 39 / 50 Excel में remove data labels path? Right-click → Delete Data Labels Chart Tools → Design → Remove Data Labels Home → Format → Delete Data Labels Layout → Chart → Remove Data Labels 40 / 50 Excel में insert data labels path? Home → Format → Data Labels d) Layout → Chart → Add Data Labels Right-click → Add Data Labels Chart Tools → Design → Add Chart Element → Data Labels 41 / 50 Excel में remove trendline path? Right-click → Delete Trendline Chart Tools → Design → Remove Trendline Home → Format → Delete Trendline Layout → Chart → Delete Trendline 42 / 50 Excel में add trendline path? Chart Tools → Design → Add Chart Element → Trendline Right-click → Add Trendline Home → Format → Trendline Layout → Chart → Add Trendline 43 / 50 Excel में format data series path? Right-click → Format Data Series Chart Tools → Format → Format Selection Home → Format → Data Series Layout → Chart → Format Series 44 / 50 Excel में format chart area path? Chart Tools → Format → Format Selection Right-click → Format Chart Area Home → Format → Chart Area Layout → Chart → Format 45 / 50 Excel में add chart element (title, legend) path? Chart Tools → Design → Add Chart Element Home → Format → Add Element Layout → Chart → Add Element Right-click → Add Element 46 / 50 Excel में delete chart path? Ctrl + D Right-click → Delete Select chart → Delete Alt + D → Chart 47 / 50 Excel में move chart to new sheet path? Chart Tools → Design → Move Chart Right-click → Move Chart Home → Format → Move Chart Layout → Chart → Move 48 / 50 Excel में change chart type path? Chart Tools → Design → Change Chart Type Right-click → Change Chart Type Home → Format → Chart Type Layout → Chart → Type 49 / 50 Excel में insert chart in new sheet shortcut/path? F11 Ctrl + Shift + C Alt + N → Chart Alt + F1 50 / 50 Excel में insert chart shortcut/path? Alt + F1 F11 Ctrl + C Alt + C → Chart Your score isThe average score is 79% 0% Restart quiz
