Spreadsheet Sample Assessment
BYERS24
Registered Posts: 7
Hi
I'm little confused with this practice assessment and the lecturer from the college hasn't been very helpful so I hope you can help me please?
When it is asking to highlight the highest bids in the ebid file I can't seem to get it to work at all! Can someone give me the steps on how to do this please? I'm using excel 2010.
The answer I got from the lecturer was that conditional formatting is straight forward and you click on it from the styles menu (which I already know!). I'm really panicking in case this comes up in the real exam.
Thanks
I'm little confused with this practice assessment and the lecturer from the college hasn't been very helpful so I hope you can help me please?
When it is asking to highlight the highest bids in the ebid file I can't seem to get it to work at all! Can someone give me the steps on how to do this please? I'm using excel 2010.
The answer I got from the lecturer was that conditional formatting is straight forward and you click on it from the styles menu (which I already know!). I'm really panicking in case this comes up in the real exam.
Thanks
0
Comments
-
In Excel 2013 you simply highlight all required cells, hit Conditional Formatting and select 'Highlight Cell rules' then 'more rules'.
This brings up a box in which you can choose your rule (in this case, highlight lowest/highest), and set the formatting you want when the rule is met.0 -
Thanks for replying.
When I've tried this its creating a 2 tone effect on the values. Would this be allowed in the assessment?0 -
I think you just need to change the 'fill' format choice within the settings box (check the tabs along the top of the box), sounds like it's applying a pattern rather than a solid fill.0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 317 NEW! Qualifications 2022
- 155 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 92 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 272 VAT
- 92 Software
- 274 Tax
- 136 Bookkeeping
- 7.2K General accounting discussion
- 201 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 582 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership