Excel Exam 1

What is the result of the expression =50+20/10*5?

60

Which of the following is not a comparison operator? ____

<<

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

=A1*C1

What is the syntax for a SUM formula adding the values of cell F6 to F9?

=SUM(F6:F9)

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

A does not equal B

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

A1

Which of the following is not a date function? ____

AND

Case Based Critical Thinking Questions ​ Case 2-2 Antoinette is part of a college department creating a number of student files with Microsoft Excel. She is working on a student retention project and wants to produce a worksheet that can alert faculty of student progress and current grade status. ​ ​ Each worksheet will contain a specific class with the students' grades for the entire term. In order to determine the current student grade, Antoinette would have to use the _____ function.

AVERAGE

Which of the following is a Statistical function? _____

AVERAGE

If you want to create a new line within a cell, press the ____ keys to move the insertion point to the next line within the cell.

Alt+Enter

____ makes it easier to enter repetitive text in cells.

AutoComplete

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

To add and remove chart elements, you can use the Add Chart Element button in the Charts Layout group on the ____ tab.

CHART TOOLS DESIGN

Which function counts how many cells in a range contain numbers, where value1, value2, and so forth are text, numbers, or cell references?

COUNT

You can move to the previous or next sheet by pressing the ____ keys.

Ctrl + Page Up or Ctrl + Page Down

To make A1 the active cell, you should press which of the following keys?

Ctrl+Home

Whenever you click the Save button on the Quick Access Toolbar or press the ____ keys, the workbook file is updated to reflect the latest content.

Ctrl+S

The ____ CHART TOOLS contextual tabs appear on the Ribbon when you select a chart.

DESIGN and FORMAT

According to the order of operation in Excel:

Excel performs exponentiation, then multiplication and division, then addition, and subtraction.

Critical-Thinking Case Based Questions ​ Case 4-1 Simon has just started a job with the police department. His director has given him the last six months of test results from four local precincts. Simon has organized the results as four data series and needs to display the trends in a graphic format. ​ ​ Simon wants to change the chart's border. To do this, he should select the CHART TOOLS ____ tab.

FORMAT

Using AutoFill, what would be the extended series of the initial entry Jan? ___

Feb,Mar,Apr

Excel functions are organized into ____ categories.

13

An Excel worksheet can have a maximum of ____ columns in a worksheet.

16,384

To move or copy a range of cells, select the correct order: 1. Move the pointer over the border of the selection until the pointer changes shape. 2. Select the cell or range you want to move or copy. 3. To move the range, click the border and drag the selection to a new location, or to copy the range, hold down the Ctrl key and drag the selection to a new location.

2,1,3

The ____ function returns the maximum value in the range.

MAX

Which of the following shows the correct order of steps for adding a data series to a chart?

Select the chart, Click the Select Data button, Click the Add button, Select the range

To move the active cell up one row, press ____.

Shift+Enter

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

The formula returns the text "RESTART".

Case-Based Critical Thinking Questions ​ Case 3-1 Ellen is a recent college graduate. She has decided to open a T-Shirt business and would like to create budget worksheet using Microsoft Excel 2016. She need to keep track of her expenses and income for the year. ​ ​ Ellen opens Excel 2016 and enters her monthly income for one year beginning with January. To create a series of months, she can ____.

Type January in cell A1 and then drag the fill handle.

=IF(G22="x", SUM(H22:J22), " ") with display ______ if G22 is not equal to "x".

a blank cell

mm/dd/yyyy is known as ____.

a date format

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

a true/false sparkline for help making decisions

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

absolute

Case-Based Critical Thinking Questions ​ Case 3-1 Ellen is a recent college graduate. She has decided to open a T-Shirt business and would like to create budget worksheet using Microsoft Excel 2016. She need to keep track of her expenses and income for the year. ​ ​ Ellen has entered all of her monthly expenses. She needs to create a formula that will deduct her monthly expenses from her monthly income. Since her monthly income is the same amount each month, she uses a(n)____ to identify the cell containing the income value.

absolute reference

Which of the following is not an Excel function category? ____

algebra

When you copy a selection of cells using drag and drop, which appears before you release the mouse button?

an outline of the new location of the selected range

The numbers, text, or cell references used by the function to return a value are called ____.

arguments

The characters +, -, *, and / are examples of ____.

arithmetic operations

The Format Cells dialog box has six tabs, including _____.

border

In "SUM(number1 [, number2, number3, ...])", number 1, number 2, and number 3 may be numbers or ____.

cell references

As a general rule, you should _____.

center column titles, left-align text, and right-align numbers

You already created a line chart, but now decide that you want to change this chart to a pie chart. To do this, you click ____ from the Type group in the Chart Tools Design tab.

change chart type

To reposition the legend to the left-hand side of a chart, click the _________ button, point to Legend, click the right arrow icon, and click Left.

chart elements

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

chart sheet

Case Based Critical-Thinking Questions ​ Case 2-1 Harold has been working as a real estate agent. He has a lot of housing data to report and needs help organizing his data sheet for an effective presentation. ​ ​ Harold cannot increase the width of his worksheet because, if he does, he will not be able to print it on one sheet. However, his columns are truncating his content. What solution would be the best for Harold to use to make all his text visible without losing data?

choose Wrap text for the columns

The _______ displays the data series in separate columns side-by-side so that you can compare the relative heights of the columns in the three series.

clustered column chart

Each range is identified with a range reference that includes the cell reference of the upper-left cell of the rectangular block and the cell reference of the lower-right cell separated by a ____.

colon

Excel makes reading formulas simpler by ____ each cell reference in the formula and its corresponding cell in the worksheet.

color coding

"AZ" is an example of a ____.

column heading

Case Based Critical Thinking Questions ​ Case 2-2 Antoinette is part of a college department creating a number of student files with Microsoft Excel. She is working on a student retention project and wants to produce a worksheet that can alert faculty of student progress and current grade status. ​ ​ Antoinette's workbook has all the data entered and students' current grades displayed. She would like the current grade cells to display the value in red if it is less than 60. Antoinette needs to add _____ to the cell.

conditional formatting

Using the AutoFill Options button, the Fill Without Formatting option copies the ____ but not the formatting.

content

The fill handle copies ____.

content and formats

_____ are an example of conditional formats in Excel.

data bars

____provide descriptive text for the individual data markers, such as pie slices

data labels

A ________ contains the actual values that are plotted on the chart.

data series

If an optional argument is not included, Excel assumes a(n) ____ value for it.

default

To format an individual sparkline, select the sparkline you want to format, and then click the Ungroup button in the Group group on the SPARKLINE TOOLS ____ tab.

design

Case-Based Critical Thinking Questions ​ Case 4-2 Mya has just surveyed 100 students to get their reaction to a new textbook she is reviewing. She has one data series that she wants to represent graphically, and she needs to display her data in a way that lets her visually compate the data values and see how much contributes to the whole. ​ ​ Since Mya is still reviewing her data, she wants to make sure that her chart reflects any changes she makes in her data source. She should ____.

do nothing since charts in Excel remain linked to data sources

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

does not change

When combination charts have data series with vastly different values, you can create ____ charts.

dual axis

Header and footer elements such as worksheet name, current date, and time are _____ elements.

dynamic

To switch to ____ mode, you double-click the cell.

edit

Category values are usually located in the ____ of the data source.

either a or b

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

equals sign

Case-Based Critical Thinking Questions ​ Case 4-2 Mya has just surveyed 100 students to get their reaction to a new textbook she is reviewing. She has one data series that she wants to represent graphically, and she needs to display her data in a way that lets her visually compate the data values and see how much contributes to the whole. ​ ​ Mya needs to call attention to one category above all others. For this purpose, she should use a(n) ____.

exploded pie chart

To move one slice of a pie chart away from the pie creates a(n) ____.

exploded pie chart

Which of the following takes precedence over multiplication?

exponentiation

A color bar is a conditional format that adds a horizontal bar to the background of a cell containing a numeric value. _________________________ (T/F)

false

A footer appears at the top of each printed page. _________________________ (T/F)

false

A formula is written using operands that combine different values, resulting in a single value that is then displayed in the cell. (T/F)

false

A theme is a collection of formatting options that include a specified font, font size, font styles, font color, fill color, and borders. _________________________ (T/F)

