starQuiz2ResultsFile Spreadsheets Credit 4 :
250 +361 6 7 d*CHOOSE YOUR TEACHER FROM THE OPTIONS BELOW @E CHOOSE YOUR TEACHER FROM THE OPTIONS BELOW @q k l Mr McGivern mMr Carey n Mrs Smith oMr Munro 1000 @ 173607 dA shop uses a spreadsheet to keep control of its stock.
Column E uses a formula that compares the values in column C and D and places a Y or an N in E, depending on whether the item needs to be re-ordered.
What kind of formula would be used in column E? @p0 A shop uses a spreadsheet to keep control of its stock.
Column E uses a formula that compares the values in column C and D and places a Y or an N in E, depending on whether the item needs to be re-ordered.
What kind of formula would be used in column E? [KU] @ k 1000 @ 173608 dThe formula in cell E2 was replicated to cells E3 to E5. Would absolute or relative replication have been used here? Explain your answer. [PS] @b The formula in cell E2 was replicated to cells E3 to E5. Would absolute or relative replication have been used here? Explain your answer. [PS] @ k 2000 @ 173609 dXWhat would be done to stop the formula in column E from being accidentally altered? [PS] @V What would be done to stop the formula in column E from being accidentally altered? [PS] @( k 1000 @ 173610 dqThe item code in column A includes a check digit.
Is a check digit an example of validation or verification? [KU] @\@ The item code in column A includes a check digit.
Is a check digit an example of validation or verification? [KU] @D k 1000 @ 173611 d@Explain the difference between validation and verification. [KU] @P Explain the difference between validation and verification. [KU] @h k 1000 @ 173612 dTWhat is the purpose of including an item code as well as the name of each item? [PS] @U What is the purpose of including an item code as well as the name of each item? [PS] @ k 1000 @ 173613 djThe manager sends the spreadsheet to head office as an attachment to an Email.
What is an attachment? [KU] @Z The manager sends the spreadsheet to head office as an attachment to an Email.
What is an attachment? [KU] @ k 1000 @ 173614 dDGive one advantage to sending the spreadsheet as an attachment. [PS] @Q Give one advantage to sending the spreadsheet as an attachment. [PS] @ k 1000 @ 173615 dAn employee in the shop asks for a copy of the software used to create the shop’s spreadsheets, to install on their own machine.
Which piece of legislation makes this action illegal? [KU] @g An employee in the shop asks for a copy of the software used to create the shop’s spreadsheets, to install on their own machine.
Which piece of legislation makes this action illegal? [KU] @p k 1000 @ 173616 2 3 4 @ 9418 ! ) @ 7822