PREMIUM
๐ŸŽฏ PPSC Past Paper Test Series
30 Mock Tests (100 MCQs Each) + 3,000+ Past Paper MCQs
โœ… Detailed Explanations โ€ข ๐Ÿ’ก One-Liner Memory Hacks โ€ข ๐Ÿ“š Previous Papers
WhatsApp Now โ†’

Which of the following option can remove the borders in MS Excel?

A. Press Enter
B. Choose No Border
C. Use formula
D. Not possible in Excel
Correct Answer: B. Choose No Border

In Microsoft Excel, formatting options are used to customize the appearance of cells. To remove borders, you need to access the specific border formatting tools. Option B, "Choose No Border," is the correct method. You typically select the cells, go to the 'Home' tab, find the 'Borders' dropdown in the 'Font' group, and then select 'No Border' to clear any existing cell borders.

  • Option A ("Press Enter") is incorrect as pressing Enter confirms cell input or moves the cursor, it does not affect cell borders.

  • Option C ("Use formula") is incorrect; formulas are for calculations and data manipulation, not for applying or removing visual formatting like borders.

  • Option D ("Not possible in Excel") is false; removing borders is a fundamental formatting capability in Excel.

Leave a Comment

Your email address will not be published. Required fields are marked *

Join Our WhatsApp Channel ×
Scroll to Top