π₯1π1π€©1π1π€1π«‘1
C language in hindi π«β¨
π₯1π1π€©1π1π€1π1
π» Computer Knowledge πͺ ( Basics - Advanced ) Quiz PDF pinned Β«C language in hindi π«β¨Β»
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
π» Computer Knowledge πͺ ( Basics - Advanced ) Quiz PDF pinned Β«C language in english β¨π«Β»
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οΈβ£ 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