Web Development CS JS Python JavaScript Hacking ReactJs Python django Flask CSS Frontend Backend Full Stack Java Node Pdf Books
How to particularly check if a variable is array in JavaScript?
To check if a variable is an array in JavaScript, you can use the Array.isArray() method.
let myVariable = [1, 2, 3];
let isItArray = Array.isArray(myVariable);
console.log(isItArray);
// Output: true
let myVariable = [1, 2, 3];
let isItArray = Array.isArray(myVariable);
console.log(isItArray);
// Output: true
❤1
Complete HTML, CSS and JS
Road map 🔥
HTML
1.Document Structure
• <!DOCTYPE>
• <html>
• <head>
• <title>
• <meta>
• <link>
• <script>
• <noscript>
2.Text Content
• <h1>, <h2>, <h3>, <h4>, <h5>, <h6>
• <p>
• <span>
• <strong>
• <em>
• <br>
• <hr>
3.Lists
• <ul>
• <ol>
• <li>
• <dl>
• <dt>
• <dd>
4.Links and Navigation
• <a>
• <nav>
• <link>
5.Embedded Content
• <img>
• <audio>
• <video>
• <iframe>
• <canvas>
• <svg>
6.Forms
• <form>
• <input>
• <textarea>
• <button>
• <select>
• <option>
• <label>
• <fieldset>
• <legend>
• <datalist>
• <output>
7.Tables
• <table>
• <tr>
• <th>
• <td>
• <caption>
8.Semantic Elements
• <article>
• <section>
• <header>
• <footer>
• <aside>
• <main>
• <figure>
• <figcaption>
• <mark>
• <progress>
• <time>
• <details>
• <summary>
9.Deprecated Elements (Avoid Using)
• <center>
• <font>
• <strike>
CSS
1. Box Model
• width
• height
• margin
• padding
• border
• box-sizing
2. Positioning
• position
• top
• right
• bottom
• left
• float
• clear
• z-index
3. Typography
• font-family
• font-size
• font-weight
• font-style
• color
• line-height
• letter-spacing
• text-align
• text-decoration
• text-transform
4. Visual Formatting
• background-color
• background-image
• background-repeat
• background-position
• background-size
• color
• display
• visibility
• overflow
• opacity
5. Flexbox
• display: flex;
• flex-direction
• justify-content
• align-items
• align-self
• flex
6. Grid Layout
• display: grid;
• grid-template-columns
• grid-template-rows
• grid-column
• grid-row
• grid-gap
• grid-area
7. Transforms and Animations
• transform
• transition
• animation
8. Others
• cursor
• list-style
• outline
• user-select
• pointer-events
JavaScript
1.Variables
• var
• let
• const
2. Data Types
• number
• string
• boolean
• null
• undefined
• symbol
3.Declaring variables
• var
• let
• const
4.Expressions
Primary expressions
• this
• Literals
• []
• {}
• function
• class
• function*
• async function
• async function*
• /ab+c/i
•
• ( )
Left-hand-side expressions
• Property accessors
• ?.
• new
• new .target
• import.meta
• super
• import()
5.operators
• Arithmetic Operators: +, -, *, /, %
• Comparison Operators: ==, ===, !=, !==, <, >, <=, >=
• Logical Operators: &&, ||, !
6.Control Structures
• if
• else if
• else
• switch
• case
• default
7.Iterations/Loop
• do...while
• for
• for...in
• for...of
• for await...of
• while
8.Functions
• Arrow Functions
• Default parameters
• Rest parameters
• arguments
• Method definitions
• getter
• setter
9.Objects and Arrays
• Object Literal: { key: value }
• Array Literal: [element1, element2, ...]
• Object Methods and Properties
• Array Methods: push(), pop(), shift(), unshift(),
splice(), slice(), forEach(), map(), filter()
10.Classes and Prototypes
• Class Declaration
• Constructor Functions
• Prototypal Inheritance
• extends keyword
• super keyword
• Private class features
• Public class fields
• static
• Static initialization blocks
11.Error Handling
• try
• catch
• finally (exception handling)
ADVANCED CONCEPTS
--------------------------
12.Closures
• Lexical Scope
• Function Scope
• Closure Use Cases
13.Asynchronous JavaScript
• Callback Functions
• Promises
• async/await Syntax
• Fetch API
• XMLHttpRequest
14.Modules
• import and export Statements (ES6 Modules)
• CommonJS Modules (require, module.exports)
15.Event Handling
• Event Listeners
• Event Object
• Bubbling and Capturing
16.DOM Manipulation
• Selecting DOM Elements
• Modifying Element Properties
• Creating and Appending Elements
17.Regular Expressions
• Pattern Matching
• RegExp Methods: test(), exec(), match(), replace()
18.Browser APIs
• localStorage and sessionStorage
• navigator Object
• Geolocation API
• Canvas API
19.Web APIs
• setTimeout(), setInterval()
• XMLHttpRequest
• Fetch API
• WebSockets
Road map 🔥
HTML
1.Document Structure
• <!DOCTYPE>
• <html>
• <head>
• <title>
• <meta>
• <link>
• <script>
• <noscript>
2.Text Content
• <h1>, <h2>, <h3>, <h4>, <h5>, <h6>
• <p>
• <span>
• <strong>
• <em>
• <br>
• <hr>
3.Lists
• <ul>
• <ol>
• <li>
• <dl>
• <dt>
• <dd>
4.Links and Navigation
• <a>
• <nav>
• <link>
5.Embedded Content
• <img>
• <audio>
• <video>
• <iframe>
• <canvas>
• <svg>
6.Forms
• <form>
• <input>
• <textarea>
• <button>
• <select>
• <option>
• <label>
• <fieldset>
• <legend>
• <datalist>
• <output>
7.Tables
• <table>
• <tr>
• <th>
• <td>
• <caption>
8.Semantic Elements
• <article>
• <section>
• <header>
• <footer>
• <aside>
• <main>
• <figure>
• <figcaption>
• <mark>
• <progress>
• <time>
• <details>
• <summary>
9.Deprecated Elements (Avoid Using)
• <center>
• <font>
• <strike>
CSS
1. Box Model
• width
• height
• margin
• padding
• border
• box-sizing
2. Positioning
• position
• top
• right
• bottom
• left
• float
• clear
• z-index
3. Typography
• font-family
• font-size
• font-weight
• font-style
• color
• line-height
• letter-spacing
• text-align
• text-decoration
• text-transform
4. Visual Formatting
• background-color
• background-image
• background-repeat
• background-position
• background-size
• color
• display
• visibility
• overflow
• opacity
5. Flexbox
• display: flex;
• flex-direction
• justify-content
• align-items
• align-self
• flex
6. Grid Layout
• display: grid;
• grid-template-columns
• grid-template-rows
• grid-column
• grid-row
• grid-gap
• grid-area
7. Transforms and Animations
• transform
• transition
• animation
8. Others
• cursor
• list-style
• outline
• user-select
• pointer-events
JavaScript
1.Variables
• var
• let
• const
2. Data Types
• number
• string
• boolean
• null
• undefined
• symbol
3.Declaring variables
• var
• let
• const
4.Expressions
Primary expressions
• this
• Literals
• []
• {}
• function
• class
• function*
• async function
• async function*
• /ab+c/i
•
string• ( )
Left-hand-side expressions
• Property accessors
• ?.
• new
• new .target
• import.meta
• super
• import()
5.operators
• Arithmetic Operators: +, -, *, /, %
• Comparison Operators: ==, ===, !=, !==, <, >, <=, >=
• Logical Operators: &&, ||, !
6.Control Structures
• if
• else if
• else
• switch
• case
• default
7.Iterations/Loop
• do...while
• for
• for...in
• for...of
• for await...of
• while
8.Functions
• Arrow Functions
• Default parameters
• Rest parameters
• arguments
• Method definitions
• getter
• setter
9.Objects and Arrays
• Object Literal: { key: value }
• Array Literal: [element1, element2, ...]
• Object Methods and Properties
• Array Methods: push(), pop(), shift(), unshift(),
splice(), slice(), forEach(), map(), filter()
10.Classes and Prototypes
• Class Declaration
• Constructor Functions
• Prototypal Inheritance
• extends keyword
• super keyword
• Private class features
• Public class fields
• static
• Static initialization blocks
11.Error Handling
• try
• catch
• finally (exception handling)
ADVANCED CONCEPTS
--------------------------
12.Closures
• Lexical Scope
• Function Scope
• Closure Use Cases
13.Asynchronous JavaScript
• Callback Functions
• Promises
• async/await Syntax
• Fetch API
• XMLHttpRequest
14.Modules
• import and export Statements (ES6 Modules)
• CommonJS Modules (require, module.exports)
15.Event Handling
• Event Listeners
• Event Object
• Bubbling and Capturing
16.DOM Manipulation
• Selecting DOM Elements
• Modifying Element Properties
• Creating and Appending Elements
17.Regular Expressions
• Pattern Matching
• RegExp Methods: test(), exec(), match(), replace()
18.Browser APIs
• localStorage and sessionStorage
• navigator Object
• Geolocation API
• Canvas API
19.Web APIs
• setTimeout(), setInterval()
• XMLHttpRequest
• Fetch API
• WebSockets
👍3
20.Functional Programming
• Higher-Order Functions
• map(), reduce(), filter()
• Pure Functions and Immutability
21.Promises and Asynchronous Patterns
• Promise Chaining
• Error Handling with Promises
• Async/Await
22.ES6+ Features
• Template Literals
• Destructuring Assignment
• Rest and Spread Operators
• Arrow Functions
• Classes and Inheritance
• Default Parameters
• let, const Block Scoping
23.Browser Object Model (BOM)
• window Object
• history Object
• location Object
• navigator Object
24.Node.js Specific Concepts
• require()
• Node.js Modules (module.exports)
• File System Module (fs)
• npm (Node Package Manager)
25.Testing Frameworks
• Jasmine
• Mocha
• Jest
------------------- END -------------------
• Higher-Order Functions
• map(), reduce(), filter()
• Pure Functions and Immutability
21.Promises and Asynchronous Patterns
• Promise Chaining
• Error Handling with Promises
• Async/Await
22.ES6+ Features
• Template Literals
• Destructuring Assignment
• Rest and Spread Operators
• Arrow Functions
• Classes and Inheritance
• Default Parameters
• let, const Block Scoping
23.Browser Object Model (BOM)
• window Object
• history Object
• location Object
• navigator Object
24.Node.js Specific Concepts
• require()
• Node.js Modules (module.exports)
• File System Module (fs)
• npm (Node Package Manager)
25.Testing Frameworks
• Jasmine
• Mocha
• Jest
------------------- END -------------------
❤4👍2
This media is not supported in your browser
VIEW IN TELEGRAM
HTTP status codes are three-digit numbers that are returned by a web server in response to a client's request made to the server via HTTP (Hypertext Transfer Protocol).
These status codes provide information about the outcome of the request, indicating whether it was successful, encountered an error, or needs further action. They are an essential part of the HTTP protocol, helping both clients (e.g., web browsers) and servers communicate effectively.
These status codes provide information about the outcome of the request, indicating whether it was successful, encountered an error, or needs further action. They are an essential part of the HTTP protocol, helping both clients (e.g., web browsers) and servers communicate effectively.
Update: I will start uploading latest edition of books on web dev - reactjs, javaScript, and other cool stuff with latest edition, so keep checking resources group.
Ask for your need book in chat group
Ask for your need book in chat group
Chat group link
https://t.me/+2KE896TMwHkxOWE1
Resources aka PDfs and Ebooks group link
https://t.me/+eweUkdFwlho4YjRl
https://t.me/+2KE896TMwHkxOWE1
Resources aka PDfs and Ebooks group link
https://t.me/+eweUkdFwlho4YjRl
Telegram
Webos
You’ve been invited to join this group on Telegram.
👍1
Common Nodejs Interview questions:🎯
What is Node.js?
How does Node.js handle asynchronous operations?
Explain the role of npm.
Differentiate between let, var, and const in JavaScript.
What is the purpose of the package.json file?
How do you handle errors in Node.js?
What is the purpose of the exports object in Node.js modules?
What is middleware in the context of Express.js?
How does Node.js handle child processes?
Explain the concept of the Event Loop in Node.js.
How does routing work in Express.js?
What is the purpose of the body-parser middleware in Express.js?
Explain the role of the dirname and filename variables in Node.js.
What is callback hell? How can it be avoided?
What are Promises in Node.js? How do they differ from callbacks?
Describe the role of the process object in Node.js.
What is the purpose of the module.exports object?
How can you handle file uploads in Node.js?
Explain the difference between process.nextTick() and setImmediate() in Node.js.
How does clustering work in Node.js?
What is Node.js?
How does Node.js handle asynchronous operations?
Explain the role of npm.
Differentiate between let, var, and const in JavaScript.
What is the purpose of the package.json file?
How do you handle errors in Node.js?
What is the purpose of the exports object in Node.js modules?
What is middleware in the context of Express.js?
How does Node.js handle child processes?
Explain the concept of the Event Loop in Node.js.
How does routing work in Express.js?
What is the purpose of the body-parser middleware in Express.js?
Explain the role of the dirname and filename variables in Node.js.
What is callback hell? How can it be avoided?
What are Promises in Node.js? How do they differ from callbacks?
Describe the role of the process object in Node.js.
What is the purpose of the module.exports object?
How can you handle file uploads in Node.js?
Explain the difference between process.nextTick() and setImmediate() in Node.js.
How does clustering work in Node.js?
👍2
Web Development CS JS Python JavaScript Hacking ReactJs Python django Flask CSS Frontend Backend Full Stack Java Node Pdf Books pinned «Chat group link https://t.me/+2KE896TMwHkxOWE1 Resources aka PDfs and Ebooks group link https://t.me/+eweUkdFwlho4YjRl»
JavaScript Animation Libraries for Web Developers:
▶️GSAP (GreenSock Animation Platform)
Www.greensock.com
▶️VelocityJS
Www.velocityjs.org
▶️Lottie
Www.airbnb.io/lottie
▶️ScrollMagic
Www.scrollmagic.io
▶️GSAP (GreenSock Animation Platform)
Www.greensock.com
▶️VelocityJS
Www.velocityjs.org
▶️Lottie
Www.airbnb.io/lottie
▶️ScrollMagic
Www.scrollmagic.io
lottie.airbnb.tech
Lottie Docs
Lottie is a library for Android, iOS, Web, and Windows that parses Adobe After Effects animations exported as json with Bodymovin and renders them natively on mobile and on the web
Master JavaScript.
Follow these Github Repos:
1. 📚 You-Dont-Know-JS
2. 😵 wtfjs
3. 🧩 javascript-algorithms
4. ✨ clean-code-javascript
5. 🤔 javascript-questions
6. 🆕 ES6-for-humans
7. 🏁 JavaScript30
8. 📦 js-stack-from-scratch
Follow these Github Repos:
1. 📚 You-Dont-Know-JS
2. 😵 wtfjs
3. 🧩 javascript-algorithms
4. ✨ clean-code-javascript
5. 🤔 javascript-questions
6. 🆕 ES6-for-humans
7. 🏁 JavaScript30
8. 📦 js-stack-from-scratch
👍5
Web Development CS JS Python JavaScript Hacking ReactJs Python django Flask CSS Frontend Backend Full Stack Java Node Pdf Books
Page 1
JavaScript Interview Questions part 2
6 API Architectural designs You Must Know
1. REST 🌐
Representational State Transfer - REST is like a classic library where you request specific books and receive them as they are. It's simple and widely used for web APIs, like ordering a la carte from a menu 🍽️.
2. GraphQL 🚀
GraphQL is like a customizable buffet 🍴 where you ask for exactly what you want and get a tailored plate. It allows clients to request only the data they need, reducing over-fetching.
3. SOAP 🧼
SOAP (Simple Object Access Protocol) is like sending a letter 💌 with detailed instructions, complete with a table of contents. It's more structured but can be heavier than REST or GraphQL.
4. gRPC 🚄:
gRPC is like a high-speed train 🚄 for communication between services. It uses Protocol Buffers for efficient data exchange and supports streaming and bidirectional communication.
5. WebSockets 🌐💬
WebSockets are like real-time phone calls ☎️ for the web. They enable two-way communication, perfect for chat apps and live updates.
6. MQTT 📡
MQTT (Message Queuing Telemetry Transport) is like a radio broadcast 📻, designed for low-bandwidth, high-latency, or unreliable networks. Ideal for IoT devices and sensor data.
1. REST 🌐
Representational State Transfer - REST is like a classic library where you request specific books and receive them as they are. It's simple and widely used for web APIs, like ordering a la carte from a menu 🍽️.
2. GraphQL 🚀
GraphQL is like a customizable buffet 🍴 where you ask for exactly what you want and get a tailored plate. It allows clients to request only the data they need, reducing over-fetching.
3. SOAP 🧼
SOAP (Simple Object Access Protocol) is like sending a letter 💌 with detailed instructions, complete with a table of contents. It's more structured but can be heavier than REST or GraphQL.
4. gRPC 🚄:
gRPC is like a high-speed train 🚄 for communication between services. It uses Protocol Buffers for efficient data exchange and supports streaming and bidirectional communication.
5. WebSockets 🌐💬
WebSockets are like real-time phone calls ☎️ for the web. They enable two-way communication, perfect for chat apps and live updates.
6. MQTT 📡
MQTT (Message Queuing Telemetry Transport) is like a radio broadcast 📻, designed for low-bandwidth, high-latency, or unreliable networks. Ideal for IoT devices and sensor data.
👍2
Excel Shortcuts
1. Ctrl + N: To create a new workbook.
2. Ctrl + O: To open a saved workbook.
3. Ctrl + S: To save a workbook.
4. Ctrl + A: To select all the contents in a workbook.
5. Ctrl + B: To turn highlighted cells bold.
6. Ctrl + C: To copy cells that are highlighted.
7. Ctrl + D: To fill the selected cell with the content of the cell right above.
8. Ctrl + F: To search for anything in a workbook.
9. Ctrl + G: To jump to a certain area with a single command.
10. Ctrl + H: To find and replace cell contents.
11. Ctrl + I: To italicise cell contents.
12. Ctrl + K: To insert a hyperlink in a cell.
13. Ctrl + L: To open the create table dialog box.
14. Ctrl + P: To print a workbook.
15. Ctrl + R: To fill the selected cell with the content of the cell on the left.
16. Ctrl + U: To underline highlighted cells.
17. Ctrl + V: To paste anything that was copied.
18. Ctrl + W: To close your current workbook.
19. Ctrl + Z: To undo the last action.
20. Ctrl + 1: To format the cell contents.
21. Ctrl + 5: To put a strikethrough in a cell.
22. Ctrl + 8: To show the outline symbols.
23. Ctrl + 9: To hide a row.
24. Ctrl + 0: To hide a column.
25. Ctrl + Shift + :: To enter the current time in a cell.
26. Ctrl + ;: To enter the current date in a cell.
27. Ctrl + `: To change the view from displaying cell values to formulas.
28. Ctrl + ‘: To copy the formula from the cell above.
29. Ctrl + -: To delete columns or rows.
30. Ctrl + Shift + =: To insert columns and rows.
31. Ctrl + Shift + ~: To switch between displaying Excel formulas or their values in cell.
32. Ctrl + Shift + @: To apply time formatting.
33. Ctrl + Shift + !: To apply comma formatting.
34. Ctrl + Shift + $: To apply currency formatting.
35. Ctrl + Shift + #: To apply date formatting.
36. Ctrl + Shift + %: To apply percentage formatting.
37. Ctrl + Shift + &: To place borders around the selected cells.
38. Ctrl + Shift + _: To remove a border.
39. Ctrl + -: To delete a selected row or column.
40. Ctrl + Spacebar: To select an entire column.
41. Ctrl + Shift + Spacebar: To select an entire workbook.
42. Ctrl + Home: To redirect to cell A1.
43. Ctrl + Shift + Tab: To switch to the previous workbook.
44. Ctrl + Shift + F: To open the fonts menu under format cells.
45. Ctrl + Shift + O: To select the cells containing comments.
46. Ctrl + Drag: To drag and copy a cell or to a duplicate worksheet.
47. Ctrl + Shift + Drag: To drag and insert copy.
48. Ctrl + Up arrow: To go to the top most cell in a current column.
49. Ctrl + Down arrow: To jump to the last cell in a current column.
50. Ctrl + Right arrow: To go to the last cell in a selected row.
51. Ctrl + Left arrow: To jump back to the first cell in a selected row.
52. Ctrl + End: To go to the last cell in a workbook.
53. Alt + Page down: To move the screen towards the right.
54. Alt + Page Up: To move the screen towards the left.
55. Ctrl + F2: To open the print preview window.
56. Ctrl + F1: To expand or collapse the ribbon.
57. Alt: To open the access keys.
58. Tab: Move to the next cell.
59. Alt + F + T: To open the options.
60. Alt + Down arrow: To activate filters for cells.
61. F2: To edit a cell.
62. F3: To paste a cell name if the cells have been named.
63. Shift + F2: To add or edit a cell comment.
64. Alt + H + H: To select a fill colour.
65. Alt + H + B: To add a border.
66. Ctrl + 9: To hide the selected rows.
67. Ctrl + 0: To hide the selected columns.
68. Esc: To cancel an entry.
69. Enter: To complete the entry in a cell and move to the next one.
70. Shift + Right arrow: To extend the cell selection to the right.
71. Shift + Left arrow: To extend the cell selection to the left.
72. Shift + Space: To select the entire row.
73. Page up/ down: To move the screen up or down.
74. Alt + H: To go to the Home tab in Ribbon.
75. Alt + N: To go to the Insert tab in Ribbon.
1. Ctrl + N: To create a new workbook.
2. Ctrl + O: To open a saved workbook.
3. Ctrl + S: To save a workbook.
4. Ctrl + A: To select all the contents in a workbook.
5. Ctrl + B: To turn highlighted cells bold.
6. Ctrl + C: To copy cells that are highlighted.
7. Ctrl + D: To fill the selected cell with the content of the cell right above.
8. Ctrl + F: To search for anything in a workbook.
9. Ctrl + G: To jump to a certain area with a single command.
10. Ctrl + H: To find and replace cell contents.
11. Ctrl + I: To italicise cell contents.
12. Ctrl + K: To insert a hyperlink in a cell.
13. Ctrl + L: To open the create table dialog box.
14. Ctrl + P: To print a workbook.
15. Ctrl + R: To fill the selected cell with the content of the cell on the left.
16. Ctrl + U: To underline highlighted cells.
17. Ctrl + V: To paste anything that was copied.
18. Ctrl + W: To close your current workbook.
19. Ctrl + Z: To undo the last action.
20. Ctrl + 1: To format the cell contents.
21. Ctrl + 5: To put a strikethrough in a cell.
22. Ctrl + 8: To show the outline symbols.
23. Ctrl + 9: To hide a row.
24. Ctrl + 0: To hide a column.
25. Ctrl + Shift + :: To enter the current time in a cell.
26. Ctrl + ;: To enter the current date in a cell.
27. Ctrl + `: To change the view from displaying cell values to formulas.
28. Ctrl + ‘: To copy the formula from the cell above.
29. Ctrl + -: To delete columns or rows.
30. Ctrl + Shift + =: To insert columns and rows.
31. Ctrl + Shift + ~: To switch between displaying Excel formulas or their values in cell.
32. Ctrl + Shift + @: To apply time formatting.
33. Ctrl + Shift + !: To apply comma formatting.
34. Ctrl + Shift + $: To apply currency formatting.
35. Ctrl + Shift + #: To apply date formatting.
36. Ctrl + Shift + %: To apply percentage formatting.
37. Ctrl + Shift + &: To place borders around the selected cells.
38. Ctrl + Shift + _: To remove a border.
39. Ctrl + -: To delete a selected row or column.
40. Ctrl + Spacebar: To select an entire column.
41. Ctrl + Shift + Spacebar: To select an entire workbook.
42. Ctrl + Home: To redirect to cell A1.
43. Ctrl + Shift + Tab: To switch to the previous workbook.
44. Ctrl + Shift + F: To open the fonts menu under format cells.
45. Ctrl + Shift + O: To select the cells containing comments.
46. Ctrl + Drag: To drag and copy a cell or to a duplicate worksheet.
47. Ctrl + Shift + Drag: To drag and insert copy.
48. Ctrl + Up arrow: To go to the top most cell in a current column.
49. Ctrl + Down arrow: To jump to the last cell in a current column.
50. Ctrl + Right arrow: To go to the last cell in a selected row.
51. Ctrl + Left arrow: To jump back to the first cell in a selected row.
52. Ctrl + End: To go to the last cell in a workbook.
53. Alt + Page down: To move the screen towards the right.
54. Alt + Page Up: To move the screen towards the left.
55. Ctrl + F2: To open the print preview window.
56. Ctrl + F1: To expand or collapse the ribbon.
57. Alt: To open the access keys.
58. Tab: Move to the next cell.
59. Alt + F + T: To open the options.
60. Alt + Down arrow: To activate filters for cells.
61. F2: To edit a cell.
62. F3: To paste a cell name if the cells have been named.
63. Shift + F2: To add or edit a cell comment.
64. Alt + H + H: To select a fill colour.
65. Alt + H + B: To add a border.
66. Ctrl + 9: To hide the selected rows.
67. Ctrl + 0: To hide the selected columns.
68. Esc: To cancel an entry.
69. Enter: To complete the entry in a cell and move to the next one.
70. Shift + Right arrow: To extend the cell selection to the right.
71. Shift + Left arrow: To extend the cell selection to the left.
72. Shift + Space: To select the entire row.
73. Page up/ down: To move the screen up or down.
74. Alt + H: To go to the Home tab in Ribbon.
75. Alt + N: To go to the Insert tab in Ribbon.
👍2