Analyzing Information using ICT

•What keys do we press when we want to move to another cell?

• Ctrl+Home

• Scroll Bar

• Ctrl+End

• Arrow Keys

A function that displays the least or smallest value that is in a range of cells.

• MIN

• MAX

• COUNT

• SUM

What is the most popular spreadsheet program that we use as electronic spreadsheet?

• Spreadsheet

• Lotus 123

• Microsoft Excel

• Google Sheet

To calculate numerical data in spreadsheet, we always start with an _______________.

The _______________ function displays the total number of values in a range of cells.

It is a place used to perform calculation on values entered in the spreadsheet including addition, subtraction, multiplication and division.

• Tabular Bar

• Scroll Bar

• Formula Bar

• Status Bar

Looks for a specified value in a column and returns the value from another column in the same row.

• MIN

• MAX

• SUM

• VLOOKUP

If you want to know the total score of your students in quizzes. What function key you will use?