3 EOT

What is the purpose of starting a formula with an equal sign (=) in Excel?

• To prevent the formula from showing errors
• To make Excel ignore the formula
• To tell Excel that the input is a calculation
• To ensure the formula is treated as text

Which of the following is an example of an arithmetic operator in Excel?

• +
• @
• &
• #

In Excel, which operation will be calculated first according to the order of operations?

• Parentheses
• Multiplication
• Subtraction
• Addition

If the formula =A1 + B1 * C1 is entered, which operation will be performed first?

• A1 + B1
• B1 * C1
• A1 - C1
• None of the above

What is the role of the Control Unit (CU) in the CPU?

• Controlling the operations of the computer system
• Managing access to secondary memory
• Storing data permanently
• Performing arithmetic operations

What is the primary difference between RAM and ROM?

• RAM retains data after power is off, while ROM doesn’t
• ROM allows faster read and write access than RAM
• ROM is faster than RAM
• RAM is volatile, while ROM is non-volatile

Which type of memory allows quick access to data being processed?

• Cache memory
• RAM
• ROM
• Secondary memory

Which device provides secondary storage in a computer?

• Arithmetic Logic Unit (ALU)
• Hard disk
• CPU
• Control Unit

If the formula =A1 - A2 + A3 is copied from cell B1 to B2, what will the new formula in B2 be?

• =A1 - A2 + A3
• =B1 - A2 + A3
• =A2 - A3 + A4
• =B2 - A2 + A3

Which formula correctly calculates the total cost when quantity is in A1 and price per item is in B1?

• =A1 - B1
• =A1 * B1
• =A1 + B1
• =B1 / A1