History, Formulas, Functions and Errors

pdf

School

University of Pennsylvania *

*We aren’t endorsed by this school

Course

10001

Subject

Computer Science

Date

Dec 6, 2023

Type

pdf

Pages

3

Uploaded by MagistrateScorpion24084

Report
Module 1 Quiz: History, Formulas, Functions and Errors Quiz, 10 questions Question 1 1 point Schlumberger-Private 1. Question 1 The story of Bricklin and Frankston and the emergence of personal computers provides evidence suggesting that ______________ The personal computer existed before Apple Hardware sells software Software sells hardware Spreadsheets were not originally used for accounting applications All of these are true 1 point 2. Question 2 If the range A1:A4 consists of the values 1,2,3,4 and the range B1:B4 consists of the values 9,8,7,6, what is the value of the sumproduct(B1:B4, A1:A4)? 1 point 3. Question 3 Review the step function in the spreadsheet below. Given the conditional pricing formula shown in C3, what ’ s the value of the order total in C5? 70 Schlumberger-Private 1 point 4. Question 4 Evaluate the formula 3^(1+2)*4-5/7 using the order of calculation followed by Excel or Sheets. Round to 2 decimals, and use a decimal point (".") in your answer. 1 point 5. Question 5 Below is a spreadsheet showing product sales for the past 6 months. Assume we want to write a formula in cell C10 that we can copy later across 6 columns representing the past 6 months of sales. The formula needs to apply the unit cost of goods sold found in cell C2. Enter the formula for cell C10 using spreadsheet syntax and the appropriate absolute and relative addresses to calculate total cost of goods sold for that period. 7650 107.29 Schlumberger-Private Question 6
1 point 6. Question 6 Which of the following formulas from the spreadsheet shown below will result in a circular reference error? Select all that apply. Formula in cell H10=sum(H5:H10) Formula in cell C10=sum(C7:C10)*$C$2 Formula in cell C10=sumproduct(C5:H7, C2) Formula in cell C14=C10*C4-C10*C2 =$C$2*C8 Schlumberger-Private All of these will result in a circular reference error Question 7 1 point 7. Question 7 In the cashflow spreadsheet below, which of the following cell addresses contains a potentially important output function for the cashflow model? Select all that apply. B7 B8 B6 B13 B12 Schlumberger-Private Question 8 1 point 8. Question 8 In this analysis of historical sales, which cell formula tells you the level of variation in the spread of sales numbers from low performing months to high performing months? C9 C8 C11 C10 None of these show the spread of sales numbers 1 point Schlumberger-Private 9. Question 9 Consider the following spreadsheet showing sales of Product A, current inventory of Product A and purchases of Product A from a supplier when inventories run low. Using appropriate syntax for entering a formula in a spreadsheet cell, write a statement in cell D5 that would trigger a 100 unit order from a supplier when the inventory for the period falls below 75 units. . Question 10
1 point 10. Question 10 The term array is closest in meaning in Excel to: Standard Deviation Spreadsheet Cell Range Sumproduct
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Related Documents

CS1083_Project_3.pdf
ProblemSet11_23f - Jupyter Notebook.pdf
Computer Essentials_lab2quiz.pdf
Computer Essentials_Hybrid3.pdf
Instructional Plan math 1.docx
Computer Essentials_finalassessment.pdf
qbe-in-class-practice.pdf
qbe-in-class-practice-sol.pdf
SampleMidterm1.pdf
Project Submission for Enforcing Specifications.docx
Python Journal Template-Abhiraj.docx
CSE166_FA23_assignment_1.pdf
Recommended textbooks for you
Text book image
Systems Architecture
Computer Science
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Cengage Learning
Text book image
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
EBK JAVA PROGRAMMING
Computer Science
ISBN:9781337671385
Author:FARRELL
Publisher:CENGAGE LEARNING - CONSIGNMENT
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Systems Architecture
Computer Science
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Cengage Learning
Text book image
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
EBK JAVA PROGRAMMING
Computer Science
ISBN:9781337671385
Author:FARRELL
Publisher:CENGAGE LEARNING - CONSIGNMENT
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
SEE MORE TEXTBOOKS