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
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
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
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
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
A single Google sheet is called ____.
1.Workbook
2.Document
3.Google Shareware
4.Worksheet
Posted Date:-2022-11-29 15:06:50
Any formula starts with the ___ sign.
1.Underscore (_)
2.Dollar ($)
3. Equal (=)
4.Column (:)
Posted Date:-2022-11-29 17:16:50
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
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
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
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
In Google sheets, the default number format is ___.
1.Automatic
2.Number
3.Currency
4.Time
Posted Date:-2022-11-30 06:18:04
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Which symbol is not recognized as mathematical operators within Google Sheets?
1.^
2. *
3.@
4./
Posted Date:-2022-11-30 06:16:26
___ 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
____ 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