BUS 1350 Module 5
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. - ✔✔Can a worksheet have only one window?
Click the sheet tab of any worksheet in the group. - ✔✔How do you ungroup a worksheet group that consists of all
the sheets in the workbook?
Monday!C20 - ✔✔What is 3-D cell reference to cell C20 in the Monday worksheet?
Monday!$C$20 - ✔✔What is the absolute 3-D cell reference to cell C20 in the Monday worksheet?
Monday:Friday!C20 - ✔✔What is the 3-D cell reference to cell C20 in the Monday through Friday worksheet
group?
=MAX(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?
[Annual Report.xlsx]Final Report'!C20 - ✔✔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 - ✔✔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 - ✔✔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. - ✔✔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. - ✔✔How does Excel indicate that a cell contains linked text?
What does Excel do when a hyperlink is clicked by the user? - ✔✔What does Excel do when a hyperlink is clicked
by the user?
It contains a dash in the name. - ✔✔Why is Report-Date not a valid names range?
Excel selects the cell or cell range referenced by the defined name. - ✔✔What happens when you select a
defined name in the Name box?
When you don't want the coworker modifying the workbook itself, but only when you want the coworker to create a
new workbook based on the workbook design. - ✔✔When would you create a template rather than just providing
a coworker with a copy of your workbook?
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller AnswersCOM. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £9.12. You're not tied to anything after your purchase.
