Computer Quiz

A spreadsheet is a piece of software made up of________ and _______

• formula and data

• rows and rows

• rows and column

• column and column

Spreadsheets are used by people and companies all around the world to.......

• Play games

• Create a picture

• Store data and make calculation

• Only calculation

Vertical lines of cells in a spreadsheet is called_______ and

Horizontal lines of cells in a spreadsheet is called______

• Rows and columns

• Columns and Rows

• Numeric and Text

• Text and Numeric

If B2=45, C2=10, D2=40. What is the formula of SUM

• (B2+D2)

• =(B2:D2)

• =SUM(B2:D2)

• =SUM(B2+D2)

Choose the correct Answer as given picture.

• This is cell D5

  (Row D column 5)

• This is cell 5D

  (Column D Row 5)

• This is cell D5

  (Row 5 Column D)

• This is cell D5

  (Column D Row 5)

To make a copy of something, for example. a formula.

• Replicate

• Data

• Formula

• Copy

What is the formula of MIN. function

• MIN(A1:G7)

• MAX(A1:G7)

• =MIN(A1:G7)

• =MIN(A1+G7)

______ is calculated by adding up all the values, then dividing by number of value

• Percent%

• Maximum

• Addition

• Average

Write the formula of Addition of all fruits price? also calculate the value.

• =SUM(C3:C5)

  104

• SUM(C3:C5)

  120

• =SUM(C3:C5)

  102

• =SUM(C3+C5)

  102

A set of instruction that are followed when a key word is entered.

• Function

• Data

• Formula

• none of these