Question 1

Case 3-1
George runs a mid-size accounting practice and recently upgraded to Excel 2013.He expects sales to grow in the next few months during tax season.After that,he would like to begin upgrading some of the equipment and furniture for the employees in his office.He will start with the Reception area,which has the most visibility.
-In George's Sales Data worksheet,the result for a formula in cell H14 is ######.What should George do?
A) increase the width of column H
B) provide a correct argument or operand
C) run the calculation again to find the available value
D) replace the incorrect formula in cell H14 with one that does not divide by zero

Accepted Answer

The appearance of "######" in a cell in Excel typically indicates that the column is not wide enough to display the value. Increasing the column width will allow the full value to be displayed.

Question 2

Discuss how you should format the various elements of a worksheet.

Accepted Answer

The answer of Discuss how you should format the various...

Question 3

Case 3-2
Bea is the best pie baker around.She has decided to go into business and takes a survey in her town to find out what types of pies are favorites.She decides to record her data in a worksheet she can present to the bank when she seeks a loan for her business startup costs.Bea is new to using Excel,however,and she would like to become conversant in the keyboard shortcuts for the options available in the Paste Options gallery to expedite her work.
-Bea wants to copy the contents and format of a source area but transpose,or swap,the rows and columns.What keyboard shortcut can she use to do this?
A) CTRL+S
B) CTRL+T
C) CTRL+K
D) CTRL+D

Accepted Answer

The correct keyboard shortcut for transposing (swapping rows and columns) while pasting in Excel is not directly listed among the options (A, B, C, D). However, the standard method to transpose data in Excel involves copying the data, then selecting the destination, and using the Paste Special option, where one can select "Transpose". This specific action does not have a direct keyboard shortcut like CTRL+S (save), CTRL+K (insert hyperlink), or CTRL+D (fill down). The closest to a direct action for transposing via a keyboard shortcut involves using the Alt key to access the Ribbon commands, not a simple CTRL command as listed. Therefore, the question might contain a misunderstanding or be seeking a different kind of answer related to Excel's capabilities as of the last update.

Question 4

Identify the letter of the choice that best matches the phrase or definition.
-Determines the value of a cell on which the formula depends.
A)NOW function
B)Fill Formatting Only
C)goal seeking
D)what-if analysis
E)NUM!
F)#NAME?
G)Keep Source Formatting
H)Fill Series
I)IF function
J)absolute cell referencing

Accepted Answer

Goal seeking is a process in Excel that determines the necessary input value to achieve a desired result in a formula.

Question 5

Case 3-1
George runs a mid-size accounting practice and recently upgraded to Excel 2013.He expects sales to grow in the next few months during tax season.After that,he would like to begin upgrading some of the equipment and furniture for the employees in his office.He will start with the Reception area,which has the most visibility.
-If sales reach a certain amount by the end of April,George will purchase a desk,chair,computer,and software upgrade for the receptionist.Otherwise,George will just purchase the desk and chair.How can George determine the best action to take using a Sales Data worksheet?
A) Copy and paste all his Sales data formulas with relative references
B) Add an IF function formula to his Sales data worksheet
C) Add the NOW function formula to his Sales data worksheet
D) Copy and paste all his Sales data formulas with absolute references

Accepted Answer

The IF function can be used to create a condition that checks if sales reach a certain amount by the end of April, and based on that condition, it can determine whether to purchase all the items or just the desk and chair.

Question 6

Case 3-2
Bea is the best pie baker around.She has decided to go into business and takes a survey in her town to find out what types of pies are favorites.She decides to record her data in a worksheet she can present to the bank when she seeks a loan for her business startup costs.Bea is new to using Excel,however,and she would like to become conversant in the keyboard shortcuts for the options available in the Paste Options gallery to expedite her work.
-Bea finished adding the results of her survey to a worksheet in her new workbook,including the number of people who voted for each type of pie.If in manipulating the worksheet she wants to copy the contents and formatting of a source area but not the formula,which keyboard shortcut will she use?
A) CTRL+R
B) CTRL+A
C) CTRL+E
D) CTRL+W

Accepted Answer

The answer of Case 3-2
Bea is the best pie baker...

Question 7

Explain in detail the utility of freezing worksheet columns and rows.

Accepted Answer

The answer of Explain in detail the utility of freezing...

Question 8

Briefly discuss how Excel modifies cell references when copying and pasting formulas,including an explanation of absolute,relative,and mixed cell references.

Accepted Answer

The answer of Briefly discuss how Excel modifies cell references...

Question 9

Identify the letter of the choice that best matches the phrase or definition.
-Indicates a cell is using a name Excel does not recognize.
A)NOW function
B)Fill Formatting Only
C)goal seeking
D)what-if analysis
E)NUM!
F)#NAME?
G)Keep Source Formatting
H)Fill Series
I)IF function
J)absolute cell referencing

Accepted Answer

#NAME? error in Excel indicates that the formula contains text that Excel does not recognize, such as a misspelled function name or a reference to a name that has not been defined.

Question 10

Identify the letter of the choice that best matches the phrase or definition.
-Scrutinizes the impact of changing values in cells that are referenced by a formula in another cell.
A)NOW function
B)Fill Formatting Only
C)goal seeking
D)what-if analysis
E)NUM!
F)#NAME?
G)Keep Source Formatting
H)Fill Series
I)IF function
J)absolute cell referencing

Accepted Answer

What-if analysis is the process used in Excel to scrutinize the impact of changing values in cells that are referenced by a formula in another cell, allowing users to see how different values affect the outcome of formulas.

Question 11

Identify the letter of the choice that best matches the phrase or definition.
-Indicates a cell that uses a number incorrectly.
A)NOW function
B)Fill Formatting Only
C)goal seeking
D)what-if analysis
E)NUM!
F)#NAME?
G)Keep Source Formatting
H)Fill Series
I)IF function
J)absolute cell referencing

Accepted Answer

E) NUM! is the error that indicates a cell in spreadsheet programs like Microsoft Excel is using a number incorrectly.

Quiz 14: Excel: Working With Large Worksheets, Charting, and What-If Analysis

Discuss how you should format the various elements of a worksheet.

Identify the letter of the choice that best matches the phrase or definition. -Determines the value of a cell on which the formula depends.

Explain in detail the utility of freezing worksheet columns and rows.

Briefly discuss how Excel modifies cell references when copying and pasting formulas,including an explanation of absolute,relative,and mixed cell references.

Identify the letter of the choice that best matches the phrase or definition. -Indicates a cell is using a name Excel does not recognize.

Identify the letter of the choice that best matches the phrase or definition. -Scrutinizes the impact of changing values in cells that are referenced by a formula in another cell.

Identify the letter of the choice that best matches the phrase or definition. -Indicates a cell that uses a number incorrectly.