Scribd
Upload
19 views8 pages

Excel Interview Question

The document outlines various Excel-related questions and solutions, including how to manage bank balances, format tables, extract IDs and names, and perform data analytics tasks. It provides formulas and methods for tasks like auto-incrementing IDs, creating drop-down lists, and calculating employee statistics. Additionally, it mentions the use of conditional formatting and pivot tables for data analysis.

Uploaded by

rajusakshenada
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
19 views8 pages

Excel Interview Question

The document outlines various Excel-related questions and solutions, including how to manage bank balances, format tables, extract IDs and names, and perform data analytics tasks. It provides formulas and methods for tasks like auto-incrementing IDs, creating drop-down lists, and calculating employee statistics. Additionally, it mentions the use of conditional formatting and pivot tables for data analysis.

Uploaded by

rajusakshenada
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 8

Ctrl +g dbake row difference ques- 2023 m kisne chhoda aur 2024 m kon new h

Ques- company ka bank balance affect hona chahiye

Iske liye hi ye formula hai


Ques- bahut badi table m se sirf kuchh portion hi show krna h

Sol- format m jake hide & unhide mai hide row jo selected hai then ctrl+ g mai jake remaining select
visible cell only pr click then ok
Ques- mix h isme se id no nikal ke id no. mai then name nikalke name mai

Sol – ctrl + g then selected hona chahiye pura constant then ek baar number pr check baki uncheck fir
wahi copy krkr daldo then again text check and baki uncheck

Ques- employee m sare bade kro capital m kro

Sol ek jagah upper lgake puri employee upper krliya then copy then employe whole select then
ctrl+alt+v then values pr click ho jayega

2nd sol - ek baar rajesh capital m likh k + pr double click sare name aa jayega
Ques- auto increment id no

Sol yehi formula daldo

Ques- isko table form mai

Sol- select -> text to coloumn -> delimeter -> next-> comma check krdena hai bas
Ques- pan k 4th character s defined krna

Sol- switch mid wala formula use

Next video s hamne data analytics in excel interview question kiye

1. Vlookup lgake location nikali


2. Countif k use krke btana h total employees for each service line

Sol- isme pehle puri range mai jo pucha h serviceline whole select -> level 2 sheet pr aake
koi v sevice line name choose krke ) ok
3. Drop down list bnani h wo to ho jayega

4.
Ques- total no. of employees sabke liye

Sol- cell fridge krne h sheat change krte waqt countifs lgake pehle service line then location wala
then ahemdabad lelio -> v baki sum ka formula lgake remaining field aajayegi

5. Ques- percentage retainers ki nikalo fir if use krke 5% ok above 5% not ok

Sol- retairnesrs find krne ka trika 31/404 = 5% khud aajayega then status if ka formula lgado
6. Conditional formatting to krlenge

7. Ques- dekhle aur sara if se ho jayega cell refrencing v lgegi ek jagah so dhyan se
8.

Ques- pivot table le then konsi row m dalni h konsi value and columns bas done

Datedif () iska use krke nikal lenge

You might also like