false

A trial-and-error method lets you explore the impact that changing input values has on the calculated values in the workbook. _________________________ (T/F)

false

An error value indicates that some part of a function is preventing Excel from returning a calculated value. ________________ (T/F)

false

By default, AutoFill copies only the content not the formatting of the original range to the selected range. _______________ (T/F)

false

By default, Excel sets the page margins to 0.5 on the left and right margins and 0.75 on the top and bottom margin. _________________________ (T/F)

false

Column width is expressed in terms of the number of characters a column can contain or the size of the column in points. (T/F)

false

Combination charts enable you to show three sets of data using the chart type that is best for each data set. _________________________ (T/F)

false

Excel organizes fonts into theme and non-theme fonts. _________________________ (T/F)

false

Functions are organized in the Function Library group on the FORMULAS tab. _______________ (T/F)

false

In pie charts, it's best to make the slice colors as similar as possible. ___________ (T/F)

false

Interest is the amount of money being loaned. ___________ (T/F)

false

Line charts are best suited for representing data that follows some nonsequential order. ___________ (T/F)

false

Normal view shows how the worksheet will appear when printed. (T/F)

false

Optional arguments are always placed first in the argument list. _______________ (T/F)

false

Page Break Preview identifies manual page breaks with a dotted blue line and automatic page breaks with a solid blue line. _________________________ (T/F)

false

Pie charts are most effective with ten or fewer slices. _________________________ (T/F)

false

Sparklines differ from data bars in that the sparklines are always placed in the cells containing the value they represent. ___________ (T/F)

false

Speed Fill enters text based on patterns it finds in the data. (T/F)

false

Text and numbers are displayed vertically within cells. _________________________ (T/F)

false

The Fill Formatting Only option, which is the default, copies both the content and the formatting. ______________ (T/F)

false

The cell with the largest value contains a data marker that extends across the entire width of the cell, and the lengths of the other bars in the selected range are determined relative to that bar. _________________________ (T/F)

false

The name of the active workbook appears in the status bar of the Excel window. (T/F)

false

The sheet in a workbook are identified in the sheet tabs at the top of the workbook window. (T/F)

false

The statement "A1 >= B1" tests whether the value in cell A1 is lesser than or equal to the value in cell B1. _________________________ (T/F)

false

To display the current date and time, which is updated each time the workbook is reopened, use the TODAY function. _______________ (T/F)

false

When text wraps within a cell, the column width increases so that all of the text within the cell is displayed. (T/F)

false

When you insert a new row, the existing rows are shifted down and the new row has the same width as the row above it. (T/F)

false

You can quickly change the appearance of the entire chart by selecting a different chart style in the Chart Design gallery. _________________________ (T/F)

false

To add a _____ to a sheet tab, right-click a sheet tab, point to Tab Color on the shortcut menu, and then click a color.

fill color

Case-Based Critical Thinking Questions ​ Case 4-2 Mya has just surveyed 100 students to get their reaction to a new textbook she is reviewing. She has one data series that she wants to represent graphically, and she needs to display her data in a way that lets her visually compate the data values and see how much contributes to the whole. ​ ​ Sometimes Mya might want to see information on only specific slices. Rather than creating a new chart that includes only those selections, she can _____ an existing chart.

filter

The _____ command searches through the current worksheet or workbook for the content or formatting you want to locate.

find

To set a page break in Excel, select the _____.

first cell below the row where you want to insert a page break

____ enters text based on patterns it finds in the data.

flash fill

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

font style

You can open the Format Cells dialog box by right-clicking a cell or selected range, and then clicking _____ on the shortcut menu.

format cells

You can choose Center, Inside End, Outside End, or Best Fit for the data label positions in the in the ____ pane.

format data labels

In a workbook's theme, _____ colors are designated for text and background, _____ colors are used for accents and highlights, and _____ colors are used for hyperlinks.

four,six,two

The Insert Function button is in the ____ group.

function library

The FV function stands for ____.

future value

By default, numbers appear in the _____ and generally display values exactly as you type them.

general format

After you describe a function in the Search for a function box in the Insert Function dialog box, click ____.

go

To go to column A of the current row, press ____.

home

