Test-1

In Google Sheets, to find the highest value in a range of cells:

• MIN()

• SUM()

• MAX()

• AVERAGE()

What is the primary purpose of a pivot table in spreadsheet software?

• Data entry

• Data validation

• Data analysis

• Chart creation

In a spreadsheet, what does the formula "=A1+B1" do?

• Multiplies the values in cells A1 and B1

• Divides the values in cells A1 and B1

• Subtracts the value in cell B1 from A1

• Adds the values in cells A1 and B1.

In G. Form what type of question allows to select multiple answer?

• Multiple Choice

• Checkbox

• Drop-down

• Linear Scale

Which sign is used in the formula to use absolute reference?

• =

• %

• $

• @

What happens when you link a Google Form to a Google Sheet?

• The responses get recorded in the sheet

• The form gets deleted

• The sheet converts into a form

• Nothing happens

function in Google Sheets is used for adding up a range of numbers:

• CONCATENATE

• VLOOKUP

• SUM

• INDEX

Which one of the following formulas are incorrect?

• =sum(A2:A10)

• =avg(A1:A10)

• =(A2-A7)

• =sum($A$1$0+B2)

How can you share a Google Form with others?

• By carrier pigeon

• By printing it out

• By sending a link

• By telepathy

In a spreadsheet, letters are used to represent:

• Rows

• Cells

• Blocks

• Columns