Data Analytics (Scholarship)

Start Application


Brief Assessment:

1. Which of the following is used to create a chart in Microsoft Excel?
Pivot table
Sparkline
Slicer
Graph

2. Which formula is used to sum a range of cells in Microsoft Excel?
COUNT
AVERAGE
MAX
SUM

3. Which of the following functions can be used to calculate the average of a range of cells in Microsoft Excel?
SUM
COUNT
MAX
AVERAGE

4. What does the "range_lookup" parameter in the VLOOKUP function do in Microsoft Excel?
It specifies whether the lookup value should be an exact match or not
It specifies the column number of the lookup value
It specifies the range of cells to be searched for the lookup value
It specifies the value to be returned if the lookup value is not found

5. What does the INDEX function in Microsoft Excel do?
It searches for a value in a range of cells and returns a corresponding value in the same row
It returns the number of cells in a range that contain numbers
It returns the position of the first occurrence of a value in a range of cells
It returns a value or reference to a value from a specified position in a range of cell

logo-footer
Who we Are

We are intentional about our service delivery and we leave our signature of excellence on everything we do.

Consulting | Outsourcing | Academy 

Follow Us
Links
Our Contacts 

© Copyright 2023 Alpher Ltd - All Rights Reserved