15 Excel Formula Tricks & Shortcuts

1. Insert SUM function → Alt + =


2. Insert IF function quickly → Type =IF( and press Tab


3. Insert VLOOKUP / XLOOKUP → Type function name + Tab


4. Toggle between relative/absolute refs → F4


5. Select entire formula → Ctrl + Shift + U


6. Expand or collapse formula bar → Ctrl + Shift + U


7. Paste formula only → Ctrl + Alt + V, F


8. Paste values only → Ctrl + Alt + V, V


9. Calculate selected cells only → Shift + F9


10. Trace precedents → Ctrl + [


11. Trace dependents → Ctrl + ]


12. Remove arrows → Alt + M, A, A


13. Evaluate formula step-by-step → Alt + M, V


14. Insert array formula (legacy) → Ctrl + Shift + Enter


15. Repeat last formula action → F4


Double tap ♥️ if this helped you

Free Mock tests 💖

https://mocktest.trendseai.com/mocks

📊 Data Analytics: A-Z! 🚀

Data Analytics is the art and science of examining raw data to draw conclusions about that information. It's a powerful field that helps businesses and organizations make informed decisions, improve efficiency, and gain a competitive edge.

Here's a journey through Data Analytics, from the basics to advanced topics:

A - Applications:
•  Across industries: Finance, Healthcare, Marketing, Retail, Supply Chain, etc.
•  Use cases: Customer segmentation, fraud detection, risk management, predictive maintenance, market research, and more.

B - Business Intelligence (BI):
•  Tools and technologies for analyzing business data and presenting it in an easily understandable format (dashboards, reports).
•  Examples: Power BI, Tableau, Qlik Sense.

C - Cleaning Data:
•  The process of identifying and correcting errors, inconsistencies, and inaccuracies in a dataset.
•  Techniques: Handling missing values, removing duplicates, correcting typos, standardizing formats.

D - Data Visualization:
•  Graphical representation of data using charts, graphs, maps, and other visual elements.
•  Goal: Communicate insights effectively and make data easier to understand.

E - ETL (Extract, Transform, Load):
•  The process of extracting data from various sources, transforming it into a consistent format, and loading it into a data warehouse or other storage system.

F - Formulas (Excel):
•  Essential for performing calculations and data manipulation in Excel.
•  Examples: SUM, AVERAGE, IF, VLOOKUP, COUNTIF.

G - Google Analytics:
•  A web analytics service that tracks and reports website traffic.
•  Used to analyze user behavior, measure the effectiveness of marketing campaigns, and improve website performance.

H - Hypothesis Testing:
•  A statistical method used to determine whether there is enough evidence to support a hypothesis about a population.
•  Common tests: T-tests, Chi-square tests, ANOVA.

I - Insights:
•  Actionable conclusions and discoveries derived from data analysis.
•  Insights should be clear, concise, and relevant to the business context.

J - JOINs (SQL):
•  A SQL clause used to combine rows from two or more tables based on a related column.
•  Types: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN.

K - Key Performance Indicators (KPIs):
•  Measurable values that demonstrate how effectively a company is achieving key business objectives.
•  Examples: Revenue growth, customer satisfaction, market share.

L - Libraries (Python):
•  Essential Python libraries for data analysis:
  •  Pandas: Data manipulation and analysis.
  •  NumPy: Numerical computing.
  •  Matplotlib & Seaborn: Data visualization.
  •  Scikit-learn: Machine learning.

M - Machine Learning (ML):
•  A type of artificial intelligence that enables computers to learn from data without being explicitly programmed.
•  Used for tasks like prediction, classification, and clustering.

N - Normalization:
•  A data preprocessing technique used to scale numerical data to a common range, improving the performance of machine learning algorithms.

O - Outliers:
•  Data points that are significantly different from other values in a dataset.
•  Can be caused by errors, anomalies, or natural variations.

P - Pivot Tables (Excel):
•  A powerful tool in Excel for summarizing and analyzing large datasets.
•  Allows you to quickly group, filter, and aggregate data.

Q - Queries (SQL):
•  Requests for data from a database.
•  Used to retrieve, insert, update, and delete data.

R - Regression Analysis:
•  A statistical method used to model the relationship between a dependent variable and one or more independent variables.
•  Types: Linear regression, logistic regression.

S - SQL (Structured Query Language):
•  The standard language for interacting with relational databases.
•  Used to retrieve, manipulate, and manage data.

T - Tableau:
•  A popular data visualization and business intelligence tool.
•  Known for its user-friendly interface and powerful analytical capabilities.

U - Unstructured Data:
•  Data that does not have a predefined format (e.g., text documents, images, videos, social media posts).
•  Requires specialized tools and techniques for analysis.

V - Visualizations:
•  Charts, graphs, maps, and other visual elements used to represent data.
•  Choose the right visualization to effectively communicate your insights.

W - WHERE Clause (SQL):
•  A SQL clause used to filter rows based on specified conditions.
•  Essential for retrieving specific data from a table.

X - Exploratory Data Analysis (EDA):
•  An approach to analyzing data to summarize its main characteristics, often with visual methods.
•  Goal: To gain a better understanding of the data before performing more formal analysis.

Y - Y-axis (Charts):
•  The vertical axis in a chart, typically used to represent the dependent variable or the value being measured.

Z - Zero-Based Thinking:
•  An approach to data analysis that encourages you to question existing assumptions and look at the data with fresh eyes.

React ❤️ if you found this helpful!

✅ 15 Excel Function Tips for Smart Work

1. Insert recently used function
→ Alt + M, R

2. Open Name Manager
→ Ctrl + F3

3. Create named range
→ Ctrl + Shift + F3

4. Paste named range
→ F3

5. Insert argument names in formula
→ Ctrl + Shift + A

6. Move to next argument in function
→ Tab

7. Move to previous argument
→ Shift + Tab

8. Select entire column in formula
→ Ctrl + Space

9. Select entire row in formula
→ Shift + Space

10. Switch between worksheets in formula
→ Ctrl + Page Up / Page Down

11. Display formula arguments tooltip
→ Ctrl + Shift + A

12. Convert formula to values
→ Copy → Ctrl + Alt + V → V → Enter

13. Check formula errors
→ Alt + M, K

14. Show calculation options
→ Alt + M, X

15. Enable manual calculation
→ Alt + M, M

Double Tap ♥️ For More

Complete Syllabus for Data Analytics interview:

SQL:
1. Basic
  - SELECT statements with WHERE, ORDER BY, GROUP BY, HAVING
  - Basic JOINS (INNER, LEFT, RIGHT, FULL)
  - Creating and using simple databases and tables

2. Intermediate
  - Aggregate functions (COUNT, SUM, AVG, MAX, MIN)
  - Subqueries and nested queries
  - Common Table Expressions (WITH clause)
  - CASE statements for conditional logic in queries

3. Advanced
  - Advanced JOIN techniques (self-join, non-equi join)
  - Window functions (OVER, PARTITION BY, ROW_NUMBER, RANK, DENSE_RANK, lead, lag)
  - optimization with indexing
  - Data manipulation (INSERT, UPDATE, DELETE)

Python:
1. Basic
  - Syntax, variables, data types (integers, floats, strings, booleans)
  - Control structures (if-else, for and while loops)
  - Basic data structures (lists, dictionaries, sets, tuples)
  - Functions, lambda functions, error handling (try-except)
  - Modules and packages

2. Pandas & Numpy
  - Creating and manipulating DataFrames and Series
  - Indexing, selecting, and filtering data
  - Handling missing data (fillna, dropna)
  - Data aggregation with groupby, summarizing data
  - Merging, joining, and concatenating datasets

3. Basic Visualization
  - Basic plotting with Matplotlib (line plots, bar plots, histograms)
  - Visualization with Seaborn (scatter plots, box plots, pair plots)
  - Customizing plots (sizes, labels, legends, color palettes)
  - Introduction to interactive visualizations (e.g., Plotly)

Excel:
1. Basic
  - Cell operations, basic formulas (SUMIFS, COUNTIFS, AVERAGEIFS, IF, AND, OR, NOT & Nested Functions etc.)
  - Introduction to charts and basic data visualization
  - Data sorting and filtering
  - Conditional formatting

2. Intermediate
  - Advanced formulas (V/XLOOKUP, INDEX-MATCH, nested IF)
  - PivotTables and PivotCharts for summarizing data
  - Data validation tools
  - What-if analysis tools (Data Tables, Goal Seek)

3. Advanced
  - Array formulas and advanced functions
  - Data Model & Power Pivot
  - Advanced Filter
  - Slicers and Timelines in Pivot Tables
  - Dynamic charts and interactive dashboards

Power BI:
1. Data Modeling
  - Importing data from various sources
  - Creating and managing relationships between different datasets
  - Data modeling basics (star schema, snowflake schema)

2. Data Transformation
  - Using Power Query for data cleaning and transformation
  - Advanced data shaping techniques
  - Calculated columns and measures using DAX

3. Data Visualization and Reporting
  - Creating interactive reports and dashboards
  - Visualizations (bar, line, pie charts, maps)
  - Publishing and sharing reports, scheduling data refreshes

Statistics Fundamentals:
Mean, Median, Mode, Standard Deviation, Variance, Probability Distributions, Hypothesis Testing, P-values, Confidence Intervals, Correlation, Simple Linear Regression, Normal Distribution, Binomial Distribution, Poisson Distribution.

Hope it helps :)

Data Analytics Interview Topics in structured way :

🔵Python: Data Structures: Lists, tuples, dictionaries, sets Pandas: Data manipulation (DataFrame operations, merging, reshaping) NumPy: Numeric computing, arrays Visualization: Matplotlib, Seaborn for creating charts

🔵SQL: Basic : SELECT, WHERE, JOIN, GROUP BY, ORDER BY Advanced : Subqueries, nested queries, window functions DBMS: Creating tables, altering schema, indexing Joins: Inner join, outer join, left/right join Data Manipulation: UPDATE, DELETE, INSERT statements Aggregate Functions: SUM, AVG, COUNT, MAX, MIN

🔵Excel: Formulas & Functions: VLOOKUP, HLOOKUP, IF, SUMIF, COUNTIF Data Cleaning: Removing duplicates, handling errors, text-to-columns PivotTables Charts and Graphs What-If Analysis: Scenario Manager, Goal Seek, Solver

🔵Power BI:
Data Modeling: Creating relationships between datasets
Transformation: Cleaning & shaping data using
Power Query Editor Visualization: Creating interactive reports and dashboards
DAX (Data Analysis Expressions): Formulas for calculated columns, measures Publishing and sharing reports, scheduling data refresh

🔵 Statistics Fundamentals: Mean, median, mode Variance, standard deviation Probability distributions Hypothesis testing, p-values, confidence intervals

