General knowledge in IT

You have already made a presentation of 100 slides and you want to add the Mount Carmel SHS logo to each slide; what is the best way to achieve this?

• Create a template with the Mount Carmel SHS logo

• Use find and replace

• Insert the logo on each slide

• Insert the logo in the slide master

In PowerPoint, you can set your slideshow to run automatically and change slides at predefined timing.

• True

• False

In Excel, what is the intersection of a row and a column on a worksheet called?

• column

• value

• address

• cell

Company A is looking into four potential projects and will accept them if the IRR is 10% or above, as shown in cell E2. What is the formula used in cell C2, which can be copied down to cell C3 through C5, to generate the results shown?

• =IF(B2>=E2, "Accept","Reject")

• =IF(B2>=$E2, "Accept","Reject")

• =IF(B2>=E$2, "Accept","Reject")

• =IF(B2>=E$2, Accept,Reject)

• =IF(B2>=$E$2, "Accept","Reject")

Excel documents are stored as files called

• Workgroups

• Worktables

• Worksheets

• Workforce

After copying a number of cells in Excel, how can you paste them in another sheet_

• Press Ctrl + v

• Press Enter

• Right-click and click Paste

• All of the above.

In Excel, when you copy the contents of cells, it copies the formulas as well. To prevent this, and copy only the text, you have to use

• Ctrl + v

• Paste special

• The $ symbol

• A new sheet

What symbol is used before a number to make it a label?

• "

• =

• _

• '

Concatenation of text can be done using

• '

• !

• #

• &

The name Rate has been given to cell B1. Cell B4 contains the formula =$A4*Rate. if you copy this formula to C4, what will the outcome be?

• 0

• 135

• 1522.5

• 1350