BUS 1350 Exam 2 Baylor University BUS 1350
Exam 2
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
A school gives out grades in the following ranges: F: 0 - < 60; D: 60 - < 70; C: 70 - < 80; B: 80 - <
90; A: 90 - 100. Create a vertical lookup table for this grade scale with the range values in the first
column and the letter grades in the second.
0F
60 D
70 C 80 B
90 A
What is the function to retrieve the letter grade stored in the second column of the GradeScale table
using a lookup value of 83 in an approximate match lookup?
=VLOOKUP(83, GradeScale, 2) - ✔✔6. What is displayed in the title bar for a workbook created
from the EmployeeList.xltx template file
=INDEX(A10:C50, 5, 2) - ✔✔What is the function to retrieve the value located in the fifth row and
second column of the data in the range A10:G50
=MATCH("Carter", E1:E50, 0) - ✔✔What is the function to return the index number of the cell within
the range E1:E50 that is equal to "Carter", using an exact match
You can do lookups in an approximate match lookup with the values sorted in descending and
ascending order. You can do searches based on any row or column from the lookup table. -
✔✔What are two advantages of index matches over the VLOOKUP and HLOOKUP functions
=COUNTIF(B1:B50, "B") - ✔✔What is the function to count the number of cells in the range B1:B50
that equal "B"
=AVERAGEIF(C1:C50, "B", B1:B50) - ✔✔What is the function to calculate the average of the cells
in the range C1:C50 for which the adjacent cell in the range B1:B50 equals "B"
=SUMIFS(D1:D50, A1:A50, "Senior", B1:B50, "B") - ✔✔What is the function to calculate the sum of
the values in the range D1:D50 for which in the adjacent value in the range A1:A50 equals "Senior"
and the adjacent value in the range B1:B50 equals "B"
A PivotTable is an interactive table that groups and summarizes data in a concise tabular format. -
✔✔What is a PivotTable
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 or Stuvia-credit 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 $11.49. You're not tied to anything after your purchase.