🔵Data Manipulation and Cleaning: Data preprocessing techniques (handling missing values, outliers), Data normalization and standardization Data transformation Handling categorical data

🔵Data Visualization: Chart types (bar, line, scatter, histogram, boxplot) Data visualization libraries (matplotlib, seaborn, ggplot) Effective data storytelling through visualization

Also showcase these skills using data portfolio if possible

Like for more content like this 😍

Most Demanding Data Analytics Skills!

↳ Dive into the essential skills and tools that are shaping the future of data analytics. From SQL and Python to Tableau and PowerBI, discover which technologies are crucial for advancing your data analysis capabilities.

↳ Explore the importance of machine learning techniques like linear regression, logistic regression, SVM, decision trees, random forests, K-means, and K-nearest neighbors, and how they can enhance your analytical prowess.

↳ Understand why soft skills such as communication, collaboration, critical thinking, and creativity are just as important as technical skills in the data analytics field.

↳ Get a comprehensive overview of the skills and technologies that can propel your career forward and make you a standout in the competitive world of data analytics.

✅ Data Analytics Roadmap for Freshers 🚀📊

1️⃣ Understand What a Data Analyst Does
🔍 Analyze data, find insights, create dashboards, support business decisions.

2️⃣ Start with Excel
📈 Learn:
– Basic formulas
– Charts & Pivot Tables
– Data cleaning
💡 Excel is still the #1 tool in many companies.

3️⃣ Learn SQL
🧩 SQL helps you pull and analyze data from databases.
Start with:
– SELECT, WHERE, JOIN, GROUP BY
🛠️ Practice on platforms like W3Schools or Mode Analytics.

4️⃣ Pick a Programming Language
🐍 Start with Python (easier) or R
– Learn pandas, matplotlib, numpy
– Do small projects (e.g. analyze sales data)

5️⃣ Data Visualization Tools
📊 Learn:
– Power BI or Tableau
– Build simple dashboards
💡 Start with free versions or YouTube tutorials.

