Ramadan Bootcamp - Excel Day 5

Ramadan Bootcamp - Excel Day 5

Assessment

Quiz

Professional Development

Professional Development

Hard

Created by

Vipanan Vidatree

Used 1+ times

FREE Resource

Student preview

quiz-placeholder

5 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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)

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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.

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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)

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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.