πŸ’» Computer Knowledge πŸͺ„ ( Basics - Advanced ) Quiz PDF
336 subscribers
757 photos
1.54K videos
2.14K files
3.46K links
Computer πŸ’»


@II_Way_to_Success_II.

Computer disscus
https://t.me/computer_discuss
Download Telegram
❀1πŸ‘1πŸ”₯1πŸ₯°1🀩1🫑1
❀1πŸ‘1πŸ”₯1πŸ₯°1😁1🀩1
πŸ”₯1😁1🀩1😍1πŸ€—1🫑1
C language in hindi πŸ’«βœ¨
πŸ”₯1😁1🀩1😍1πŸ€—1πŸ’˜1
C LANGUAGE PDF IN Hindi.pdf
2.1 MB
❀━━┅━━━┅━━┅━━━┅━━❀

C LANGUAGE PDF IN Hindi pdf

❀━━┅━━━┅━━┅━━━┅━━❀

πŸ“₯ 𝐅𝐒π₯𝐞 π’π’π³πž:-  2.06 MB

✿- - - - - - - - - - - - - - - - - - -✿
𖣐 Provided by : π—–π—›π—’π—¦π—˜π—‘ π—’π—‘π—˜ ⚝
πŸ†2❀1πŸ‘1πŸ”₯1🀩1
C language in english βœ¨πŸ’«
❀1πŸ”₯1😁1🀩1🀝1
lecture1424354156.pdf
396.5 KB
❀━━┅━━━┅━━┅━━━┅━━❀

lecture1424354156 pdf

❀━━┅━━━┅━━┅━━━┅━━❀

πŸ“₯ 𝐅𝐒π₯𝐞 π’π’π³πž:-  396.53 KB

✿- - - - - - - - - - - - - - - - - - -✿
𖣐 Provided by : π—–π—›π—’π—¦π—˜π—‘ π—’π—‘π—˜ ⚝
😍2❀1πŸ”₯1😁1🀩1
βœ… Top 10 Excel Interview Questions πŸ“ŠπŸ’Ό

1️⃣ What’s the difference between relative, absolute & mixed reference?
⦁ Relative: Changes when copied (A1)
⦁ Absolute: Fixed ($A$1)
⦁ Mixed: Part fixed (A$1 or $A1)

2️⃣ What is VLOOKUP and how does it work?
Searches a value vertically in the first column of a range:
VLOOKUP(value, table, col_index, [range_lookup])

3️⃣ Difference between VLOOKUP and INDEX-MATCH?
⦁ VLOOKUP: Left-to-right only
⦁ INDEX-MATCH: More flexible & faster for big data

4️⃣ Explain Pivot Tables.
Summarizes large data sets with dynamic grouping, filtering & aggregation.

5️⃣ What is conditional formatting?
Applies formatting like colors/icons based on rules or formulas.

6️⃣ How to remove duplicates?
Select data β†’ Data tab β†’ Remove Duplicates.

7️⃣ What’s a dynamic named range?
Range that auto-expands/shrinks as data changes, often using OFFSET + COUNTA.

8️⃣ How to handle errors in formulas?
Use IFERROR() or ISERROR() to catch and manage errors.

9️⃣ How to protect a sheet/workbook?
Use Review tab β†’ Protect Sheet/Workbook + password.

πŸ”Ÿ Difference between COUNT, COUNTA, COUNTIF, COUNTBLANK?
⦁ COUNT: Counts numbers only
⦁ COUNTA: Counts non-empty cells
⦁ COUNTIF: Counts based on condition
⦁ COUNTBLANK: Counts empty cells

πŸ’¬ Tap ❀️ for more Excel interview tips & tricks!
⚑1❀1πŸ”₯1🀩1😍1