A payroll analyst needs to send an Excel worksheet to an external accounting system that only accepts comma-separated values (.csv) files. After the analyst saves the worksheet in .csv format and re-opens it in Excel, which limitation of the .csv format is the analyst MOST LIKELY to observe compared with keeping the file in .xlsx format?
Any worksheet wider than 256 columns is automatically truncated during export.
Embedded formulas are saved as static values or text, so their calculation logic is lost.
Column order may change because .csv cannot guarantee original column sequencing.
UTF-8 characters such as accented letters or non-Latin scripts cannot be stored and must be converted to ASCII.
The .csv format stores plain text only-no workbook metadata, styles, or executable objects. When Excel exports to .csv, each cell is written as the literal characters that appear on the screen. As a result, any formula that existed in the original workbook is flattened: the cell now contains the last calculated result (or the formula text, depending on how the sheet was displayed) rather than the underlying formula logic. The other options describe characteristics that do not stem from the .csv specification: column order is preserved, UTF-8 characters can be stored when the file is encoded as UTF-8, and there is no inherent 256-column limit (that limit applied to very old Excel .xls files, not to text formats).
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
Why does a .csv file store formulas as static values?
Open an interactive chat with Bash
What is the difference between .csv and .xlsx formats?
Open an interactive chat with Bash
How can UTF-8 characters be stored in a .csv file?
Open an interactive chat with Bash
CompTIA Data+ DA0-002 (V2)
Data Concepts and Environments
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99 $11.99
$11.99/mo
Billed monthly, Cancel any time.
$19.99 after promotion ends
3 Month Pass
$44.99 $26.99
$8.99/mo
One time purchase of $26.99, Does not auto-renew.
$44.99 after promotion ends
Save $18!
MOST POPULAR
Annual Pass
$119.99 $71.99
$5.99/mo
One time purchase of $71.99, Does not auto-renew.
$119.99 after promotion ends
Save $48!
BEST DEAL
Lifetime Pass
$189.99 $113.99
One time purchase, Good for life.
Save $76!
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .