ITE 140 Exam 1

Which symbol does the excel use to indicate that a cell is not wide enough to display a formula or function result? * @ # -

#

Which symbol represents that a cell is an absolute cell reference in a function or formula? % & $ *

$

By default, Excel 2016 files are saved in the native Microsoft Excel Workbook file format with the following file extension ________. .xls .xlsx .xlsd .csv

.xlsx

All formulas begin with ____ = sign % sign + sign # sign

= sign

___ is a group of related data points represented by data markers. A data series A value axis The Y-axis The X-axis

A data series

Which of the following displays trends over time? A pie chart An axis What-if analysis A line chart

A line chart

What is an Excel table? A series of rows and columns that contains related data that can be managed independently from other data in a worksheet A series of rows and columns that has been assigned a name and can be used in a formula or function A series of rows and columns that contain related data located on a minimum of two worksheets A series of rows and columns on a separate worksheet that can be managed independently from other data in a worksheet

A series of rows and columns that contains related data that can be managed independently from other data in a worksheet

What is a summary sheet? A sheet with two panes: one with the data, the other with the summary A worksheet where totals from other worksheets are displayed A worksheet with data on the left side and the summary on the right A worksheet with sheet names, sheet information, and sheet locations of all other worksheets

A worksheet where totals from other worksheets are displayed

A(n) ___ refers to a cell by its fixed position in the worksheet Relative cell reference Absolute cell reference 3-D cell reference data marker

Absolute cell reference

If you want every one of the comparison criteria that you specify to be true, you would use the ________. Or comparison operator Equals operator And comparison operator Less than operator

And comparison operator

To tile multiple open worksheets on the screen, use the ________ command. Rearrange Split Go To Arrange All

Arrange All

____ is the process of examining a worksheet for errors in formulas. Segmenting Tracing Defining Auditing

Auditing

Which of the following is NOT a way to create a formula? By typing By using the point-and-click technique By using a function button located on the ribbon By using a Function button on the status bar

By using a Function button on the status bar

Which of the following file formats is commonly used to import data into a database program? MDB CSV TBL DOC

CSV

Apply styles to cells, such as Headings and Titles and Data and Model, by using the ___ command in the styles group. Cell Styles Conditional formatting Format as Table Merge Styles

Cell Styles

A chart and all of its elements is known as the _____. Chart sheet Chart area plot area axis

Chart area

The COUNT function counts the number of cells in a range that ____. Contain a number or text Contain a number Contain text Match a given value

Contain a number

Hold down the ________ key to select nonadjacent cells. Spacebar Ctrl Alt F2

Ctrl

Use the ___ key to select A5:A8 and D5:D8 Alt Shift $ Ctrl

Ctrl

Which of the following is NOT a way to insert the SUM function into a cell? Alt + = Insert the AutoSum function from the home tab Insert the AutoSum function from the Formulas tab Ctrl + =

Ctrl + =

What is the keyboard shortcut for flash fill? Alt + E Ctrl + E Ctrl + F Ctrl + F2

Ctrl + E

The keyboard shortcut to display Print Preview is ______ Alt + F2 F2 Ctrl + F2 F3

Ctrl + F2

A range of cells that show how changing certain values in your formula affects the results of those formulas and that makes it easy to calculate multiple versions in one operation is a(n) ___. Data table Column Row Array

Data table

A technique to improve accuracy when entering data in a worksheet by controlling the type of data or the values that can be entered is called ___. Goal Seek Data validation Data protection What-if Analysis

Data validation

A word or string of characteres in Excel represents a cell, a range of cells, a formula, or a constant value is called a ___. Cell range Table Array Validation list Defined name

Defined name

Each of the following is a rule for defining names except: The letters C or R cannot be defined as a name The first character of a name must be a letter, underscore, or backslash Defined names can contain spaces a defined name can be no longer than 255 characters

Defined names can contain spaces

When formatting a worksheet to be printed, ____ show where page breaks are located. Red lines Blue lines A solid bold line Dotted lines

Dotted lines

