Digital Technology

What type of document is the Microsoft Excel Program?

• presentation

• word processing

• spreadsheet

• none of the above

In digital technology, a browser is...

• software that allows you to search the files on a computer.

• software that allows a person to access and search the internet.

• a person who likes to look at items in a store.

• hardware that stores data.

The spreadsheet software that you used to develop your digital reading log was called

(a)  

The co-ordinates of the cell highlighted in yellow are...

• 5D

• A1

• D5

• 4D

What does ICT stand for...

• Internet and Computer Testing

• Information and Computer Technologies

• Information and Communication Technologies

• Internet and Cable Television

The feature in Excel that allows you to change the colour of the text and cells depending on the number or time that is typed into a cell is called (a)   formatting

What is the name of the function in Excel that allows data in different cells to be added together.

• AVERAGE

• SUM

• MAX

• MIN

Which tool in an Excel spreadsheet allows a user to enter a drop down list or a pop up message in a cell?

• data validation

• insert function

• conditional formatting

Which of the following represents the correct way to write a SUM function in Excel?

• SUM(A1:A3)

• =SUM(1A:3A)

• +SUM(A1;A3)

• =SUM(A1:A3)

In which tab would you find condition formatting?

• Data

• Home

• Formulas

• Insert