SIMnet Excel Exam Questions and Correct
Answers| Latest Update
Which of the following keystroke combinations completes a formula?
Ctrl+Enter
The TODAY function inserts the current date and time in a cell.
false
By default, text and values are oriented horizontally from left to right, but you can change text
orientation to display text vertically or at an angle.
true
Which of the following functions retrieves a value from a range or table of cells located in
another area of the worksheet?
LOOKUP
The cell address $R$6 is an absolute cell reference.
,true
which one equals 11
3+2*4
which of the following displays the result of a formula?
cell
in excel, a worksheet is also referred to as a spreadsheet or a sheet and you can use these terms
interchangeably
true
to insert a new worksheet in a workbook, press Shift+F11
true
which of the following shows the correct syntax for the IF function?
=IF(C5<=20,7,10)
a cell displays the result of the formula and the formula bar displays the formula
true
,column and row references do not change when you copy a relative cell address
false
excel calculates addition operations before operations within parentheses are performed
false
which of the following characters must always start a function
=
an IF function can test if monthly revenue is above or below average and displays "yes" or "no"
in the cell.
true
excel 2016 has over 16,000 columns and over 1 million rows.
true
A circular reference occurs when the formula references the wrong cell address.
False
, Arguments are the pieces of information within parentheses in functions that determine what
value of a function returns.
True
AutoCalculate allows you to view totals, averages, or other statistical information without
creating a formula.
True
Column and row references do not change when you copy a relative cell address.
False
Excel calculates addition operations before operations within parentheses are performed.
False
Excel has 240 date and time functions.
False
Excel treats any empty cell in an array as if it has a value of 1.
False
Answers| Latest Update
Which of the following keystroke combinations completes a formula?
Ctrl+Enter
The TODAY function inserts the current date and time in a cell.
false
By default, text and values are oriented horizontally from left to right, but you can change text
orientation to display text vertically or at an angle.
true
Which of the following functions retrieves a value from a range or table of cells located in
another area of the worksheet?
LOOKUP
The cell address $R$6 is an absolute cell reference.
,true
which one equals 11
3+2*4
which of the following displays the result of a formula?
cell
in excel, a worksheet is also referred to as a spreadsheet or a sheet and you can use these terms
interchangeably
true
to insert a new worksheet in a workbook, press Shift+F11
true
which of the following shows the correct syntax for the IF function?
=IF(C5<=20,7,10)
a cell displays the result of the formula and the formula bar displays the formula
true
,column and row references do not change when you copy a relative cell address
false
excel calculates addition operations before operations within parentheses are performed
false
which of the following characters must always start a function
=
an IF function can test if monthly revenue is above or below average and displays "yes" or "no"
in the cell.
true
excel 2016 has over 16,000 columns and over 1 million rows.
true
A circular reference occurs when the formula references the wrong cell address.
False
, Arguments are the pieces of information within parentheses in functions that determine what
value of a function returns.
True
AutoCalculate allows you to view totals, averages, or other statistical information without
creating a formula.
True
Column and row references do not change when you copy a relative cell address.
False
Excel calculates addition operations before operations within parentheses are performed.
False
Excel has 240 date and time functions.
False
Excel treats any empty cell in an array as if it has a value of 1.
False
