TLE 6 Q1 (ICT & ENTREPRENEURSHIP), THIRD SUMMATIVE TEST

TLE 6 Q1 (ICT & ENTREPRENEURSHIP), THIRD SUMMATIVE TEST

(1-10) Creates an online survey form (TLEIE6-0e-9) Processes online survey data (TLEIE6-0f-11) • Differentiate traditional survey to online survey

Multiple Select

Choose online survey tool that you can use in creating your survey form.

• Google Forms

• MS Forms

• SurveyMonkey

• Monkey

Multiple Choice

What survey that is easier and faster way to deliver surveys using online system?

• Google Forms

• Offline Survey

• Online Survey

• SurveyMonkey

Multiple Choice

In making online survey form, it is cheaper because there is a need to print the form.

• True

• False

Multiple Choice

One of the disadvantages of online survey is that respondents may ignore some questions.

• True

• False

Multiple Choice

Online survey systems can be run without computers

• True

• False

Multiple Choice

Online surveys are a quick and easy way of keeping track of data

• True

• False

Multiple Choice

Questionnaires and survey can be handed out to people or can be posted online

• True

• False

Multiple Choice

It is easier to do statistical analysis with online questionnaires.

• True

• False

Multiple Choice

The reseacher has no _______ over the respondents.

• answers

• control

• internet

• problems

Multiple Choice

Which of the following is NOT an option in sharing your online survey form?

• A.Sending through email

• B.Sharing on Facebook and Twitter

• C.Sharing using printed materials

• D.Using a direct link

TLE 6 Q1 (ICT & ENTREPRENEURSHIP), THIRD SUMMATIVE TEST

(11-20) Uses functions and formulas in an electronic spreadsheet tool to perform advanced calculations on numerical data (TLEIE6-0f- 12)

Multiple Choice

An Excel spreadsheet is primarily used for calculating which of the following options

• A. Data

• B. Finances

• C. Numbers

• D. All of the above

Multiple Choice

A worksheet range is a

• a. A command used for data modeling

• b. A range of values such as from 23 to 234

• c. A group of cells

• d. A group of worksheets

Multiple Choice

Which of the following is an absolute cell reference?

• a. !A!1

• b. $A$1

• c. #a#1

• d. A1

Multiple Choice

All formulas in Excel begin with the following symbol

• A. +

• B. =

• C. %

• D. #

Multiple Choice

Which button do you click to add up a series of numbers?

• a. The autosum button

• b. The Formula button

• c. The quicktotal button

• d. The total button

Multiple Select

What is the formula to ADD up A1 and B1?

• =SUM(A1:B1)

• =A1+B1

• A1+B1

• =ADD(A1:B1)

Multiple Choice

What is the formula to SUBTRACT A3 by B3?

• =SUM(A3:B3)

• =SUM(A3-B3)

• =A3-B3

• =A3SUDB3

Multiple Choice

What is the formula to MULTIPLY A3 by B3?

• =MULTIPLY(A3:B3)

• =A3xB3

• =A3*B3

• =A3TIMESB3

Multiple Choice

What is the formula to DIVIDE A4 by B4?

• =A4÷B4

• =A4DIVIDEB4

• =A4\B4

• =A4/B4

Multiple Choice

What is the difference between a formula and a function?

• Nothing. They are exactly the same.

• a formula uses words and functions use mathematical symbols.

• A formula is input entirely by the user using cell references and mathematical symbols. A function uses a predefined formula, usually in the form of a word.

• A formula starts with an = sign but a function doesn't.