Google%20Wave/Google%20Sheets%20MCQs Sample Test,Sample questions

Question:
 If the tax (any value) reference is B11, and you do not want the fill function to change this, so we lock it using ____.

1.$B$11

2. $B11

3.$(B)11

4.=B11

Posted Date:-2022-11-29 17:20:22


Question:
 In a single cell, the maximum limit of the characters is ____.





1.65536

2.18730

3.50000

4.32364

Posted Date:-2022-11-30 06:11:57


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




1.Numbers

2.Letters

3.Letters and Numbers

4.Cells

Posted Date:-2022-11-29 17:17:35


Question:
 Which function is used to find the average (arithmetic mean)?




1.AVERAGE

2.AVERAGEIF

3.AVERAGEIFS

4.AM

Posted Date:-2022-11-30 06:23:16


Question:
A group of cells is known as ___ in Google Sheets.

1.Cells group

2.Multi cells

3.Collection

4.Cell range

Posted Date:-2022-11-29 15:08:56


Question:
A single Google sheet is called ____.

1.Workbook

2.Document

3.Google Shareware

4.Worksheet

Posted Date:-2022-11-29 15:06:50


Question:
Any formula starts with the ___ sign.

1.Underscore (_)

2.Dollar ($)

3. Equal (=)

4.Column (:)

Posted Date:-2022-11-29 17:16:50


Question:
Can we freeze header rows and columns in Google sheets?

1.Yes

2.No

3.Error

4.None of these

Posted Date:-2022-11-30 06:32:02


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

Posted Date:-2022-11-30 06:31:20


Question:
Google sheet saves the changes automatically?


1.Yes

2.No

3.Error

4.All of the above

Posted Date:-2022-11-29 15:07:38


Question:
In Google sheets, most of the functions contain one or more ____ in parentheses.




1.Arguments

2.Formulas

3.Functions

4.Subfunctions

Posted Date:-2022-11-30 06:13:45


Question:
In Google sheets, the default number format is ___.

1.Automatic

2.Number

3.Currency

4.Time

Posted Date:-2022-11-30 06:18:04


Question:
Shortcut command to hide rows in Google sheet?

1.Ctrl + Alt + R

2.Ctrl + Alt + H

3.Ctrl + Alt + 9

4.Ctrl + Alt + 0

Posted Date:-2022-11-30 06:38:34


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

Posted Date:-2022-11-30 06:39:38


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

1.Ctrl + F

2.Ctrl + Shift + F

3.Ctrl + &

4.Ctrl + ~

Posted Date:-2022-11-30 06:37:23


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

Posted Date:-2022-11-30 06:35:06


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

Posted Date:-2022-11-30 06:36:11


Question:
Shortcut to select current column in Google sheet?

1.CTRL + Space

2.ALT + Space

3.SHIFT + Space

4. CTRL + SHIFT + Space

Posted Date:-2022-11-30 06:33:29


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


1.CTRL + Space

2.ALT + Space

3.SHIFT + Space

4.CTRL + SHIFT + Space

Posted Date:-2022-11-30 06:34:01


Question:
The ____ command in Google Sheets allows for more complex sorting of data.

1.Sort

2.Sort Range

3.Sort Data

4.Data Sort

Posted Date:-2022-11-30 06:26:25


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

Posted Date:-2022-11-30 06:17:14


Question:
Which feature allows you to narrow down the data in your worksheet?




1.Filters

2.Reporting

3.Sorting

4.Statics

Posted Date:-2022-11-30 06:15:00


Question:
Which format represents the numbers with the dollars ($) sign? [For example, $1,000.00]





1.Automatic

2.Number

3.Currency

4.Time

Posted Date:-2022-11-30 06:18:53


Question:
Which function adds up numbers in a range in Google sheets?





1.ADD

2.SUM

3.SUMIF

4.SUMRANGE

Posted Date:-2022-11-30 06:19:34


Question:
Which function calculates the sum of a range based on one or more true or false conditions?




1.ADD

2.SUM

3.SUMIF

4.SUMIFS

Posted Date:-2022-11-30 06:21:17


Question:
Which function calculates the sum of values in a range based on a true or false condition?




1.ADD

2.SUM

3.SUMIF

4.SUMRANGE

Posted Date:-2022-11-30 06:20:36


Question:
Which function is used to find the average (arithmetic mean) of a range based on a true or false condition?

1.AVERAGE

2.AVERAGEIF

3.AVERAGEIFS

4.AM

Posted Date:-2022-11-30 06:24:09


Question:
Which function is used to find the average (arithmetic mean) of a range based on one or more true or false conditions?

1.AVERAGE

2.AVERAGEIF

3.AVERAGEIFS

4.AM

Posted Date:-2022-11-30 06:25:19


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

Posted Date:-2022-11-30 06:27:07


Question:
Which function(s) is/are used to check combinations of two or more conditions in Google sheets?


1.AND()

2.OR()

3.Both A and B

4.NOT()

Posted Date:-2022-11-30 06:22:16


Question:
Which of the following is an absolute cell reference?



1.B2

2.#B2

3.B:2

4.$B$2

Posted Date:-2022-11-29 18:40:24


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

1.Underscore (_)

2.Dollar ($)

3.Equal (=)

4.Column (:)

Posted Date:-2022-11-29 17:19:06


Question:
Which symbol is not recognized as mathematical operators within Google Sheets?


1.^

2. *

3.@

4./

Posted Date:-2022-11-30 06:16:26


Question:
___ function returns the current date and time as a date value.

1.DATE()

2.TODAY()

3.NOW()

4.GETDATE()

Posted Date:-2022-11-30 06:30:20


Question:
____ function returns the current date as a date value.

1.DATE()

2.TODAY()

3.NOW()

4.GETDATE()

Posted Date:-2022-11-30 06:27:57


More MCQS

  1. Google Sheets MCQs
  2. Google Chrome Multiple-Choice Questions (MCQs)
  3. Google AdWords Multiple-Choice Questions
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website 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!