Practice Test 2- AGRI – Flashcards

A ________ contains the actual values that are plotted on the chart

Which of the following is not a date function? ____

The ____ is the best chart type to compare a single row or column of values.

The _____ command searches through the current worksheet or workbook for the content or formatting you want to locate.

Absolute references are marked with a ____.

Information that prints on the top of each page, like a company name or logo, may be set as a _____.

To make A1 the active cell, you should press which of the following keys?

Harold would like to center a title across the top of his data. His data runs across five columns, from column A to column E. One way he could accomplish this is to _____.

Antoinette wants all her worksheets to have the same formatting for text, colors, and graphical effects applied to create a specific look and feel. Antoinette needs to apply a _____.

One way to ensure that you are using consistent formats is to copy and paste your formats using the Format _____.

One of the entries Tyler enters into the spreadsheet automatically right-aligns in the cell. Which entry does this?

Generally, _____ are given a "washed-out" appearance and are placed behind text or charts on the sheet so that they do not obscure any of the other content on the sheet.

Harold needs to format several cells with 11pt Calibri font, two decimal places, right-aligned, and a blue font color. The most efficient way to accomplish this would be to _____.

When you nest functions, you should have ____.

The ____ category of Excel functions returns (true-false) values

____ enters text based on patterns it finds in the data.

The ____ dialog box provides options for moving charts to another worksheets or creating a new chart sheets.

In Excel, to merge cells A1, B1, C1, D1, and E1, _____ is the correct reference for the newly merged cell.

To move one slice of a pie chart away from the pie creates a(n) ____.

Harold cannot increase the width of his worksheet because, if he does, he will not be able to print it on one sheet. However, two columns have lengthy text entries and not all the data is visible. What solution would be the best for Harold to use to make all his text visible without losing data?

The numbers, text, or cell references used by the function to return a value are called ____.

When creating an Excel document, you should avoid using _____ text and background together, since this is the most common form of color blindness.

Use ____ references when you want different formulas to refer to the same cell.

An Excel formula always begins with a(n) ____.

To resize an embedded chart, ____.

Which function counts how many cells in a range contain numbers, where value1, value2, and so forth are text, numbers, or cell references?

Tyler notices that the Address column is too wide. He could use that extra space for other columns so he ____.

Options to rotate cells in Excel are available using the _____ button in the Alignment group on the Home tab.

Samantha will add the number of orders. She chooses to use the ____ function from the AutoSum feature.

The ____ function returns the maximum value in the range.

After entering Jan in cell A1, you decide to use AutoFill to complete the next three cells. What would be the resulting series in the next three cells? ___

You already created a line chart, but now decide that you want to change this chart to a pie chart. To do this, you click ____ from the Type group in the Chart Tools Design tab.

To switch to ____ mode, you double-click the cell.

The fill handle copies ____.

In one of Harold's columns there are too many numbers after the decimal place. It is distracting from the data and he really only needs two numbers after the decimal. How could Harold make the data appear cleaner in the most efficient way?

Samantha wants to find out how much money she will make on her largest order, which is currently in row E. Cell E4 contains the number of items ordered and cell E5 contains the price per item. An appropriate formula would be ____.

FUNCTION(argument1, argument2, ...) is ____.