# Excel Basics

<figure><img src="/files/qT5VRYqzwtmVVu7V2NVQ" alt=""><figcaption></figcaption></figure>

***

## Questions

<details>

<summary>Find Revenue</summary>

From the source below can you find the Revenue the specified account?&#x20;

<img src="/files/RQsJMh2GNRsovPCvxiyd" alt="" data-size="original">

**Answer**

This can be solved with a simple VLOOKUP

```
=VLOOKUP(F3,B2:D12,3,FALSE)
```

</details>

<details>

<summary>Find Customer Number</summary>

From the source below can you find the Customer Number corresponding to the Account Name?

&#x20;![](/files/2GTvYybNFoTtnC4LeMvo)

**Answer**

VLOOKUP won't work as Customer Num is to the LEFT of the Account Name. We need INDEX MATCH [📖Explanation](https://exceljet.net/index-and-match)

```
=INDEX(A2:D12,MATCH(F7,B2:B12),1)
```

</details>

<details>

<summary>Total Revenue</summary>

From the source below can you find the total revenue per sales rep? ![](/files/ok3rPRNMHhUAdNU3sKZ3)

**Answer**

This can be solved with a simple SUMIF. For the first row the answer is given below. It will be similar for other rows.

```
=SUMIF(C3:C12,"="&F11,D3:D12)
```

</details>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://book.thedatascienceinterviewproject.com/excel/excel-basics.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.