6️⃣ Practice with Real Data
🔍 Use sites like Kaggle or Data.gov
– Clean, analyze, visualize
– Try small case studies (sales report, customer trends)

7️⃣ Create a Portfolio
💻 Share projects on:
– GitHub
– Notion or a simple website
📌 Add visuals + brief explanations of your insights.

8️⃣ Improve Soft Skills
🗣️ Focus on:
– Presenting data in simple words
– Asking good questions
– Thinking critically about patterns

9️⃣ Certifications to Stand Out
🎓 Try:
– Google Data Analytics (Coursera)
– IBM Data Analyst
– LinkedIn Learning basics

🔟 Apply for Internships & Entry Jobs
🎯 Titles to look for:
– Data Analyst (Intern)
– Junior Analyst
– Business Analyst

💬 React ❤️ for more!

✅ 🔤 A–Z of Excel Functions 📊⚡💻

A – AVERAGE()
Calculates the average of a range of values.

B – COUNTBLANK()
Counts empty cells in a range.

C – COUNT()
Counts numeric values in a range.

D – DATE()
Creates a date from year, month, and day.

E – EXACT()
Checks if two text values are exactly the same.

F – FIND()
Finds position of text within another text (case-sensitive).

G – CONCAT()
Combines text from multiple cells.

H – HLOOKUP()
Searches data horizontally in a table.

I – IF()
Performs logical test and returns value based on condition.

J – JOIN (TEXTJOIN())
Combines text with delimiter.

K – LARGE()
Returns the nth largest value.

L – LEFT()
Extracts characters from left side of text.

M – MAX()
Returns highest value.

N – NOW()
Returns current date and time.

O – OR()
Returns TRUE if any condition is true.

P – PMT()
Calculates loan payment amount.

Q – QUARTILE()
Returns quartile value of dataset.

R – RIGHT()
Extracts characters from right side of text.

S – SUM()
Adds values in a range.

T – TRIM()
Removes extra spaces from text.

U – UPPER()
Converts text to uppercase.

V – VLOOKUP()
Searches data vertically in a table.

W – WEEKDAY()
Returns day of week from a date.

X – XLOOKUP()
Modern lookup function replacing VLOOKUP/HLOOKUP.

Y – YEAR()
Extracts year from date.

Z – Z.TEST()
Returns probability value for z-test.

❤️ Double Tap for More

Data Analytics isn't rocket science. It's just a different language.

Here's a beginner's guide to the world of data analytics:

1) Understand the fundamentals:
- Mathematics
- Statistics
- Technology

2) Learn the tools:
- SQL
- Python
- Excel (yes, it's still relevant!)

3) Understand the data:
- What do you want to measure?
- How are you measuring it?
- What metrics are important to you?

4) Data Visualization:
- A picture is worth a thousand words

5) Practice:
- There's no better way to learn than to do it yourself.

Data Analytics is a valuable skill that can help you make better decisions, understand your audience better, and ultimately grow your business.

It's never too late to start learning!

📊 Complete Roadmap to Master Excel

📂 1. Learn Basics
– Interface, cells, rows & columns
– Data entry & formatting basics

📂 2. Understand Formulas & Functions
– Basic formulas: SUM, AVERAGE, COUNT
– Logical functions: IF, AND, OR
– Text functions: CONCATENATE, LEFT, RIGHT

📂 3. Work with Data
– Sorting, filtering, conditional formatting
– Data validation

📂 4. Learn Advanced Functions
– VLOOKUP, HLOOKUP, INDEX & MATCH
– Date & time functions

📂 5. Master Pivot Tables & Charts
– Summarize large data sets
– Create dynamic reports & visualizations

📂 6. Use Data Analysis Tools
– What-If analysis, Goal Seek, Solver

📂 7. Automate with Macros & VBA Basics
– Record macros to automate repetitive tasks
– Basic VBA scripting for custom solutions

📂 8. Practice Real-World Projects
– Budget tracker, sales dashboard, inventory management

💬 Tap ❤️ for more!

✅ If you're serious about learning Power BI — follow this roadmap 📊🚀

