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,
0%
Excel
Share
Share
Share
by
Joebroad
SEN
Computing
I-edit ang Content
I-Print kini
Embed
Uban pa
Assignments
Leaderboard
Show more
Show less
Kini nga leaderboard naka-pribado. Pag-klik sa
Share
aron himuon kini nga publiko.
Kini nga leaderboard gi-disable sa tag-iya sa resource.
Kini nga leaderboard gi-disable tungod ang imong mga kapilian lahi ra sa tag-iya sa resource.
I-revert ang mga Kapilian
Ang
Pair or No Pair
usa ka open-ended nga template. Dili kini makamugna ug mga marka sa leaderboard.
Kinahanglan mag log in
Visual style
Fonts
Subscription required
Mga Option
I-switch ang template
Ipakita tanan
Daghang mga format ang mugawas samtang gidula nimo ang activity.
Open results
Copy link
QR code
Mag-delete
I-restore ang gi-autosave:
?