Spreadsheets

What is the purpose of the * operator in arithmetic operations?

What is the purpose of the / operator in arithmetic operations?

What type of data visualization is used to display data in a graphical format?

What function is used to calculate the total of a range of cells?

What is the purpose of array formulas in data analysis?

What is the shortcut to apply standard formatting to a cell?

How can you identify a particular cell in a worksheet?

What is the difference between a formula and a function

What must every formula start with?

Define the term 'computer model'

What program do we use to create a spreadsheet?

Simplify the following formula: =A3+A4

What function would you use to find the average of a group of cells.

What function would you use to add all number up within a cell

What function would you use to find out what the minimum number was in a group of cells

What function would you use to identify the largest number within a group of cells

What function would you use to identify how many cells had a value in them

What is the problem with the following formula A3+A23

What is the problem with the following formula : =SUM A3+A12)

What is missing from the following formula =(A10 A32)

Arithmetic Operators:
- + for addition
- - for subtraction
- * for multiplication
- / for division
- % for modulus (remainder)
Comparison Operators:
- = for equal to
- <> for not equal to
- > for greater than
- < for less than
- >= for greater than or equal to
- <= for less than or equal to
Functions:
- SUM(range) for sum of values in a range
- AVERAGE(range) for average of values in a range
- COUNT(range) for count of values in a range
- IF(logical_test, [value_if_true], [value_if_false]) for conditional statements

Data Manipulation:
- Sorting data: by rows or columns, in ascending or descending order
- Filtering data: selecting specific data based on conditions
- Grouping data: categorizing data into groups
Data Visualization:
- Charts: column, bar, pie, line, scatter, and more
- Tables: pivot tables, conditional formatting
Data Analysis Tools:
- Conditional formatting: highlighting cells based on conditions
- Pivot tables: summarizing and analyzing large datasets
- What-if analysis: testing scenarios and forecasting

Navigation:
- Ctrl + Home to navigate to the beginning of the worksheet
- Ctrl + End to navigate to the end of the worksheet
- Ctrl + Arrow keys to navigate to edges of the worksheet
Selection:
- Ctrl + A to select all cells in the worksheet
- Ctrl + Shift + Arrow keys to select a range of cells
Editing:
- Ctrl + C to copy
- Ctrl + X to cut
- Ctrl + V to paste
- Ctrl + Z to undo
- Ctrl + Y to redo