Google Sheets Formula 1 — Questions and Answers
Question 1: A cell reference that is absolute is which of the following?
- B:2
- $B$2 (Correct answer)
- B2
- #B2
Correct answer: $B$2
An absolute cell reference in Google Sheets uses dollar signs ($) before both the column letter and the row number, like `$B$2`. This notation locks the reference to that specific cell, preventing it from changing when the formula is copied or filled to other cells. Absolute references are essential when a formula needs to consistently refer to a particular data point regardless of its new location.
Question 2: ____ is the most characters that can fit in a single cell.
- 32364
- 65536
- 18730
- 50000 (Correct answer)
Correct answer: 50000
Google Sheets imposes a limit on the amount of data that can be stored within a single cell. The maximum number of characters that can fit in a single cell is 50,000. This limit is important to consider when inputting very long text strings or complex formulas to ensure data integrity and proper sheet functionality.
Question 3: The majority of functions in Google Sheets have one or more ____ enclosed in parenthesis.
- Functions
- Sub functions
- Arguments (Correct answer)
- Formulas
Correct answer: Arguments
In Google Sheets, most functions require specific inputs, known as arguments, to perform their calculations. These arguments are enclosed within parentheses after the function name, providing the necessary data or conditions for the function to execute correctly. For example, in `SUM(A1:A10)`, `A1:A10` is the argument specifying the range of cells to be summed.
Question 4: Which term refers to a person's education, income, and occupation?
- Sorting
- Statics
- Filters (Correct answer)
- Reporting
Correct answer: Filters
In data analysis, 'filters' are used to display only the data that meets specific criteria, effectively narrowing down a dataset. When examining attributes like education, income, and occupation, applying filters allows users to isolate and analyze subsets of data based on these demographic categories. This helps in quickly identifying patterns, trends, or specific groups within a larger dataset.
Question 5: Which symbol in Google Sheets is not recognized as a mathematical operator?
- *
- @ (Correct answer)
- ^
- /
Correct answer: @
In Google Sheets, standard mathematical operators include `+` (addition), `-` (subtraction), `*` (multiplication), `/` (division), and `^` (exponentiation). The `@` symbol is not recognized as a mathematical operator for performing arithmetic calculations within formulas. It is sometimes used in other programming contexts but does not serve a basic mathematical function in Sheets.
Question 6: Which Google Sheets command is used to remove formatting from a selected cell?
- Clear Styles
- Clear Formatting (Correct answer)
- Clear
- Clear all
Correct answer: Clear Formatting
The 'Clear Formatting' command in Google Sheets is specifically designed to remove all applied formatting from selected cells, such as bolding, italics, font size, color, and borders. This action reverts the cells to their default style without deleting the actual content. It is a useful tool for standardizing data appearance or preparing cells for new formatting.
Question 7: In Google sheets, the default format for numbers is ___.
- Currency
- Time
- Automatic (Correct answer)
- Number
Correct answer: Automatic
In Google Sheets, the default format for numbers is 'Automatic.' This setting allows the spreadsheet to intelligently determine the most appropriate display format for the data entered, such as recognizing dates, times, percentages, or plain numbers. While generally effective, users can manually apply specific formats if the automatic detection doesn't perfectly match their needs.
Google Sheets Formula 1
A cell reference that is absolute is which of the following?