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