Data Analytics

Instructions:

You will have 5 minutes for filling your Basic Details & 25 minutes to complete the Assessment Test.
You are allowed to complete the test in one attempt only. Mutiple submissions may lead to rejection of your candidature.

Enter Your Full Name*

PrefixFirst NameLast Name

Phone Number*

Enter your Email ID*

example@example.com

Education*

Qualification / Ongoing Education

Take Photo

E-Signature

What is the output of =ODD(20)+EVEN(39)*

5759610

What type of chart is good for single series of data?*

Pie ChartLine ChartColumn ChartCone Chart

When you insert an Excel file into a Word document, the data are*

HyperlinkedEmbeddedPlaced in a word tableLinked

Suppose cells A2:B20 contain a table with product numbers in column A and product prices in column B. What does the formula =VLOOKUP(A25,A2:B20,1,FALSE) return?*

The price for the product in column A if the exact product number corresponding to A25 can be found, or #N/A if not.The number for the product in column A if the exact product number corresponding to A25 can be found, or #N/A if not.The price for the product in column A if the exact product number corresponding to A25 can be found, or the price for the closest product if the exact product number can't be found.Don’t know

We can check the conditions against __________ when applying conditional formatting*

Cell valueFormulaBoth of above are correctNone of the Above

What is the keyboard shortcut for creating a chart from the selected cell range?*

F2F4F6F11

Comments put in cells are called?*

Cell tipSmart tipWeb tipSoft tip

A function inside other function is called*

Nested FunctionRound FunctionInner FunctionNone of the above

IF Statement can be written to carry out an action*

TRUEFALSEI do not knowNone of the above

Which function returns the current date?*

LookupVLookupCountIFNOW

Advanced Functions are used in higher-level operations such as in conditional and comparison equations to compute interest rates, due dates and payment terms, and financial projections.*

TrueFalseI do not knowNone of the above

Suppose cells A2:B20 contain a table with sorted product numbers in column A and product prices in column B. What does the formula =VLOOKUP(A25,A2:B20,2) return?*

The price for the product in column A if the exact product number corresponding to A25 can be found, or #N/A if not.The number for the product in column A if the exact product number corresponding to A25 can be found, or #N/A if not.The price for the product found in column A (or the closest product if the exact product number can't be found)Don’t know

Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used with only two columns in the array.*

LookupVLookupNOWCountIF

Which of following functions MS-Excel have 1 SUM 2 CONCATENATE?*

Only 1Only 2None of 1 and 2Both 1 and 2

Which of the following is an example of text in a spreadsheet?*

2763Sales 1994 1995=A1+A2+A3=sum (A1+A2+A3)

To Add up entries from D6 to D10, we use the formula?*

Add D6.. D10=Sum (D6..D10)Add D6 to D10None of these

Excel uses a _________ to denote a range of cells?*

SemicolonCommaColonDot

Which menu can be used to turn on or turn off the formula and status bar?*

Windows MenuView MenuEdit MenuDate Menu

Finds maximum value among a range of cell from A4, A5, A6, A7 and A8 in MS-Excel?*

Max (A4 to A8)Max (A4 - A8)Max (A4 : A8)Max (8A : 4A)

Suppose cells A2:B20 contain a table with product numbers in column A and product prices in column B. What does the formula =VLOOKUP(A25,A2:B20,2,FALSE) return?*

The price for the product in column A if the exact product number corresponding to A25 can be found, or #N/A if not.The number for the product in column A if the exact product number corresponding to A25 can be found, or #N/A if not.The price for the product in column A if the exact product number corresponding to A25 can be found, or the price for the closest product if the exact product number can't be found.Don’t know

A features that displays only the data in column (s) according to specified criteria*

FormulaFilteringSortingPivot

Which function is used to return the number of cells in a range that meet a condition set forth in the formula?*

LookupVLookupNOWCountIF

for image of Entity and sales-which is the correct formula*

=HLOOKUP(A4, A1:F1,2, FALSE)=VLOOKUP(B4, A1:F1,2, TRUE)=HLOOKUP(A4, A1:F1,2, TRUE)=VLOOKUP(A4, A1:F2,2, FALSE)

The four arguments used in the VLookUp function are: Name of Item, _________, column index number, look for approximate match.*

range containing dataPrice of the item being looked forif conditionDon’t know

Sita wants to search her spreadsheet for a value in the first column of her table. What function should she use? Kindly refer to the picture below the question.*

VlookupHlookupSortingFiltering

Course Name: Data Analytics

Basic Details

Assessment Test