SIMNET EXCEL 2025/2026 Exam 3
Comprehensive Questions and
Verified Answers | Accurate Solutions
| Get it 100% Correct!! | Already
Graded A+
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
If your formula includes a syntax error, Excel displays an error message
or returns an error code as the formula result.
True
In Excel, you can create nested IF functions that allow for more than
one logical test.
True
Pressing Shift+F3 opens the insert Function dialog box.
True
Range names describe the cell or purpose of a group of cells and make
it easier to interpret a formula.
True
The AVERAGE function calculates an average by adding cell values
together and dividing the total of the values by 4.
False
The IF function calculates loan payment amounts.
False
The PMT function assumes the borrower makes regular payments and
the loan has a constant interest rate.
True
Comprehensive Questions and
Verified Answers | Accurate Solutions
| Get it 100% Correct!! | Already
Graded A+
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
If your formula includes a syntax error, Excel displays an error message
or returns an error code as the formula result.
True
In Excel, you can create nested IF functions that allow for more than
one logical test.
True
Pressing Shift+F3 opens the insert Function dialog box.
True
Range names describe the cell or purpose of a group of cells and make
it easier to interpret a formula.
True
The AVERAGE function calculates an average by adding cell values
together and dividing the total of the values by 4.
False
The IF function calculates loan payment amounts.
False
The PMT function assumes the borrower makes regular payments and
the loan has a constant interest rate.
True
