• 0 Posts
  • 91 Comments
Joined 3 years ago
cake
Cake day: October 1st, 2023

help-circle













  • Excel sees the cells you tell it to operate on. When you’re working with code, all the code is relevant. Usually in Excel, you have specific cells you want to do an operation on, and those are provided to the function, just like any other thing you do in Excel. If you want to operate on the entire spreadsheet, just provide a range including the entire spreadsheet, but this is not done unless you ask for it.





  • People do all sorts of weird non-math stuff in Excel. The stated use-case for this feature is stuff that operates on text. Say for example you fill column A with quotes from your customers about your product. Then you can tell Copilot to provide a summary of each row in column B, and whether the sentiment is positive or negative in column C. You could aggregate the results as well.

    There are better tools for that sort of thing, but a lot of people really love their Excel hammer, and they see nails everywhere.



  • bus_factor@lemmy.worldtoMemes@sopuli.xyzVery normal and safe
    link
    fedilink
    arrow-up
    29
    arrow-down
    3
    ·
    edit-2
    21 days ago

    It pains me to defend an AI feature, but this whole tweet is disingenuous and stupid. The documentation for =COPILOT() says a few things which are relevant to understand what we’re seeing here:

    • You’re not supposed to use it for math
    • It only has access to the parts of the spreadsheet you pass it as the second argument

    In this case the user has not provided copilot any cells to look at, so they’re just asking what the typical answer on the Internet is for the request “sum the numbers above”. And the sum of numbers above things are apparently often 15.