LO 2

Question 1

What does every Excel formula begin with?

Answer 1

An equals sign (=).

Question 2

What is BODMAS?

Answer 2

BODMAS stands for Brackets, Order (Power), Division, Multiplication, Addition, and Subtraction, dictating the order of operations in Excel.

Question 3

How does Excel prioritize operations in a formula?

Answer 3

Excel follows the BODMAS rule, executing operations in this order: Brackets, Order, Division, Multiplication, Addition, and Subtraction.

Question 4

What does the error value #DIV/0! indicate in Excel?

Answer 4

It appears when you are dividing by 0 or if the cell is empty.

Question 5

What is a relative reference in Excel?

Answer 5

A relative reference changes when a formula is copied to another cell (e.g., A1 becomes A2 when copied down).

Question 6

What is an absolute reference in Excel?

Answer 6

An absolute reference is fixed and does not change when a formula is copied (e.g., $A$1).

Question 7

How do you make a cell reference absolute?

Answer 7

By adding dollar signs before the column letter and row number (e.g., $A$1).

Question 8

What is a mixed cell reference in Excel?

Answer 8

A mixed reference locks either the row or the column (e.g., $A1 locks the column, A$1 locks the row).

Question 9

How can you use the Insert Function button in Excel?

Answer 9

By clicking the Insert Function button (fx) in the Function Library group of the Formulas tab to search and insert functions.

Question 10

What is the purpose of naming cells and ranges in Excel?

Answer 10

Named ranges can be used in formulas for easier reference and to make formulas more understandable.

Question 11

How do you create a named range using the Name Box?

Answer 11

Select the range, then type the desired name into the Name Box and press Enter.

Question 12

What is the syntax for the LEFT function in Excel?

Answer 12

LEFT(text, num_chars) returns the specified number of characters from the start of a text string.

Question 13

What is the syntax for the MID function in Excel?

Answer 13

MID(text, start_num, num_chars) returns a specific number of characters from a text string, starting at the specified position.

Question 14

How do you isolate the first two characters of the text in cell A1 using the LEFT function?

Answer 14

=LEFT(A1, 2).

Question 15

What is the syntax for the RIGHT function in Excel?

Answer 15

RIGHT(text, num_chars) returns the specified number of characters from the end of a text string.

Question 16

What formula can you use to calculate VAT for a product priced in cell B3 with a VAT rate in cell B12?

Answer 16

=B3*B12. Use absolute referencing for B12 if copying the formula (e.g., =B3*$B$12).

Question 17

How can you calculate the monthly profit/loss for Forth Valley Fitness in a spreadsheet?

Answer 17

Use the formula Total Income - Total Expenses for each month.

Question 18

What function calculates the total sales for a range named “Sales”?

Answer 18

=SUM(Sales).

Question 19

How do you use the IF function to check if a value in cell A1 is greater than 100 and return “Yes” or “No”?

Answer 19

=IF(A1 > 100, "Yes", "No").

Question 20

How can you calculate the profit/loss percentage for a specific month?

Answer 20

=Monthly Profit / Total Profit formatted as a percentage.

Question 21

What is the formula to calculate the price plus VAT if the VAT amount is in cell D3?

Answer 21

=Price + D3.

Question 22

How can you use absolute references to copy the VAT calculation correctly in a list of products?

Answer 22

Use the formula =B3*$B$12 to ensure the VAT rate in cell B12 does not change when copied.

Question 23

What does the error value #NAME? mean in Excel?

Answer 23

It appears when a formula contains text that Excel does not recognize, such as a misspelled function name or missing quotation marks.

Question 24

What does the #VALUE! error indicate?

Answer 24

It indicates that an incorrect type of argument or operator has been used in a function.

Question 25

How can you fix the ##### error in a cell?

Answer 25

Widen the column to fit the data.