The _____ command checks for common errors that occur using formulas. Hide Error Audit Error Checking Seek Error

Error Checking

How do banded rows display? Even rows are formatted differently from odd rows Even rows are bolded; odd rows are not with a solid border around each row Even rows have a different background and font color that do odd rows

Even rows are formatted differently from odd rows

Which of the following are some frequently and commonly used file formats for Excel? Bitmap or JPEG MDB or PDF Excel Template, Excel 97-2003 Workbook, CSV or tab delimited TXT or DOC

Excel Template, Excel 97-2003 Workbook, CSV or tab delimited

Which of the following is the second order of operations? Multiplication Division Expressions within parentheses Exponentiation

Exponentiation

Which of the following is the first order of operations? Multiplication Division Expressions within parentheses Exponentiation

Expressions within parentheses

The quickest way to repeat an action in Excel is the ____ function key F2 F4 F6 F11

F4

______ is the keyboard shortcut for the spelling command. F1 F2 F7 F12

F7

A ________ is a single piece of information that is stored in every record. field value database query

Field

To display the document properties, click the _____ tab. Design Home Page layout File

File

Which of the following excel features recognizes a pattern in the data of a worksheet? Find and Replace Flash Fill IF Function CUUNTIF Function

Flash Fill

What are the two contextual tabs that display under Chart Tools when a chart is selected? Insert and Format Format and Design Insert and Design Home and Design

Format and Design

the default number format for cells is the _____ number format General Currency Comma style Accounting number

General

Which of the following is a default number format in Excel 2016? General Format, Calibri, 11 pt Decimal format, Calibri, 11 pt General format, times new roman, 12pt General format, Cambria, 12 pt

General Format, Calibri, 11 pt

A method to find a specific value for a cell by adjusting the value of one other cell is ___. Lookup Protection Goal Seek Validation

Goal Seek

___ is an Excel tool that finds the input needed to arrive at a desired result. Goal Seek Formula AutoComplete A what-if analysis A bevel

Goal Seek

A ___ triangle in the upper left corner of a cell indicated that the formula in the cell is suspect for some reason and could be a potential error. Orange Green Red Blue

Green

The ___ function looks up values in the table array arranged in horizontal rows. VLOOKUP MATCH LOOKUP HLOOKUP

HLOOKUP

Which of the following is NOT one of the three spatial dimensions of 3-D? Depth Length Width Height

Height

Which of the following is FALSE about a workbook? It can contain only one workbook It contains one or more worksheet It contains pages called worksheets It contains one or more worksheets with a series of cells

It can contain only one workbook

How can you identify the chart elements button when you select a chart? It is a green plus sign It looks like a funnel It looks like a paintbrush It is a percent sign

It is a green plus sign

When you print a chart sheet, how is it automatically formatted? It is left-aligned on the page It is right-aligned on the page It is centered on the page It has a default footer and page number

It is centered on the page

Which of the following is FALSE about the NOW functon? It updates each time the workbook is opened. It is a volatile function It remains constant even when the workbook is opened. It uses the computer's calendar and clock to display the date and time

It remains constant even when the workbook is opened.

Which of the following is TRUE about a pie chart? It shows the relationship of each part to a whole It displays data that is arranged in one or more columns or rows or data A pie chart has a minimum of three data series A pie chart should be your first choice when there are two data series to plot

It shows the relationship of each part to a whole

____ functions look up a value in a defined range of cells located in another part of the workbook to find a corresponding value. Financial Lookup Statistical Logical

Lookup

Where do sheet tabs display in a workbook? Under the ribbon On the status bar Lower area of the workbook window On the right side of the workbook window

Lower area of the workbook window

Which of the following is NOT one of the default calculations displayed by AutoCalculate? Sum Average Maximum Count

Maximum

Which of the following does not display to the right side of a selected chart? Chart style button Chart filters button Chart elements button Move chart button

Move chart button

Where is the Format Painter button located? On the mini toolbar and the Design tab On the mini toolbar and the Pay Layout tab On the Home tab and the Page Layout tab On the mini toolbar and the Home tab

