Ramadan Bootcamp - Excel Day 5

Akhil is preparing a financial report in Excel and needs to analyze data that is located several rows and columns away from his current cell. If he wants to dynamically reference this data based on his current position, which function would he use to achieve this?

• OFFSET

• INDEX MATCH

• XLOOKUP

• INDIRECT

Riyaan has recorded his study hours and corresponding grades for the semester. He wants to find out which study hours resulted in grades above 75%. How can he effectively use FILTER and SORT in a single formula to create a list of his study hours that correspond to these high grades, sorted in ascending order?

• =SORT(FILTER(range, condition), sort_index, sort_order)

• =FILTER(range, condition)

• =SORT(range, sort_index, sort_order)

• =FILTER(SORT(range, sort_index, sort_order), condition)

While working on a financial report, Kabir attempts to use the OFFSET function in a spreadsheet to reference a specific data range. However, he mistakenly inputs an invalid range. What is the likely outcome of this action?

• The OFFSET function will return an error message indicating the invalid range.

• The OFFSET function will produce a #REF! error in spreadsheet applications.

• The OFFSET function will skip the invalid range and return the next valid range.

• The OFFSET function will attempt to correct the range automatically.

Shaan is organizing his study materials in a spreadsheet and needs to find a specific reference for his notes. He has a list of topics starting from cell A1. If he wants to reference the topic that is located 3 rows down and 2 columns to the right of the first topic, which OFFSET function should he use to accurately point to that cell?

• OFFSET(A1, 3, 2)

• OFFSET(A1, 2, 3)

• OFFSET(A1, 1, 1)

• OFFSET(A1, 4, 2)

Aanya is analyzing her study hours for different subjects and wants to focus on the subjects where she spent more than 5 hours last week. If she uses the FILTER function in her data analysis tool, how can it help her in making informed decisions about her study schedule?

• It allows her to isolate and view only the subjects where she dedicated more than 5 hours, enabling her to focus her study efforts effectively.

• It provides a way to rank all subjects based on hours spent, which might distract her from identifying key subjects to prioritize.

• It assists her in generating charts of her study hours, but does not specifically aid in determining which subjects to prioritize.

• It compiles her total study hours into one figure, which fails to give her insights into the individual subjects she studied.