BUS 1350 - Final Exam | UPDATED Questions with 100%
Verified Answers
Q1: Enter a formula using the SUM function and a 3-D reference
that totals the Mini sales values (cell B5) in Quarter 1 from the
Us, Canada, and Mexico worksheet
A: =SUM(US:Mexico!B5)
Q2: To break a link
A: Data
Edit Links
Break Link
Q3: To create a define name
A: Select the cells
Enter in name in the name box at the top left
Formulas
Define name
Select name
Names in left column: - - Select cells including the name area
Formula
Define Name
Create from Selection - Left Column
Q4: How do you create a worksheet group consisting of sheets
that are not adjacent in a workbook?
A: Press and hold CTRL
Click on each tab you want to add
Q5: Can a worksheet have only one window?
A: No; a single workbook can have multiple workbook windows.
Q6: How do you ungroup a worksheet group that consists of all
the sheets in a workbook?
A: Click the sheet tab of any worksheet in the group
Q7: What i 3-D cell reference to cell C20 in the monday
worksheet?
A: Monday!C20
Q8: What is the absolute 3-D cell reference to call C20 in the
Monday worksheet?
, A: Monday!$C$20
Q9: What is the 3-D cell reference to cell C20 in the Monday
through Friday worksheet group?
A: Monday:Friday!C20
Q10: Write a formula that uses MAX function to calculate the
maximum value of cell C20 of the monday through Friday
worksheet group?
A: =MAX(Monday;Friday!C20)
Q11: What is the external reference to cell C20 of the Final Report
worksheet located in the Annual Statement.xlsx workbook?
A: '[Annual Report.xlsx]Final Report'!C20
Q12: When would you paste a copied cell using the Pates Link
option?
A: When you want to paste the reference to the cell and not the cell's value or format
Q13: 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
A: Data
Edit Link
View the link's status in the Status column
Q14: How does Excel indicate that a cell contains linked text?
A: The text is displayed in green and underlined
Q15: What does Excel do when a hyperlink is clicked by the user?
A: it opens an applicated assoicated with the type of link (ex: a website, another workbook,
picture, etc)
Q16: Why is Report-Date not a valid names range?
A: It contains a dash in the name.
Q17: What happens when you select a defined name in the Name
box?
A: Excel selects the cell or cell range referenced by the defined name
Q18: What expression to reference the local scope defined name
TotalSales from Final Report worksheet?
Verified Answers
Q1: Enter a formula using the SUM function and a 3-D reference
that totals the Mini sales values (cell B5) in Quarter 1 from the
Us, Canada, and Mexico worksheet
A: =SUM(US:Mexico!B5)
Q2: To break a link
A: Data
Edit Links
Break Link
Q3: To create a define name
A: Select the cells
Enter in name in the name box at the top left
Formulas
Define name
Select name
Names in left column: - - Select cells including the name area
Formula
Define Name
Create from Selection - Left Column
Q4: How do you create a worksheet group consisting of sheets
that are not adjacent in a workbook?
A: Press and hold CTRL
Click on each tab you want to add
Q5: Can a worksheet have only one window?
A: No; a single workbook can have multiple workbook windows.
Q6: How do you ungroup a worksheet group that consists of all
the sheets in a workbook?
A: Click the sheet tab of any worksheet in the group
Q7: What i 3-D cell reference to cell C20 in the monday
worksheet?
A: Monday!C20
Q8: What is the absolute 3-D cell reference to call C20 in the
Monday worksheet?
, A: Monday!$C$20
Q9: What is the 3-D cell reference to cell C20 in the Monday
through Friday worksheet group?
A: Monday:Friday!C20
Q10: Write a formula that uses MAX function to calculate the
maximum value of cell C20 of the monday through Friday
worksheet group?
A: =MAX(Monday;Friday!C20)
Q11: What is the external reference to cell C20 of the Final Report
worksheet located in the Annual Statement.xlsx workbook?
A: '[Annual Report.xlsx]Final Report'!C20
Q12: When would you paste a copied cell using the Pates Link
option?
A: When you want to paste the reference to the cell and not the cell's value or format
Q13: 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
A: Data
Edit Link
View the link's status in the Status column
Q14: How does Excel indicate that a cell contains linked text?
A: The text is displayed in green and underlined
Q15: What does Excel do when a hyperlink is clicked by the user?
A: it opens an applicated assoicated with the type of link (ex: a website, another workbook,
picture, etc)
Q16: Why is Report-Date not a valid names range?
A: It contains a dash in the name.
Q17: What happens when you select a defined name in the Name
box?
A: Excel selects the cell or cell range referenced by the defined name
Q18: What expression to reference the local scope defined name
TotalSales from Final Report worksheet?
