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