Spreadsheet
Akopọ
Spreadsheet software turns raw numbers into answers. Whether you are tracking a budget, analysing survey results, or modelling the growth of a population, the combination of formulae, functions, and charts gives you the power to process data quickly and present it clearly.
In this lesson you will learn how to format cells, write formulae with absolute and relative references, apply key functions such as SUM, IF, and VLOOKUP, choose the right chart type for your data, and print your work in both data view and formula view. These are core skills tested across Paper 2 of the Edexcel IGCSE ICT examination.
Awọn Afojusun
- Know data types: number, text
- Format a worksheet: currency, percentage, decimal places, date, time, text wrap, row height, column width, gridlines, merge/split cells, cell borders, cell shading, hiding rows and columns
- Use formulae: arithmetic operators, percentage, single and multiple operators, absolute and relative cell referencing, named cells/ranges; replicate effectively
- Use functions: SUM, AVERAGE, IF, VLOOKUP/LOOKUP, MAXIMUM, MINIMUM, COUNT (COUNTA, COUNTIF), LENGTH, PRODUCT
- Use other features: multiple worksheets, sorting, filtering
- Add graphs and charts: pie chart, line chart, bar/column chart, scattergram
- Select an appropriate graph/chart and format it effectively adding title, axis labels, legends, axis, scale, trend line as appropriate
- Print selected columns/rows from a worksheet formula view or data view in landscape or portrait format, adding headers and footers, row and column headers
Akọ̀wé Ẹ̀kọ́
O wa lori ohun elo Green Bridge
Gba ohun elo Green Bridge CBT sori foonu tabi kọmputa rẹ lati ri awọn akọsilẹ ẹkọ ni kikun, awọn ibeere adaṣe, ati diẹ sii.
Ìdánwò Ẹ̀kọ́
Oriire fun ipari ẹkọ lori Spreadsheet. Ni bayi ti o ti ṣawari naa awọn imọran bọtini ati awọn imọran, o to akoko lati fi imọ rẹ si idanwo. Ẹka yii nfunni ni ọpọlọpọ awọn adaṣe awọn ibeere ti a ṣe lati fun oye rẹ lokun ati ṣe iranlọwọ fun ọ lati ṣe iwọn oye ohun elo naa.
Iwọ yoo pade adalu awọn iru ibeere, pẹlu awọn ibeere olumulo pupọ, awọn ibeere idahun kukuru, ati awọn ibeere iwe kikọ. Gbogbo ibeere kọọkan ni a ṣe pẹlu iṣaro lati ṣe ayẹwo awọn ẹya oriṣiriṣi ti imọ rẹ ati awọn ogbon ironu pataki.
Lo ise abala yii gege bi anfaani lati mu oye re lori koko-ọrọ naa lagbara ati lati ṣe idanimọ eyikeyi agbegbe ti o le nilo afikun ikẹkọ. Maṣe jẹ ki awọn italaya eyikeyi ti o ba pade da ọ lójú; dipo, wo wọn gẹgẹ bi awọn anfaani fun idagbasoke ati ilọsiwaju.
- What does the formula =SUM(A1:A10) do? A) Counts the number of cells in the range B) Finds the largest value in the range C) Adds all the values in the range D) Calculates the average of the range Answer: C
- Which symbol makes a cell reference absolute in a formula? A) # B) $ C) & D) @ Answer: B
- Which chart type is best for showing how a total is divided into proportions? A) Line chart B) Scattergram C) Bar chart D) Pie chart Answer: D
- What does the function =COUNTIF(B2:B20,">50") return? A) The total of all values greater than 50 B) The number of cells containing values greater than 50 C) The average of values greater than 50 D) The largest value that is greater than 50 Answer: B
- In formula view, a cell displays =B3*C3 instead of a number. What does this tell you? A) There is an error in the formula B) The spreadsheet is showing formulae instead of results C) The cell is formatted as text D) The formula has not been entered correctly Answer: B
O wa lori ohun elo Green Bridge
Gba ohun elo Green Bridge CBT sori foonu tabi kọmputa rẹ lati ri awọn akọsilẹ ẹkọ ni kikun, awọn ibeere adaṣe, ati diẹ sii.
O wa lori ohun elo Green Bridge
Gba ohun elo Green Bridge CBT sori foonu tabi kọmputa rẹ lati ri awọn akọsilẹ ẹkọ ni kikun, awọn ibeere adaṣe, ati diẹ sii.
Awọn Iwe Itọsọna Ti a Gba Nimọran
Ṣe Adaṣe Awọn Ibeere Idanwo Adaṣe
Ṣe o fẹ ṣe adaṣe awọn ibeere idanwo adaṣe nipa Spreadsheet? Ṣe igbasilẹ ohun elo Green Bridge CBT lati wọle si awọn ibeere idanwo adaṣe ati awọn ayẹwo adaṣe kikun fun koko-ọrọ yii.
Ṣe igbasilẹ ohun elo naa lori Google Playstore
Gbogbo ohun ti o nilo lati ṣe dara julọ ninu JAMB, WAEC ati NECO.
