Spreadsheet modeling for business decisions.
1. The advantage of an electronic ____ is that the content can be easily
edited and updated to reflect changing financial conditions.: spreadsheet
2. "AZ" is an example of a ____.: column heading
3. To go to column A of the current row, press ____.: Home
4. The characters +, -, *, and / are examples of ____.: arithmetic operators
5. An Excel formula always begins with a(n) ____.
parentheses: equals sign
6. The formula used to multiply cell A1 by cell C1 is ____.: =A1*C1
7. 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
8. What is the result of the expression =50+20/10*5?: 60
9. To change the order of operations, enclose part of the formula in ____.:
parentheses
10. Which of the following takes precedence over multiplication?:
exponentiation
11. The Format Painter does not copy formatting applied to selected text
within a cell, and it does not copy data.: True
12. Each header and footer has three sections—a left section, a center
section, and a right section.: true
13. Formatting changes only the appearance of data—it does not affect the
data itself.: true
14. 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.: false
15. The appearance of non-theme fonts, colors, and effects remains
unchanged no matter which theme is applied to the workbook: true
16. Changing the number of decimal places displayed in a cell does not
change the value stored in the cell: true
17. Page Break Preview identifies manual page breaks with a dotted blue line
and automatic page breaks with a solid blue line.: false
18. A theme is a collection of formatting options that include a specified
font, font size, font styles, font color, fill color, and borders.: false
19. A conditional format can make negative numbers red and positive
numbers black.: true
20. Calculated values too large to fit into the cell are displayed in scientific
notation.: true
21. The name of the active workbook appears in the status bar of the Excel
window: False
1/6
, Spreadsheet modeling for business decisions.
22. To switch to ____ mode, you double-click the cell.: edit
23. The sheets in a workbook are identified in the sheet tabs at the top of the
workbook window: false
24. 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
25. Formatting changes only the appearance of data—it does not affect the
data itself: true
26. Excel organizes fonts into theme and non-theme fonts: true
27. 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
28. The background image does not affect any cell's format or content.: true
29.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 wants to find out what her median monthly spending is. The
monthly totals for her spending appear in the range A10:L10. Which of
the following is NOT a way to enter the MEDIAN function into her
database?: Select the range A10:L10, click the Quick Analysis button, click
TOTALS, and then click Median.
30. Lookup tables can be constructed for exact match or approximate match
lookups: true
31. The ____ function returns the maximum value in the range: MAX
32. The Insert Function dialog box has a(n) ____ option: search
33. Susan is in charge of the inventory reports for her company. She will
need to find specific inventory items as well as project increases in
inventory costs. To get ready she will create a worksheet and use the
Microsoft Excel 2016 Analysis tools.
2/6
1. The advantage of an electronic ____ is that the content can be easily
edited and updated to reflect changing financial conditions.: spreadsheet
2. "AZ" is an example of a ____.: column heading
3. To go to column A of the current row, press ____.: Home
4. The characters +, -, *, and / are examples of ____.: arithmetic operators
5. An Excel formula always begins with a(n) ____.
parentheses: equals sign
6. The formula used to multiply cell A1 by cell C1 is ____.: =A1*C1
7. 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
8. What is the result of the expression =50+20/10*5?: 60
9. To change the order of operations, enclose part of the formula in ____.:
parentheses
10. Which of the following takes precedence over multiplication?:
exponentiation
11. The Format Painter does not copy formatting applied to selected text
within a cell, and it does not copy data.: True
12. Each header and footer has three sections—a left section, a center
section, and a right section.: true
13. Formatting changes only the appearance of data—it does not affect the
data itself.: true
14. 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.: false
15. The appearance of non-theme fonts, colors, and effects remains
unchanged no matter which theme is applied to the workbook: true
16. Changing the number of decimal places displayed in a cell does not
change the value stored in the cell: true
17. Page Break Preview identifies manual page breaks with a dotted blue line
and automatic page breaks with a solid blue line.: false
18. A theme is a collection of formatting options that include a specified
font, font size, font styles, font color, fill color, and borders.: false
19. A conditional format can make negative numbers red and positive
numbers black.: true
20. Calculated values too large to fit into the cell are displayed in scientific
notation.: true
21. The name of the active workbook appears in the status bar of the Excel
window: False
1/6
, Spreadsheet modeling for business decisions.
22. To switch to ____ mode, you double-click the cell.: edit
23. The sheets in a workbook are identified in the sheet tabs at the top of the
workbook window: false
24. 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
25. Formatting changes only the appearance of data—it does not affect the
data itself: true
26. Excel organizes fonts into theme and non-theme fonts: true
27. 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
28. The background image does not affect any cell's format or content.: true
29.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 wants to find out what her median monthly spending is. The
monthly totals for her spending appear in the range A10:L10. Which of
the following is NOT a way to enter the MEDIAN function into her
database?: Select the range A10:L10, click the Quick Analysis button, click
TOTALS, and then click Median.
30. Lookup tables can be constructed for exact match or approximate match
lookups: true
31. The ____ function returns the maximum value in the range: MAX
32. The Insert Function dialog box has a(n) ____ option: search
33. Susan is in charge of the inventory reports for her company. She will
need to find specific inventory items as well as project increases in
inventory costs. To get ready she will create a worksheet and use the
Microsoft Excel 2016 Analysis tools.
2/6
