Carmen Quiz 1 - Chapter 1 - Spreadsheet Basics_ AU23 CSE 2111 - Spreadsheets & DBs (7288)

pdf

School

Ohio State University *

*We aren’t endorsed by this school

Course

2111

Subject

Computer Science

Date

Feb 20, 2024

Type

pdf

Pages

5

Uploaded by CaptainFlyPerson872

Report
2024/1/12 18:49 Carmen Quiz 1 - Chapter 1 - Spreadsheet Basics: AU23 CSE 2111 - Spreadsheets & DBs (7288) https://osu.instructure.com/courses/151434/quizzes/940003 1/5 Carmen Quiz 1 - Chapter 1 - Spreadsheet Basics Due Aug 25, 2023 at 11:59pm Points 20 Questions 10 Available Aug 22, 2023 at 12am - Aug 25, 2023 at 11:59pm Time Limit 15 Minutes Instructions This quiz was locked Aug 25, 2023 at 11:59pm. Attempt History Attempt Time Score LATEST Attempt 1 5 minutes 20 out of 20 Correct answers are no longer available. Score for this quiz: 20 out of 20 Submitted Aug 24, 2023 at 11:27pm This attempt took 5 minutes. Please select the appropriate answer to each True/False or Multiple Choice question. There are 10 questions total. Questions will be shown one at a time. You have one attempt at taking this quiz. The quiz is timed at 15 minutes . Correct responses will be available after the due date for the quiz. Materials for this quiz will be taken from the Course Notes Chapter 1 and all lecture materials covered to-date. IMPORTANT! Make sure you read the Course Notes PRIOR to taking this quiz. You will NOT have enough time to read the Course Notes as you progress through the quiz. It is expected that you read the Course Notes PRIOR to taking this quiz. No credit will be given for late submissions. No late submissions or makeups will be allowed. The lowest quiz grade will be dropped. Therefore, if you miss a quiz, this will be the one that is dropped. 2 / 2 pts Question 1 What are spreadsheets such as Excel used for in business?
2024/1/12 18:49 Carmen Quiz 1 - Chapter 1 - Spreadsheet Basics: AU23 CSE 2111 - Spreadsheets & DBs (7288) https://osu.instructure.com/courses/151434/quizzes/940003 2/5 to create balance sheets to analyze data to keep track of project costs, inventory, etc. to prepare budgets all of the choices listed are uses of Excel 2 / 2 pts Question 2 When writing formulas for spreadsheets in Excel, you do NOT need to pay attention to or worry about the order of precedence. True False 2 / 2 pts Question 3 When you change the format of how a cell is displayed, it doesn't affect the actual value stored by the computer. True False 2 / 2 pts Question 4 The cell containing the formula =2*12-1 < 100/4+1 will evaluate to TRUE.
2024/1/12 18:49 Carmen Quiz 1 - Chapter 1 - Spreadsheet Basics: AU23 CSE 2111 - Spreadsheets & DBs (7288) https://osu.instructure.com/courses/151434/quizzes/940003 3/5 True False 2 / 2 pts Question 5 A cell in Excel is being formatted with percentage style. You enter 10/50 in the cell. What is the displayed value and the actual value stored in the cell ? Displayed value - 20% Actual Value - 20% Displayed value - 20% Actual Value - 0.2 Displayed value - 0.2 Actual Value - 20% Displayed value - 0.2 Actual Value - 0.2 2 / 2 pts Question 6 How would you enter a formula to calculate the result of $25,000 times 2 in a cell such that the formula produces no error and shows $50,000 (assume the cell is formatted to display as currency)? 25000x2 =25000x2 =$25,000*2 $25,000*2 =25000*2
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
2024/1/12 18:49 Carmen Quiz 1 - Chapter 1 - Spreadsheet Basics: AU23 CSE 2111 - Spreadsheets & DBs (7288) https://osu.instructure.com/courses/151434/quizzes/940003 4/5 2 / 2 pts Question 7 Which of the following is NOT true of the basic features of Excel? The cell address first lists the row name and then the column name columns are named by letters the intersection of a row and column is referred to as a cell rows are named by numbers 2 / 2 pts Question 8 The value that Excel displays for a cell is always the precise value you enter in the spreadsheet or the precise value resulting from a formula in that cell that is stored by the software. True False 2 / 2 pts Question 9 How would you enter a formula to calculate the result of $15,000 times 3 in a cell such that the formula produces no error and shows $45,000 (assume the cell is formatted to display as currency)? =$15000X3 $15,000*3 15,000X3
2024/1/12 18:49 Carmen Quiz 1 - Chapter 1 - Spreadsheet Basics: AU23 CSE 2111 - Spreadsheets & DBs (7288) https://osu.instructure.com/courses/151434/quizzes/940003 5/5 =15000*3 2 / 2 pts Question 10 Which ribbon/menu do you click on to include a header or a footer in Excel 2019? File Formulas Insert Review Data Quiz Score: 20 out of 20

Related Documents

Chicka chicka boom boom lesson plan 5:23.docx
Understanding Alpha-Beta Pruning Enhancing Game Tree Search Efficiency.docx
Carmen Quiz 4 - Chapter 4 - Countif(s)_Sumif(s)_Averageif(s)_Large_Small_Rank_ AU23 CSE 2111 - Sprea
Carmen Quiz 6 - Chapter 6 - IF Functions_ AU23 CSE 2111 - Spreadsheets & DBs (7288).pdf
Carmen Quiz 5 - Chapter 5 - Boolean Functions_ AU23 CSE 2111 - Spreadsheets & DBs (7288).pdf
Carmen Quiz 3 - Chapter 3 - Spreadsheet Design_ AU23 CSE 2111 - Spreadsheets & DBs (7288).pdf
WireShark-Lab8_ CS.4310.001.pdf
lab02.py
Week7Algorithms and Decision MakingNelsonDanietta (1).docx
lab6_support.py
UNIT III Collett FIR 5301.pdf
Lab 08 - The Cow Strikes Back.pdf
Recommended textbooks for you
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
Systems Architecture
Computer Science
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Cengage Learning
Text book image
CMPTR
Computer Science
ISBN:9781337681872
Author:PINARD
Publisher:Cengage
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
Systems Architecture
Computer Science
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Cengage Learning
Text book image
CMPTR
Computer Science
ISBN:9781337681872
Author:PINARD
Publisher:Cengage
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
SEE MORE TEXTBOOKS