Which category of Excel functions returns information about the format, location, or contents of worksheet cells? ____

information

____ is the amount added to the prinicpal of a loan by the lender.

interest

Edward Tufte was concerned with what he termed as "chart ____," in which a proliferation of chart elements—chosen because they look "nice"—confuse and distract the reader.

junk

The header and footer sections include a _____.

left, right, and center section

The ____ identifies which data markers are associated with each data series.

legend

One of the benefits of Live Preview is that it _____.

lets you see and evaluate different formats as you develop your workbook

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

logical

______ functions find values in tables of data and insert them in another location in the worksheet such as cells or in formulas.

lookup

Critical-Thinking Case Based Questions ​ Case 4-1 Simon has just started a job with the police department. His director has given him the last six months of test results from four local precincts. Simon has organized the results as four data series and needs to display the trends in a graphic format. ​ ​ It's difficult to read the exact scale on some of Simon's data. Adding ____ would make it easier to read.

major tick marks

To avoid splitting a worksheet in awkward places, you can insert a _____ to specify a specific breaking point.

manual page break

A _____ is the space between the page content and the edges of the page.

margin

Another name for the middle value is the ____ value.

median

_____ merges each of the rows in the selected range across the columns in the range.

merge across

____ references are seldom used other than when creating tables of calculated values such as a multiplication table in which the values of the formula or function can be found in the initial rows and columns of the table.

mixed

The ____ dialog box provides options for moving charts between worksheets and chart sheets.

move chart

=ROUND(AVERAGE(A1:A100),2) is an example of a(n) ____ function.

nested

Harold wants to print ranges E6:F12 and E16:F22 of his worksheet. These are referred to as _____ cell ranges.

nonadjacent

In the Format Cells dialog box, the _____ tab allows you to format currency by choosing decimal places, comma separators, and regular number displays.

number

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

numbers

A chart sheet can contain ____.

only one chart

A pie slice is a data marker that represents ____ from a data series.

only one value

____ arguments may provide more control over the returned value.

optional

PMT(rate, nper, pv [, fv=0] [, type=0]) In the figure above, fv and type are ____.

optional arguments

Options to rotate cells in Excel are available using the _____ button in the Alignment group on the Home tab.

orientation

Critical-Thinking Case Based Questions ​ Case 4-1 Simon has just started a job with the police department. His director has given him the last six months of test results from four local precincts. Simon has organized the results as four data series and needs to display the trends in a graphic format. ​ ​ Simon 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?

overlay the legend in areas without data

____ displays the location of the different page breaks within the worksheet.

page break preview

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

painter

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

parentheses

Case-Based Critical Thinking Questions ​ Case 4-2 Mya has just surveyed 100 students to get their reaction to a new textbook she is reviewing. She has one data series that she wants to represent graphically, and she needs to display her data in a way that lets her visually compate the data values and see how much contributes to the whole. ​ ​ Since it's important for Mya 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 Mya? _____

pie

The ____ is the only one of the following charts to compare relative values from different categories to the whole.

pie

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

portrait

PMT(rate, nper, pv [, fv=0] [, type=0]) In the figure above, pv stands for the ____.

present value of the loan

The amount of money being loaned is known as the ____.

principal

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

print area

Information that prints on each page, like a company name or logo, may be set as a _____.

print title

The Format Cells dialog box tab that provides options for locking or hiding cells to prevent other users from modifying their contents is _____.

protection

A(n) ____ is a group of cells in a rectangular block.

range

Case Based Critical-Thinking Questions ​ Case 2-1 Harold has been working as a real estate agent. He has a lot of housing data to report and needs help organizing his data sheet for an effective presentation. ​ ​ Harold has chosen green as the background color for his workbook. He should not use _____ for any of the font or highlight colors.

red

When creating an Excel document, you should avoid using _____ text and background together, since this is the most common form of color blindness.

red and green

One of the great advantages of ____ references is that you can quickly generate row and column totals without having to worry about revising the formulas as you copy them to new locations.

relative

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

right

When you insert a new column, the existing columns are shifted to the ____ and the new column has the same width as the column directly to its left.

right

The range of values or _______, of an axis is based on the values in the data source.

scale

