Scribd
Upload
4 views6 pages

Excel Questions

The document provides essential Excel functions and tools for data analysts, including an explanation of PivotTables for data summarization and analysis. It details the differences between COUNT, COUNTA, COUNTIF, and COUNTIFS functions, as well as the SUM and SUMIF functions for adding numbers based on conditions. Additionally, it mentions the TODAY function for retrieving the current date in Excel.

Uploaded by

Navya Sama
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
4 views6 pages

Excel Questions

The document provides essential Excel functions and tools for data analysts, including an explanation of PivotTables for data summarization and analysis. It details the differences between COUNT, COUNTA, COUNTIF, and COUNTIFS functions, as well as the SUM and SUMIF functions for adding numbers based on conditions. Additionally, it mentions the TODAY function for retrieving the current date in Excel.

Uploaded by

Navya Sama
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

Common Excel Questions Every

Data Analyst Should Know


Part-3

Geethika Putcha
What is a Pivot table and when would you use it?

A PivotTable is a powerful data analysis tool in Excel that allows you to


summarize and analyze large datasets. It enables users to rearrange, filter,
and aggregate data to gain insights quickly. PivotTables are useful when
you want to examine data from different perspectives, perform in-depth
analysis, and present information in a more structured and organized
manner.

Geethika Putcha
Explain the difference between COUNT, COUNTA, COUNTIF, and
COUNTIFS.

COUNT: Counts the number of cells in a range that contains


numbers.
COUNTA: Counts the number of cells in a range that are not empty
(includes cells with text or any value).
COUNTIF: Counts the number of cells in a range that meet a specific
condition.
COUNTIFS: Counts the number of cells in a range that meet multiple
specified conditions. It is used for multiple criteria.

Geethika Putcha
What are SUM() and SUMIF() functions?

1. SUM Function:
The SUM function is used to add up a range of numbers in Excel. Here's
an example: =SUM(A1:A5)
This formula adds up the values in cells A1 to A5.
2. SUMIF Function:
The SUMIF function allows you to sum values based on a specific
condition.
Here's an example:=SUMIF(B1:B5, ">50", A1:A5)
This formula adds up the values in cells A1 to A5 where the corresponding
values in cells B1 to B5 are greater than 50.
Geethika Putcha
What is the function to retrieve present date in Excel

The function to retrieve the present date is the TODAY function.


Here's an example:=TODAY()
This formula returns the current date.

Geethika Putcha
Thankyou!

For more such content


Follow @GeethikaPutcha

Geethika Putcha

You might also like