Excel Flashcards
YAY
What is an Testing Range ?
An pacific selection of cells within an spreadsheet.That you designate for data analysis
EG: A1:A10
What are calculations in excel
Formulas that use an “=” sign at the start.
List some calculations
-SUM
-COUNT
-COUNTIF
-AVERAGE
-MEDIAN
-OFFSET
-RANGE
-INDEX MATCH
List types of graphs
-Pie Chart
-Bubble Chart
-Bar Chart
-Scatter Plot
-Stream
-Histograms
-Line Graph
What is a Pie Chart ?
-An cicurclar chart using coloured “slices” to represent the proportion to the percentage of the “whole pie”
When is a Pie Chart best used ?
-Depiction of relative amounts in proportion.
-Representation of the data to 100%
What is important to note about Pie Charts ?
Do not show changes overtime.
What is an Histogram ?
-An statistical graph which represents the distribution of an continuous data set.EACH representing an category or class interval.
Bar height = Frequency
What is an Bar/Column Graph ?
-Arrangement of data vertically and horizontally through rows like an bar.
What is an Line Graph ?
An display of continuous data overtime.As a “series” connected by straight line segments on two axes
What are advantages of Column and Bar Graphs ?
-Showing data changes over an period of time.
-Comparing among items
-Showing an large change from category to category.
What is an advantage of an Line Graph ?
-Good for the determination of an relationship between values.
What is a bubble chart ?
-Use of circles to represent numbers
-Bigger the circle the larger the number.
-Number of cases per category depending on size of bubble.
What are advantages on an bubble chart ?
-Good when you have 3 or more variables
-Good for showcasing of relationships between datapoints.
What are Scattergraphs ?
-Depeiction of “raw” data points as dots,useally with an line of best fit.
What are advantages of Scattergraphs ?
-Identifies possible relationships between two variables.
-Provides an way to “test” the strength b/w two variables.
What are Stream Graphs ?
-Visualaiztion of trends and patterns overtime.Over Detailed sets of information.
What is SS ?
-Sum of Squares
Used to calculate the variability of data points around the mean in a dataset.
What are the Graph Conventions ?
Title –
Axes Labels –
Legend –
Scale & Units –
Data Labels –
What is Cell Referencing ?
Cell referencing-Using an cell’s location in a formula so the data updates automatically when changes are made.
What does the $ mean ?
-Ensures that it stays the same when filled down or across
-Absolute referencing
EG: ($A$1) – The column (A) and row
What are the Data Types ?
- Number
- Currency
- Date & Time
- Text
- Error
What is Data Validation ?
Data Validation in Excel helps control
what you can type in a cell.
Data is accurute and meets standards.
Ensures accurucy/quality.
What does Data Validation do ?
✅ Allows only certain values (like numbers or dates).
✅ Creates a drop-down list to choose from.
✅ Shows a warning if the wrong data is entered
Why are Spreadsheets efficient ?
Spreadsheets are efficient because they help organize, calculate, and analyze data quickly and accurately.
What makes a Spreadsheet effective ?
Spreadsheets are effective because they help manage, analyze, and present data in a clear and organized way.
What is sorting ?
Sorting in Excel means arranging data in a specific order, like A to Z or smallest to largest.
What is filtering ?
Filtering in Excel means showing only the data you need while hiding the rest.
