4. Creating User-friendly Spreadsheets

Question 0

What is the order of operation?

Answer 0

Same as maths

1. Brackets
2. Exponents
3. Multiplication/division from left to right
4. Addition/subtractions from left to right

Question 1

What are the operators that differ from mathematics?

Answer 1

1. Multiplication *
2. Division /
3. Exponents ^
4. Not equal <>

Question 2

What is the basic formula to calculate the variables when dealing with VAT?

Answer 2

The amount you want is calculated by:

1. Percent of what you need
2. Divide by percent of what you have
3. Multiply by what you have in Randa

Question 3

What is the mark-up?

Answer 3

The amount the selling price exceeds cost price

Question 4

What is gross profit?

Answer 4

Amount selling price exceed cost price

Question 5

How is the mark-up percentage calculated?

Answer 5

(selling price - cost price) / cost price

Question 6

How is gross profit margin calculated?

Answer 6

(selling price - cost price) / selling price

Question 7

What is a print area?

Answer 7

The selected range of cells to print