BUSA Excel

The PMT function calculates the payment required in each period to pay back the loan. T or F

True

You can move a chart from one worksheet to another, or you can place the chart in its own chart sheet. T or F

True

The sheets in a workbook are identified in the sheet tabs at the top of the workbook window. T or F

False

17

Font size box

In the formula =IF(A1=B1, C1, C2), the result will be C2 if ____.

A1 does not equal B1

To display the current date and time, which is updated each time the workbook is reopened, use the TODAY function.

False

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

Excel supports all of the following types of sparklines EXCEPT ____.

a true/false sparkline for help making decisions

In the following formula: =IF(A1="YES", "DONE", "RESTART"), what happens if A1= "NO"? a) The formula returns the text "RESTART". b) The formula returns the text "DONE". c) The formula returns the text "NO". d) The formula returns the text "NO, RESTART".

a) The formula returns the text "RESTART".

The intersection of a row and column is known as a ____. a) cell b) range c) reference d) border

a) cell

What type of operation does the formula "C9/B10" use a) division b) multiplication c) fraction d) exponentiation

a) division

Use ____ references when you want different formulas to refer to the same cell.

absolute

23

alignment buttons

10

cell H13

To display a large number of categories whose values are close to one another, you should create a ____ chart. a) column b) bar c) pie d) either a. or b.

d) either a. or b.

Case-Based Critical Thinking Questions Case 2 Anya has just surveyed 100 reviewers to get their reaction to a new marketing ad campaign she is heading. She has one data series that she wants to represent graphically, and she needs to display her data in a way that keeps the percent of the whole data in mind when viewing. Since it's important for Anya to keep percentages of her whole reviewer base in mind, she wants to represent data as parts of a whole. What chart type would you suggest to Anya? a) bar b) column c) scatter d) pie

d) pie

Italic, bold, bold italic, and underline are examples of _____.

font styles

9

formula bar

Another name for the middle value is the ____ value.

median

Because Excel stores dates and times as _____, you can apply different formats without affecting the date and time value.

numbers

To change the order of operations, enclose part of the formula in ____.

parentheses

In ____ orientation, a page is taller than it is wide.

portrait

In Excel, dates are _____-aligned in the cell by default, regardless of date format.

right

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

Setting the _____ to A1:L10 will print only data in those cells.

Print Area

A column chart turned on its side is called a bar chart, with the length of the bar determined by the data value. T or F

True

21

borders added above and below cell content

The characters +, -, *, and / are examples of ____. a) formulas b) values c) arithmetic operators d) calculations

c) arithmetic operators

22

Indented text maybe because centered was wrong?

Cell B4 has the number 3, B5 has the number 2, and B6 has the number 4. Cell C4 has the formula =B4+B6/B5. What is the number displayed in C4? a) 11 b) 5 c) 3.5 d) 6

b) 5

In Excel, the ____ table style formats alternating columns in different colors. a) Banded Rows b) Banded Columns c) Last Column d) First Column

b) Banded Columns

An Excel formula always begins with a(n) ____.

equals sign

To resize an embedded chart, ____.

select the chart and drag the corner sizing handle of the selection box

The advantage of an electronic ____ is that the content can be easily edited and updated to reflect changing financial conditions.

spreadsheet

The formula used to multiply cell A1 by cell C1 is ____.

=A1*C1

33

?

52

?

53

?

57

?

Which of the following is not a date function?

AND

Which of the following is not an Excel function category?

Algebra

32

Auto Fill Options button

To change a column width, you can click ____ on the Column submenu to make the column(s) as wide as the longest entry of the cells in the column.

AutoFit

In Excel, to merge cells A1, B1, C1, D1, and E1, _____ is the correct reference for the merged cell.

B:A1

In pie charts, it's best to make the slice colors as similar as possible. T or F

False

The name of the active workbook appears in the status bar of the Excel window. T or F

False

The ____ category of Excel functions returns (true-false) values

Logical

The ____ function returns the maximum value in the range.

MAX

One way to ensure that you are using consistent formats is to copy and paste your formats using the Format _____.

Painter

In the following formula: =IF(A1="YES", "DONE", "RESTART"), what happens if A1= "NO"?

The formula returns the text "RESTART".

A conditional format can make negative numbers red and positive numbers black. T or F

True

A mixed reference "locks" one part of the cell reference while the other part can change. T or F

True

Each slice in a pie chart represents a single value from a data series. T or F

True

