1.\$B\$11

2. \$B11

3.\$(B)11

4.=B11

1.65536

2.18730

3.50000

4.32364

## Question: ``` In Google sheet, columns are represented by ____. ```

1.Numbers

2.Letters

3.Letters and Numbers

4.Cells

1.AVERAGE

2.AVERAGEIF

3.AVERAGEIFS

4.AM

1.Cells group

2.Multi cells

3.Collection

4.Cell range

1.Workbook

2.Document

4.Worksheet

1.Underscore (_)

2.Dollar (\$)

3. Equal (=)

4.Column (:)

1.Yes

2.No

3.Error

4.None of these

## Question: `Correct steps to group rows or columns in Google sheets.`

1.Data > Group rows or Group columns

2.Format > Group rows or Group columns

3.Insert > Group rows or Group columns

4.None of These

## Question: ```Google sheet saves the changes automatically? ```

1.Yes

2.No

3.Error

4.All of the above

1.Arguments

2.Formulas

3.Functions

4.Subfunctions

1.Automatic

2.Number

3.Currency

4.Time

1.Ctrl + Alt + R

2.Ctrl + Alt + H

3.Ctrl + Alt + 9

4.Ctrl + Alt + 0

## Question: ```Shortcut command to insert a link on selected text/cell? ```

1.Ctrl + k

2.Ctrl + h

3.Ctrl + Alt + k

4.None of the above

## Question: ```Shortcut command to show all formulas in Google sheet? ```

1.Ctrl + F

2.Ctrl + Shift + F

3.Ctrl + &

4.Ctrl + ~

## Question: ```Shortcut for group rows or columns in Google sheet? ```

1.Alt + Shift + Right Arrow

2.Alt + Shift + Left Arrow

3.Alt + Shift + Down Arrow

4.Alt + Shift + Up Arrow

## Question: `Shortcut for ungrouping rows or columns in Google sheet?`

1.Alt + Shift + Right Arrow

2.Alt + Shift + Left Arrow

3.Alt + Shift + Down Arrow

4.Alt + Shift + Up Arrow

## Question: `Shortcut to select current column in Google sheet?`

1.CTRL + Space

2.ALT + Space

3.SHIFT + Space

4. CTRL + SHIFT + Space

## Question: ```Shortcut to select the current row in Google sheet? ```

1.CTRL + Space

2.ALT + Space

3.SHIFT + Space

4.CTRL + SHIFT + Space

1.Sort

2.Sort Range

3.Sort Data

4.Data Sort

## Question: ```Which command is used to clear the formatting of selected cells in Google sheets? ```

1.Clear

2.Clear all

3.Clear Styles

4.Clear Formatting

1.Filters

2.Reporting

3.Sorting

4.Statics

1.Automatic

2.Number

3.Currency

4.Time

2.SUM

3.SUMIF

4.SUMRANGE

2.SUM

3.SUMIF

4.SUMIFS

2.SUM

3.SUMIF

4.SUMRANGE

1.AVERAGE

2.AVERAGEIF

3.AVERAGEIFS

4.AM

1.AVERAGE

2.AVERAGEIF

3.AVERAGEIFS

4.AM

## Question: ```Which function is used to find the most common value(s)? ```

1.SNGL()

2.MULT()

3.Both A and B

4.None of the above

1.AND()

2.OR()

3.Both A and B

4.NOT()

1.B2

2.#B2

3.B:2

4.\$B\$2

1.Underscore (_)

2.Dollar (\$)

3.Equal (=)

4.Column (:)

1.^

2. *

3.@

4./

1.DATE()

2.TODAY()

3.NOW()

4.GETDATE()

1.DATE()

2.TODAY()

3.NOW()

4.GETDATE()

## More MCQS

##### Olete Team
Online Exam TestTop Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on Online Exam Testwebsite is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!