4. Creating User-friendly Spreadsheets Flashcards

0
Q

What is the order of operation?

A

Same as maths

  1. Brackets
  2. Exponents
  3. Multiplication/division from left to right
  4. Addition/subtractions from left to right
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
1
Q

What are the operators that differ from mathematics?

A
  1. Multiplication *
  2. Division /
  3. Exponents ^
  4. Not equal <>
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A

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
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is the mark-up?

A

The amount the selling price exceeds cost price

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is gross profit?

A

Amount selling price exceed cost price

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

How is the mark-up percentage calculated?

A

(selling price - cost price) / cost price

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

How is gross profit margin calculated?

A

(selling price - cost price) / selling price

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is a print area?

A

The selected range of cells to print

How well did you know this?
1
Not at all
2
3
4
5
Perfectly