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