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
