ITE 140

The IF function can use which of the following comparison operators? Select all the options that apply.

= (equal), > (greater than), <> (not equal)

When you paste formula cells using the Paste button in the Clipboard group, which of the following is true?

A button appears near the selected cells with options for pasting formulas and values.

Which of the following are functions you can use to calculate measures of central tendency? Select all the options that apply.

AVERAGE, MEDIAN

Calista wants to provide additional information about a hyperlink she is creating. Which of the following can she do?

Add a ScreenTip.

Evelyn wants to work on different parts of a workbook at the same time by displaying worksheets in separate windows. Which option on the View tab should she select?

Arrange All

Which of the following lets you extend any data pattern involving dates, times, numbers, or text?

AutoFill Options button

What can you do to make data series easier to distinguish from one another?

Change the color of the data series

Mia inserted a plain table in a worksheet. She wants to change the black borders and white fill to make the table more attractive and easier to use. What is the quickest way for her to change the appearance of the table?

Change the table style.

Josh wants to insert a column in an Excel table to add the values from two other columns. Which of the following methods can he use to insert a table column?

Click a column header and then click the insert button on the home tab

When Valerie used AutoFill to copy a formula, Excel copied the format and removed shading from some cells. What can she do to prevent the formatting change?

Click the AutoFill Options button and then click Fill Without Formatting.

A Line sparkline displays a green block for increasing values and a red block for declining values.

False

Bruno has a table with four fields and dozens of records. To make the fields easier to distinguish, he can apply filtered columns.

False

Changing a worksheet window to Normal view changes the contents of the worksheet.

False

The only way to update a link to another workbook is to insert a new link.

False

When you change cell contents to italics, you are changing the cell's alignment.

False

When you print in portrait orientation, the page is wider than it is tall.

False

Which Excel features can you use to extend a formula into a range with AutoFill? Select all the options that apply.

Fill handle, Fill button in the Editing group

A _______ refers to a collection of characters with a similar, specific design.

Font

To change the color of cell content, you use the ________ color list arrow.

Font

To copy a cell's formatting to another cell, which of the following can you use?

Format Painter

Joe wants to format several worksheets at the same time. What is the easiest way for him to perform this task?

Group the worksheets.

To format a cell range so that values between 100 and 500 appear in red, which of the following can you use?

Highlight Cells Rules

Which of the following is a type of logical function?

IF

Which of the following can you do to make a chart title stand out on a chart?

Increase the font size.

Which of the following buttons on the Home tab can you use to insert a row in a table?

Insert

In column D of a worksheet, Cal lists the number of hours each employee works. What function should he use to find the employee who worked the most hours?

MAX

Kylie created a table with a Skill Number column that contains values from 400 to 500. What type of filter can she use to select records with skill numbers less than 450?

Number filter

Steffie needs a wider left margin in her worksheet. Which of the following can she do to change the margin?

On the Margins tab of the Page Setup dialog box, change the number in the Left box.

When you _____ a formula, Excel retrieves the formula from the Clipboard and places it into the selected cell.

Paste

To which of the following chart types can you not add axis titles?

Pie chart

Which of the following functions does Excel provide for rounding values? Select all the options that apply.

ROUND, ROUNDDOWN, ROUNDUP

Which of the following techniques can you use to remove hyperlink from a cell?

Right-click the hyperlink and then click Remove Hyperlink on the shortcut menu.

Which of the following chart types show how two numeric data series are related to each other?

Scatter

Kathy wants to add the numbers entered in a range of selected cells. To do this, which tab will she click on the menu that appears after clicking on Totals in the Quick Analysis option?

Sum

A(n) _____ is a range of data Excel treats as a single object that can be managed independently from other data in the workbook.

Table

To create a workbook containing text, formulas, macros, and formatting that you use repeatedly, you create a _____.

Template

When you select a range of values, you can create defined names based on the text in which of the following locations within the range? Select all the options that apply.

Top row, left column

A combination chart combines two chart types and can plot data on primary and secondary axes.

True

Binay wants to create an X-Y scatter plot. To do so, he should select the data he wants to plot in the scatter chart, then click the Insert tab, and then click Insert Scatter (X, Y) or Bubble Chart.

True

Dean wants to insert two blank rows above row 5. To do so, he can click the row 5 heading, and then click the Insert button in the Cells group two times.

True

Decreasing a cell's indent moves its contents to the right one space.

True

Liza has a table with six fields and 50 records. To make it easier to distinguish the records, she can apply banded rows.

True

Niki wants to insert a Line sparkline in Excel. To do this, she can click on the cell she wants to insert a Sparkline, then click Insert tab, select Line Sparkline from the Sparklines group and then OK.

True

The Comma Style format adds a comma and a dollar sign to a cell value.

True

The Remove Duplicates tool locates and deletes records that are duplicated across more than one field.

True

When you open a trusted workbook containing external links, you can update the workbook with the latest data.

True

When you use the Windows Start menu to start Excel, it opens in Backstage view.

True

You can add data markers to sparklines to indicate the high and low points in the chart.

True

You can edit cell contents in the formula bar or in the cell itself.

True

teacher creates a table of student data that contains columns for First Name, Last Name, and Date of Birth. To list the students in alphabetical order by last name, she can sort the Last Name column in ascending order.

True

Shelley creates a table containing the marks of Language Arts students in her class with these columns: Names of Students and Marks. She now wants to see the names of students who scored exactly 60 marks. What will Shelley do after selecting the column header arrow for the column with heading Marks?

Uncheck (Select All), select the box beside the number 60 and click OK.

Which of the following is not true about setting column width?

You can change the width of only one column at a time.

Which of the following is true about moving cell contents?

You can move cells using the drag-and-drop feature.

Which of the following is an acceptable name for a range in Excel?

_TotalExpenses

You can use the Find and Replace dialog box to find and replace _____.

cell references

If you see a cells with blue fills of varying lengths representing the values, the cells most likely have ________ applied to them.

data bars

A _____ is a named operation that replaces the action of an arithmetic expression.

function

If you want to print only part of a worksheet, you can set a _____.

print area

You can use the Name Manager dialog box to view and manage named ranges, including the _____, which indicates where the named range is recognized.

scope