Forum Discussion

Ye Chen's avatar
Ye Chen
Copper Contributor
Jul 05, 2018

may i have an assist please.... please...please..."copy the function to cell range"

may i have an assist please....

i got a question from ECDL sample test but not understand what does it means "copy the function to cell range", is it copy the funtion and apply to all the cell range/F4 it and apply? or it got some different meaning...help please..

[Enter a function in cell B15 to calculate the minimum of the cell range B5:B10. Copy the function in cell B15 to the cell range C15:D15]

BI & Data Analysis
Excel
Excel on Mac
Excel on mobile
Excel Online
Formulas and Functions
training
User Adoption
  • Lorenzo Kim's avatar
    Lorenzo Kim
    Bronze Contributor
    Jul 14, 2018

    I am not an EXCEL guru - but interpreting your query, I made a sample. Please see if it is what you are asking.. I can not figure out what it suppose to mean...

    thanks

    • Lorenzo Kim's avatar
      Lorenzo Kim
      Bronze Contributor
      Jul 14, 2018
      erratum:
      should read >
      B15 CONTAINS THE MINIMUM OF RANGE B5 TO B10

Resources