Y&NE TS Knowledge Quiz

Create an informative and visually appealing illustration featuring elements of financial analysis, technical services, and collaborative teamwork within an office environment, using bright colors and modern design.

Y&NE TS Knowledge Quiz

Test your knowledge and expertise in Technical Services (TS) with our comprehensive quiz that covers key concepts, procedures, and software techniques. Whether you're a novice or a seasoned professional, this quiz is designed to enhance your understanding and prepare you for real-world applications.

22 engaging multiple-choice and text questions
Instant feedback on your answers
Perfect for professionals looking to sharpen their skills

22 Questions6 MinutesCreated by EngagingExpert47

How long have you worked in TS?

More than 2 years

6 months - 2 years

1 month - 6 months

Less than 1 month (Graduates)

1. A proposal can be sent out with no prior conflict check being approved

True but the client must be informed

True but the client cannot be listed

True no conditions

False a CC must be approved first

2. When should a first draft Engagement Letter be sent to the client?

Before the TOP is signed

Before EPCC 1 is signed

Before work commences

Before first draft report is sent

3. Who must sign EPCC Stage 1?

Engagement Manager, LEP

LEP, EQAR

Who created EPCC, Engagement Manager, LEP, EQAR

Who created EPCC, LEP, EQAR

4. When can an IRL be sent to the client?

No take on required, I.e. anytime

After CC and TOP cleared

After EPCC Stage 1 signed

After Engagement Letter sent

5. Can excel workings be shared with the client?

Never

Sometimes, appropriate disclaimers and LEP approval

Sometimes, LEP approval only

Always

6. An AM is taking notes and struggles to with the speed of the conversation, they ask if you (a manager) if they can record the meeting on their phone through voice notes, what is the correct response:

Yes, what a great idea, can you file them on the onedrive though please

Yes, but don’t tell anyone

No, we would need the client’s permission to record the meeting

No, we are never allowed to do this

7. When should a PSR docket be raised for a draft report release?

A week before the report is sent

As soon as you know the date of when the report is being released

The day before the report is being sent

At the start of the project and just keep moving it

8. The report being sent is a Volume 1: FDD report, with Tax (Volume II) to follow next week. Is a tax partner review and sign off needed?

No, this is an FDD volume no tax review is needed

It depends, if tax items are within the value schedules, then a review/sign off is needed

Yes, a tax review is always needed if they share the same Engagement Letter

Yes, every report needs tax sign off

9. What is the correct review cycle?

Manager/Director, LEP, Call & Cast, EQAR, PSR, 2nd LEP

Manager/Director, Call & Cast, LEP, PSR, 2nd LEP, EQAR

Call & Cast, Manager/Director, LEP, EQAR, 2nd LEP, PSR

Call & Cast, Manager/Director, LEP, EQAR, PSR, 2nd LEP

10. What is the purpose of a PBAA in a VDD?

The client signs the PBAA so they can distribute to multiple buyers

Only the lender (bank) signs it when the report goes final, so they have reliance on the report and funding

All potential buyers sign to have access to the report

We (Deloitte) sign it, to say no one but the client has reliance on the report

11. I have been linking my worksheet to “Model v11”, the client have updated the file to “Model v12”, what is the most efficient way to update this?

Don’t bother, there won’t be many changes and any changes can be done manually

Use “find and replace” for “v11” to “v12”

Redo the entire workbook

Use data>edit links and change the file path

13. What does the shortcut, Ctrl G do?

Drags a formula to the bottom of a table

Copy’s formatting

Takes you to the last cell you worked in

Follows the formula source

15. What does the lightening button on the toolbar do?

Prepares an empty worksheet for Deloitte formatting

Deletes all empty rows and columns

Finds errors in your workbook

Turns all numbers black

16. A client sends data for multiple years and entities in a workbook, but all the information is in separate worksheets, what can I do to consolidate it?

Nothing, never change client data

The FA toolbar has a Combine button

Ask TSA/DIJV to combine it

Manually copy and paste

17. I’ve been pasting in tables to powerpoint from excel and they have green triangles everywhere, what should I do?

Keep them, it makes the report look pretty

Right click on each one and press ignore

Turn off formula errors in settings

Put a white box over them in the report

18. My excel workbooks should be saved where?

On my hard-drive

On flex

On Deloitte One-drive

On Personal One-drive

19. I am looking at the average occupancy within 15 care homes throughout the year, sum of which are newly opened in year, what formula should I use?

Index match

Sum of each care home / Sum of total

Average

Averageifs

20. I want to highlight the top 10 accounts in year for revenue, how should I do this?

Write down each revenue and figure it out manually

Take a copy of the spreadsheet and sort by high to low

Use excel conditional formatting

Use an average ifs formatting formula

Y&NE TS Knowledge Quiz

Y&NE TS Knowledge Quiz

More Quizzes