1. Understand the basics of data visualization: Importance, principles, and best practices 🎨
2. Get familiar with Power BI components: Power BI Desktop, Power BI Service, and Power BI Mobile 📱
3. Install Power BI Desktop: Set up your environment to start building reports 🖥️
4. Learn about data sources: Connect to various data sources (Excel, SQL Server, Web, etc.) 🔗
5. Explore the Power Query Editor: Data transformation and cleaning techniques (ETL processes) 🔄
6. Understand data modeling concepts: Relationships, tables, and data hierarchies 📊
7. Study DAX (Data Analysis Expressions): Basic formulas and functions for calculations 🔢
8. Create visualizations: Charts, tables, maps, and custom visuals 📈
9. Learn about interactive features: Slicers, filters, tooltips, and drill-through options 🔍
10. Design effective dashboards: Layout, color schemes, and user experience principles 🖌️
11. Explore Power BI Service: Publishing reports, sharing dashboards, and collaboration features 🌐
12. Understand row-level security (RLS): Implementing security measures for data access 🔒
13. Learn about Power BI apps: Creating and managing apps for users 📦
14. Explore advanced DAX functions: Time intelligence, CALCULATE, and context transition ⏳
15. Familiarize yourself with Power BI Report Server: On-premises reporting solutions 🏢
16. Integrate with other Microsoft tools: Excel, Teams, and SharePoint for enhanced collaboration 🔗
17. Study performance optimization techniques: Improving report performance and efficiency ⚡
18. Stay updated on new features and updates: Follow the Power BI blog and community forums 📰
19. Practice with sample datasets: Use resources like Microsoft’s sample data or Kaggle datasets 📊
20. Consider obtaining certifications: Microsoft Certified: Data Analyst Associate 🎓
21. Join online communities: Engage with forums like Power BI Community, LinkedIn groups, or Reddit 📢
22. Build a portfolio of projects: Showcase your skills with real-world examples and case studies 🌍
23. Attend webinars and workshops: Learn from experts and gain insights into best practices 🎤
24. Experiment with storytelling through data: Craft narratives that convey insights effectively 📖

Tip: Focus on practical application—build reports based on real business scenarios!

💬 Tap ❤️ for more!

Data Analyst Interview Preparation Roadmap ✅

Technical skills to revise

- SQL
Write queries from scratch.
Practice joins, group by, subqueries.
Handle duplicates and NULLs.
Window functions basics.

- Excel
Pivot tables without help.
XLOOKUP and IF confidently.
Data cleaning steps.

- Power BI or Tableau
Explain data model.
Write basic DAX.
Explain one dashboard end to end.

- Statistics
Mean vs median.
Standard deviation meaning.
Correlation vs causation.

- Python. If required
Pandas basics.
Groupby and filtering.

Interview question types

- SQL questions
Top N per group.
Running totals.
Duplicate records.
Date based queries.

- Business case questions
Why did sales drop.
Which metric matters most and why.

- Dashboard questions
Explain one KPI.
How users will use this report.

- Project questions
Data source.
Cleaning logic.
Key insight.
Business action.

Resume preparation
- Must have Tools section.
- One strong project.
- Metrics driven points.
Example: Improved reporting time by 30 percent using Power BI.

Mock interviews
- Practice explaining out loud.
- Time your answers.
- Use real datasets.

Daily prep plan
1 SQL problem.
1 dashboard review.
10 interview questions.

- Common mistakes
Memorizing queries.
No project explanation.
Weak business reasoning.

- Final task
- Prepare one project story.
- Prepare one SQL solution on paper.
- Prepare one business metric explanation.

Double Tap ♥️ For More

📊 Excel Beginner Roadmap 🚀

📂 Start Here
∟📂 What is Microsoft Excel & Why Use It?
∟📂 Understanding Excel Interface (Rows, Columns, Cells, Ribbon)

📂 Excel Basics
∟📂 Entering & Formatting Data
∟📂 Basic Formulas (SUM, AVERAGE, COUNT)
∟📂 Cell References (Relative, Absolute, Mixed)

📂 Important Functions
∟📂 Logical Functions (IF, AND, OR)
∟📂 Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)
∟📂 Text Functions (LEFT, RIGHT, MID, LEN, CONCAT)

📂 Data Handling
∟📂 Sorting & Filtering Data
∟📂 Remove Duplicates
∟📂 Data Validation

