ISMG Exam #1
A scatter chart shows the relationship between two numeric variables
True
Click outside a chart object or press Esc to deselect an object
True
The TRIM function returns text from which Amy leading, trailing, or extra spaces between words have been removed
True
A chart element can be easily removed by selecting the element and pressing ___
Delete
It is fairly simple to create a perfect chart the first time you create it
False
The dollar sign ($) and comma (,) are stored as part of a numeric cell value
False
Names for ranges CANNOT begin with a(n) ___
Number
The Merge and Center button is located in the ___ tab
Alignment group on the Home
To insert a line break or hard return in a cell, you would press ___
Alt + Enter
A(n) ___ chart is a variation of a stacked line chart that emphasizes the magnitude of change over time and visually depicts a trend
Area
The inputs used by an Excel function to calculate a result are called ___
Arguments
The file extension for Microsoft excel 2016 workbook is ___
.xlsx
The result of =CONCATENATE("12", "34") is ____
1234
All of the following are valid cell ranges EXCEPT:
12E
Excel has more than ___functions organized I to several categories
400
There are ___ types of cell alignment in Excel
6
Formulas and functions begin with a(n) ___ sign
=
When cell A4 containing the formula =$B$5/$C$6 is copied to cell F6, what will the formula in cell F6 look like?
=$G$7/$H$8
Which of the following is NOT a comparison operator symbol?
=/
An example of a range of cells is ___
A1:A3
The Comma Style is the ___ format without a monetary symbol
Accounting Number
The currency symbol is aligned to the left side of the cell in the ___ format
Accounting number
Which of the following is NOT a common readability issue that should be avoided when creating a chart?
Add a chart title that conveys context of time and scope
If you want to total a specified range, list of numbers, list of cells, or any combination, you would use the ____ function
SUM
A ___ chart is wet common as a statistical tool depicting the correlation between the two variables
Scatter
To have a better sense of how the worksheet is structured, you can ___
Show the formulas
___ are small charts that are embedded into the cells in a worksheet
Spark lines
A ___ application is a computer program has a user interface comprised of a grid of rows and columns
Spreadsheet
Which if the following I get data types is NOT automatically right aligned by Excel?
Text
If you click ___, the insertion point is displayed in the formula bar
The Home tab
Headers and footers contain ___ section(s)
Three
A ___ is a line that shows the direction of the data
Trend line
A chart is like a picture, where a picture is worth 1,000 words
True
A chart sheet is a special worksheet that is dedicated to displaying chart objects
True
A comment is added to an individual cell.
True
A destination cell is the location cell to be modified by a move or paste operation
True
A formula is a built in program that would be used to find the average of a series of numbers
True
A function is a built in program that performs operations on data
True
A legend is considered to be a chart index
True
A named range is a group of cells that have been given a name, which you can use when writing a formula or a function
True
Bar charts are similar to column charts
True
Chart sizes can be locked so they do not resize when columns or rows are resized
True
Charts are a critical component of data visualization
True
Conditional formatting v can be used to highlight information by changing v formats such as cell fill color, font color, and font style
True
Documentation is an important part of building a good worksheet
True
Excel's AVERAGE function returns the mean of a set of numbers
True
Fill color can be used to categorize information
True
Functions can be created by using the Function Arguments dialog box or by typing the function in the cell
True
If you incorrectly name a range, you can rename it by selecting the data and naming the range again
True
In a function, arguments are included inside the parentheses following the function name t
True
It is important to present a well designed chart because the chart can become a reflection on you and your company
True
Keyboard shortcuts allow rapid navigation in a worksheet without having to use the mouse
True
One of the most efficient ways of moving data from one cell to another is to drag and drop
True
Page Break Preview allows you to manually adjust the location of page breaks
True
Tables allow for calculations in a total row such as summations, averages, or counts
True
The Accounting Number format structures a cell with a comma at the thousand and two decimal places
True
The Comma Style is formatted as the Currency Style without a monetary symbol
True
The Ctrl + S shortcut quickly saves your files to the same location as the last save
True
The first task that needs to take place when creating a chart is to organize the data
True
To make rapid and accurate changes to the appearance of a workbook with very little effort, you can use built in cell styles
True
To paint a format to more than one non adjacent cell, you can double click the Format Painter and then select non adjacent cells
True
When constructing a formula, Excel's default reference type is relative cell referencing
True
You can resize a chart by clicking and dragging a sizing handle
True
Given a students numerical average and a table that lists the grades and percent needed to obtain the grades in column format, which Excel function would be used to determine the students letter grade?
VLOOKUP
The combination of the graphical presentation of data with a focus on qualitative understanding is called data___
Visualization
Which of the following is NOT true about the Accounting Number Format?
Zero values are displayed as 0 with zeros in each decimal place
____ formatting is a way to dynamically change he visual presentation of information in a manner that adds information to the worksheet
Conditional
You can select a noncontiguous range of cells by pressing and holding the ___ key when using it in combination with other navigation keys and/or the mouse
Ctrl
The keyboard shortcut to move to cell A1 is:
Ctrl + Home
The keyboard shortcut for Undo is ___
Ctrl + Z
If you want to find the time between two dates, you would use the ____ function
DATEDIF
A ___ is a graphic component that is overlaid onto the data in worksheet cells
Data bar
A group of related data values to be charted is a
Data series
A ___ is a grid of columns and rows in which data is entered
Database
A(n) ___ cell is the cell that receives the result of an operation such as Paste or an AutoSum function
Destination
An important part of building g a good worksheet is using ___
Documentation
An absolute cell reference is denoted by a(n) ___
Dollar sign ($)
You can move a worksheet within a workbook, by ___, and the dropping the worksheet to it's new location
Double clicking the worksheet tab
Formatting will change the value stored in a cell, as well as add information value
False
Merge & Center can only be applied to horizontal cell ranges
False
The AutoFill property adjusts the height of a row so that it's cell contents fit into the row
False
The COUNT function returns the total number of cells in a cell range that are blank
False
The TODAY and NOW functions return the same result
False
Which of the following is NOT true about using fill colors?
Fill color refers to the border color and style of a cell
To modify the border of a cell or cells, click the Borders button in the ___ group of the Home tab
Font
To open the format chart area task pane, right click the border, and then select ___
Format Chart Area
An example of a ____ is (C5+D5)/100
Formula
A ___ is a built in program that performs operations on data
Function
An example of a ____ is SUM(A1:A10)
Function
The lines that go across charts to help gauge the size of the bars, columns, or data lines are called ___
Grid lines
Which of the following is NOT a unit value option for the DATEDIF function?
H
To hide a row or column in Excel, click the row or column heading, point to the selected row or column heading(s), right click, and then select ___ on the displayed shirt cut menu
Hide
The ___ tool is a contextual tool That appears when you select data in a worksheet
Quick Analysis
When using a text string in an argument, enclose the string in ___ so Excel will recognize it as a text string rather than a named range
Quotes " "
A comment is indicated by the presence of a ___ in the upper right corner of a cell
Red triangle
____ can set the font, font size and colo, number format, background color, borders, and alignment
A built in cell style
A name of a range CANNOT contain any spaces
True
The intersection of a row and column is called a ___
Cell
If a numerical value is too narrow to be displayed in a cell, a series of ___ characters is displayed
#
There are how many different types of cell references?
3
A ___ chart is used to communicate trends over time
Line
A(n) ___ chart is similar to a column chart except the data is horizontal instead of vertical
Bar
Optional arguments in a function are enclosed in a pair of ___
Brackets [ ]
If you want to see how many cells in a specified range contain numbers, you would use the ___ function
COUNT
If you wanted to determine how many cells in a range are not empty, you would use the ___ function
COUNTA
The process of removing unwanted characters, rearranging data in a cell, or corrections b erroneous data in text is called ____
Cleansing
A(n) ___ chart is useful for comparing data sets that are categorized
Column
A(n) ___ chart displays two different types of data by using multiple chart types in a single chart object
Combination
If the value in B4=40, what is the result of =IF(B4>65, "Passing", "Failing")?
Failing
=$B$2 - C5 is an example of mixed cell referencing
False
A cell reference is a combination of a row number followed by a column letter such as 12C
False
A chart sheet contains gridlines
False
A column chart is a quantitative E chart that shows growth or change in totals
False
A function is a equation that produces a result and may contain numbers, operators, text, and/or functions
False
A line chart is used to display a percent to a whole
False
A non contiguous cell range consists of multiple cells where all cells are directly adjacent to each other
False
A pie chart shows trends over time
False
Absolute cell reference b uses the # symbol
False
Excel's RANDBETWEEN function returns a random number from 0 to less than 1
False
The ___ is an index within a chart that provides information about the data
Legend
If you want to see which employee has the highest sale, you could use the ___ function
MAX
Which of the following functions returns the number in the middle of a set of numbers?
MEDIAN
If a chart is placed on a special worksheet that is dedicated to displaying chart objects, it is ____
On a chart sheet
All arguments in a function are enclosed in a pair of ___
Parentheses ( )
A ___ chart is generally used for showing the relationship of the parts to the whole
Pie
The default print range in Excel is___
Print Active Sheets
