Present Data
Gbogbo ọrọ náà
A spreadsheet that calculates correctly can still be hard to read. Presenting data is the craft of making the numbers clear: showing them to a sensible number of decimal places, attaching the right currency symbol, colouring cells so a warning leaps out, and laying the sheet out to print neatly on the page. None of this changes the values; it changes how they are displayed and understood.
In this lesson you will learn to switch between the values view and the formulae view, to size rows and columns and wrap text so nothing is cut off, to hide and reveal rows and columns, to format numbers as currency and percentages, to apply conditional formatting that responds to a cell's contents, and to control page orientation and printing. These are the finishing skills that separate a usable spreadsheet from a confusing one.
Ebumnobi
- Adjust the display features.
- Display either formulae or values Adjust row height, column width and cell sizes so that all data, labels, and formulae is fully visible Wrap text within cells so that all data is fully visible Hide and display rows and columns.
- Format a spreadsheet.
- Enhance a spreadsheet including text colour, cell colour, bold, underline, italic, shading Format numeric data appropriately including to display the number of decimal places, different currency symbols, percentages Use conditional formatting to change the display format depending on the contents of a cell.
- Set page layout.
- Set the orientation to portrait or landscape Control the page layout to print including specified number of pages, print area, display or hide gridlines, display or hide row and column headings.
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 Present Data. 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.
- Formatting a cell that holds 1.7 to show zero decimal places makes the cell: A. Store the value 2 B. Display 2 but still hold 1.7 C. Display 1 and hold 1 D. Become text Answer: B
- Which feature automatically changes a cell's colour based on what the cell contains? A. Wrap text B. Conditional formatting C. Page orientation D. Bold Answer: B
- To print a wide formulae view so it is not cut off, the best page orientation is usually: A. Portrait B. Landscape C. Square D. A5 Answer: B
- To make a cell actually contain a whole number rather than just display as one, you should use: A. Decimal-place formatting B. Bold C. The INT function D. Wrap text Answer: C
- Hiding a column in a spreadsheet: A. Deletes the data in it B. Stops its formulae working C. Conceals it but keeps the data D. Converts it to text Answer: C
Ọ 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 Present Data? 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.
