Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Question from an Excel test - Please Answer

0

I got below question on an excel test, and I didn't mange to find the answer. Could anybody help?

Answer
Discuss

Discussion

No thanks! We're not here to do your Excel test (or homework), even if you had told us what the question was (which you didn't, probably tried to paste and image into your question and didn't notice that nothing was added).
John_Ru (rep: 6142) Mar 24, '22 at 9:37 am
Yes to what John said!
don (rep: 1989) Mar 24, '22 at 1:24 pm
First time using this forum, did not realize that the image was not showing. 
This is a genuine Excel question/doubt I have. If you know how to solve below question with the correct formula that would be much appreciated. Thanks!


In yellow cells below create a single formula that can be copied in to all yellow cells without change, that calculates the same result as table on the right (i.e. sum of row and column headers).                         Expected results   1 3     1 3 20       20 21 23 30       30 31 33
bmrt29 Mar 25, '22 at 5:46 am
No one here wants to do someone else's homework, that is the thing. It is not about the image.
don (rep: 1989) Mar 26, '22 at 8:29 am
Dude, its not HW, its just a excel question I saw and didnt know the answer. I thought this forum was to help people with excel doubts, not police why the question was posted in the first place.
bmrt29 Mar 31, '22 at 10:34 am
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login