Every chart contains elements that can be formatted, added to the chart, or removed from the chart. T or F

True

Excel charts are either placed in their own chart sheets or embedded in a worksheet. T or F

True

The AutoComplete feature automatically completes an entry based on previous entries in a column. T or F

True

The Format Painter does not copy formatting applied to selected text within a cell, and it does not copy data. T or F

True

The IF function is a logical function that returns one value if a condition is true, and returns a different value if that condition is false. T or F

True

The formula used to multiply cell A1 by cell C1 is ____. a) =A1*C1 b) C1*A1 c) =A1/C1 d) A1*C1

a) =A1*C1

You want to create a formula in cell D10 that multiplies B10 by C10 and then subtracts A10 after it has been multiplied by A11. a) =D10*(C10-A10)*A11 b) =A10*A11-B10*C10 c) =B10*C10-A10*A11 d) =B10/C10+A10*A11

c) =B10*C10-A10*A11

Given the formula =B5*B6+C3/D4^2, which expression would be evaluated first? a) B6+C3 b) B5*B6 c) D4^2 d) C3/D4

c) D4^2

Functions can be ____. a) incorporated as part of larger formulas b) placed inside another function c) either a. or b. d) neither a. nor b.

c) either a. or b.

The PMT function is a(n) ____ function. a) date b) IF c) financial d) Statistical

c) financial

Case-Based Critical Thinking Questions Case 2 Sam is a distributor of ceramics. He uses Excel 2010 to record his inventory and order forms. Sam's worksheet for his company's monthly orders needs to display summary information including total number of items ordered, and the amount of revenue generated from those orders. Sam is happy with the results of the formula. All of a sudden he realizes that the cell that once displayed the result is now displaying the formula and all of the columns are wider. He must have ____. a) switched to editing mode by double-clicking the results cell b) switched to formula view by pressing Ctrl + Alt c) switched to editing mode by pressing Ctrl + Alt d) switched to formula view by pressing Ctrl + `

d) switched to formula view by pressing Ctrl + `

Case Based Critical-Thinking Questions Case 1 Karl has been working on a field survey project where he has gathered data from across five cities in the last six months. Karl has a lot of data to report and needs help organizing his data sheet for an effective presentation. In column C, there are too many numbers after the decimal place. Karl does not need this level of detail as it is distracting from the data, and you really don't need more than two numbers after the decimal. How could Karl make the data appear cleaner? a) reenter all numbers b) decrease column width c) decrease font size d) use Number group to decrease number of digits displayed

d) use Number group to decrease number of digits displayed

Absolute references are marked with a ____.

$

Case-Based Critical Thinking Questions Case 2 Anya has just surveyed 100 reviewers to get their reaction to a new marketing ad campaign she is heading. She has one data series that she wants to represent graphically, and she needs to display her data in a way that keeps the percent of the whole data in mind when viewing. Anya tells you that she is using a 3-D chart for the first time and asks if you have any advice for this chart type. You should tell Anya that it's especially important to ____ in 3-D charts. a) include data labels b) use bright colors c) use a small font d) detail the legend and title

a) include data labels

Because Excel stores dates and times as ____, you can apply different formats without affecting the date and time value. a) numbers b) text c) both a. and b. d) neither a. nor b.

a) numbers

The ____ is the only one of the following charts to compare relative values from different categories to the whole. a) pie b) column c) line d) area

a) pie

Case Based Critical Thinking Questions Case 2 Ajeesh is part of a team creating a number of files with Microsoft Office. Ajeesh is working with four other team members to create individual files for a joint presentation. Ajeesh is in charge of the Excel workbook for his team. Ajeesh has copied his data set to a new spreadsheet where he wants to draw attention to data that received above a 75% approval rating. To highlight these numbers, Ajeesh could apply ____. Correct Response a) the Greater Than rule with Conditional Formatting b) the Format Painter c) a bold format to all text d) manual highlighting to each percentage

a) the Greater Than rule with Conditional Formatting

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

What is the result of the expression =50/(10*5)? a) 1/5 b) 1 c) 25 d) 50

b) 1

If cell A1 has 2, cell A2 has 7, and cell A3 has 5, what would be the answer displayed in cell B1 if it contained the formula = A1+A2*A3? a) 70 b) 37 c) 35 d) 45

b) 37

For which of the following reasons would you choose to use a chart or graph? a) To organize information in columns and rows b) To show trends or relationships across data c) To present data using text only d) To add color to a report

b) To show trends or relationships across data

