Only answer in abcd format doesn't need explanation

Where can you find the option to set Conditional Formatting rules?

Select one:

a. Under the Formulas tab on the Ribbon in the Formatting group.

b. Under the Insert tab on the Ribbon in the Formatting group

c. Under the Home tab on the Ribbon in the Styles group.

d. Under the Page Layout tab on the Ribbon in the Styles group

Column C contains the yearly sales data Which of the following can be used to draw a histogram using tor the yearwise sales

Select one

a. =DUPLICATE(c2)

b. Using Graphs in Insert tab

C Using Histogram in Data Analysis

d. =REPT(*C2/100)

Goal Seek has three parts - Select the incorrect option

Select one:

a A formula to run values

b A target value to achieve

C A cell that it can change while testing the values

d. Simple constraints to get optimum value

Which of the following function will give ll as outcome?

Select one

a =FIND(Year Happy New Year')

b None of these

FIND 'New "Happy New Year')

FIND a Happy New Year