Forum Discussion
I am Excel ignorant and need help for college assignment.
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.
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.
If i teach students i'd recommend them to avoid autoformat...
Check this http://www.easytweaks.com/auto-format-dates-cells-sizes-height-excel-2016/, that's how to use it in Excel 2016, for earlier versions it shall be similar
She will be checking for proficiency in the use of excel features, so i have to use autoformat.
Googling is no problem; that's how i got half the assignment done so far. But thsi particualr part of it seems pretty unclear. Or it is straight forward and i am just over-reading into it.
- Three steps
- add autoformat to your menu, it's not here by default. Better to Quick Access, will be easier to remove then. As in article.
- select cells you'd like to format (could be empty cells) and click on added on previous step autoformat icon
- in appeared window select any formatting style you like and click ok
Do first step literally as described, the rest is obvious. The most complex thing your exercise assumes you have autoformat button available. Actually most probably it's not here, that's why first step is required
