SAMs Final Exam 2025 Questions and
Answers
Add the Sheet Name header element to the left header section, and the text Page_
followed by the Page Number header element to the right header section. Click cell
F1 to deselect the header to view the results. - ....ANSWER☑️☑️...-
B9 select
=ROUND and decrease decimal place (k9)
1.) select cell F4.
2.) on the formula bar insert the function button. (fx) - ....ANSWER☑️☑️...-B9 select
=ROUND and decrease decimal place (k9)
1.) select cell F4.
2.) on the formula bar insert the function button. (fx)
3.) click the "Or select a category arrow"
4.) click logical
5.) click IF
6.) click ok.
7.) type E4>0. In the logical test box.
8.) press tab
9.) type YES in the "value_if_true box."
10.) Press tab.
11.) type NO in the "Value_if_False box."
FOR STUDY PURPOSES ONLY ©️ 2025 ALL RIGHTS RESERVED 1
, In cell E4, enter a formula using relative cell references that multiplies cell C4 by cell
D4, - ....ANSWER☑️☑️...-Click E4
type = (equal sign).
select the cells
Enter a formula in cell C5 that divides the value in cell B5 to by the value in cell B15,
using an absolute cell reference to cell B15. - ....ANSWER☑️☑️...-=B5/$B15
Enter a formula in cell E4, using the IF function, that
returns a value of YES if cell D4 is greater than 25, and a value of NO if cell D4 is 25
or less. - ....ANSWER☑️☑️...-Financial >if functions
In cell D5, create a formula using the VLOOKUP function to determine the cost per
participant for the Game Room workshop based on the Workshop ID in cell A5. Use
range H4:111 as the lookup table and the cost per participant listed in column 2 of
the lookup table. Do not enter a value
for the optional range lookup argument. - ....ANSWER☑️☑️...-=VLookup
1.) select cell E5
2.) type =VLOOKUP(C5,H4:I8,2) in cell E5.
3.) press enter.
Move the Clustered Bar chart to a chart sheet; accept the default chart sheet name, -
....ANSWER☑️☑️...-Click anywhere in the chart. Under Chart Tools, on the Design
tab, in the Location group, click Move Chart. Do one of the following: To move the
chart to a new worksheet, click New sheet, and then in the New sheet box, type a
name for the worksheet.
Add a chart title element to the chart in the default
FOR STUDY PURPOSES ONLY ©️ 2025 ALL RIGHTS RESERVED 2
Answers
Add the Sheet Name header element to the left header section, and the text Page_
followed by the Page Number header element to the right header section. Click cell
F1 to deselect the header to view the results. - ....ANSWER☑️☑️...-
B9 select
=ROUND and decrease decimal place (k9)
1.) select cell F4.
2.) on the formula bar insert the function button. (fx) - ....ANSWER☑️☑️...-B9 select
=ROUND and decrease decimal place (k9)
1.) select cell F4.
2.) on the formula bar insert the function button. (fx)
3.) click the "Or select a category arrow"
4.) click logical
5.) click IF
6.) click ok.
7.) type E4>0. In the logical test box.
8.) press tab
9.) type YES in the "value_if_true box."
10.) Press tab.
11.) type NO in the "Value_if_False box."
FOR STUDY PURPOSES ONLY ©️ 2025 ALL RIGHTS RESERVED 1
, In cell E4, enter a formula using relative cell references that multiplies cell C4 by cell
D4, - ....ANSWER☑️☑️...-Click E4
type = (equal sign).
select the cells
Enter a formula in cell C5 that divides the value in cell B5 to by the value in cell B15,
using an absolute cell reference to cell B15. - ....ANSWER☑️☑️...-=B5/$B15
Enter a formula in cell E4, using the IF function, that
returns a value of YES if cell D4 is greater than 25, and a value of NO if cell D4 is 25
or less. - ....ANSWER☑️☑️...-Financial >if functions
In cell D5, create a formula using the VLOOKUP function to determine the cost per
participant for the Game Room workshop based on the Workshop ID in cell A5. Use
range H4:111 as the lookup table and the cost per participant listed in column 2 of
the lookup table. Do not enter a value
for the optional range lookup argument. - ....ANSWER☑️☑️...-=VLookup
1.) select cell E5
2.) type =VLOOKUP(C5,H4:I8,2) in cell E5.
3.) press enter.
Move the Clustered Bar chart to a chart sheet; accept the default chart sheet name, -
....ANSWER☑️☑️...-Click anywhere in the chart. Under Chart Tools, on the Design
tab, in the Location group, click Move Chart. Do one of the following: To move the
chart to a new worksheet, click New sheet, and then in the New sheet box, type a
name for the worksheet.
Add a chart title element to the chart in the default
FOR STUDY PURPOSES ONLY ©️ 2025 ALL RIGHTS RESERVED 2
