Excel Job Interview Questions test for application 2021 2019
Learn excel interview questions in ten minutes Beginner excel tips and tricks 2021 excel tutorial 2021 2021 msexcel tutorial for beginners 2021 ms excel tutorial for beginners Excellent Excel Dude
/ exceldude
Chapters:
00:00-01:19 What are common data formats?
01:19-02:28 How does Excel Calculate?
02:28-03:40 What is VLOOKUP and how does it work?
03:40-04:57 Explain a Pivot Table, show me.
04:57-05:54 What's a spreadsheet? Why is it different than a workbook?
05:54-06:36 Show me some formatting (Multiple examples)
06:36-07:10 What functions do you use most often?
07:10-08:10 What's the Ribbon & how are the tabs on it different?
08:10-08:58 What's a function and why would you use one?
08:58-11:10 What's a logical statement? Show me an example.
11:10-11:50 Specific Syntax Questions (I HATE these!)
11:50-13:09 Absolute vs Relative reference
13:09-13:49 What are some of your best practices in Excel?
13:49-13:55 Most difficult problem you've solved in Excel
13:55-14:42 Adding comments in a cell? How & why?
14:42-15:32 How do you use shortcuts? Cell inputs with one key?
15:32-16:25 Hotkeys to add or delete a worksheet or column?
16:25-17:59 What is a Macro? How do you record and use one?
17:59-18:39 Build me a chart (Several methods)
18:39-19:44 Can you lock a worksheet or specific cells?
19:44-20:18 How can you view a worksheet in more than one window?
20:18-20:46 How do you spellcheck a workbook/worksheet?
20:46-21:33 How do you freeze a top row in a worksheet? Columns?
21:33-21:58 How do you remove gridlines?