Question 1

In a chart, a data table displays the data series in rows and the category values in columns.

Accepted Answer

In a data table, the data series are listed in columns and the category values are listed in rows.

Question 2

Nathan wants a formula to return "Yes" if the value in cell A1 is less than the value in cell B1, and to return "No" otherwise.Which of the following functions should he use?

Accepted Answer

Nathan needs to use an IF function to compare the values in A1 and B1. The IF function will return "Yes" if the condition (A1<B1) is true and "No" otherwise.

Question 3

Patrick is editing a worksheet with many formulas and functions, making the worksheet slow to update when he changes data.How can he work more efficiently?

Accepted Answer

By selecting the manual calculation option, Patrick can control when the worksheet updates and prevent the slow updating when he changes data. This allows him to work more efficiently by only calculating the formulas when he wants to.

Question 4

To display a duplicate of a chart on another worksheet, select the chart and then click the Move button in the Clipboard group.

Accepted Answer

- Copy
 - copy
 - COPY

Question 5

You can use the Excel equation tools to insert an equation for calculating the area of a circle.

Accepted Answer

Excel has equation tools that can be used to insert various mathematical equations, including the formula for calculating the area of a circle.

Question 6

Jason wants to display the text "Poor" if the value in cell A3 is less than 25.If the value in cell A3 is less than 50, Jason wants to display "Average"; otherwise, he wants to display "Good".Which of the following formulas should he use?

Accepted Answer

The correct formula for this scenario is "=IF(A3 < 25, "Poor", IF(A3 < 50, "Average","Good"))". This formula checks if the value in cell A3 is less than 25, and if it is, it displays "Poor". If it is not less than 25, it checks if it is less than 50, in which case it displays "Average". If it is greater than or equal to 50, it displays "Good". The other answer choices either have syntax errors or do not correctly display the desired text based on the conditions.

Question 7

A trendline is a small, simple chart in a worksheet cell that shows trends of data in nearby cells.

Accepted Answer

A trendline is a graphical representation added to a chart showing the overall direction or trend of the data, not a small chart in a worksheet cell. What's described is more akin to a Sparkline.

Question 8

You can use trendlines to project future data based on past trends.

Accepted Answer

Trendlines can be used to make predictions about future data based on past trends. These predictions are not always accurate, but can be useful in making strategic decisions or planning for the future.

Question 9

To show formulas instead of values, click on the Formulas tab in the ribbon, then in the Formula Auditing group, click on the Show Formulas option.

Accepted Answer

This is the correct way to show formulas instead of values in Excel.

Question 10

Liam needs to count the cells in the range B1:B20 that contain numbers, dates, or text.Which of the following formulas should he use?

Accepted Answer

The COUNTA function counts all cells in a given range that are not empty, including those containing numbers, dates, or text. Therefore, B is the best choice for Liam to count all cells in the range B1:B20 that contain numbers, dates, or text.

All other options are not appropriate for the task at hand. Option A would only count cells that contain numbers, while option C would give the sum of the cells' values, not the number of cells that contain any data. Option D is not a valid function in Excel.

Question 11

The score of a student is inserted in cell B2.The passing score for the subject is 60.Which of the following functions should you insert in cell C2 to check whether the student has passed or failed?

Accepted Answer

The IF function with the logical test B2>=60 checks whether the score in cell B2 is greater than or equal to 60. If it is, the function returns "Pass", otherwise it returns "Fail".

Question 12

Which of the following elements uses colors to identify how the data is represented in a chart?

Accepted Answer

The legend typically uses colors to identify different data series or categories in a chart. The other elements listed (gridlines, chart title, data label) do not necessarily use colors for identification.

Question 13

Jose inserts the formula =DATE(2021, 2, 15) in cell A15.When he presses ENTER, 2/15/2021 will appear in the cell.

Accepted Answer

The DATE function in Excel returns a date value based on year, month, and day inputs. In this case, the formula =DATE(2021, 2, 15) will return the date 2/15/2021 when entered into cell A15.

Question 14

Sam wants to count the number of cells in the range B1: B20 that contain numbers.Which of the following formulas should he use?

Accepted Answer

The COUNT function is specifically designed to count the number of cells in a range that contain numbers, making it the correct choice for Sam's requirement.

Question 15

Which of the following are effects you can apply to the chart title? Select all the options that apply.

Accepted Answer

The answer of Which of the following are effects you...

Question 16

Which of the following can you apply to change the fill of a data series? Select all the options that apply.

Accepted Answer

Texture, Color, and Shape Style can all be used to change the fill of a data series. WordArt is not applicable for changing a data series fill.

Question 17

You can insert WordArt into a worksheet, but not a chart.

Accepted Answer

WordArt can be inserted into a chart as well as a worksheet.

Question 18

Which of the following keys should you press to have Excel calculate all open workbooks manually?

Accepted Answer

Pressing F9 will calculate all open workbooks manually.

Question 19

Megan wants to refine the appearance of a column chart, including applying a lighter shade of blue.Which of the following tools can she use to do so? Select all the options that apply.

Accepted Answer

The answer of Megan wants to refine the appearance of...

Question 20

To insert only the current date in cell B1, use the NOW function in cell B1 .

Accepted Answer

The NOW function inserts both the current date and time. To insert only the current date, the TODAY function should be used instead.

Quiz 7: Excel