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
In a single cell, the maximum limit of the characters is ____.
1.65536
2.18730
3.50000
4.32364
In Google sheet, columns are represented by ____.
1.Numbers
2.Letters
3.Letters and Numbers
4.Cells
Which function is used to find the average (arithmetic mean)?
1.AVERAGE
2.AVERAGEIF
3.AVERAGEIFS
4.AM
A group of cells is known as ___ in Google Sheets.
1.Cells group
2.Multi cells
3.Collection
4.Cell range
A single Google sheet is called ____.
1.Workbook
2.Document
3.Google Shareware
4.Worksheet
Any formula starts with the ___ sign.
1.Underscore (_)
2.Dollar ($)
3. Equal (=)
4.Column (:)
Can we freeze header rows and columns in Google sheets?
1.Yes
2.No
3.Error
4.None of these
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
Google sheet saves the changes automatically?
1.Yes
2.No
3.Error
4.All of the above
In Google sheets, most of the functions contain one or more ____ in parentheses.
1.Arguments
2.Formulas
3.Functions
4.Subfunctions
In Google sheets, the default number format is ___.
1.Automatic
2.Number
3.Currency
4.Time
Shortcut command to hide rows in Google sheet?
1.Ctrl + Alt + R
2.Ctrl + Alt + H
3.Ctrl + Alt + 9
4.Ctrl + Alt + 0
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
Shortcut command to show all formulas in Google sheet?
1.Ctrl + F
2.Ctrl + Shift + F
3.Ctrl + &
4.Ctrl + ~
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
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
Shortcut to select current column in Google sheet?
1.CTRL + Space
2.ALT + Space
3.SHIFT + Space
4. CTRL + SHIFT + Space
Shortcut to select the current row in Google sheet?
1.CTRL + Space
2.ALT + Space
3.SHIFT + Space
4.CTRL + SHIFT + Space
The ____ command in Google Sheets allows for more complex sorting of data.
1.Sort
2.Sort Range
3.Sort Data
4.Data Sort
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
Which feature allows you to narrow down the data in your worksheet?
1.Filters
2.Reporting
3.Sorting
4.Statics
Which format represents the numbers with the dollars ($) sign? [For example, $1,000.00]
1.Automatic
2.Number
3.Currency
4.Time
Which function adds up numbers in a range in Google sheets?
1.ADD
2.SUM
3.SUMIF
4.SUMRANGE
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
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
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
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
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
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()
Which of the following is an absolute cell reference?
1.B2
2.#B2
3.B:2
4.$B$2
Which sign is used in the formula to use absolute reference?
1.Underscore (_)
2.Dollar ($)
3.Equal (=)
4.Column (:)
Which symbol is not recognized as mathematical operators within Google Sheets?
1.^
2. *
3.@
4./
___ function returns the current date and time as a date value.
1.DATE()
2.TODAY()
3.NOW()
4.GETDATE()
____ function returns the current date as a date value.
1.DATE()
2.TODAY()
3.NOW()
4.GETDATE()