CSE EXAM 1 QUESTIONS AND ANSWERS
When 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! ?
When 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! ?
