4. Creating User-friendly Spreadsheets Flashcards
0
Q
What is the order of operation?
A
Same as maths
- Brackets
- Exponents
- Multiplication/division from left to right
- Addition/subtractions from left to right
1
Q
What are the operators that differ from mathematics?
A
- Multiplication *
- Division /
- Exponents ^
- Not equal <>
2
Q
What is the basic formula to calculate the variables when dealing with VAT?
A
The amount you want is calculated by:
- Percent of what you need
- Divide by percent of what you have
- Multiply by what you have in Randa
3
Q
What is the mark-up?
A
The amount the selling price exceeds cost price
4
Q
What is gross profit?
A
Amount selling price exceed cost price
5
Q
How is the mark-up percentage calculated?
A
(selling price - cost price) / cost price
6
Q
How is gross profit margin calculated?
A
(selling price - cost price) / selling price
7
Q
What is a print area?
A
The selected range of cells to print