How do you create a worksheet group consisting of sheets that are not adjacent in a workbook?
- correct answer ✔✔ Press and hold CTRL as you click each sheet tab that you want to add to
the worksheet group.
Can a worksheet have only one window? - correct answer ✔✔ No; a single workbook can have
multiple workbook windows.
How do you ungroup a worksheet group that consists of all the sheets in the workbook? -
correct answer ✔✔ Click the sheet tab of any worksheet in the group.
What is 3-D cell reference to cell C20 in the Monday worksheet? - correct answer ✔✔ Monday!
C20
What is the absolute 3-D cell reference to cell C20 in the Monday worksheet? - correct answer
✔✔ Monday!$C$20
What is the 3-D cell reference to cell C20 in the Monday through Friday worksheet group? -
correct answer ✔✔ Monday:Friday!C20
Write formula that uses the MAX function to calculate the maximum value of cell C20 of the
Monday through Friday worksheet group? - correct answer ✔✔ =MAX(Monday:Friday!C20)
What is the external reference to cell C20 of the Final Report worksheet located in the Annual
Statement.xlsx workbook? - correct answer ✔✔ [Annual Report.xlsx]Final Report'!C20