Forum Discussion

kinetic_bomb's avatar
kinetic_bomb
Copper Contributor
Jun 13, 2017

I am Excel ignorant and need help for college assignment.

Hello, Everyone. I am a doing a computer assignment for a single college credit, and this one is aboou the use of excel. I have NEVER clicked on the thing before on any of the computers i have had, and now this assingment tells me to go do a bunch of complex stuff with it. The last credit assignment was for datasheet, and that i have never had a need to open either. But that one i managed to hash out. 

 

This assignment ihave been getting done through googling everything, I am up to thsi part where the instructions are vague. 

 

 Modifying the Worksheets

  1. The Board of Directors decided to increase Valerie’s part time hours. Now, she will earn $15,000 per year.  Make the necessary adjustment (Salary worksheet.).
  2. Choose a Format from the AutoFormat gallery that best represents the data and apply it to the Expenses worksheet.
  3. Print out a copy of the Expenses worksheet and label it Part I e.

I am working on 2 worksheets. The second one, which is for the slaries, has one of the empliyees salary going up to $15,000, when the original data entry was for $10,000. How do i modify this? Do I simply replace $10,000 in the cell with $15,000 instead? Or Is there something specific I have to do? 

 

Let me know if anypne will need the whole sheet of instrcutions for the assignment. There is a previous part if it that i got done that i am not sure i did corrrectly. 

 

 

 

7 Replies

  • Hello,

    if there is an assignment about Excel, wouldn't the course include some basic instructions on how to use Excel?

     

    It is hard to advise you where to make a change without knowing the workbook. But if there is a cell where the number 10000 has been entered as a value, chances are that if you change that to 15000, it will do the trick. Just make sure the cell has a number and not a formula. You can see that in the formula bar. If the formula bar shows a number, then you can enter a different number. If the formula bar shows a formula that starts with a = sign, then you should not write a different number into that cell. 

    • kinetic_bomb's avatar
      kinetic_bomb
      Copper Contributor

      This is a series of little assignments and tests for people to get extra credits at Nyack College. No specific course at all. You choose which assignment you want to do. I did all of them, and this last one is for excel, unfortunately. 

       

      I am also \thinking thta i have to do something more complex than changing 10,000 to 15,000 becuase of the "Autoformat" thing. 

      • Well, if you are "thinking" that it may be more complex than just changing a number, I'm afraid we have reached the end of what we can advise without seeing the actual workbook. 

         

        Excel is a platform for writing powerful business calculation scenarios and we can't just "magically" see what you need to do to complete your assignment. 

         

        Share the workbook for inspection. Then we can see what's what.

Resources