ICT year5

The intersection of a row and a column is called

• table

• cell

• spreadsheet

• workbook

The vertical aspect of a table is known as the___.

• cell

• row

• column

• file

In Ms Excel, we start with____ sign when applying a formula.

• colon

• left bracket

• equal

• plus

The cell address for Gross Pay is____.

• I4

• 4I

• =I4

• =4I

The formula to get the total for column cost of sales is____.

• =sum(D3:D10)

• =sum(D3:F10)

• =sum(C3:E3)

• =sum(C3:E10)

What is the correct formula to get the maximum number ?

• =min(1st cell : last cell)

• =average(1st cell : last cell)

• =mode(1st cell : last cell)

• =max(1st cell : last cell)

The horizontal aspect of a table is called____.

• Row

• Cell

• Column

• Sheet

How do we encrypt our sheet with password?

• Home>Info>Protect workbook>Encrypt with password

• File>Info>Protect workbook>Encrypt with password

• Insert>Info>Protect workbook>Encrypt with password

• Formula>Info>Protect workbook>Encrypt with password

How do we merge cells?

• On the Insert tab>Highlight cells>Click on merge cells

• On the Formulas tab>Highlight cells>Click on merge cells

• On the Home tab>Highlight cells>Click on merge cells

• On the Data tab>Highlight cells>Click on merge cells

How we create a table in Ms Excel application?

• On the Home tab>Highlight the cells>Click on all borders

• On the Insert tab>Highlight the cells>Click on all borders

• On the Formula tab>Highlight the cells>Click on all borders

• On the Data tab>Highlight the cells>Click on all borders