Exam (elaborations)
CSE EXAM 1 QUESTIONS AND ANSWERS
- Course
- Institution
CSE EXAM 1 QUESTIONS AND ANSWERS
[Show more]
Content preview
CSE EXAM 1 QUESTIONS AND ANSWERSWhen you change the format of how a cell is displayed, it doesn't affect the actual value
stored by the computer.
True
False - Answers-true
What cells are contained in the range D4:D8
D5, d6, d7
None of the choices are correct
D4, d8
D4, d5, d6, d7, d8 - Answers-d4, d5, d6, d7, d8
When writing formulas for spreadsheets in Excel, you do NOT need to pay attention to
or worry about the order of precedence.
True
False - Answers-False
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 - Answers-False
Why is it important to use cell references in functions or formulas in Excel?
It greatly improves the readability, maintenance and reliability of the spreadsheet
The formula or function won't work otherwise
It is required when multiple cells are used in a formula or function
You won't get accurate results otherwise
Cell referencing is a requirement in all formulas - Answers-it greatly improves the
readability, maintenance and reliability of the spreadsheet
The relational operators (>, <, =, >=, <=, <>) have a lower order of precedence than
addition and subtraction in Excel formulas.
True
False - Answers-True
, The cell containing the formula =4*12-2 > 100/2+2 will evaluate to TRUE.
True
False - Answers-False
Which of the following is NOT true of the basic features of Excel?
Rows are named by numbers
Columns are named by letters
The intersection of a row and column is referred to as a cell
The cell address first lists the row name and then the column name - Answers-The cell
address first lists the row name and then the column name
How do the AVERAGE( ), MIN( ), MAX( ), COUNT( ), and SUM( ) functions handle cells
in a range that are blank or contain labels?
They are ignored
They are treated the same as any arithmetic values
It depends on the cell format
It doesn't matter what is in the cell
It depends on the size of the range used - Answers-they are ignored
What is the difference between a formula and a function in excel?
Functions are predefined formulas that perform specific calculations
Functions never use numbers
There is no difference
Formulas are user defined functions that perform various calculations
Formulas only use numbers - Answers-functions are predefined formulas that perform
specific calculations
What is a possible cause of the error in cell A2 in Sheet1 containing the formula
=SUM(10, Sheet2!F4) if the error shown is #REF! ?
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller GEEKA. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75632 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now