When asking an AI tool to write a spreadsheet formula, what should the prompt specify?
A Only the workbook color
B A random column name
C Goal, cells, and expected result
D The user's password
Answer: C. Goal, cells, and expected result. A useful request explains the calculation, the relevant cells or columns, and what a correct result should look like.
How can a user check an AI-suggested formula before filling it down?
A Test it on known examples
B Trust the explanation alone
C Hide the source cells
D Change every number
Answer: A. Test it on known examples. Known examples provide a quick check that the formula behaves as intended.
Does an AI explanation of a formula prove that its result is correct?
A Yes, explanations are proof
B Only for short formulas
C Only with charts
D No, calculate and verify
Answer: D. No, calculate and verify. A fluent explanation can still describe an incorrect formula, so verify the logic and output.
What structure helps spreadsheet tools analyze a dataset reliably?
A Merged cells everywhere
B Consistent rows and headers
C Multiple values per cell
D Unlabeled columns
Answer: B. Consistent rows and headers. Tools work more reliably when records follow consistent rows and clearly named columns.
Why should a data table use one clear header row?
A Identify each field
B Increase workbook size
C Hide missing values
D Change calculation mode
Answer: A. Identify each field. Clear headers help people and tools understand what each column represents.
In a simple sales table, what should each row usually represent?
A Several unrelated records
B A workbook theme
C One sales record
D A chart legend
Answer: C. One sales record. A consistent row-per-record structure keeps fields aligned and easier to analyze.
Why are merged cells usually avoided inside a raw-data table?
A They create formulas automatically
B They disrupt consistent records
C They verify AI suggestions
D They store hidden charts
Answer: B. They disrupt consistent records. Merged cells can make sorting, filtering, and automated analysis harder because the table no longer has a consistent grid.
How should dates be stored for dependable analysis?
A Mix text and date values
B Use ambiguous abbreviations
C Omit the year
D Use a consistent date format
Answer: D. Use a consistent date format. Consistent date values help formulas sort and compare records without confusing different formats.
What should a blank cell mean in a dataset?
A Always the same as zero
B A hidden formula
C A clearly defined missing value
D A positive result
Answer: C. A clearly defined missing value. Blank and zero can mean different things; define and handle missing values consistently.
Why check a table for duplicate records before analysis?
A Duplicates change file color
B Duplicates can inflate totals
C They improve accuracy automatically
D They remove missing values
Answer: B. Duplicates can inflate totals. Repeated records can overstate counts or sums if they are not intended duplicates.
Which spreadsheet feature can restrict entries to an approved list?
A Data validation
B Conditional formatting
C Chart title
D Page break
Answer: A. Data validation. Data validation can constrain cell entries, such as requiring a value from an allowed list.
When a formula is copied to a new row, what happens to a relative reference?
A It always stays fixed
B It deletes the source
C It converts to text
D It adjusts with the formula
Answer: D. It adjusts with the formula. Relative references shift according to the copied formula's new position.
Which reference keeps a cell fixed when copied?
A A relative reference
B An absolute reference
C A filtered range
D A chart reference
Answer: B. An absolute reference. An absolute reference keeps its row and column fixed when the formula is copied.
In a mixed cell reference, what stays fixed?
A Either the row or column
B Both rows and columns
C Neither part ever
D The worksheet color
Answer: A. Either the row or column. A mixed reference locks one dimension while allowing the other to adjust.
What should be checked after filling a formula down a column?
A Only cell color
B Workbook title length
C References and boundary rows
D The browser history
Answer: C. References and boundary rows. Copied formulas can shift references unexpectedly, so inspect both typical and edge rows.
Why define the calculation range carefully?
A Change the file type
B Hide all errors
C Increase text size
D Avoid missing or extra rows
Answer: D. Avoid missing or extra rows. An incorrect range can omit relevant records or include totals and unrelated cells.
Which function is commonly used to add values in a range?
A COUNTIF
B LEFT
C SUM
D ROUND
Answer: C. SUM. SUM adds values in the selected cells or range.
What does AVERAGE usually return for a numeric range?
A The largest value
B The arithmetic mean
C The number of blanks
D The first text value
Answer: B. The arithmetic mean. AVERAGE calculates the arithmetic mean of numeric values in the referenced range.
Which function can return a result based on a condition?
A SORT
B LEFT
C UNIQUE
D IF
Answer: D. IF. IF evaluates a condition and returns one result when true and another when false.
When using a lookup formula, what should match between the tables?
A A reliable key value
B The background color
C The row height
D The file extension
Answer: A. A reliable key value. Lookups depend on matching keys, such as unique product codes, to return the intended related value.
What is a PivotTable useful for?
A Rewrite source documents
B Summarize grouped data
C Verify legal terms
D Remove every blank
Answer: B. Summarize grouped data. PivotTables summarize and rearrange data by categories, such as totals by region or month.
Before relying on a generated chart, what needs checking?
A Animation speed
B Workbook password length
C Print margins
D Source values and labels
Answer: D. Source values and labels. Check chart values, labels, units, and ranges against the source data.
What can an outlier check help identify?
A Unusual values needing review
B The formula's author
C The workbook theme
D A user's job title
Answer: A. Unusual values needing review. Outlier checks can flag unusual observations, but the values should be investigated rather than automatically deleted.
When sorting a dataset, what should be included in the selection?
A Only one column always
B The workbook theme
C All related columns
D An unrelated chart
Answer: C. All related columns. Sorting only one field can misalign records; keep each row's related values together.
What does filtering a table usually do?
A Delete those records
B Change their values
C Convert them to charts
D Hide nonmatching rows
Answer: D. Hide nonmatching rows. Filters display matching rows while leaving other records in the dataset.
Can an AI-generated formula be correct just because it returns a plausible number?
A No, verify the calculation path
B Yes, plausible means correct
C Only when rounded
D Only for totals
Answer: A. No, verify the calculation path. A plausible output can still come from a wrong reference or logic, so inspect intermediate steps and source cells.
What does a division-by-zero formula error usually indicate?
A The workbook has no theme
B The column is too narrow
C The denominator is zero
D The chart is filtered
Answer: C. The denominator is zero. A division-by-zero error occurs when a formula attempts to divide by zero or an empty denominator treated as zero.
Why compare a copied formula across several rows?
A The data may change colors
B References may shift unexpectedly
C Charts change their source
D Dates become strings
Answer: B. References may shift unexpectedly. Relative references can shift as a formula is copied, so compare outputs across different row cases.
What does a CSV file generally preserve from a workbook?
A Plain tabular values and text
B Every sheet and formatting
C Macros and chart animations
D All formulas and themes
Answer: A. Plain tabular values and text. CSV stores delimited text, not a full workbook's formatting, macros, charts, or multiple-sheet structure.
Why inspect formulas in an untrusted spreadsheet before enabling macros?
A Macros only change fonts
B Formulas cannot contain errors
C Charts require permission
D Macros can execute code
Answer: D. Macros can execute code. Macros may execute code, so files from untrusted sources should be treated cautiously.
How should AI-generated spreadsheet scripts or macros be handled?
A Run them without inspection
B Review before running
C Share admin credentials
D Disable all backups
Answer: B. Review before running. Generated code can contain mistakes or unsafe behavior; review it in a controlled context before execution.
What is a safer way to protect sensitive spreadsheet data?
A Hide columns only
B Use a secret worksheet name
C Restrict access and minimize sharing
D Color the cells
Answer: C. Restrict access and minimize sharing. Hiding cells is not access control; use appropriate permissions and share only what recipients need.
Before sending a workbook to an AI service, what should be checked?
A The sheet tab color
B The title font
C The number of charts
D Privacy and service policies
Answer: D. Privacy and service policies. Check whether the workbook contains confidential data and how the service handles submitted content.
Why keep a record of the data source used in an analysis?
A Make formulas shorter
B Support traceability and review
C Increase workbook size
D Replace cell validation
Answer: B. Support traceability and review. Source notes help others trace where values came from and review whether the dataset is appropriate.
Why separate raw inputs from calculated outputs?
A Prevent formulas from recalculating
B Hide source data
C Make changes easier to audit
D Increase chart animations
Answer: C. Make changes easier to audit. Separating source data and calculations makes the workflow easier to inspect and update.
What can a named range improve in a formula?
A Readability of cell references
B Data confidentiality
C Image resolution
D File compression
Answer: A. Readability of cell references. Named ranges can make formulas more understandable by replacing some cell references with meaningful labels.
What is a benefit of structured references in a table formula?
A Change a cell's color
B Protect a workbook password
C Remove all blank rows
D Refer to named table columns
Answer: D. Refer to named table columns. Structured references use table and column names, which can make formulas easier to interpret.
How can regional date settings affect spreadsheet analysis?
A Formulas become private
B Charts gain extra data
C Dates may be interpreted differently
D Rows are deleted automatically
Answer: C. Dates may be interpreted differently. Different locales can interpret date strings differently, so verify how imported dates were parsed.
What can happen when decimal separators differ across locales?
A Numbers may import as text
B All rows become duplicates
C Charts are automatically correct
D Dates gain time zones
Answer: A. Numbers may import as text. A decimal comma or point may be interpreted differently, potentially leaving numeric-looking values stored as text.
Why state units beside a calculated result?
A Change formula references
B Prevent ambiguous interpretation
C Reduce data validation
D Hide rounding errors
Answer: B. Prevent ambiguous interpretation. Units clarify what a number measures, such as dollars, hours, or kilograms.
How should a percentage formula be interpreted?
A Review only cell color
B Assume every format is correct
C Check numerator and denominator
D Ignore the base value
Answer: C. Check numerator and denominator. A percentage depends on which value is divided by which base, so confirm the formula's intended denominator.
What does rounding a displayed number change?
A Always its stored value
B Its displayed precision
C The source dataset
D The worksheet name
Answer: B. Its displayed precision. Number formatting may round what is displayed without changing the underlying stored value.
Why check data types before using spreadsheet formulas?
A Cell colors affect arithmetic
B All dates are text
C Tables cannot contain numbers
D Text and numbers behave differently
Answer: D. Text and numbers behave differently. Values stored as text may not calculate or sort like numeric values.
What is a careful way to handle missing values before summarizing?
A Document and apply a rule
B Replace every blank with zero
C Delete the entire row
D Assume blanks are errors
Answer: A. Document and apply a rule. The appropriate treatment depends on what a blank means; document the rule and apply it consistently.
Which check can catch a wrong AI-generated formula in a small sample?
A Change the sheet theme
B Recalculate selected cases manually
C Hide the formula bar
D Rename all columns
Answer: B. Recalculate selected cases manually. Manual checks on selected cases can reveal wrong references or calculations before a formula is applied broadly.
Why save a version before accepting broad AI edits?
A Guarantee a correct result
B Change file ownership
C Allow recovery if needed
D Prevent future review
Answer: C. Allow recovery if needed. A saved version or copy gives the user a recovery point if automated changes are incomplete or incorrect.
What should a user check if formulas do not update after inputs change?
A The chart's title font
B The prompt's punctuation
C The file's thumbnail
D Workbook calculation settings
Answer: D. Workbook calculation settings. Calculation settings can affect whether formulas recalculate automatically or require a manual update.
How can an analyst audit a formula that references another sheet?
A Trace each linked cell
B Hide the other worksheet
C Rename the workbook
D Delete source formulas
Answer: A. Trace each linked cell. Tracing references across sheets helps confirm that the formula uses the intended cells and source data.
Which practice supports repeatable spreadsheet analysis?
A Keep rules only in memory
B Change methods each time
C Document steps and assumptions
D Hide the source ranges
Answer: C. Document steps and assumptions. Documented steps and assumptions help another person reproduce and review an analysis.
Why keep an unchanged copy of imported data before cleaning it?
A Make formulas invisible
B Allow comparison and recovery
C Guarantee no missing values
D Increase chart detail
Answer: B. Allow comparison and recovery. An untouched source copy helps verify cleaning steps and restore original values if a transformation is incorrect.