Sorting data - Example: Sort prices low to high. How to do it: Highlight the table, Click Sort & Filter, Choose Smallest to Largest 📌 Always highlight all the data, not one column., Add borders - Highlight cells, Click Borders, Choose All Borders, What your data must look like - You need two columns. Column A on the left = Labels (words), Column B on the right = Numbers., How to make a chart - Highlight all the data (including the titles), Click Insert, Choose a chart: Bar chart (best for beginners), OR Column chart, OR Pie chart. The chart will appear on the screen, Change text size - Highlight cells, Choose a bigger number (e.g. 14), Adding numbers (SUM) - Example: Numbers in A1 to A5. How to do it: Click the empty cell, Type: =SUM(A1:A5) – or whatever cells you want to sum, Press Enter, AutoFill (fast copying) - What it does: Copies numbers or formulas automatically. How to do it: Click the cell, Hover over the small square in the corner, Drag down or across, Cell name - A cell is named by column + row, Example: A1, B3, The screen – basic parts - Cell - One box where you type, Row - Goes across (1, 2, 3…), Column - Goes down (A, B, C…), Worksheet - One page, Workbook - The whole file,

Excel

列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?