CSEC IT JAN 2024 as MC PT2

Based on the pictureSelect the correct formatting feature applied to row 2

• Underline formatting applied to row 2
• No formatting applied to row 2
• Merge and Center applied to row 2

• Italic formatting applied to row 2

Based on the picture Select the type of cell referencing used if the formula E4/$E$11 was inserted in cell F4 on cell E11

• Circular referencing
• Mixed referencing (relative and absolute)
• Relative referencing

• Absolute referencing

Based on the picture Select correct function you would use in cell G8 to insert "GOOD" if the total export for the three years is more than US300 million or "POOR" if it is less

• =IF(E8=300,"GOOD","POOR")

• =IF(E8>300,"GOOD","POOR")

• =IF(E8<300,"GOOD","POOR")

• =IF(E8>500,"GOOD","POOR")

Based on the picture Select the correct Chart type shown

• Bar Chart
• Pie Chart
• Line Graph
• Histogram

Based on the picture Select ONE chart feature missing

• Chart title
• Legend for chart segments
• Data source information
• Axis labels

Based on the picture Select TWO data label formats which have been applied to the chart

• Bold

• Total values
• Centered

• Month labels

Based on the Picture Select the correct construct used :

• Repetition

• Selection

• Sequence

• None of the above

Based on the Picture Select the line where a relational operator is used

• Line 3
• Line 6
• Line 5
• Line 11

Based on the Picture Select the logical operator used

• Greater than - Less than and equal to

• Less than - Less than and equal to

• Greater than - Greater than and equal to

• Greater than - Less than

Based on the Picture the picture is the following was entered:
"John" $175 000

"Mary" $ 400 000
What would the tax for each be:

• $120,000 and $20,000

• $20,000 and $120,000

• $75,000 each

• $75,000 and $120,000