Google Sheet Basics

What is Ctrl + V in keyboard shortcut of windows?

• Copy Text

• Paste Text

• Replace Text

• Select All Text

What is the keyboard shortcut in windows to cop text/cell?

• Ctrl + A

• Ctrl + C

• Ctrl + H

• Ctri + V

A group cells called a ___?

• multicell

• cell range

• cell cluster

• chart

Which of the following features allows you to narrow down the data in yout work sheets?

• Relative references

• Merge Cells

• Filters

• Sorting

Why would you want to freeze rows in your spreadsheet?

• To modify only the frozen rows.

• To prevent the rows from being edited by collaborators.

• To limit the data that can ve entered in the frozen row.

• To scroll throug the spreadsheet while continuing to see the frozen rows.

Which of the following symbols are recognized as mathematical operators within Google Sheets?

• + * / ^

• + x / ^

• + - x /

• + x @ -

Which function would you use to add the values of several cells?

• Total

• Max

• Sum

• Average

Which of the following is an absolute cell reference?

• $A$S

• A:2

• #A2

• A2

Most Functions contain one or more ____ in parentheses?

• arguments

• sub-functions

• plus signs

• sentences

Formulas should always begin with a ___?

• header

• equals sign

• dollar sign

• Hashtag