Spreadsheet
Gbogbo ọrọ náà
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.
Ebumnobi
- 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ọmọ Ojú-ẹkọ
Ọ dị na ngwa Green Bridge
Budata ngwa Green Bridge CBT na ekwentị maọbụ kọmputa gị iji nweta akwụkwọ ndụmọdụ zuru oke, ajụjụ mmụta, na ndị ọzọ.
Ayẹwo Ẹkọ
Ekele diri gi maka imecha ihe karịrị na Spreadsheet. Ugbu a na ị na-enyochakwa isi echiche na echiche ndị dị mkpa, ọ bụ oge iji nwalee ihe ị ma. Ngwa a na-enye ụdị ajụjụ ọmụmụ dị iche iche emebere iji kwado nghọta gị wee nyere gị aka ịmata otú ị ghọtara ihe ndị a kụziri.
Ị ga-ahụ ngwakọta nke ụdị ajụjụ dị iche iche, gụnyere ajụjụ chọrọ ịhọrọ otu n’ime ọtụtụ azịza, ajụjụ chọrọ mkpirisi azịza, na ajụjụ ede ede. A na-arụpụta ajụjụ ọ bụla nke ọma iji nwalee akụkụ dị iche iche nke ihe ọmụma gị na nkà nke ịtụgharị uche.
Jiri akụkụ a nke nyocha ka ohere iji kụziere ihe ị matara banyere isiokwu ahụ ma chọpụta ebe ọ bụla ị nwere ike ịchọ ọmụmụ ihe ọzọ. Ekwela ka nsogbu ọ bụla ị na-eche ihu mee ka ị daa mba; kama, lee ha anya dị ka ohere maka ịzụlite onwe gị na imeziwanye.
- 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
Ọ dị na ngwa Green Bridge
Budata ngwa Green Bridge CBT na ekwentị maọbụ kọmputa gị iji nweta akwụkwọ ndụmọdụ zuru oke, ajụjụ mmụta, na ndị ọzọ.
Ọ dị na ngwa Green Bridge
Budata ngwa Green Bridge CBT na ekwentị maọbụ kọmputa gị iji nweta akwụkwọ ndụmọdụ zuru oke, ajụjụ mmụta, na ndị ọzọ.
Àwọn Ìwé Tó Dáa Láti Kà
Meecha Ajụjụ Ule Ọmarịcha
Ị chọrọ ime ajụjụ ule ọmarịcha gbasara Spreadsheet? Budata ngwa Green Bridge CBT iji nweta ajụjụ ule ọmarịcha na nyocha zuru ezu gbasara isiokwu a.
Dawunlodi Ẹpp naa lori Google Playstore.
Ihe nile ichoro iji nwee ihe ịga nke ọma na JAMB, WAEC & NECO.