The numbers, text, or cell references used by the function to return a value are called ____. a) expressions b) arguments c) data d) values

b) arguments

A ____ sheet is a worksheet that provides information about the content and purpose of the workbook. a) planning analysis b) documentation c) glossary d) precedence

b) documentation

When you copy a formula that contains an absolute reference to a new location, the reference ____. a) is updated automatically b) does not change c) becomes bold d) has a dotted outline in its cell

b) does not change

An Excel formula always begins with a(n) ____. a) parentheses b) equals sign c) plus sign d) colon

b) equals sign

Case-Based Critical Thinking Questions Case 2 Anya has just surveyed 100 reviewers to get their reaction to a new marketing ad campaign she is heading. She has one data series that she wants to represent graphically, and she needs to display her data in a way that keeps the percent of the whole data in mind when viewing. Anya needs to call attention to one category above all others. For this purpose, she should use a(n) ____. a) line chart b) exploded pie chart c) scatter chart d) banded chart

b) exploded pie chart

Which of the following takes precedence over multiplication? a) division b) exponentiation c) addition d) subtraction

b) exponentiation

Text is ____-aligned in cells. a) right b) left c) center d) justify

b) left

A table ____ applies alternating row colors to the entire Excel table and adjusts the banded rows effect as needed if you add or delete rows. a) theme b) style c) structure d) band

b) style

Case-Based Critical Thinking Questions Case 2 Sam is a distributor of ceramics. He uses Excel 2010 to record his inventory and order forms. Sam's worksheet for his company's monthly orders needs to display summary information including total number of items ordered, and the amount of revenue generated from those orders. Sam now wants to find out how much money he will make on his largest order, which is currently in row E. Cell E4 contains the number of items ordered and cell E5 contains the price per item. An appropriate formula would be ____. a) =E4+E5 b) =E5/E4 c) =E4*E5 d) =E4^E5

c) =E4*E5

Case Based Critical-Thinking Questions Case 1 Karl has been working on a field survey project where he has gathered data from across five cities in the last six months. Karl has a lot of data to report and needs help organizing his data sheet for an effective presentation. Karl cannot increase the width of his worksheet or he will not be able to print it on one sheet. However, his columns are truncating his content. What solution could Karl use for making his text visible without losing data? a) abbreviate all text b) reduce the font size to 8 pt c) click Wrap text d) delete one column

c) click Wrap text

In the above figure, the data markers shown in the cells in the column labeled "Percentages," are ____. a) data lines b) sparklines c) data bars d) spark bars https://gordonstate.view.usg.edu/content/enforced/166717-CO.760.BUSA2101.XLS.SS.20134/questioncollections/442495/nar003-1.jpg?_&d2lSessionVal=LlZbOAsl56LWbaczADa26ARiK

c) data bars

All of the following are conditional formats in Excel except ____. a) data bars b) highlighting c) font sets d) icon sets

c) font sets

Part of effective formula writing is knowing when to use relative, absolute, and ____ references. a) complex b) simple c) mixed d) matched

c) mixed

Every function has to follow ____. a) a formula b) directions c) syntax d) a format

c) syntax

Placing a chart in a ____ displays only the chart and no worksheet cells.

chart sheet

5

column heading

Critical-Thinking Case Based Questions Case 1 Andy has just started a job with the school district. His director has given him the last six months of test results from four local schools. Andy has organized the results as four data series and needs to display the trends in a graphic format. Andy has finished his chart but needs to save some space. What's the most effective way for Andy to reduce space without losing important data? a) Delete parts of the data b) Delete the legend c) Delete the title d) Overlay the legend in areas without data

d) Overlay the legend in areas without data

You are checking over your worksheet and notice that several cells display a series of pound signs (########). What is the most likely explanation? a) There is an error in one or more of your formulas. b) Your computer has caught the dreaded ####### virus. c) The cells contain circular references. d) There is not enough room to display the contents of the cell.

d) There is not enough room to display the contents of the cell.

Excel supports the following three types of sparklines that does NOT include ____. a) A win/loss sparkline for highlighting positive and negative values b) A column sparkline used for column charts c) A line sparkline for highlighting trends d) a true/false sparkline for helping make decisions

d) a true/false sparkline for helping make decisions

Placing a chart in a ____ displays only the chart and no worksheet cells. a) new worksheet b) tabbed view c) graph display d) chart sheet

d) chart sheet

When you copy a formula that contains an absolute reference to a new location, the reference ____.

does not change