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