Spreadsheet Modeling and Formulae Quiz

How can you edit a spreadsheet model?

• By clicking on the cell and typing in the new value or formula

• By asking someone else to do it

• By shaking the computer screen

• By deleting the entire spreadsheet

What are the steps to create formulae using cell references?

• Start with a dollar sign ($) followed by the function or mathematical operation, and then select the cells you want to reference.

• Start with an equal sign (=) followed by the function or mathematical operation, and then select the cells you want to reference.

• Start with an exclamation mark (!) followed by the function or mathematical operation, and then select the cells you want to reference.

• Start with a hashtag (#) followed by the function or mathematical operation, and then select the cells you want to reference.

Explain the order of mathematical operations in a spreadsheet model.

• BODMAS

• PEMDOS

• PEMDAS

• BEDMAS

What is absolute cell referencing and how is it used in a spreadsheet model?

• Absolute cell referencing is used to delete a specific cell in a spreadsheet model.

• Absolute cell referencing is used to change the font color of a specific cell in a spreadsheet model.

• Absolute cell referencing is used to keep a specific cell reference constant in a spreadsheet model.

• Absolute cell referencing is used to merge multiple cells in a spreadsheet model.

Describe the concept of relative cell referencing in a spreadsheet model.

• Relative cell referencing is not a feature available in spreadsheet models

• When a formula is copied to another cell, the cell references in the formula are adjusted relative to the new location.

• When a formula is copied, the cell references stay the same

• Relative cell referencing only works for text values, not numerical values

What are the key features of a well-edited spreadsheet model?

• No use of formulas or functions

• Clear and organized data, consistent formatting, proper use of formulas and functions, error checking, and documentation

• Random and inconsistent formatting

• Colorful and eye-catching design

Why is it important to understand the order of mathematical operations in a spreadsheet model?

• To waste time and effort

• To confuse people using the spreadsheet

• To make the spreadsheet look more organized

• To ensure accurate calculations and prevent errors

How do you create a formula using cell references in a spreadsheet model?

• Start with a hashtag (#) followed by the cell references

• Start with a dollar sign ($) followed by the cell references

• Start with a plus sign (+) followed by the cell references

• Start with an equal sign (=) followed by the cell references and the mathematical operators or functions.

Explain the difference between absolute and relative cell referencing.

• Absolute cell referencing and relative cell referencing both change based on the position of the formula.

• Absolute cell referencing always refers to a specific cell, while relative cell referencing changes based on the position of the formula.

• Absolute cell referencing changes based on the position of the formula, while relative cell referencing always refers to a specific cell.

• Absolute cell referencing and relative cell referencing both always refer to a specific cell.

What are the common mistakes to avoid when editing a spreadsheet model?

• Not using consistent formatting, not double-checking formulas for accuracy, not labeling or documenting assumptions, and not validating data inputs

• Labeling and documenting assumptions

• Double-checking formulas for accuracy

• Using consistent formatting