You can ____ the width or the height of the printout so that all of the columns or all of the rows fit on a single page.

scale

Which of the following will not change the location of the active cell?

scrolling

The Insert Function dialog box has a(n) ____ option.

search

Case-Based Critical Thinking Questions ​ Case 4-2 Mya has just surveyed 100 students to get their reaction to a new textbook she is reviewing. She has one data series that she wants to represent graphically, and she needs to display her data in a way that lets her visually compate the data values and see how much contributes to the whole. ​ ​ Mya has decided she needs to move her chart so that it appears below her data source. Before she can move or resize her chart she must ______.

select the chart

To resize an embedded chart, ____.

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

Keyboard ____ can help you work faster and more efficiently because you can keep your hands on the keyboard.

shortcuts

A _____ indicates a manual page break.

solid blue line

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

spreadsheet

A chart that compares three set of values in a three-dimensional chart is _____.

surface

In the formula =INT(AVERAGE(A1:A100)), which would occur first? ____

the average of the values in the range A1:A100 is calculated

FUNCTION(argument1, argument2, ...) is ____.

the general syntax of all functions

When you nest functions, you should have ____.

the same number of left and right parentheses

Case Based Critical Thinking Questions ​ Case 2-2 Antoinette is part of a college department creating a number of student files with Microsoft Excel. She is working on a student retention project and wants to produce a worksheet that can alert faculty of student progress and current grade status. ​ ​ Antoinette wants all her worksheets to have the same formatting for text, colors, and graphical effects applied to create a specific look and feel. Antoinette needs to apply a _____.

theme

Fonts, colors, and cell styles are organized in _____ categories.

theme and non-theme

PMT(rate, nper, pv [, fv=0] [, type=0]) In the figure above, nper stands for the ____.

total number of payment periods

In ____, the ribbon increases in height, the buttons are bigger, and more space appears around each button so you can more easily use your finger or a stylus to tap the button you need.

touch mode

A ScreenTip is a box with descriptive text about a command that appears when you point to a button on the ribbon. (T/F)

true

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

true

A common business practice is to include a worksheet named Documentation that contains a description of the workbook, the name of the person who prepared the workbook, and the date it was created. (T/F)

true

A conditional format applies formatting to a cell when its value meets a specified condition. _________________________ (T/F)

true

A conditional format can make negative numbers red and positive numbers black. _________________________ (T/F)

true

A constant is a value in a formula that doesn't change. _______________ (T/F)

true

A keyboard shortcut is a key or combination of keys that you press to access a feature or perform a command. (T/F)

true

A lookup table organizes numbers or text into categories. _____________ (T/F)

true

A mixed reference "locks" one part of the cell reference while the other part can change. _______________ (T/F)

true

An adjacent range is a collection of separate ranges. (T/F)

true

An argument can be any type of value including text, numbers, cell references, or even other formulas or functions. _______________ (T/F)

true