📂 Data Analysis Tools
∟📂 Conditional Formatting
∟📂 Pivot Tables
∟📂 Pivot Charts

📂 Charts & Visualization
∟📂 Column, Line, Pie Charts
∟📂 Creating Dashboards in Excel
∟📂 Formatting Charts for Insights

📂 Advanced Excel
∟📂 INDEX & MATCH
∟📂 Nested IF Statements
∟📂 Introduction to Macros

📂 Excel for Data Analysis
∟📂 Cleaning Data
∟📂 Using Excel Tables
∟📂 Basic Data Analysis Techniques

📂 Practice Projects
∟📌 Sales Data Dashboard
∟📌 Employee Attendance Tracker
∟📌 Personal Budget Tracker

📂 ✅ Move to Next Level
∟📂 Power Query Basics
∟📂 Power Pivot & Data Model
∟📂 Automating Tasks with VBA

React "❤️" for more! 📊🚀

Data Analyst INTERVIEW QUESTIONS AND ANSWERS
👇👇

1.Can you name the wildcards in Excel?

Ans: There are 3 wildcards in Excel that can ve used in formulas.

Asterisk (*) – 0 or more characters. For example, Ex* could mean Excel, Extra, Expertise, etc.

Question mark (?) – Represents any 1 character. For example, R?ain may mean Rain or Ruin.

Tilde (~) – Used to identify a wildcard character (~, *, ?). For example, If you need to find the exact phrase India* in a list. If you use India* as the search string, you may get any word with India at the beginning followed by different characters (such as Indian, Indiana). If you have to look for India” exclusively, use ~.

Hence, the search string will be india~*. ~ is used to ensure that the spreadsheet reads the following character as is, and not as a wildcard.


2.What is cascading filter in tableau?

Ans: Cascading filters can also be understood as giving preference to a particular filter and then applying other filters on previously filtered data source. Right-click on the filter you want to use as a main filter and make sure it is set as all values in dashboard then select the subsequent filter and select only relevant values to cascade the filters. This will improve the performance of the dashboard as you have decreased the time wasted in running all the filters over complete data source.


3.What is the difference between .twb and .twbx extension?

Ans:
A .twb file contains information on all the sheets, dashboards and stories, but it won’t contain any information regarding data source. Whereas .twbx file contains all the sheets, dashboards, stories and also compressed data sources. For saving a .twbx extract needs to be performed on the data source. If we forward .twb file to someone else than they will be able to see the worksheets and dashboards but won’t be able to look into the dataset.


4.What are the various Power BI versions?

Power BI Premium capacity-based license, for example, allows users with a free license to act on content in workspaces with Premium capacity. A user with a free license can only use the Power BI service to connect to data and produce reports and dashboards in My Workspace outside of Premium capacity. They are unable to exchange material or publish it in other workspaces. To process material, a Power BI license with a free or Pro per-user license only uses a shared and restricted capacity. Users with a Power BI Pro license can only work with other Power BI Pro users if the material is stored in that shared capacity. They may consume user-generated information, post material to app workspaces, share dashboards, and subscribe to dashboards and reports. Pro users can share material with users who don’t have a Power BI Pro subscription while workspaces are at Premium capacity.

ENJOY LEARNING 👍👍

Quick Excel Cheatsheet! 📊

Basic Formulas
1. Add: =A1+B1
2. Subtract: =A1-B1
3. Multiply: =A1*B1
4. Divide: =A1/B1
5. Average: =AVERAGE(A1:A10)
6. Sum: =SUM(A1:A10)

Logical Functions
1. IF: =IF(A1>10, "Yes", "No")
2. AND: =AND(A1>5, B1<10)
3. OR: =OR(A1=1, B1=2)
4. EXACT (case-sensitive match): =EXACT(A1, B1)

Lookup Functions
1. VLOOKUP: =VLOOKUP(A1, Table, 2, FALSE)
2. HLOOKUP: =HLOOKUP(A1, Table, 2, FALSE)
3. XLOOKUP: =XLOOKUP(A1, Range1, Range2)

Counting Data Types
1. Count numbers: =COUNT(A1:A10)
2. Count non-empty: =COUNTA(A1:A10)
3. Count blanks: =COUNTBLANK(A1:A10)
4. Is number: =ISNUMBER(A1)
5. Is text: =ISTEXT(A1)

React ❤️ for more