Computer Science, asked by ThereseAnn, 4 months ago

You should be careful with the figures you enter into a cell if you want them to be interpreted properly by Excel. Why is this so?
5-10 sentences...

Answers

Answered by veerkchauhan10
2

Answer:

yes

Explanation:

However, if your screen looks like Figure 4 after starting Excel, you should click the ... Data are entered and managed in an Excel worksheet. ... If you have not done so already, start Excel.

Answered by btsgirl445
2

Answer:

1. Sort data

Highlight the entire data set you want to sort (not just one column!) by either dragging your cursor across all of the cells or clicking the triangle in the upper left of your spreadsheet to select the entire thing.

Hit the “Data” tab.

Click the “Sort” button.

Select how you want to sort your data (in the example below, I sorted by city!).

Hit “OK.”

2. Remove duplicates

Highlight the entire data set.

Hit the “Data” tab.

Click the “Remove Duplicates” button.

Select what columns you want Excel to find duplicates in.

Hit “OK.”

3. Basic math functions

Addition: Type “SUM=” in a blank cell where you want the total to appear, click the cells you want to add together, and then hit “Enter.”

Subtraction: Type “=” in a blank cell where you want the difference to appear, click the cell you want to subtract from, type “-”, click the cell you want to subtract, and then hit enter.

Multiplication: Type “=” in a blank cell where you want the total to appear, click the cell for a number you want to multiply, type “*”, click the cell for the other number you want to multiply, and then hit enter.

Division: Type “=” in a blank cell where you want the remainder to appear, click the cell for the number you want to divide, type “/”, click the cell for the number you want to divide by, and then hit enter.

4. Freeze panes

Click on the row underneath your column headers.

Click on the “View” tab.

Click the “Freeze Panes” button.

5. Insert current date

Ctrl + ;

Put your cursor in the cell where you want the date to appear, use that shortcut, and Excel will automatically fill in today’s date for you. Easy peasy!

6. Make the same change across worksheets

Hold the “Command” key on your keyboard (or “Control” if you’re using a PC).

Select the appropriate tabs of your workbook.

Make the necessary change to one cell.

Check to make sure it applied across all of your worksheets.

Explanation:

i hope my answer helped you!!!

Similar questions