FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -The fill commands are available only if you are copying data to cells adjacent to the original cell. Deleting a row or column erases the data in that row or column. Splitting creates teo, three, or four panes in the worksheet.

Detailed explanation-2: -First, all of the cells must be adjacent to each other. This means that they must be next to each other horizontally or vertically, but not diagonally. Second, the cells must be in the same row or column; you cannot select a range of cells that are in different rows or columns.

Detailed explanation-3: -Be careful if you paste copied cell information into cells that already contain data. If you do, the existing data is overwritten. You can copy information from many different sources-including websites, emails, or other Office applications like Word and PowerPoint-and paste it into an Excel spreadsheet.

Detailed explanation-4: -Autofill is a very useful Excel feature. It allows you to create entire columns or rows of data which are based on the values from other cells. In other words, Excel compares the selected data and tries to guess the next values that will be inserted.

Detailed explanation-5: -Select the cell that contains the formula you want to copy. Hover your cursor around the black square in the lower right corner of the cell until your cursor turns into a plus sign. Click and hold the left mouse button while dragging the handle to include all cellswhere you would like the formula copied.