On the mini toolbar and the Home tab

In a cell that contains a function, to copy the VALUE to another to cell - rather than the function - use the ___. Paste command Format painter command Paste special command to display commands for paste values Paste Link command

Paste special command to display commands for paste values

____ cells are cells that are referred to by a formula in another cell Dependent Precedent Trace Related

Precedent

The total amount that a series of future payments is worth is called the ___. principal percentage interest rate

Principal

in a large worksheet, which two excel commands help to make the worksheets attractive and easier to read? Print Titles and Scale to Fit Print Titles and Summary sheet Detail sheet and summary sheet Print Titles and Conditional format

Print Titles and Scale to Fit

to rotate text in a worksheet, in the Format Cells dialog box, you can click and drag the ____. Red circle Blue diamond Red diamond Black, bold triangle

Red diamond

____ is a procedure that determines which digit to the right of a number will be the last to be displayed. Rounding An absolute cell reference A constant value Cell addressing

Rounding

How do you know if some rows of a table have been hidden from view when a filter is invoked? Row numbers display in red Row numbers are bolded Row numbers display in blue A number pertaining the number of hidden rows displays next to the funnel icon

Row numbers display in blue

In the Data validation dialog box, you can create a ___ that will display when the cell is selected and that provides instructions to the person entering data. defined name ScreenTip cell reference table array

ScreenTip

All of the following are methods to define a name for a cell or group of cells except: ____. Select the range, open name manager, click New, and them type the name Select the range, click in the formula bar, and then type the name Select the range, click in the Name box,and then type the name Select the range, click the Define Name button, and then type the name

Select the range, click in the formula bar, and then type the name

In Goal Seek, the ___ box contains the formula that calculates the information you seek. To value Set cell By changing cell Goal Seek dialog

Set cell

What are the default names of worksheets? Sheet1, Sheet2, etc. Workshhet1, Worksheet2, etc. Excel 1, Excel 2, etc. 1,2,3, etc.

Sheet1, Sheet2, etc.

To size a chart proportionately, hold down the ___ key and ___. Ctrl; drag a corner sizing handle Shift; drag a left or right sizing handle Shift; drag a top or bottom sizing handle Shift; drag a corner sizing handle

Shift; drag a corner sizing handle

When using a touchscreen, which of the following actions is the same as clicking an item? Slide right Tap the Item Press and hold for a few seconds Touch the item with two fingers

Tap the Item

Which of the following is FALSE about worksheet tabs? You can change the color of worksheet tabs You can rename a tab by double-clicking on it The active worksheet tab displays in red font A worksheet tab can be copied

The active worksheet tab displays in red font

Where does Excel's NOW function retrieve the data from? The internet The Excel program The computers clock The office 2016 suite

The computers clock

On your keyboard, which two symbols function identically in data formats? The forward slash key and the period The dollar sign and the ampersand The comma and the forward slash key The hyphen key and the forward slash key

The hyphen key and the forward slash key

The MEDIAN function finds _____. The average value in a range of cells The middle value in a range of cells All numbers that correspond to an argument in the function The one number that corresponds to an argument in the function

The middle value in a range of cells

If you edit in a worksheet that is associated with a pie chart ____. The pie slices must be manually updated An error message will display The pie slices will be automatically updated A new, second pie chart must be created

The pie slices will be automatically updated

The COUNTIF function has two arguments _____. The range of cells to check and the criteria The range of cells to check and the sum of the range a value as the criteria and an average of a range of cells the range of cells to sum the criteria

The range of cells to check and the criteria

What does a data bar in a cell represent? The value of a cell relative to other cells The value in a range of cells The values of the two cells to the left of the cell with the data bar The sum of the values above the data bar cell

The value of a cell relative to other cells

In a line chart, which of the following resides along the bottom of the chart? The x-axis The plot area The y-axis The legend

The x-axis

Which of the following resides along the left side of a column chart? The x-axis The plot area The y-axis the legend

The y-axis

In Goal Seek, you enter the specific value that you want to achieve in the _____ box. To value Set cell By changing cell Goal Seek dialog