An error value begins with a pound sign (#) followed by an error name that indicates the type of error. _______________ (T/F)

true

AutoFit changes the column width or row height to display the longest or tallest entry within the column or row. (T/F)

true

By default, Excel displays text in a black font color. _________________________ (T/F)

true

By default, Excel inserts a chart as an embedded chart. _________________________ (T/F)

true

Calculated values too large to fit into the cell are displayed in scientific notation. _________________________ (T/F)

true

Changing the number of decimal places displayed in a cell does not change the value stored in the cell. _________________________ (T/F)

true

Conditional formats are dynamic, so a cell's appearance will change to reflect its current value. _________________________ (T/F)

true

Cutting moves the selected content, whereas copying duplicates the selected content. (T/F)

true

Each header and footer has three sections—a left section, a center section, and a right section. _________________________ (T/F)

true

Each slice in a pie chart represents a single value from a data series. ____________ (T/F)

true

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

true

Every function follows a set of rules, or syntax, which specifies how the function should be written. (T/F)

true

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

true

Formatting changes only the appearance of data—it does not affect the data itself. _________________________ (T/F)

true

Goal Seek automates the trial-and-error process by allowing you to specify a value for a calculated item, which Excel uses to determine the input value needed to reach that goal. _________________________ (T/F)

true

If you want to print only part of a worksheet, you can set a print area, which is the region of the worksheet that is sent to the printer. _________________________ (T/F)

true

In a line chart, the data markers are the points connected by the line. _________________________ (T/F)

true

In the formula, =2+6*2, addition would be calculated after multiplication. (T/F)

true

Interest is the amount added to the principal by the lender. _________________________ (T/F)

true

Lookup tables can be constructed for exact match or approximate match lookups. _______________ (T/F)

true

Numeric data is any number that can be used in a mathematical calculation. (T/F)

true

One challenge of nesting functions is to make sure that you include all of the parentheses. _______________ (T/F)

true

The AutoComplete feature automatically completes an entry based on previous entires in a column. (T/F)

true

The Format Painter does not copy formatting applied to selected text within a cell, and it does not copy data. _________________________ (T/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/F)

true

The PMT function calculates the payment required in each period to pay back the loan. ___________ (T/F)

true

The WORKDAY function displays the date of the weekday a specific number of weekdays past a starting date. (T/F)

true

The appearance of non-theme fonts, colors, and effects remains unchanged no matter which theme is applied to the workbook. _________________________ (T/F)

true

The background image does not affect any cell's format or content. _________________________ (T/F)

true

The following mixed reference in the formula, $A5, has an absolute column reference and a relative row reference. _________________________ (T/F)

true

The formula bar displays the value or formula of the active cell. (T/F)

true

The worksheet is organized into individual cells. (T/F)

true

When a formula includes a cell reference, Excel interprets that cell reference as being located relative to the position of the current cell. _________________ (T/F)

true

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

true

A logical function is a function that works with values that are either ____.

true or false

When using the Format Painter, double-click the Format Painter button to paste the same format multiple times and click the Format Painter again to _____.

turn it off

Case Based Critical-Thinking Questions ​ Case 2-1 Harold has been working as a real estate agent. He has a lot of housing data to report and needs help organizing his data sheet for an effective presentation. ​ ​ Harold would like to center a title across the top of his data. His data runs across five columns, from column A to column E. One way he could accomplish this is to _____.

type the data in A1 and Merge cells A1:E1

Case Based Critical-Thinking Questions ​ Case 2-1 Harold has been working as a real estate agent. He has a lot of housing data to report and needs help organizing his data sheet for an effective presentation. ​ ​ Harold needs to format several cells with 11pt Calibri font, two decimal places, right-aligned, and a blue font color. The most efficient way to accomplish this would be to _____.

use format painter

Case Based Critical-Thinking Questions ​ Case 2-1 Harold has been working as a real estate agent. He has a lot of housing data to report and needs help organizing his data sheet for an effective presentation. ​ ​ In one of Harold's columns there are too many numbers after the decimal place. Harold does not need this level of detail. It is distracting from the data and he really only needs two numbers after the decimal. How could Harold make the data appear cleaner in the most efficient way?

use the Number group to decrease number of digits displayed

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

Case-Based Critical Thinking Questions ​ Case 4-2 Mya has just surveyed 100 students to get their reaction to a new textbook she is reviewing. She has one data series that she wants to represent graphically, and she needs to display her data in a way that lets her visually compate the data values and see how much contributes to the whole. ​ ​ Mya has asked for your advice. A colleague told her to remove the legend from her pie chart because it takes up too much space. What would be a better piece of advice to give Mya?

Overlay the legend on a part of the chart that's empty.

If the VLOOKUP function cannot find the lookup value, the _________ error value is displayed in the cell.

#N/A

Absolute references are marked with a ____.

$

The code _____ will display the filename of the current workbook.

&[File]

PMT(rate, nper, pv [, fv=0] [, type=0]) The possible values for the type argument in the function above are.

0 or 1

Put the following five steps in the order in which you would perform them to use the Paste Special function. 1. Select and copy a range. 2. Click the Paste button arrow in the Clipboard group on the HOME Tab. 3. Specify exactly what you want to paste. 4. Click Paste Special to open the dialog box. 5. Select the range where you want to paste the Clipboard contents.

1,5,2,4,3

Ctrl + G is used to access the ____.

Go to a location in the worksheet command

Which of the following is a Math & Trig function? ____

INT