Test 8
Once a range has been named, you can go to a range
  • By selecting ranges using the F8 key
  • Both a and b
  • None of the above
The built in default copying in excel is programmed to
  • Use relative position when copying formulas
  • Use absolute position when copying formulas
  • Use mixed position when copying formulas
  • None of the above
Explanation: a. Use relative position when copying formulas By default, Excel uses relative references when copying formulas. This means that the cell references in the formula adjust relative to the position where the formula is copied. For example, if you copy a formula from cell A1 to cell B1, a reference to A1 in the original formula will change to B1 in the copied formula.
Formulas with absolute references are references that always.
  • Refer to the different cells, regardless of the location of the formula
  • Refer to the same cells, regardless of the location of the formula
  • Refer to the same cells, regardless of the location of the formula d. None of the above
  • None of the above
Explanation: c. Refer to the same cells, regardless of the location of the formula Formulas with absolute references always refer to the same specific cells, regardless of where the formula is copied. This is achieved by using the dollar sign ($) in the cell references (e.g., $A$1).
The today() function enters the current
  • System time in cell
  • System date and time in cell
  • System date only
  • None of the above
Explanation: c. System date only The TODAY() function in Excel returns the current system date only, without the time. If you need both the current date and time, you would use the NOW() function.
A function in Excel
  • Is a readymade formula
  • Is a shortcut formula
  • Can be built using Function Wizard
  • All of the above
Explanation: In Excel, a function: Is a readymade formula designed to perform specific calculations. Acts as a shortcut to more complex formulas, allowing users to perform calculations quickly and efficiently. Can be built using the Function Wizard, which helps users insert functions and provides guidance on the required arguments.
Mark the most appropriate statement
  • Now () can be used to display the current time.
  • Now () can be used to display the current date.
  • Now () can be used to display the current date as well as time in the same cell.
  • None of the above
Explanation: The NOW() function in Excel returns both the current date and the current time in the same cell.
Which of the following is not a financial function?
  • FV ()
  • NPV ()
    • Explanation: The SUM() function is not a financial function; it is a basic mathematical function used to add up a range of numbers. The other options, FV(), NPV(), and PMT(), are all financial functions used for various financial calculations such as future value, net present value, and payment amount, respectively.