To value

Use the ___ command to locate and resolve an error in a formula. Find Error Locate Error Trace Error Fix Error

Trace Error

A command that displays arrows to indicate what cells affect the value of the cell that is selected is the ___. Trace Dependents command Trace Precedents command Trace Error command Tracer command

Trace Precedents command

____ displays arrows that indicate what cells are affected by the value of the currently selected cell. Trace dependents command Trace Precedents command Tracer Arrow Trace Error Trace Error command

Trace dependents command

You must select ___ on a worksheet to create a pie chart. One range Two ranges At least three ranges Four or more ranges

Two ranges

Sheet tab names are ________ when they are grouped. Underlined Bolded Italicized In red

Underlined

To what extent can a pie chart be rotated? Up to 360 degrees Up to 180 degrees Up to 90 degrees Up to 45 degrees

Up to 360 degrees

An excel function that looks up values in a table array arranged as verticle columns is the ___ function. COLUMN VLOOKUP HLOOKUP MATCH

VLOOKUP

When preparing a document for printing, a _____ indicated that only the columns to the left will be printed on the first page. Vertical dotted line between columns vertical bolded, black line between columns horizontal bolded line between rows vertical red, bold line between columns

Vertical dotted line between columns

What is a pane bounded by? A solid red line Vertical or horizontal bars The status bar The ribbon

Vertical or horizontal bars

Using various interest rates to determine the amount of loan payments is an example of using ___. What-If Analysis Protection Validation Lookup

What-If Analysis

The process of changing the values in cells to see how those changes affect the outcome formulas in a worksheet is called ____. Goal Seek What-if Analysis Lookup Validation

What-if Analysis

The process of changing cells in a worksheet to see how those changes affect the outcome of formulas is known as ___. Goal Seek What-if analysis General fund analysis Relative cell reference

What-if analysis

If a sheet tab has ___ you know that it is not selected a dotted background a background color a bolded border a red border

a background color

When a cell is part of an active formula, it is surrounded with ________. a colored border with small boxes on each side a colored background with small circles on each corner a bold, black border with small circles on each side a white border with small boxes on each corner

a colored border with small boxes on each side

A chart value that originates in a worksheet cell is referred to as ______ a data point a data marker a data series the x-axis

a data point

For lookup functions to work properly, the data in the table array must be sorted ___. by color in reverse alphabetical order in descending order in ascending order

an ascending order

A defined set of formatting characteristics such as font, font size, and font color are known as a ____ label theme cell style series

cell style

The ____ is the temporary storage location for cell contents copied from a worksheet. Clipboard Office Pane Paste area Excel tabel

clipboard

Saving an Excel worksheet as a CSV file separates the cells of each row with ________. quotes commas periods tabs

commas

The <,> and <> can be described as ______ Logical tests comparison operators criteria arguments

comparison operators

To apply complex criteria to a single column, use a(n) ________. advanced filter autofilter custom filter extracting filter

custom filter

A defined name provides a logical reference to ___. data tables functions formulas

data

A ____ in a pie chart identifies the pie slices. data series data label data marker data point

data label

Subtotaled rows that are totaled and summarized are referred to as ________ data. Summary subtotal actual detail

detail

A data table is useful for all of the following except for ___. calculating possible values for each argument viewing and comparing results determining the Future Value (Fv) calculating multiple versions in one operation

determining the Future Value (Fv)

The first step in adding subtotals to a group or list is to sort the data by the ________ for which you want to create a subtotal. query list field block

field

You can create a custom table style by clicking ________. table designs cell styles format as table table elements

format as table

An advantage to naming a range of cells is that you can use the name in a ___. data table formula table array lookup table

formula

Scaling reduces the ________ size of the printed data by a percentage or by the number of pages you specify. page and worksheet horizontal and vertical logical and proportionate column and row

horizontal and vertical

Where is the fill handle located? in the top right of an active cell in the lower right corner of a selected cell in the quick access toolbar on the home tab

in the lower right corner of a selected cell

