Which formula totals a range of numbers?
A =COUNT(A1:A5)
B =MIN(A1:A5)
C =AVERAGE(A1:A5)
D =SUM(A1:A5)
Answer: D. =SUM(A1:A5). SUM adds the numeric values in the specified range.
What does AVERAGE calculate?
A Largest value
B Cell count
C Arithmetic mean
D Text length
Answer: C. Arithmetic mean. AVERAGE returns the arithmetic mean of numeric values.
Which function counts numeric cells?
A COUNTA
B COUNT
C COUNTIF
D SUM
Answer: B. COUNT. COUNT counts cells containing numeric values.
How does COUNTA differ from COUNT?
A Counts nonempty cells
B Counts only formulas
C Counts numeric cells
D Adds cell values
Answer: A. Counts nonempty cells. COUNTA counts cells that are not empty, including text and numbers.
Which function counts cells meeting criteria?
A SUMIF
B COUNTA
C AVERAGEIF
D COUNTIF
Answer: D. COUNTIF. COUNTIF counts cells in a range that meet one condition.
What does an IF formula evaluate?
A A chart title
B A sheet tab
C A logical condition
D A file size
Answer: C. A logical condition. IF tests a condition and returns one result when true and another when false.
Which reference stays fixed when copied?
A A1
B $A$1
C A:A
D 1:1
Answer: B. $A$1. Dollar signs before the column and row make a reference absolute when copied.
What happens to relative reference A1 when copied?
A It adjusts position
B It becomes text
C It stays fixed
D It is deleted
Answer: A. It adjusts position. Relative references change based on the formula’s new location.
Which reference locks the column only?
A A$1
B $A$1
C A1
D $A1
Answer: D. $A1. In $A1, the dollar sign fixes column A while the row can change.
Which reference locks the row only?
A $A1
B $A$1
C A$1
D A1
Answer: C. A$1. In A$1, the dollar sign fixes row 1 while the column can change.
What does MIN return?
A Largest numeric value
B Smallest numeric value
C Average numeric value
D Number of entries
Answer: B. Smallest numeric value. MIN returns the smallest number in the supplied values or range.
Which function returns the largest number?
A MAX
B MIN
C MEDIAN
D COUNT
Answer: A. MAX. MAX returns the largest numeric value in the selected data.
Which formula sums only matching rows?
A COUNT
B AVERAGE
C UNIQUE
D SUMIF
Answer: D. SUMIF. SUMIF adds values when corresponding cells meet a specified condition.
What does IFERROR help handle?
A Duplicate sheets
B Hidden rows
C Formula errors
D Chart labels
Answer: C. Formula errors. IFERROR returns a chosen alternative when its formula produces an error.
Which error often means division by zero?
A #REF!
B #DIV/0!
C #N/A
D #NAME?
Answer: B. #DIV/0!. A division by zero or a blank divisor can produce #DIV/0!.
What does #REF! usually indicate?
A Invalid cell reference
B Text too long
C Missing chart
D Protected sheet
Answer: A. Invalid cell reference. #REF! signals that a formula contains an invalid or deleted cell reference.
When does #N/A commonly appear?
A A row is frozen
B A chart is hidden
C A cell is bold
D No value is available
Answer: D. No value is available. #N/A commonly means a formula cannot find a requested value.
What does a filter do to rows?
A Deletes them permanently
B Changes formulas
C Hides nonmatching rows
D Moves them to another file
Answer: C. Hides nonmatching rows. A filter hides rows that do not match selected conditions without deleting the data.
Which menu contains sorting and filter tools?
A Insert menu
B Data menu
C Help menu
D Extensions menu
Answer: B. Data menu. Google Sheets places sort and filter controls in the Data menu.
Why freeze the header row?
A Keep labels visible
B Protect formulas
C Sort all rows
D Hide blank columns
Answer: A. Keep labels visible. Freezing the header keeps column labels visible while scrolling through data.
What does a filter view allow?
A Change every user’s view
B Delete filtered rows
C Lock all formulas
D Personalize a data view
Answer: D. Personalize a data view. A filter view lets someone sort and filter a range without changing other users’ views.
Which tool summarizes large datasets?
A Named range
B Fill handle
C Pivot table
D Data validation
Answer: C. Pivot table. Pivot tables aggregate and reorganize source data for analysis.
What is a pivot table source range?
A Chart legend
B Input data cells
C Formula bar
D Comment thread
Answer: B. Input data cells. The source range contains the data that the pivot table summarizes.
Where do pivot table summaries appear?
A Rows, columns, values
B Only in comments
C Only in formulas
D Only in chart titles
Answer: A. Rows, columns, values. Pivot table fields can be organized into rows, columns, values, and filters.
Which pivot setting narrows summarized records?
A Theme
B Font
C Merge
D Filter
Answer: D. Filter. A pivot table filter limits which source records contribute to its summary.
What does conditional formatting change?
A Underlying cell values
B File ownership
C Appearance based on rules
D Sheet names
Answer: C. Appearance based on rules. Conditional formatting changes how cells look when specified rules are met.
Which feature creates an in-cell dropdown?
A Pivot chart
B Data validation
C Named version
D Find and replace
Answer: B. Data validation. Data validation can restrict inputs and provide dropdown choices in cells.
What is a named range?
A A labeled cell range
B A renamed spreadsheet file
C A protected workbook
D A chart series
Answer: A. A labeled cell range. A named range gives a cell or range a memorable name for easier formulas.
Why protect a range?
A Encrypt the spreadsheet
B Prevent copying data
C Hide formulas from owners
D Limit editing changes
Answer: D. Limit editing changes. Protected ranges help control who can edit cells, but they are not a security measure.
What does the fill handle help do?
A Create a pivot table
B Set permissions
C Copy formulas or series
D Open version history
Answer: C. Copy formulas or series. Dragging the fill handle can extend formulas, values, or recognized sequences.
Which formula finds matching values vertically?
A HLOOKUP
B VLOOKUP
C COUNTIF
D SUM
Answer: B. VLOOKUP. VLOOKUP searches the first column of a range and returns a value from a specified column.
What is the key advantage of XLOOKUP?
A Flexible lookup direction
B Formats cells automatically
C Creates charts
D Locks cell references
Answer: A. Flexible lookup direction. XLOOKUP can search a range and return a corresponding result without requiring a fixed leftmost lookup column.
Which function returns rows matching conditions?
A SORT
B COUNT
C ROUND
D FILTER
Answer: D. FILTER. FILTER returns a subset of a range whose rows or columns meet given conditions.
What does UNIQUE return?
A Sorted formulas
B Blank rows
C Distinct values
D Duplicate records
Answer: C. Distinct values. UNIQUE returns distinct rows or values from the specified input.
Which function sorts a range in a formula?
A FILTER
B SORT
C COUNTIF
D MATCH
Answer: B. SORT. SORT returns a range sorted by one or more chosen columns.
What does QUERY do?
A Runs a data query
B Protects a range
C Adds page numbers
D Colors duplicates
Answer: A. Runs a data query. QUERY applies a query language to a data range and returns matching results.
Which function combines text with a delimiter?
A SUMIFS
B COUNTBLANK
C RANK
D TEXTJOIN
Answer: D. TEXTJOIN. TEXTJOIN joins text values and can insert a chosen delimiter between them.
What does IMPORTRANGE bring into a sheet?
A Images from a chart
B Comments from Docs
C Cells from another spreadsheet
D Rows from a PDF
Answer: C. Cells from another spreadsheet. IMPORTRANGE imports a specified range from another Google spreadsheet after access is authorized.
What must happen before IMPORTRANGE can read a new source?
A Freeze its first row
B Grant access
C Create a pivot table
D Rename the source tab
Answer: B. Grant access. The destination spreadsheet must be allowed to access the source spreadsheet.
How is a formula usually started?
A Equals sign
B Hash sign
C Question mark
D Semicolon
Answer: A. Equals sign. Google Sheets formulas typically begin with an equals sign.
What does a chart visualize?
A Sharing permissions
B Revision history
C Cell comments
D Data patterns
Answer: D. Data patterns. Charts present data visually to make patterns and comparisons easier to interpret.
Which chart suits category comparisons?
A Scatter plot
B Candlestick chart
C Bar chart
D Map chart
Answer: C. Bar chart. Bar charts make values across categories straightforward to compare.
When is a scatter chart useful?
A Display document pages
B Show two-variable relationships
C List sheet names
D Count comments
Answer: B. Show two-variable relationships. Scatter charts plot paired numeric values to show relationships between two variables.
What does the chart editor customize?
A Chart setup and style
B Drive sharing roles
C Version history
D Named ranges
Answer: A. Chart setup and style. The chart editor controls a chart’s data setup and visual presentation.
Why should a data range include headers?
A Hide blank cells
B Lock formulas
C Prevent sorting
D Identify each column
Answer: D. Identify each column. Headers make columns easier to identify when sorting, filtering, or building a pivot table.
What can sorting a range change?
A Cell permissions
B Formula language
C Row order
D Spreadsheet owner
Answer: C. Row order. Sorting rearranges rows according to values in one or more selected columns.
Which option keeps a header row out of sorting?
A Freeze first column
B Data has header row
C Create filter view
D Protect range
Answer: B. Data has header row. Marking that the range has a header prevents the header from being treated as a data record.
What does Remove duplicates do?
A Deletes repeated records
B Colors repeated values
C Creates a filter view
D Counts unique formulas
Answer: A. Deletes repeated records. Remove duplicates deletes repeated rows based on the selected columns.
Which format keeps a spreadsheet editable in Excel?
A PDF
B PNG
C MP3
D XLSX
Answer: D. XLSX. XLSX exports spreadsheet data in a format that Microsoft Excel can edit.
When is PDF export useful?
A Continue formula editing
B Build pivot tables
C Share a fixed layout
D Change cell references
Answer: C. Share a fixed layout. PDF is useful for distributing a viewable copy with a stable page layout.