BUS 1350 Exam 2|Baylor University BUS 1350 Exam 2 Exam Questions with Correct Answers
100% Verified by Experts| 2025/2026 Latest Update
Press
and hold CTRL as you click each sheet tab that you want to add to the worksheet group.
How do you create a worksheet group consisting of sheets that are not adjacent in a
workbook
No; a single workbook can have multiple workbook windows. 2. Can a worksheet have only
one window
Click the
sheet tab of any worksheet in the group. 3. How do you ungroup a worksheet group that
consists of all the sheets in the workbook
Monday!C20 4. What is 3-D cell reference to cell C20 in the Monday worksheet
Monday!$C$20 5. What is the absolute 3-D cell reference to cell C20 in the Monday
worksheet
Monday:Friday!C20 6. What is the 3-D cell reference to cell C20 in the Monday through
Friday worksheet group
=MAX(Monday:Friday!C20) 7. Write formula that uses the MAX function to calculate the
maximum value of cell C20 of the
Monday through Friday worksheet group
'[Annual Report.xlsx]Final Report'!C20 8. What is the external reference to cell C20 of the
Final Report worksheet located in the Annual
Statement.xlsx workbook
, '[C:\Documents\Reports\Weekly
Report.xlsx]Sunday'!D10 9. What is the external reference to cell D10 of the Sunday
worksheet located in the Weekly Report.xslx
workbook that is stored in the C:\Documents\Reports folder
When you want to paste the reference
to the cell and not the cell's value or format 10. When would you paste a copied cell using
the Paste Link option
On the Data tab, in the Queries & Connections group, click the
Edit Link button to open the Edit Links dialog box, and then view the link's status in the Status
column. 11. How do you check the status of a link within the current workbook to determine
whether the link's
source file is accessible and up to date
The text is displayed in green and underlined. 12. How does Excel indicate that a cell
contains linked text
It opens an application associated with the
type of link. 13. What does Excel do when a hyperlink is clicked by the user
It contains a dash in the name. 1. Why is Report-Date not a valid names range
Excel selects the cell or cell range
referenced by the defined name. 2. What happens when you select a defined name in the
Name box
EmployeeList1
100% Verified by Experts| 2025/2026 Latest Update
Press
and hold CTRL as you click each sheet tab that you want to add to the worksheet group.
How do you create a worksheet group consisting of sheets that are not adjacent in a
workbook
No; a single workbook can have multiple workbook windows. 2. Can a worksheet have only
one window
Click the
sheet tab of any worksheet in the group. 3. How do you ungroup a worksheet group that
consists of all the sheets in the workbook
Monday!C20 4. What is 3-D cell reference to cell C20 in the Monday worksheet
Monday!$C$20 5. What is the absolute 3-D cell reference to cell C20 in the Monday
worksheet
Monday:Friday!C20 6. What is the 3-D cell reference to cell C20 in the Monday through
Friday worksheet group
=MAX(Monday:Friday!C20) 7. Write formula that uses the MAX function to calculate the
maximum value of cell C20 of the
Monday through Friday worksheet group
'[Annual Report.xlsx]Final Report'!C20 8. What is the external reference to cell C20 of the
Final Report worksheet located in the Annual
Statement.xlsx workbook
, '[C:\Documents\Reports\Weekly
Report.xlsx]Sunday'!D10 9. What is the external reference to cell D10 of the Sunday
worksheet located in the Weekly Report.xslx
workbook that is stored in the C:\Documents\Reports folder
When you want to paste the reference
to the cell and not the cell's value or format 10. When would you paste a copied cell using
the Paste Link option
On the Data tab, in the Queries & Connections group, click the
Edit Link button to open the Edit Links dialog box, and then view the link's status in the Status
column. 11. How do you check the status of a link within the current workbook to determine
whether the link's
source file is accessible and up to date
The text is displayed in green and underlined. 12. How does Excel indicate that a cell
contains linked text
It opens an application associated with the
type of link. 13. What does Excel do when a hyperlink is clicked by the user
It contains a dash in the name. 1. Why is Report-Date not a valid names range
Excel selects the cell or cell range
referenced by the defined name. 2. What happens when you select a defined name in the
Name box
EmployeeList1
