SPREADSHEET SOFTWARE

Question 1

productivity application that is used for
calculation and organizing data using tables and
functions.

Answer 1

Spreadsheet Software / Microsoft Excel

Question 2

Started on ________ by__________ and
release the very first name of the
software which is ____________.

Answer 2

1978, Dan Bricklin, VISICALC

Question 3

Developed by __________ and added 5
Columns and 20 rows called _______.

Answer 3

Mitch Kapor, Lotus 123

Question 4

Adopted by Microsoft Corporation and
released their own version

Answer 4

Multi-Plan

Question 5

Single box on the worksheet

Answer 5

Cell

Question 6

Contains 2 or more cells

Answer 6

Range

Question 7

the vertical area of the
worksheet that contains letters

Answer 7

Column Heading

Question 8

these are the horizontal grid of
the worksheet started from no. 1 onwards.

Answer 8

Row Numbers

Question 9

This shows the inputted formula
on the cell

Answer 9

Formula Bar

Question 10

displays the name of the cell

Answer 10

Name Box

Question 11

individual sheets of the worksheet

Answer 11

Sheet Tab

Question 12

display the
entire worksheet

Answer 12

Vertical and Horizontal Scroll Bar

Question 13

Addition,
subtraction, multiplication, & division

Answer 13

Math Operations

Question 14

compute for the total values of a
range

Answer 14

Sum

Question 15

give the average of a range

Answer 15

Average

Question 16

function that is used to count
values of a range with criteria and
condition

Answer 16

Countif

Question 17

used to get the overall total
from a range using a condition

Answer 17

Sumif

Question 18

getting the average of a
values from a range using certain
condition or criteria

Answer 18

Averageif

Question 19

a logical test that display
certain condition or criteria

Answer 19

If function

Question 20

used to put
color markings on the cell or range
using rules and conditions

Answer 20

Conditional Formatting

Question 21

function that is used
to create dropdown

Answer 21

Data Validation

Question 22

used to retrieve a value
from a column number

Answer 22

Vlook-up