100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Previously searched by you
Previously searched by you
logo
BUS 1350 Exam 2 Baylor University BUS 1350 Exam 2 Questions &Exam (COMPLETE ANSWERS elaborations) answers 100% satisfaction guarantee $11.49
Add to cart
Quickly navigate to
Preview
  2.  
  3. BMTCN
  4.  
  5. BMTCN

Exam (elaborations)

BUS 1350 Exam 2 Baylor University BUS 1350 Exam 2 Questions &Exam (COMPLETE ANSWERS elaborations) answers 100% satisfaction guarantee
 2 purchases
  • Course
  • BMTCN
  • Institution
  • BMTCN

BUS 1350 Exam 2 Baylor University BUS 1350 Exam 2 Questions &Exam (COMPLETE ANSWERS elaborations) answers 100% satisfaction guarantee

Preview 2 out of 10  pages

Document information

  • August 26, 2024
  • 10
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers

Subjects

  • bus 1350 exam 2 baylor university bus 1350 exam 2

Written for

  • BMTCN
  • BMTCN

Seller

avatar-seller
AnswersCOM

Reviews received

Content preview

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

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

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

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.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

69411 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 15 years now

Start selling
$11.49  2x  sold
  • (0)
Add to cart
Added