Excle Part-2 1 / 50 Excel में clear print area path? Page Layout → Print Area → Clear Print Area Tools → Print → Clear Home → Format → Clear Area Layout → Print Area → Clear 2 / 50 Excel में set print area path? Layout → Print Area → Set Home → Format → Print Area Page Layout → Print Area → Set Print Area Tools → Print → Set Area 3 / 50 Excel में print preview shortcut/path? Ctrl + F2 Ctrl + P Alt + F → Print Preview Alt + P → Preview 4 / 50 Excel में page setup shortcut/path? Alt + P → S → P Ctrl + P Alt + S → Page Setup File → Page Setup 5 / 50 Excel में remove header/footer path? Tools → Header/Footer → Clear Layout → Header/Footer → Remove Insert → Header & Footer → Remove Header/Footer Home → Header/Footer → Delete 6 / 50 Excel में insert header/footer path? Insert → Header & Footer Tools → Header/Footer Home → Insert → Header/Footer Layout → Insert → Header/Footer 7 / 50 Excel में show/hide headings path? Tools → Headings Home → Format → Headings Layout → View → Headings View → Show → Headings 8 / 50 Excel में show/hide formula bar path? Home → Format → Formula Bar View → Show → Formula Bar Layout → View → Formula Bar Tools → View → Formula Bar 9 / 50 Excel में refresh all pivot tables shortcut/path? Shift + F5 Alt + F5 Ctrl + F5 Ctrl + Alt + F5 10 / 50 Excel में insert pivot chart path? Insert → PivotChart Home → Insert → PivotChart Data → PivotChart Tools → PivotChart 11 / 50 Excel में group worksheets shortcut/path? Ctrl + Click worksheets Shift + Click worksheets Alt + W → Group Ctrl + Shift + G 12 / 50 Excel में clear validation path? Data → Data Validation → Clear All Home → Validation → Clear Layout → Data → Clear Validation Tools → Validation → Remove 13 / 50 Excel में circle invalid data path? Data → Data Validation → Circle Invalid Data Home → Validation → Circle Invalid Tools → Data → Circle Layout → Data → Circle 14 / 50 Excel में data validation path? Data → Data Validation Home → Data → Validation Layout → Data → Validation Tools → Validate 15 / 50 Excel में flash fill shortcut/path? Ctrl + Shift + F Home → Flash Fill Ctrl + E Alt + F → Flash Fill 16 / 50 Excel में text to columns path? Data → Text to Columns Home → Data → Text to Columns Layout → Data → Text to Columns Tools → Text → Columns 17 / 50 Excel में remove duplicates path? Tools → Remove → Duplicates Home → Remove → Duplicates Data → Remove Duplicates Layout → Data → Remove Duplicates 18 / 50 Excel में insert table shortcut/path? Ctrl + T Ctrl + L Alt + N → Table Ctrl + Shift + T 19 / 50 Excel में delete slicer path? Select slicer → Delete Home → Delete → Slicer Tools → Delete → Slicer Layout → Delete → Slicer 20 / 50 Excel में insert slicer path? Insert → Slicer Home → Insert → Slicer Layout → Insert → Slicer Tools → Slicer 21 / 50 Excel में delete sparklines path? Layout → Delete → Sparkline Select sparkline → Design → Clear Tools → Clear → Sparkline Home → Delete → Sparkline 22 / 50 Excel में insert sparklines path? Insert → Sparklines Home → Insert → Sparklines Layout → Insert → Sparklines Tools → Sparklines 23 / 50 Excel में remove outline path? Data → Ungroup → Clear Outline Home → Clear Outline Layout → Ungroup → Clear Tools → Outline → Remove 24 / 50 Excel में outline → show levels path? Data → Group → Show Detail / Show Levels Home → Outline → Levels Layout → Group → Levels Tools → Outline → Show 25 / 50 Excel में ungroup rows/columns shortcut/path? Alt + U → Ungroup Ctrl + Shift + U Ctrl + Shift + G Alt + Shift + ← 26 / 50 Excel में group rows/columns shortcut/path? Alt + Shift + → Ctrl + G Alt + G → Group Ctrl + Shift + G 27 / 50 Excel में bring to front / send to back path? Right-click → Bring to Front / Send to Back Home → Arrange → Bring to Front Layout → Arrange → Order Tools → Object → Arrange 28 / 50 Excel में delete picture path/shortcut? Select picture → Delete Ctrl + D Alt + D → Picture Right-click → Delete 29 / 50 Excel में recalculate all worksheets shortcut/path? Ctrl + Alt + F9 F9 Shift + F9 Ctrl + F9 30 / 50 Excel में open name manager shortcut/path? Ctrl + F3 Alt + N → Name Manager Ctrl + Shift + F3 Tools → Names → Manager 31 / 50 Excel में insert pivot table path? Insert → PivotTable Home → Insert → PivotTable Tools → PivotTable Data → PivotTable 32 / 50 Excel में refresh pivot table shortcut/path? Alt + F5 Ctrl + F5 Alt + R → Refresh Ctrl + Shift + R 33 / 50 Excel में group worksheets shortcut/path? Ctrl + Click worksheets Shift + Click worksheets Alt + W → Group Ctrl + Shift + G 34 / 50 Excel में split window path? View → Split Layout → Split Data → Split Tools → Window → Split 35 / 50 Excel में ungroup worksheets shortcut/path? Right-click → Ungroup Sheets Ctrl + Click → Ungroup Alt + W → Ungroup Ctrl + Shift + U 36 / 50 Excel में remove split window shortcut/path? View → Split Alt + W → Split Ctrl + Shift + W Tools → Window → Remove Split 37 / 50 Excel में zoom in/out path? View → Zoom Layout → Zoom Home → Zoom Tools → Zoom 38 / 50 Excel में freeze first row only path? View → Freeze Panes → Freeze Top Row Home → Freeze → Top Row Data → Freeze → Row 1 Layout → Freeze → Top Row 39 / 50 Excel में insert comment for selected cell shortcut? Ctrl + M Shift + F2 Ctrl + Alt + M Alt + C 40 / 50 Excel में delete comment path? Review → Delete → Delete Comment Alt + D → Comment Ctrl + D Right-click → Delete Comment 41 / 50 Excel में show/hide gridlines path? View → Show → Gridlines Layout → View → Gridlines Home → Format → Gridlines Tools → Gridlines 42 / 50 Excel में wrap text in cell path/shortcut? Alt + H → W Ctrl + W Home → Wrap Text Ctrl + Shift + W 43 / 50 Excel में merge & center cell path/shortcut? Alt + H → M → C Ctrl + M Home → Merge & Center Alt + M → C 44 / 50 Excel में format painter shortcut/path? Ctrl + Shift + C Alt + H → F → P Ctrl + F Ctrl + Shift + P 45 / 50 Excel में apply currency format shortcut/path? Ctrl + Shift + $ Alt + H → N → $ Ctrl + $ Ctrl + Alt + $ 46 / 50 Excel में apply percentage format shortcut/path? Ctrl + Shift + % Alt + H → N → % Ctrl + % Ctrl + Alt + % 47 / 50 Excel में increase/decrease decimal shortcut/path? Alt + H → 0 / Alt + H → 9 Ctrl + Shift + D / Ctrl + Shift + I Home → Increase/Decrease Decimal Alt + D → Decimal 48 / 50 Excel में insert hyperlink shortcut/path? Ctrl + K Alt + N → Link Ctrl + Shift + K Right-click → Hyperlink 49 / 50 Excel में remove hyperlink shortcut/path? Ctrl + Shift + F9 Ctrl + R Alt + H → Remove Hyperlink Right-click → Remove Hyperlink 50 / 50 Excel में insert picture path? Insert → Pictures Home → Insert → Picture Layout → Insert → Picture Tools → Picture Your score isThe average score is 72% 0% Restart quiz
