Mitchel Wants to Remove a Row of Unnecessary Data in a Table

question 1

Multiple Choice

Mitchel wants to remove a row of unnecessary data in a table created in MS Excel.What should he do after selecting the row?

• A) Right-click and select Insert from the drop-down menu,and pick Table Rows Above.
• B) Right-click and select Insert from the drop-down menu,and pick Table Rows Below.
• C) Click on the Design tab in the Tools group,and then click Remove Duplicates.
• D) Click the arrow next to Delete on the Home tab,in the Cells group,and then click Delete Table Rows.

---

Definitions:

Weighted Average

A calculation that takes into account the varying degrees of importance of the numbers in a data set.

Weighted Average

A calculation that takes into account the varying degrees of importance of the numbers in a data set, assigning weights to each number before averaging.

Ordinary Shares

Equity securities representing ownership in a company, entitling holders to vote on corporate matters and share in profits through dividends.

Dilutive Securities

Financial instruments that could reduce earnings per share if converted to common stock, such as warrants and convertible bonds.