Spreadsheets

20 Questions

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

To perform multiplication

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

To perform division

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

Charts

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

SUM

What is the purpose of array formulas in data analysis?

To perform calculations on arrays

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

Ctrl + 1

How can you identify a particular cell in a worksheet?

cell referencing

What is the difference between a formula and a function

a formula is a basic calculation using operators, a function is a keyword that performs one specific task added to a formula to increase efficiency

What must every formula start with?

= , a equal sign

Define the term 'computer model'

Computer model is a spreadsheet used to predict and investigate how real-life devices or processes might behave in different situations

What program do we use to create a spreadsheet?

Microsoft Excel

Simplify the following formula: =A3+A4

=SUM(A3:A4)

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

AVERAGE

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

SUM

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

MIN

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

MAX

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

COUNT

What is the problem with the following formula A3+A23

no equals sign

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

Missing a bracket

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

Missing colon

Study Notes

Formulas

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 Analysis

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

Shortcuts

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

Test your knowledge of Microsoft Excel formulas, data analysis tools, and shortcuts. Covering arithmetic operators, comparison operators, functions, data manipulation, data visualization, and navigation and editing shortcuts.

Make Your Own Quizzes and Flashcards

Convert your notes into interactive study material.

Spreadsheets - 7H