Information and Communication Technology - 4IT1 PearsonEdexcel

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

Maapụ uche

E seela isiokwu a ka ị hụ otu echiche si ejikọta.

Mepee maapụ uche na ngwa

Kaadị ncheta

Omume ncheta ngwa ngwa n'ihe a na-anwale n'isiokwu a.

Mee omume kaadị ndị a na ngwa

Akwụkwọ Ọmụmụ

A table of figures on its own says very little. Add a formula to calculate profit, a function to find the highest value, and a chart to reveal the trend, and the same figures begin to tell a story. Spreadsheet software is built for exactly this kind of work: organising numerical data, performing calculations automatically, and presenting results so that patterns jump off the page.

Ndetu Nkuzi Zuru Ezu di na Ngwa Green Bridge

Nweta ngwa Green Bridge CBT na ekwenti gi ma o bu kompiuta maka ulo akwukwo IGCSE zuru oke: akwukwo ule ndi gara aga, usoro nyocha, eserese uche, kaadi omumu na nkuzi olu.

Akwụkwọ ndụmọdụ zuru oke nwere eserese

Onye inyeaka mmụta AI

Ule nnwale nwere oge a na-ahazi ozugbo i mechara

Budata ngwa ekwentị Budata ngwa kọmputa

Ọ dị na Android, Windows, macOS, na Linux Ngwa iOS na-abia n'oge na-adighi anya

Nnyocha Ọmụmụ

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

Rue ajuju ndi a n'ime ngwa ahu