Quiz 3 Flashcards
Which tool allows you to work backwards to determine what input value is required for a specific output value?
Goal seeking
True or False?
You can change the orientation of the data using Paste Special and choose Values Only and the Transpose option. This adjustment is a temporary solution.
True
True or False?
It is possible to change the orientation of the data in a worksheet using paste special with values only and the transpose option.
True
True or False?
The formula =SUM(Job1!B15:Job6!B15) works if the sheets are not adjacent to each other in workbook.
False
Which of the following is a limitation when using 3-D formulas and a range of cells spanning multiple worksheets?
A. No other worksheets can be in the workbook
B. Only one cell can be used
C. You cannot have different values in the same cell in multiple worksheets
D. The worksheets must be named in the same workbook
E. The sheets must be adjacent to each other in the workbook
E
3-D cell referencing is used when _________________ .
A. Comparing and aggregating data when each case is on the same worksheet
B. Comparing and aggregating data where each case is on a different sheet in the workbook
C. Only the inputs are placed in multiple files
D. Inputs and outputs are all placed in one worksheet
E. You have exactly 3 cases in multiple worksheets
B
True or False?
You should plan a workbook design before implementing a solution to avoid time consuming changes later.
True
An analysis in which alternative values are substituted for data inputs is known as ____________ .
What-if
Which of the following is a possible reason why a spreadsheet solution may require changes?
A. It’s difficult to read and use
B. It doesn’t allow values to be easily changed
C. Additional information is needed in it
D. It doesn’t allow additional variables to be included in it
E. All of the above
E
True or False?
It is not possible to display multiple worksheets simultaneously on your screen in Excel.
False
