Scribd
Upload
170 views2 pages

Excel Data Entry Interview Guide

This document serves as an interview preparation guide for data entry jobs focusing on essential Excel skills. It covers important topics such as basic Excel functions, data entry techniques, and common interview questions with suggested answers. Additionally, it provides a list of useful keyboard shortcuts for efficient Excel use.

Uploaded by

ayush.gupta92102
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
170 views2 pages

Excel Data Entry Interview Guide

This document serves as an interview preparation guide for data entry jobs focusing on essential Excel skills. It covers important topics such as basic Excel functions, data entry techniques, and common interview questions with suggested answers. Additionally, it provides a list of useful keyboard shortcuts for efficient Excel use.

Uploaded by

ayush.gupta92102
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/ 2

Excel for Data Entry - Interview Prep Guide

1. Important Excel Topics for Data Entry Jobs

- Basic Excel Interface: Cells, Rows, Columns, Workbook vs Worksheet

- Data Entry & Formatting: Bold, Font Size, Color, Alignment

- Basic Formulas: SUM(), AVERAGE(), COUNT(), MAX(), MIN()

- Sorting & Filtering Data

- Data Validation: Drop-downs, restrictions

- Copy, Paste, Paste Special

- Useful Keyboard Shortcuts

- Basic Charts (Bar, Pie) - Optional

- Freeze Panes / Split View

- Excel Table Creation from Range

2. Common Interview Questions with Answers

Q: Aap Excel me kis level tak kaam kar sakte ho?

A: Mujhe basic se lekar intermediate level tak kaam aata hai jaise data entry, sorting, filtering aur formulas ka

use.

Q: Kya aapko basic formulas pata hain jaise SUM, AVERAGE?

A: Haan, main SUM, AVERAGE, COUNT, MAX, MIN jaise formulas ka use karta hoon.

Q: Aapne kabhi Excel me data filter kiya hai? Kaise karte ho?

A: Haan, Data tab me jaakar Filter option se specific data ko filter kiya ja sakta hai.

Q: Sorting aur Filtering me kya difference hai?

A: Sorting data ko order me arrange karta hai (A-Z), jabki filtering se specific data dikhai deta hai.

Q: Data validation kya hota hai?

A: Ye feature data entry ko control karta hai jaise ke sirf numbers ya dropdown values allow karna.

Q: Freeze Panes ka use kab aur kaise karte ho?

A: Jab hume headers ko scroll karte waqt bhi dikhana hota hai, toh View tab me jaake Freeze Panes use

karte hain.

Q: Excel me Table aur Range me kya farak hai?

A: Table me filtering, formatting aur dynamic referencing hoti hai, range me ye features limited hote hain.

Q: Shortcuts batao data copy-paste ke liye.


A: Ctrl+C (Copy), Ctrl+V (Paste), Ctrl+X (Cut)

Q: Ek column me duplicate values kaise check karoge?

A: Conditional Formatting ka use karke Duplicate Values select karke.

Q: Excel me error #DIV/0! ka matlab pata hai?

A: Jab kisi number ko 0 se divide karte hain toh ye error aata hai.

3. Useful Excel Keyboard Shortcuts

- Ctrl + C : Copy

- Ctrl + V : Paste

- Ctrl + X : Cut

- Ctrl + Z : Undo

- Ctrl + Y : Redo

- Ctrl + Arrow keys : Move to edge of data region

- Ctrl + Shift + L : Apply/remove filters

- Ctrl + Space : Select column

- Shift + Space : Select row

- Alt + E + S + V : Paste Special (Values)

You might also like