How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask The-PC-Guy Your Own Question

The-PC-Guy
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1842
Experience:  20 years experience providing remote computer support
62934938
Type Your Microsoft Office Question Here...
The-PC-Guy is online now
A new question is answered every 9 seconds

(TCO 5) The tabs of grouped worksheets are displayed with a

Resolved Question:

1. (TCO 5) The tabs of grouped worksheets are displayed with a ________ background. (Points : 2)
gray
yellow
blue
white

2. (TCO 5) In Excel, which of the following would you perform to group adjacent worksheets? (Points : 2)
Click the first tab, hold Shift, and then click the last tab.
Click the first tab, hold Ctrl, and then click the last tab.
Right-click a worksheet tab, then select Select All Sheets.
Right-click a worksheet tab, then select Group.

3. (TCO 5) If the active cell is in row 1, but not in column A, when you click the Split command, the worksheet will appear in two ________ panes. (Points : 2)
horizontal
diagonal
vertical
square

4. (TCO 5) In Excel, which of the following is NOT a method for splitting a worksheet? (Points : 2)
Drag a split box.
Double-click a split box.
Right-click in the active cell and click Split.
Click Split in the Window group on the View tab.

5. (TCO 5) Which of the following external references is correct for a workbook and worksheet that have no spaces? (Points : 2)
"[New#Jersey#xlsx]Qtr4!"B6
'#New#Jersey#xlsx#Qtr4!'B6
#New#Jersey#xlsx#Qtr4!,B6
#NewJersey#xlsx#Qtr4!B6

6. (TCO 5) Which formula would return the #NA#E? error? (Points : 2)
=SUM#B6#B12#
=MAX#B6:B12#
=AVG#B6:B12#
=IF#A6="Atlanta",A3,0#

7. (TCO 5) Which of the following is a valid worksheet reference to a sheet named Year3? (Points : 2)
F8!Year3
F8Year3!
Year3F8
Year3!F8

8. (TCO 6) When creating a range for the substitution values in a one-variable data table, it is best to arrange them in a#n# ***** orientation. (Points : 2)
horizontal
vertical
alphabetical
reverse

9. (TCO 6) In a data table, the ________ number format is used to disguise the formula references in the first row as labels. (Points : 2)
Custom
Scientific
Text
Special

10. (TCO 6) What is the main difference between Goal Seek and variable data tables? (Points : 2)
Goal Seek produces a list of result values.
Goal Seek uses the original worksheet data to change an input.
Goal Seek manipulates multiple variables to produce multiple results.
Goal Seek shows results in a separate table.

11. (TCO 6) The Goal Seek command is located in the ________ command on the Data tab. (Points : 2)
What-If Analysis
Data Validation
Consolidate
Advanced

12. (TCO 6) After creating a scenario summary report, it is recommended that you do all the following EXCEPT: (Points : 2)
delete blank row 1 and blank column A.
change the colors of the title row.
replace cell references with descriptive labels in the first column.
replace the explanatory paragraph below the table with a narrative explaining the report.

13. (TCO 6) Where is Solver located if it is already loaded onto Excel? (Points : 2)
Add-Ins tab
Formulas tab
Analysis group on the Data tab
Data Tools group on the Data tab

14. (TCO 6) Which of the following commands cannot be used on a constraint in the Solver Parameters dialog box? (Points : 2)
Add
Format
Change
Delete

15. (TCO 6) The maximum number of scenarios Scenario Manager can handle is: (Points : 2)
30
32
18
16

Submitted: 5 years ago.
Category: Microsoft Office
Expert:  The-PC-Guy replied 5 years ago.
1 white
2 Click the first tab, hold Shift, and then click the last tab. & Click the first tab, hold Ctrl, and then click the last tab.
3 horizontal
4 Right-click in the active cell and click Split.
5 '#New#Jersey#xlsx#Qtr4!'B6
6 =IF#A6="Atlanta",A3,0#
7 Year3!F8
8 vertical
9 Text
10 Goal Seek uses the original worksheet data to change an input.
11 What-If Analysis
12 replace cell references with descriptive labels in the first column.
13 Add-Ins tab
14 Format
15 32

The-PC-Guy and other Microsoft Office Specialists are ready to help you