Carmen Quiz 1 - Chapter 1 - Spreadsheet Basics_ AU23 CSE 2111 - Spreadsheets & DBs (7288)
.pdf
keyboard_arrow_up
School
Ohio State University *
*We aren’t endorsed by this school
Course
2111
Subject
Computer Science
Date
Feb 20, 2024
Type
Pages
5
Uploaded by CaptainFlyPerson872
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
Related Questions
https://www.bartleby.com/questions-and-answers/in-the-written-exam-held-at-the-end-of-the-driving-license-course-50-questions-from-traffic-40-from-/c0836364-9bad-48ea-990d-a1c9ad89f7be
In the written exam held at the end of the driving license course, 50 questions from Traffic, 40 from Engine, 30 questions from First Aid are asked. Passing grade in driver's license exams is 70 out of 100. A student who scores 70 and above in each course becomes successful and becomes eligible to take the driving exam. Calculate the scores according to the number of mistakes entered on the keyboard and write the program c that will show whether the student can take the steering test or not.
EXAMPLE:
Enter the traffic wrong number: 10
Enter the wrong number of engine: 10
Enter first aid wrong number: 10
-------------------------
Your traffic score: 80.00
Your engine score: 75.00
Your first aid score: 66.66
Sorry, you cannot take the steering test
arrow_forward
Table name: EMPLOYEE
EMP_NUM EMP_LNAME
215 Smith
216 Romero
217 Randall
218 Aarden
Table name: EMP_EDUC
EMP_NUM EDU_CODE EE_YEAR
2002
1991
1994
1989
2004
2002
1985
1992
2000
1990
2000
2005
1984
1995
215 84
215 HS
215 JC
216 B4
216 CDP
216 CNP
216 HS
217 HS
217 JC
218 B4
218 CDP
218 CNP
218 HS
218 M2
Table name: EDUCATION
EDU_CODE
EDU_DESCRIPTION
34
CDP
CNP
CPA
DR
HS
JC
M2
Bachelor's degree
Certified data Processing
Certified Network Professional
Certified Public Accountant
Earned Doctorate degree
Highschool diploma
Junior College degree
Master's degree
arrow_forward
using PHP and MYSQL create a web based PIZZA ORDERING SYSTEM
- The customer orders, the admin can see the order of the customer
- the admin will decide whether he/she will accept the order or not and the customer will be notified
- the customer can cancel order then the admin will be notified by the cancellation
arrow_forward
Set up
Order
[ single order )
Assign
seats
[ subscription )
Assign
chairs
Award bonus
Debit
Account
charge
credit card
Mail
packet
arrow_forward
https://www.coursehero.com/file/63707916/lab-3-ddbpdf/
arrow_forward
Create some SPARQL for the rdf graph below
arrow_forward
7
arrow_forward
7
arrow_forward
display SQL query with screenshots
arrow_forward
What is N-key rollover?
arrow_forward
ggfh
arrow_forward
The Khan Academy module - "Modular Arithmetic"
https://www.khanacademy.org/computing/computer-science/cryptography#modarithmetic (Links to an external site.)
What is modular arithmetic?
What is Congruence Modulo?
What is Congruence Relation?
arrow_forward
Write a SQL Statement that give the output below.
Profit
The profit for Product ID 183 (Asus GTX780TI-3GD5) is $118.08
The profit for Product ID 185 (MSI GTX 1080 TI LIGHTNING Z) is $185.63
The profit for Product ID 281 (Asus ROG-POSEIDON-GTX1080TI-P11G-GAMING) is $168.84
The profit for Product ID 216 (MSI GTX 1080 TI LIGHTNING X) is $121.84
The profit for Product ID 6 (Zotac ZT-P10810A-10P) is $147.64
The profit for Product ID 108 (MSI GAMING) is $96.81
The profit for Product ID 83 (Asus STRIX-GTX1080TI-O11G-GAMING) is $138.86
The profit for Product ID 215 (PNY VCOP4000-PB) is $105.89
arrow_forward
What Are The Requirement Of Page-table?
arrow_forward
Discussion of both recursive and non-recursive DNS queries, authoritative and root servers, and DNS records.
arrow_forward
What is swapping?
arrow_forward
EIGRP uses what algroithm to maintain rout information
arrow_forward
What precisely is the JDBC Driver?
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Related Questions
- https://www.bartleby.com/questions-and-answers/in-the-written-exam-held-at-the-end-of-the-driving-license-course-50-questions-from-traffic-40-from-/c0836364-9bad-48ea-990d-a1c9ad89f7be In the written exam held at the end of the driving license course, 50 questions from Traffic, 40 from Engine, 30 questions from First Aid are asked. Passing grade in driver's license exams is 70 out of 100. A student who scores 70 and above in each course becomes successful and becomes eligible to take the driving exam. Calculate the scores according to the number of mistakes entered on the keyboard and write the program c that will show whether the student can take the steering test or not. EXAMPLE: Enter the traffic wrong number: 10 Enter the wrong number of engine: 10 Enter first aid wrong number: 10 ------------------------- Your traffic score: 80.00 Your engine score: 75.00 Your first aid score: 66.66 Sorry, you cannot take the steering testarrow_forwardTable name: EMPLOYEE EMP_NUM EMP_LNAME 215 Smith 216 Romero 217 Randall 218 Aarden Table name: EMP_EDUC EMP_NUM EDU_CODE EE_YEAR 2002 1991 1994 1989 2004 2002 1985 1992 2000 1990 2000 2005 1984 1995 215 84 215 HS 215 JC 216 B4 216 CDP 216 CNP 216 HS 217 HS 217 JC 218 B4 218 CDP 218 CNP 218 HS 218 M2 Table name: EDUCATION EDU_CODE EDU_DESCRIPTION 34 CDP CNP CPA DR HS JC M2 Bachelor's degree Certified data Processing Certified Network Professional Certified Public Accountant Earned Doctorate degree Highschool diploma Junior College degree Master's degreearrow_forwardusing PHP and MYSQL create a web based PIZZA ORDERING SYSTEM - The customer orders, the admin can see the order of the customer - the admin will decide whether he/she will accept the order or not and the customer will be notified - the customer can cancel order then the admin will be notified by the cancellationarrow_forward
- What is N-key rollover?arrow_forwardggfharrow_forwardThe Khan Academy module - "Modular Arithmetic" https://www.khanacademy.org/computing/computer-science/cryptography#modarithmetic (Links to an external site.) What is modular arithmetic? What is Congruence Modulo? What is Congruence Relation?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage