Question

Complete the sentences relating to the role each of the following functions have in excel. bushra is an intern at a local pharmaceutical company. each morning, she records the success rate of 220 server backups from the night before. each sever provides a percentage of the amount of data that has been backed up from the night before. the minimum target is a 95% success rate for each server. to be able to complete the task in the least amount of time, she should use the function to eliminate all percentages above the target. alternately, although more time-consuming, she could use a to do the same process.

Answer 1

The intern should use the IF function to eliminate percentages above the target in Excel. Alternatively, the intern can use the FILTER function to filter out percentages above the target.

Step-by-step explanation:

The function that should be used to eliminate all percentages above the target is the IF function. This function allows the intern to set a specific condition and return different values based on whether the condition is met or not. In this case, the condition would be whether the success rate is above the target or not. If it is above the target, the function can return a value indicating that it should be eliminated.

The function that could be used alternatively, although more time-consuming, is the FILTER function. This function allows the user to specify criteria and extract only the data that meets those criteria. In this case, the criteria would be a success rate below or equal to the target, and the function would filter out any percentages above the target.

Answer 2

Bushra should use the IF function or filter function in Excel to eliminate all percentages above the target success rate of 95% for each server backup.

Step-by-step explanation:

The function that Bushra should use to eliminate all percentages above the target is the IF function. In this case, Bushra can use the IF function to check if the success rate of each server backup is above 95%, and if it is, eliminate that percentage. The IF function would look like this:

=IF(A1>95%, A1,0)

This formula checks if the value in cell A1 is greater than 95%. If it is, it returns the value in cell A1, and if it isn't, it returns 0.

Alternatively, Bushra could use a filter to achieve the same result. The filter function allows you to apply a condition to a range of data and only display the rows that meet the condition. In this case, Bushra could use the filter function to only display the rows where the success rate is not above 95%. The filter function would look like this:

=FILTER(A:A, A:A<=95%)

This formula filters the values in column A and only displays the values that are less than or equal to 95%.