SIMnet 2025/2026 Exam Questions with
Detailed Verified Answers (100% Correct
Answers) | Already Graded A+
Enter a formula in cell B9 to display the text from cell A9 in all upper case -
🧠 ANSWER ✔✔Formulas tab - function group - click the Text button. Select
UPPER from the list. Type A9 in the Text box, click ok.
Using cell refrences enter a formula in B6 to calculate monthly payments
for the loan described in this worksheet. Omit the optional arguments. Use
a negative value for the Pv argument - 🧠 ANSWER ✔✔Formulas tab -
function l group -
click finnanical button & click PMT.
Enter B3/12 in rate argument box.
B4 in the Nper box.
-B2 in PV box
click ok
COPYRIGHT©NINJANERD 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
1
STATEMENT. ALL RIGHTS RESERVED
,In cell E15, enter a formula using a count function to count the numbers in
the cost column (E2:E14) - 🧠 ANSWER ✔✔Formulas tab - Function library
group
click more functions button
point to statistical and select COUNT
click and drag to select cells in E2:E14
Use Formula AutoComplete to enter a SUM function in cell B7 to calculate
the total of cells B2:B6 - 🧠 ANSWER ✔✔Type = in B7
Type SU
double click SUM
click and drag to select cells B2 - B6
Enter a formula in cell B7 to display the text from cell A7 with only the first
letter of each word in upper case. - 🧠 ANSWER ✔✔Formulas Ribbon Tab
Function Library Ribbon click the Text button.
In the Text menu click PROPER Inside the Function Arguments dialog, you
typed A7 in the Text input, clicked the OK button.
COPYRIGHT©NINJANERD 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
2
STATEMENT. ALL RIGHTS RESERVED
, Edit the CurrentSalaries named range so it refers to cells B2:B6 on the
Salaries worksheet. Close the Name Manager when you are finished. - 🧠
ANSWER ✔✔Formulas tab - defined names group
Name manager button
Click current salaries
Click check mark to left to accept changes
ok
Enter a formula in cell C2 to calculate next year's salary increase by
multiplying the previous year's salary (cell B2) times the Cost of Living
Adjustment (cell named COLA). Use the cell name in the formula. - 🧠
ANSWER ✔✔double click cell C2
Type =B2*
then type c
double click COLA and press enter
Use the Function Arguments dialog to enter a SUM function in cell B7 to
calculate the total of cells B2:B6. - 🧠 ANSWER ✔✔Formulas tab - functional
l group
COPYRIGHT©NINJANERD 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
3
STATEMENT. ALL RIGHTS RESERVED
Detailed Verified Answers (100% Correct
Answers) | Already Graded A+
Enter a formula in cell B9 to display the text from cell A9 in all upper case -
🧠 ANSWER ✔✔Formulas tab - function group - click the Text button. Select
UPPER from the list. Type A9 in the Text box, click ok.
Using cell refrences enter a formula in B6 to calculate monthly payments
for the loan described in this worksheet. Omit the optional arguments. Use
a negative value for the Pv argument - 🧠 ANSWER ✔✔Formulas tab -
function l group -
click finnanical button & click PMT.
Enter B3/12 in rate argument box.
B4 in the Nper box.
-B2 in PV box
click ok
COPYRIGHT©NINJANERD 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
1
STATEMENT. ALL RIGHTS RESERVED
,In cell E15, enter a formula using a count function to count the numbers in
the cost column (E2:E14) - 🧠 ANSWER ✔✔Formulas tab - Function library
group
click more functions button
point to statistical and select COUNT
click and drag to select cells in E2:E14
Use Formula AutoComplete to enter a SUM function in cell B7 to calculate
the total of cells B2:B6 - 🧠 ANSWER ✔✔Type = in B7
Type SU
double click SUM
click and drag to select cells B2 - B6
Enter a formula in cell B7 to display the text from cell A7 with only the first
letter of each word in upper case. - 🧠 ANSWER ✔✔Formulas Ribbon Tab
Function Library Ribbon click the Text button.
In the Text menu click PROPER Inside the Function Arguments dialog, you
typed A7 in the Text input, clicked the OK button.
COPYRIGHT©NINJANERD 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
2
STATEMENT. ALL RIGHTS RESERVED
, Edit the CurrentSalaries named range so it refers to cells B2:B6 on the
Salaries worksheet. Close the Name Manager when you are finished. - 🧠
ANSWER ✔✔Formulas tab - defined names group
Name manager button
Click current salaries
Click check mark to left to accept changes
ok
Enter a formula in cell C2 to calculate next year's salary increase by
multiplying the previous year's salary (cell B2) times the Cost of Living
Adjustment (cell named COLA). Use the cell name in the formula. - 🧠
ANSWER ✔✔double click cell C2
Type =B2*
then type c
double click COLA and press enter
Use the Function Arguments dialog to enter a SUM function in cell B7 to
calculate the total of cells B2:B6. - 🧠 ANSWER ✔✔Formulas tab - functional
l group
COPYRIGHT©NINJANERD 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
3
STATEMENT. ALL RIGHTS RESERVED
