ITE140 Test 1 Questions (?)

If you want to create a new line within a cell, press the ____ keys to move the insertion point to the next line within the cell.

Alt + Enter

You can open the Format Cells dialog box by right-clicking a cell or selected range, and then clicking _____ on the shortcut menu.

Format Cells

In a workbook's theme, _____ colors are designated for text and background, _____ colors are used for accents and highlights, and _____ colors are used for hyperlinks.

Four, six, two

The Insert Function button is in the ____ group.

Function Library

By default, numbers appear in the _____ and generally display values exactly as you type them.

General format

After you describe a function in the Search for a function box in the Insert Function dialog box, click ____.

Go

Which of the following is a Math & Trig function? ____

INT

Put the following five steps in the order in which you would perform them to use the Paste Special function. 1. Select and copy a range. 2. Click the Paste button arrow in the Clipboard group on the HOME Tab. 3. Specify exactly what you want to paste. 4. Click Paste Special to open the dialog box. 5. Select the range where you want to paste the Clipboard contents.

1, 5, 2, 4, 3

Excel functions are organized into ____ categories.

13

What is the result of the expression =50+20/10*5?

60

Using AutoFill, what would be the extended series of the initial entry Jan? ___

Feb, Mar, Apr

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

Find

____ arguments may provide more control over the returned value.

Optional

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

Orientation

____ displays the location of the different page breaks within the worksheet.

Page Break Preview

In the formula =INT(AVERAGE(A1:A100)), which would occur first? ____

The average of the values in the range A1:A100 is calculated.

In the following formula: =IF(A1="YES", "DONE", "RESTART"), what happens if A1= "NO"? _____

The formula returns the text "RESTART".

mm/dd/yyyy is known as ____.

a date format

Excel supports all of the following types of sparklines EXCEPT ____.

a true/false sparkline for help making decisions

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

absolute

When you copy a selection of cells using drag and drop, which appears before you release the mouse button?

an outline of the new location of the selected range

In "SUM(number1 [, number2, number3, ...])", number 1, number 2, and number 3 may be numbers or ____.

cell references

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

data series

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

equals sign

To add a _____ to a sheet tab, right-click a sheet tab, point to Tab Color on the shortcut menu, and then click a color.

fill color

To set a page break in Excel, select the _____.

first cell below the row where you want to insert a page break

The FV function stands for ____.

future value

Edward Tufte was concerned with what he termed as "chart ____," in which a proliferation of chart elements—chosen because they look "nice"—confuse and distract the reader.

junk

The header and footer sections include a _____.

left, right, and center section

One of the benefits of Live Preview is that it _____.

lets you see and evaluate different formats as you develop your workbook

To avoid splitting a worksheet in awkward places, you can insert a _____ to specify a specific breaking point.

manual page break

A _____ is the space between the page content and the edges of the page.

margin

Another name for the middle value is the ____ value.

median

Harold wants to print ranges E6:F12 and E16:F22 of his worksheet. These are referred to as _____ cell ranges.

nonadjacent

Because Excel stores dates and times as _____, you can apply different formats without affecting the date and time value.

numbers

A chart sheet can contain ____.

only one chart

PMT(rate, nper, pv [, fv=0] [, type=0]) In the figure above, fv and type are ____.

optional arguments

To change the order of operations, enclose part of the formula in ____.

parentheses

In ____ orientation, a page is taller than it is wide.

portrait

The amount of money being loaned is known as the ____.

principal

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

print title

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

red and green

The range of values or _______, of an axis is based on the values in the data source.

scale

You can ____ the width or the height of the printout so that all of the columns or all of the rows fit on a single page.

scale

Which of the following will not change the location of the active cell?

scrolling

The Insert Function dialog box has a(n) ____ option.

search

Keyboard ____ can help you work faster and more efficiently because you can keep your hands on the keyboard.

shortcuts

When you nest functions, you should have ____.

the same number of left and right parentheses

One way to perform a _________ is by changing one or more of the input values to see how they affect the calculated results.

what-if analysis

If the VLOOKUP function cannot find the lookup value, the _________ error value is displayed in the cell.

#N/A

Absolute references are marked with a ____.

$

The code _____ will display the filename of the current workbook.

&[File]

