 Assessment Back to the course

Well done, you have passed the graded

assessment
You have scored 100%

For Engineering Notes & Updates Join Telegram : @eduenginnering

Downloaded From : Eduengineering.in

 Assessment

Question 1 of 20
Single choice question

The Conditional Formatting function in

Excel allows you to:

Select the correct answer

All of the options listed above are correct

Automatically apply to highlight selected cell ranges based on specific rules or

conditions being met.

Automatically apply formatting based on specific rules or conditions being met.

Automatically change the font of selected cell ranges based on specific rules or
conditions being met.

 Previous Next 

For Engineering Notes & Updates Join Telegram : @eduenginnering

Downloaded From : Eduengineering.in

 Assessment

Question 2 of 20
Single choice question

Microsoft Excel uses the _____________

function to calculate the results in the data table

Select the correct answer

CALTAB

RESULT

TABLE

AUTOSUM

 Previous Next 

For Engineering Notes & Updates Join Telegram : @eduenginnering

Downloaded From : Eduengineering.in

For Engineering Notes & Updates Join Telegram : @eduenginnering

Downloaded From : Eduengineering.in

 Assessment

Question 4 of 20
Single choice question

What dialog box allows you to change a

field name in a PivotTable?

Select the correct answer

Field Structures

Field Settings

Field Panes

Field Options

 Previous Next 

For Engineering Notes & Updates Join Telegram : @eduenginnering

Downloaded From : Eduengineering.in

For Engineering Notes & Updates Join Telegram : @eduenginnering

Downloaded From : Eduengineering.in

 Assessment

Question 6 of 20
Single choice question

When all the numbers between 0 and 100 in a

range should be displayed in red color apply?

Select the correct answer

Apply the Conditional formatting command on the Format menu

Select the cells that contain numbers 0 and 100 then click Red Color on Text Color Tool

Use =IF() function to format the required numbers in red

All of the Above

 Previous Next 

For Engineering Notes & Updates Join Telegram : @eduenginnering

Downloaded From : Eduengineering.in

 Assessment

Question 7 of 20
Single choice question

What is the first step for creating a Pivot

Table?

Select the correct answer

Deciding on which fields (column and row labels) to use to analyze the data

Create or select data that needs to be analyzed

Clicking on the Insert Tab and inserting a Pivot Table

None of the Above

 Previous Next 

For Engineering Notes & Updates Join Telegram : @eduenginnering

Downloaded From : Eduengineering.in

 Assessment

Question 8 of 20
Single choice question

What does the VLOOKUP function do?

Select the correct answer

Checks whether the text is the same in one cell as in the next

Finds related records

Looks up text that contains V

All of above

 Previous Next 

For Engineering Notes & Updates Join Telegram : @eduenginnering

Downloaded From : Eduengineering.in

 Assessment

Question 9 of 20
Single choice question

______________ is not a function in Microsoft Excel

spreadsheets?

Select the correct answer

HYPERLINK

AVG

COUNTIF

MIN

 Previous Next 

For Engineering Notes & Updates Join Telegram : @eduenginnering

Downloaded From : Eduengineering.in

 Assessment

Question 10 of 20
Single choice question

Which of the following formulas will Excel

Not be able to calculate?

Select the correct answer

=SUM(A1:A5)-10

=SUM(A1:A5)*.5

=SUM(Sales)-A3

=SUM(A1:A5)/(10-10)

 Previous Next 

For Engineering Notes & Updates Join Telegram : @eduenginnering

Downloaded From : Eduengineering.in

 Assessment

Question 11 of 20
Single choice question

Under which tab and in which

function group will you find the option to insert a Pivot Table?

Select the correct answer

Under the Formulas tab in the Data Analysis group

In the Data group in the Tables group

In the Data group in the Pivot Tables group

Under the Insert tab in the Tables group

 Previous Next 

For Engineering Notes & Updates Join Telegram : @eduenginnering

Downloaded From : Eduengineering.in

 Assessment

Question 12 of 20
Single choice question

 What function displays row data in a

column or column data in a row?

Select the correct answer

Hyperlink

Rows

Transpose

Index

 Previous Next 

For Engineering Notes & Updates Join Telegram : @eduenginnering

Downloaded From : Eduengineering.in

 Assessment

Question 13 of 20
Single choice question

Which one is not a function in MS Excel?

Select the correct answer

AVERAGE

COUNT

PROPER

CLEAR

 Previous Next 

For Engineering Notes & Updates Join Telegram : @eduenginnering

Downloaded From : Eduengineering.in

 Assessment

Question 14 of 20
Single choice question

Which formula would provide a dynamic array

showing all columns of the Items table where the Category equals “SUN”?

Select the correct answer

Formula A: =UNIQUE(FILTER(Items[Description],Items[Category]="SUN") )

None of the Above

Formula C: =FILTER(Items,Items[Category]>>"SUN")

Formula B: =FILTER(Items,Items[Category]="SUN")

 Previous Next 

For Engineering Notes & Updates Join Telegram : @eduenginnering

Downloaded From : Eduengineering.in

 Assessment

Question 15 of 20
Single choice question

Which of the following is not true

regarding Conditional Formatting?

Select the correct answer

You can delete any condition from the conditional formatting dialog box if it is not
required

You can apply Font, Border, and pattern formats that meet the specified conditions

You can set conditions to look for Bold and apply Italics on them

You can add more than one condition to check

 Previous Next 

For Engineering Notes & Updates Join Telegram : @eduenginnering

Downloaded From : Eduengineering.in

For Engineering Notes & Updates Join Telegram : @eduenginnering

Downloaded From : Eduengineering.in

For Engineering Notes & Updates Join Telegram : @eduenginnering

Downloaded From : Eduengineering.in

 Assessment

Question 18 of 20
Single choice question

How can we provide a dynamic range in the

'data Source' of pivot tables?

Select the correct answer

Both A and B

None

Create a Named range using the Offset function

Base the pivot table using the Named range created in Step 1

 Previous Next 

For Engineering Notes & Updates Join Telegram : @eduenginnering

Downloaded From : Eduengineering.in

For Engineering Notes & Updates Join Telegram : @eduenginnering

Downloaded From : Eduengineering.in

 Assessment

Question 20 of 20
Single choice question

  You

can add a hyperlink to your worksheet by pressing

Select the correct answer

Alt + K

Ctrl + H

Ctrl + K

Ctrl + Shift + K

 Previous Submit

For Engineering Notes & Updates Join Telegram : @eduenginnering