Present Data
Bayani Gaba-gaba
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.
Manufura
- 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.
Takardar Darasi
Akwai a cikin manhajar Green Bridge
Zazzage manhajar Green Bridge CBT a wayar ka ko kwamfyuta ka don samun cikakkiyar bayanan darasi, tambayoyin aiki, da ƙari.
Nazarin Darasi
Barka da kammala darasi akan Present Data. Yanzu da kuka bincika mahimman raayoyi da raayoyi, lokaci yayi da zaku gwada ilimin ku. Wannan sashe yana ba da ayyuka iri-iri Tambayoyin da aka tsara don ƙarfafa fahimtar ku da kuma taimaka muku auna fahimtar ku game da kayan.
Za ka gamu da haɗe-haɗen nau'ikan tambayoyi, ciki har da tambayoyin zaɓi da yawa, tambayoyin gajeren amsa, da tambayoyin rubutu. Kowace tambaya an ƙirƙira ta da kyau don auna fannoni daban-daban na iliminka da ƙwarewar tunani mai zurfi.
Yi wannan ɓangaren na kimantawa a matsayin wata dama don ƙarfafa fahimtarka kan batun kuma don gano duk wani yanki da kake buƙatar ƙarin karatu. Kada ka yanke ƙauna da duk wani ƙalubale da ka fuskanta; maimakon haka, ka kallesu a matsayin damar haɓaka da ingantawa.
- 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
Akwai a cikin manhajar Green Bridge
Zazzage manhajar Green Bridge CBT a wayar ka ko kwamfyuta ka don samun cikakkiyar bayanan darasi, tambayoyin aiki, da ƙari.
Akwai a cikin manhajar Green Bridge
Zazzage manhajar Green Bridge CBT a wayar ka ko kwamfyuta ka don samun cikakkiyar bayanan darasi, tambayoyin aiki, da ƙari.
Littattafan da ake ba da shawarar karantawa
Yi Aikin Tambayoyin Gwaji
Kana son yin aikin tambayoyin gwaji kan Present Data? Sauke manhajar Green Bridge CBT don samun tambayoyin gwaji da cikakkun jarrabawa akan wannan batu.
Sauke Manhajar Daga Google Playstore
Duk abin da kake buƙata don yin fice a JAMB, WAEC & NECO.
