BBK99E1 PRACTICAL SHEET
CERTIFICATION SCRIPT 2026 QUESTIONS
WITH SOLUTIONS GRADED A+
◍ Create a custom header with the text Little Turtle Jewelry in the left section
and the current date code using Header & Footer Elements in the right
section..
Answer: Click the view tab on the ribbon. In the workbook views group,
click the page layout button. In the leftmost header, type "Little Turtle
Jewelry". In the right header, add current date by clicking the button up top
and click off (possibly click design and press current date)
◍ Sort the Pledges table in ascending order based on the Zip Code field..
Answer: Click the cell with the zip code. In the editing group on the home
tab, click the sort & filter button. On the menu, click custom sort. Click the
column sort by and click the arrow button and then click Zip code.
◍ Questioning techniques.
Answer: Repeat, verify, answer, verify
◍ Insert a 2D Line chart on the Projections sheet that charts the Total Project
Expenses from the range D23:F23 for the three years in the range D4:F4..
Answer: Select D23:F23 and then hold down control and select D4:F4.
Click the insert tab, under the Charts section look at the first column next to
recommended charts and click on the middle one (between the bars and
circle), under 2D click line (first one)
◍ Use the Format Painter to apply the styles from cell B29 to cells C29 and
D29..
Answer: Click cell B29. In the clipboard group, click the format painter
button. Click and drag cells C29 and D29.
, ◍ For the range N6:N24, add Line sparklines from the data range of K6:M24..
Answer: Select N6 and press insert. Press Line. for data range put K6:M24
and for location range put N6:N24 (Select cells. Drag the bottom corner.)
◍ Additional safety equipment for waterfront operations.
Answer: Swim fins, goggles/ mask, wet suits, rescue boards, rescue buoy,
safety water craft
◍ NAVMC 11627.
Answer: MCIWS Prerequisites / Pre-screening Checklist
◍ Add the following alternative text to the Salary Expenses chart and then
close any open panes: Salary Expenses for project director and part-time
staff.
Answer: Right click on the chart, click edit alt text, and type " Salary
Expenses for project director and part-time staff" ORRR--- Right click on
the chart. Click format chart area. Now click on alt text
◍ Requirements for underwater swimming.
Answer: Hyperventilation, water condition, supervision, safety equipment,
techniques of underwater swimming
◍ Add Olympics as a Title property to the workbook..
Answer: Click file, click info and then in properties (top right ish) add your
title "Olympics"
◍ On the Cash worksheet, in cell B22, enter a formula using relative cell
addresses that finds the difference between total income in cell B6 and total
expenses in cell B20..
Answer: =B6-B20
◍ NAVMC 11629.
Answer: Emergency response guidelines checklist
◍ Change the order of the Tuition and Cash worksheets so that the Tuition
sheet is first..
Answer: drag them
CERTIFICATION SCRIPT 2026 QUESTIONS
WITH SOLUTIONS GRADED A+
◍ Create a custom header with the text Little Turtle Jewelry in the left section
and the current date code using Header & Footer Elements in the right
section..
Answer: Click the view tab on the ribbon. In the workbook views group,
click the page layout button. In the leftmost header, type "Little Turtle
Jewelry". In the right header, add current date by clicking the button up top
and click off (possibly click design and press current date)
◍ Sort the Pledges table in ascending order based on the Zip Code field..
Answer: Click the cell with the zip code. In the editing group on the home
tab, click the sort & filter button. On the menu, click custom sort. Click the
column sort by and click the arrow button and then click Zip code.
◍ Questioning techniques.
Answer: Repeat, verify, answer, verify
◍ Insert a 2D Line chart on the Projections sheet that charts the Total Project
Expenses from the range D23:F23 for the three years in the range D4:F4..
Answer: Select D23:F23 and then hold down control and select D4:F4.
Click the insert tab, under the Charts section look at the first column next to
recommended charts and click on the middle one (between the bars and
circle), under 2D click line (first one)
◍ Use the Format Painter to apply the styles from cell B29 to cells C29 and
D29..
Answer: Click cell B29. In the clipboard group, click the format painter
button. Click and drag cells C29 and D29.
, ◍ For the range N6:N24, add Line sparklines from the data range of K6:M24..
Answer: Select N6 and press insert. Press Line. for data range put K6:M24
and for location range put N6:N24 (Select cells. Drag the bottom corner.)
◍ Additional safety equipment for waterfront operations.
Answer: Swim fins, goggles/ mask, wet suits, rescue boards, rescue buoy,
safety water craft
◍ NAVMC 11627.
Answer: MCIWS Prerequisites / Pre-screening Checklist
◍ Add the following alternative text to the Salary Expenses chart and then
close any open panes: Salary Expenses for project director and part-time
staff.
Answer: Right click on the chart, click edit alt text, and type " Salary
Expenses for project director and part-time staff" ORRR--- Right click on
the chart. Click format chart area. Now click on alt text
◍ Requirements for underwater swimming.
Answer: Hyperventilation, water condition, supervision, safety equipment,
techniques of underwater swimming
◍ Add Olympics as a Title property to the workbook..
Answer: Click file, click info and then in properties (top right ish) add your
title "Olympics"
◍ On the Cash worksheet, in cell B22, enter a formula using relative cell
addresses that finds the difference between total income in cell B6 and total
expenses in cell B20..
Answer: =B6-B20
◍ NAVMC 11629.
Answer: Emergency response guidelines checklist
◍ Change the order of the Tuition and Cash worksheets so that the Tuition
sheet is first..
Answer: drag them
