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
Baham ko'rish
Baham ko'rish
Baham ko'rish
tomonidan
Joebroad
SEN
Computing
Tarkibini tahrirlash
Chop etish
qo'shib qo'yish
Ko'proq
Tayinlashlar
Ilg'orlar ro'yxati
Ko'proq ko'rsatish
Kamroq koʻrsatish
Ushbu etakchilar jadvali hozirda xususiy. Uni ommaga etkazish uchun
Ulashish-ni
bosing.
Liderlar ro'yxati resurs egasi tomonidan o'chirib qo'yildi.
Ushbu etakchilar ro'yxati o'chirib qo'yilgan, chunki sizning variantlaringiz resurs egasidan farq qiladi.
Qaytish moslamalari
Juftlik yoki juftlik yoʻq
ochiq-oydin shablon. Etakchilar ro'yxati uchun ballar yaratmaydi.
Tizimga kirish talab qilinadi
Vizual uslub
Shriftlar
Obuna talab etiladi
Moslamalar
Namunani almashtirish
Hammasini koʻrsatish
Faoliyatni o'ynaganingizda ko'proq formatlar paydo bo'ladi.
Ochiq natijalar
Bogʻdan nusxa olish
Tez javob kodi
& Olib tashlash
Tahrirlashni davom ettirish:
?