To move or copy a range of cells, select the correct order: 1. Move the pointer over the border of the selection until the pointer changes shape. 2. Select the cell or range you want to move or copy. 3. To move the range, click the border and drag the selection to a new location, or to copy the range, hold down the Ctrl key and drag the selection to a new location.

2,1,3

Which of the following is not a comparison operator? ____

<<

The formula used to multiply cell A1 by cell C1 is ____.

=A1*C1

What is the syntax for a SUM formula adding the values of cell F6 to F9?

=SUM(F6:F9)

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

A1

Which of the following is not an Excel function category? ____

Algebra

____ makes it easier to enter repetitive text in cells.

AutoComplete

The Format Cells dialog box has six tabs, including _____.

Border

To add and remove chart elements, you can use the Add Chart Element button in the Charts Layout group on the ____ tab.

CHART TOOLS DESIGN

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

COUNT

To reposition the legend to the left-hand side of a chart, click the _________ button, point to Legend, click the right arrow icon, and click Left.

Chart Elements

You can move to the previous or next sheet by pressing the ____ keys.

Ctrl + Page Up or Ctrl + Page Down

Whenever you click the Save button on the Quick Access Toolbar or press the ____ keys, the workbook file is updated to reflect the latest content.

Ctrl + S

_____ are an example of conditional formats in Excel.

Data bars

____provide descriptive text for the individual data markers, such as pie slices

Data labels

Antoinette wants to be sure that her worksheet does not contain any duplicates. She will use the highlight cells rule _____ to check for this.

Duplicate Values

According to the order of operation in Excel:

Excel performs exponentiation, then multiplication and division, then addition, and subtraction.

____ is the amount added to the prinicpal of a loan by the lender.

Interest

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

Logical

______ functions find values in tables of data and insert them in another location in the worksheet such as cells or in formulas.

Lookup

The ____ function returns the maximum value in the range.

MAX

____ references are seldom used other than when creating tables of calculated values such as a multiplication table in which the values of the formula or function can be found in the initial rows and columns of the table.

Mixed

The ____ dialog box provides options for moving charts between worksheets and chart sheets.

Move Chart

In the Format Cells dialog box, the _____ tab allows you to format currency by choosing decimal places, comma separators, and regular number displays.

Number

Setting the _____ to A1:L10 will print only data in those cells.

Print Area

The Format Cells dialog box tab that provides options for locking or hiding cells to prevent other users from modifying their contents is _____.

Protection

In ____, the ribbon increases in height, the buttons are bigger, and more space appears around each button so you can more easily use your finger or a stylus to tap the button you need.

Touch Mode

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

arguments

The characters +, -, *, and / are examples of ____.

arithmetic operators

As a general rule, you should _____.

center column titles, left-align text, and right-align numbers

Placing a chart in a ____ displays only the chart and no worksheet cells.

chart sheet

The _______ displays the data series in separate columns side-by-side so that you can compare the relative heights of the columns in the three series.

clustered column chart

Each range is identified with a range reference that includes the cell reference of the upper-left cell of the rectangular block and the cell reference of the lower-right cell separated by a ____.

colon

Excel makes reading formulas simpler by ____ each cell reference in the formula and its corresponding cell in the worksheet.

color coding

"AZ" is an example of a ____.

column heading

Using the AutoFill Options button, the Fill Without Formatting option copies the ____ but not the formatting.

content

If an optional argument is not included, Excel assumes a(n) ____ value for it.

default

When combination charts have data series with vastly different values, you can create ____ charts.

dual axis

Header and footer elements such as worksheet name, current date, and time are _____ elements.

dynamic

Which of the following takes precedence over multiplication?

exponentiation

PMT(rate, nper, pv [, fv=0] [, type=0]) In the figure above, pv stands for the ____.

present value of the loan

When you insert a new column, the existing columns are shifted to the ____ and the new column has the same width as the column directly to its left

right

A _____ indicates a manual page break.

solid blue line

The advantage of an electronic ____ is that the content can be easily edited and updated to reflect changing financial conditions.

spreedsheet

Fonts, colors, and cell styles are organized in _____ categories.

theme and non-theme

PMT(rate, nper, pv [, fv=0] [, type=0]) In the figure above, nper stands for the ____.

total number of payment periods

A logical function is a function that works with values that are either ____.

true or false

When using the Format Painter, double-click the Format Painter button to paste the same format multiple times and click the Format Painter again to _____.

turn it off