Skip to content
CramShare
FreePractice exam

D388 fundamentals of spreadsheets and data presentations

HEAL100 Health Care — exam and revision material · Other

Updated today

Health Care exam material, 6 pages. Originally published on StudyMerit.

Pages
6
Academic year
2025/2026
Language
English

What’s included

Preview 2 of 6 pages

See the first 2 pages exactly as they appear in the document.

Read page 1 as text

Fundamentals of Spreadsheets and Data Presentations – D388 Section 1: Performs Common Spreadsheet Tasks 1. Purpose and Use of Spreadsheets o Understand basic functions and applications.  Why: To utilize spreadsheets for organizing, analyzing, and presenting data. o Familiarize with Microsoft Excel, Google Sheets, etc.  Why: To choose the right tool based on features and accessibility. 2. Components of Spreadsheets o Cells: Intersection of a row and column.  Why: Fundamental unit for data entry. o Rows: Horizontal group of cells.  Why: Organizes data horizontally. o Columns: Vertical group of cells.  Why: Organizes data vertically. o Ranges: Selection of multiple cells.  Why: Allows for bulk operations and functions. 3. Sorting and Filtering o Sorting:  Steps: Select data range → Data tab → "Sort A to Z" or "Sort Z to A."  What: Organizes data in ascending or descending order.  Why: To quickly arrange data for better readability and analysis. o Filtering:  Steps: Select data range → Data tab → "Filter" → Use drop-down arrows.  What: Displays specific data subsets.  Why: To focus on data points without altering the entire dataset. Downloaded by Studymerit Dotcom (samuelkaruiki40@gmail.com) lOMoARcPSD|6879242

Read page 2 as text

4. Creating Spreadsheets o Creating a New Spreadsheet:  Steps: Open Excel/Google Sheets → "New" or "Blank spreadsheet."  What: Initiates a new spreadsheet.  Why: To start data entry and organization from scratch. o Entering Data:  Steps: Click a cell → Type data → Press Enter.  What: Inputs data into cells.  Why: To populate the spreadsheet with information. o Formatting Cells:  Steps: Select cells → Home tab → Choose formatting options (font, color, borders).  What: Adjusts cell appearance.  Why: To enhance data presentation and readability. 5. Simple Operations o Addition: =A1 + B1  What: Adds values in two cells.  Why: To calculate the total of two numbers. o Subtraction: =A1 - B1  What: Subtracts one value from another.  Why: To find the difference between two numbers. o Multiplication: =A1 * B1  What: Multiplies two values.  Why: To compute the product of two numbers. o Division: =A1 / B1  What: Divides one value by another.  Why: To determine the quotient of two numbers. o SUM: =SUM(A1:A10)  What: Adds a range of values. Downloaded by Studymerit Dotcom (samuelkaruiki40@gmail.com) lOMoARcPSD|6879242

That’s the free preview

You’ve read 2 of 6 pages. The whole document is yours with a free account, and it stays in your library.

Others on this course also opened

Free

With a free account