The amount charged for the use of borrowed money is called ___. capital interest Present value (Pv) principal

interest

A text value in Excel is also referred to as a ___ label Formula Constant Cell address

label

When you type text in a cell it is ____ right aligned fully justified left aligned centered

left aligned

A series of rows that contains related data is known as a ________. list record block query

list

The defined table range will automatically display as the ________ range in the Advanced Filter dialog box. criteria list conditional action

list

Fonts are associated with different themes and can be customized by ________. clicking in the default themes option using the predefined themes that come with Office 2016 mixing Colors and Fonts from any of the supplied themes using Live Preview

mixing Colors and Fonts from any of the supplied themes

In Excel 2016, row heading are identified by _____ uppercase letters lowercase letters roman numerals numbers

numbers

In the Excel window, where does [Group] display when worksheets are grouped On the status bar On the ribbon On the title bar On the sheet tab

on the title bar

To see how different interest rates affect a monthly payment, use a ___. two-variable data table one-variable data table defined name table array

one-variable data table

Cells that are referred to by a formula in another cell are called ___. dependent cells precedent cells trace dependents trace precedents

precedent cells

Using a touchscreen, which of the following actions is the same as right-clicking the mouse? slide right slide right and the press press and hold for a few seconds touch the screen with two fingers

press and hold for a few seconds

In the Excel PMT function, the term used to indicate teh interest rate for a loan is called ____. Present value (Pv) rate Future value (Fv) payment period

rate

Which of the following describes all of the categories of data pertaining to one person, place, thing, event, or idea within a table row? database query field record

record

Excel's Formula Auditing features can show ____ between cells and formulas to ensure that formulas are logical and correct and also to resolve error messages. relationships links pathways sequences

relationships

The location within which a defined name is recognized without qualification is refereed to as the ___. table array cell range formula scope

scope

The outline bar along the left side of a worksheet enables you to ________ levels of detail with a single mouse click. paste and close copy and open show and hide copy and paste

show and hide

Tiny charts embedded in a cell that display a visual trend summary alongside your data are called _______ Sparklines Data labels Data series Data markers

sparklines

the ______ displays the current cell mode, the page number, and the zoom buttons. ribbon status bar formula bar quick access toolbar

status bar

Saving an Excel worksheet as a ________ separates the cells of each row with tab characters. macro template comma separated value tab delimited text file

tab delimited text file

In a lookup formula, the defined range is a referred to as the ____. table array named range validation list defined name

table array

When you type data in a cell and press Enter, what cell becomes the active cell? The cell to the right the cell below the cell above the insertion point does not move

the cell below

Which of the following is NOT part of the accounting number format? A fixed dollar sign aligned at the left edge of the cell a thousand comma seperator small amount of space at the right edge of the cell three decimal places

three decimal places

An indicator that shows the relationship between the active cell and its related cell is called a(n) ___. tracer arrow tracking arrow error triangle error diamond

tracer arrow

Comma Style format displays a number with ___ two decimal places a dollar sign and two decimal places three decimal places no decimal places

two decimal places

To see how different interest rates and different payment periods affect a monthly payment, use a ___. two-variable data table one-variable data table defined name table array

two-variable data table

Defined names can contain ___. uppercase and lowercase letters with spaces the letter C by itself the same value as a cell reference, such as M$10 uppercase and lowercase letters

uppercase and lowercase letters

A ___ is a list of values that are acceptable for a range of cells. table array data table validation list cell range

validation list

AutoFill will fill a series when you establish a pattern ___. with two of more cells with a minimum of three cells through the use of a formula through the use of a function

with two of more cells

the value axis is also known as the ______ x-axis y-axis category axis legend

y-axis

The Error Checking button displays as a ____. purple arrow blue circle red square yellow diamond

yellow diamond

The future value (Fv) at the end of the time period in an Excel function is usually ___ for loans. twice the principal zero half the principal the same as the principal

zero

the percent style button formats selected cells as a percentage with ____ zero decimal places one decimal place two decimal places three decimal places

zero decimal places