Use the attached spreadsheet to answer the following questio

Use the attached spreadsheet to answer the following question. Which formula can be used to find: How many songs were sung by Madonna and were three to four minutes long (inclusive)? =COUNTIFS(B2:B23, \"Madonna\", D2:D23, \"3\") =COUNTIFS(B2:B23, \"Madonna\", D2:D2 3, \" = 3\") =COUNTIFS(B2:B23, \'Madonna\', D2:D23, \" = 3\") =COUNTIFS(B2:B23, \"Madonna\", D2:D23, = 3) Suppose your worksheet has a comment in cell A1 and a comment in cell B5. Your active cell is Bl. Which command can you use to navigate to the comment in cell Review (tab) rightarrow Comments (command group) rightarrow Next Review (tab) rightarrow Comments (command group) rightarrow Previous Home (tab) rightarrow Navigate (command group) rightarrow Next Comment Page Layout (tab) rightarrow Search (command group) rightarrow Jump To Comment

Solution

Ans1.

Okay so to find the Number of Songs sung by \"Madonna\", which are 3 to 4 minutes long in duration we will use the COUNTIFS Command.

This command is used to count the number of entries following a fixed condition. Here the entry is Madonna, and the condition is 3 to 4 minutes long in Duration.

The Command used is: -

COUNTIFS (Range of Cell\'s to be searched, “Entry to be searched”, Range of Condition1,\"Condition1”, Range of Condition 2,\"Condition 2”,...)

So, the Formula used will be: -

=COUNTIFS (B2:B23,\"Madonna”, D2:D23,\"<=4”, D2:D23,\">=3\")

The Option 2 in the above Question. We are using the = sign with 3 and 4 as we need to include the 3rd and 4th minute too.

Ans6.

Now as we are on Cell B1, and we have 2 comments at Cell A1, and B5, so according to excel we are between the 2 comments. Now to go to the Comment on Cell B5 we need to go to the Next Comment.

To go to the next comment, Go to Review (tab) -> Comments (Command Group) -> Next

Option 1 in the above Question.

This command will take you to the Comment of Cell B5.

These are the answers to the questions you provided.

Thank You for using Chegg...