Updated: Jun 25, 2025

The FizziQ Spreadsheet is an integrated tool within the app that allows users to enter, manipulate, and visualize numerical data. Designed specifically for educational settings, it combines ease of use with powerful features for scientific data analysis.

Spreadsheet Interface

The FizziQ spreadsheet offers an intuitive interface divided into several areas:

Column headers: Identified by letters (A, B, C…) or custom names

Row numbers: Sequential numbering of rows (1, 2, 3…)

Cells: The intersection of columns and rows where data is stored

Toolbar: Options to switch between table view and graph view

Basic Operations

Adding Data

Tap a cell to select it

Enter the desired value or formula

Press Enter or tap another cell to confirm

Editing Data

Tap the cell to modify to open the editor

Edit the content

Confirm by pressing Enter

Adding Rows and Columns

Add a row: Tap the ”+” button below the last row

Add a column: Scroll to the right until the ”+” button appears after the last column

Spreadsheet Navigation

Horizontal Navigation

Swipe left or right to scroll through columns

Use the navigation arrows at the bottom to move between columns

Vertical Navigation

Scroll up or down to view more rows

Data Manipulation

Column Management

Tap a column header to access options:

Rename column: Set a custom label

Add sequential indices: Auto-fill the column with numbers

Set decimals: Choose number of displayed decimals (0–4)

Delete column: Remove the entire column

Row Management

Tap a row number to access options:

Move up/down: Reorder rows

Add row: Insert a new row after the current one

Duplicate row: Copy the selected row

Delete row: Remove the selected row

Cells

Double-tap a cell to access options:

Copy to entire column: Duplicate the value/formula to the whole column

Copy formula: Copy only the formula to the clipboard

Formulas and Functions

Formula Syntax

Formulas always begin with an equal sign (=), followed by the expression to evaluate.

Column References

Use column labels to reference values:Example: =A+B adds the values of columns A and B for the current row

Math Operators

Addition: +

Subtraction: -

Multiplication: *

Division: /

Exponentiation: ^

Built-In Functions

Math Functions

sin(colX), cos(colX), tan(colX), arcsin(a), arccos(a), arctan(a) – Trigonometry

e^colX, ln(colX) – Exponential and logarithm

sqrt(colX), nrt(colY,colX) – Square root and n-th root

Statistical Functions

sum() – Calculates the sum of previous values in the column

average() – Calculates the average of previous values

stddev() – Calculates the standard deviation of previous values

Starting from version 4.5.21, you can also use the functions sum(A), average(A), and stdev(A) to calculate statistical values in another column.

Analysis Functions

DIFF(colY, colX) – Computes the derivative of Y with respect to X at the current rowExample: =DIFF(B, A)

DIFF2(colY, colX) – Computes the second derivative of Y with respect to XExample: =DIFF2(B, A)

Navigation Functions

PREC(colX) – Retrieves the value from the previous row in the specified columnExample: =PREC(A) + 1 adds 1 to the previous value in column A

NEXT(colX) – Retrieves the value from the next row in the specified column

Examples of Complex Formulas

=A*2 + B^2 – Multiplies A by 2 and adds the square of B

=SUM() / (ROW-1) – Averages previous values in the column

=(B - PREC(B)) / (A - PREC(A)) – Calculates rate of change between two rows

Graph Visualization

Accessing Graph Mode

Click the “Graph” button in the toolbar

Configure graph settings in the dialog

Graph Configuration

X-axis: Choose a column or use row index

Y-axis: Choose up to three columns

Interpolation: Select from several types of interpolation to show trends:

Linear

Quadratic

Exponential

Logarithmic

Sinusoidal

Graph Interaction

Zoom on Y-axis: Use zoom in/out/reset buttons

Horizontal navigation: Use the bottom slider to adjust X range

Trackball/crosshair: Enable or disable to see exact values

Tips and Tricks

Effective Use

Name your columns clearly: Use meaningful names for easier formula references

Use decimals wisely: Choose decimal precision based on your needs

Start with simple data: Make sure your basic data is accurate before adding complex formulas

Save regularly: Changes are saved automatically when you leave the spreadsheet

Troubleshooting

#N/A: Value not available or formula error

#ERR: Invalid column reference

#ERR: Syntax error in formula

#ERR: Not enough points to calculate derivative or interpolation

Usage Examples

Example 1: Moving Average

Column A: Raw data

Column B: Moving average over 2 points=(A + PREC(A)) / 2

Example 2: Instantaneous Speed

Column A: Time (seconds)

Column B: Position (meters)

Column C: Instantaneous speed=DIFF(B, A)

Example 3: Compound Interest

Column A: Year

Column B: Capital=PREC(B) * 1.05 (for a 5% interest rate)

Conclusion

This guide covers the essential features of the FizziQ spreadsheet. For specific questions or advanced features, feel free to consult the full app documentation.