Ad
Sponsored by Sir Tauqeer
CLICK HERE TO JOIN SIR TAUQUEER WHATSAPP GROUP
FOR PREPARATION CLASSES AND JOBS UPDATES
Join 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

Join Our WhatsApp Channel ×
Scroll to Top