Question

In reference to working with Microsoft Excel, what problems could you run into when using a large worksheet? How can you prevent these problems?

When is it appropriate to delete an entire row or column, as opposed to deleting data in the row or column?

Answer 1

ANSWER:-

The problem we face when we use a large worksheet are:-

The most common mistake that excel users make when creating their spreadsheet is that they do not set uo and lay out the data in the manner in which excel and its features expects.

1]  Unneccessarily spreading data over many different workbooks.

2].Unneccessarily spreading data over numerous worksheet.

3].Unneccessarily spreading data over different tables.

4].Having blank column and rowsin tables of data .

5].Leaving blank cells for repeated data.

To prevent these problems:-

The first three items on the preceding list add up to one thing :you should always try to keep related data in one contineous table.Time and time again we see spread sheet that do not follow this simple rule ans thus are limited in their ability to take full advantages of some of excel's most powerful features,including pivotetables,subtotals ,and worksheet formulas.in such scenarios ,you can use these features to their full potential only when you've laid out your data in a very basic tables

Mkae sure your data is sorted whenever possible. Excel has a rich set of lookup and reference formulas sme of which required,some of which required that b your data be sorted in a logical order.Sorting will also speed the calculation process of many function significantly.

It is an appropriate to delete the entire row or column to delete the data in that column or rows.

One way to remove data in excel is to use the clear button on the home ribbon. Choose ''ciear contents'' to clear just the contents choose ''clear all'' to clear both the contents and the formatting. A faster way to clear content is to use the delete key. Just select the cells you 'd like to delete, then press the delete key. Notice that deleting cells this way removes the data but not the formatting. If you want to remove the formatting, use ''clear all'' in the clear menu on the home ribbon. Another easy way remove data in a worksheet is to delete entire columns or rows that contain the data you' d like to remove, and delete. This method will completely remove all data and formatting, And it can be a good way to quickly tidy up a worksheet. As always when deleting rows or columns, be careful not to delete other data that may exist elsewhere in the worksheet

THANKYOU. &  please. Thumsup if you like the answer.