QUIZ 3 (Class 8)

What is formula?

• A graphical representation of data.
• A type of chemical compound.
• A set of instructions for cooking.
• A mathematical expression representing a relationship between variables.

How to enter formula

• Type '+' followed by your formula in the desired cell.
• Type '=' followed by your formula in the desired cell.
• Enter your formula in the toolbar above.
• Use 'set' followed by your formula in the cell.

Move a formula and keep references from changing

• Use absolute references (e.g., $A$1) in the formula.
• Use relative references (e.g., A1) in the formula.
• Apply conditional formatting to the formula.
• Copy and paste the formula without adjustments.

Use a table to enter formulas automatically

• Use a word processor to create a table and enter formulas manually.
• Create a table in a presentation software to input formulas automatically.
• Use a database application to generate tables without formulas.
• Use spreadsheet software to create a table and drag the fill handle to enter formulas automatically.

Use AutoComplete + tab to enter functions

• Use AutoComplete + Enter to enter functions.
• Press Tab to complete functions without AutoComplete.
• Use AutoComplete + Tab to enter functions.
• Use AutoComplete + Shift to enter functions.

Use Paste Special to adjust values in place

• Use Paste to overwrite existing values directly.
• Select the entire sheet to apply Paste Special.
• Use Copy and Paste without any adjustments.
• Use Paste Special to adjust values in place by selecting the operation you want after copying the values.

Use named ranges to make formulas more readable

• Use named ranges to improve formula readability.
• Named ranges are only for data validation.
• Avoid using named ranges for clarity.
• Use named ranges to complicate formulas.

On excel A,B,C... are?

• Row labels in a spreadsheet.
• Data types in a database.
• File formats for saving documents.
• Column headers in a spreadsheet.

On Excel 1,2,3... are?

• Rows

• Boolean values
• Date values
• Text values

On Excel for example A7 is?

• Cell B7
• Cell A7
• Column A
• Row 7