Last answered:

26 Dec 2021

Posted on:

07 May 2021

0

Paste Special; Pasting only the formulas

At 0:50 when using the paste special to paste only the formulas; When pasting SUM(D9:D10) why doesn't it show the actual summary of the numbers existing in the cells D9 and D10? Why is it showing 0 instead?

5 answers ( 0 marked as helpful)
Instructor
Posted on:

07 May 2021

1

Hi MIchael,

The cells in D9 and D10 are empty and hence the formula shows 0.

Best,
Ned

Posted on:

07 May 2021

0

Oh ok,  it seems that I identified the cells incorrectly. Thanks for the quick reply.

Posted on:

08 May 2021

0

How many Project should to as a beginner in Excel , SQL , Poer Bi - Tablue, R Basic , Python Basics ?

Posted on:

26 Dec 2021

0

What is the concept of "formula" while using special paste?
How come the formula 136 and 129 came for the given exercise?

Instructor
Posted on:

26 Dec 2021

0

Hello,
A formula is the operation that we've specified in the formula bar.
Best,
Ned

Submit an answer