Y&NE TS Knowledge Quiz
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
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
12. What is the shortcut to group rows/columns together?
Ctrl G -
Alt A G G
Shift G +
There isn’t one
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
14. Which headers in a Deloitte table should be in Dark Grey?
Forecast periods
Outturn periods
LTM & YTD
YTD
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
{"name":"Y&NE TS Knowledge Quiz", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"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 questionsInstant feedback on your answersPerfect for professionals looking to sharpen their skills","img":"https:/images/course6.png"}
More Surveys
Task 4.2: Review Process
5230
CIA Part 1
13638
ICQA Auditor Application
63109
PSSR question summary
7429
Formal Secretaries Boards of Examiners
6331
Agile Maturity Test
1050
Master Your Sales Skills Quiz
10510
Questionnaire
3225
Banking and Credit Analysis
84102
The Scrum Framework
1477
How many Endo interviews do you have so far?
3229
Free Day of PTO competition
1268