MCQs

Disclaimer:

Educational Use Only:

The website links provided are to be used strictly for educational and knowledge-gaining purposes only.

No Misuse:

Do not misuse the links or the information contained therein for any commercial, illegal, or unethical activities.

Respect for Websites and Businesses:

Respect the intellectual property and business interests of the websites and their owners. Do not attempt to alter, copy, or redistribute content without proper authorization.

Acknowledge Value of Knowledge:

Recognize and value the knowledge and resources shared by these websites. Use the information responsibly and ethically.

No Endorsement:

The provision of these links does not imply endorsement of the linked sites, their content, or their products and services. Users are responsible for evaluating the suitability and accuracy of the information.

User Responsibility:

By accessing these links, you agree to use the information at your own risk and to comply with all applicable laws and website terms of use.

Overall MCQs for Reference

In machine learning, spreadsheet files typically used for data input are in which format?
a. .pdf
b. .csv
c. .exe
d. .mp4
Answer: b. .csvcsiplearninghub+1
Which software is commonly used to create and manage spreadsheets for ML data?
a. Microsoft Word
b. Google Sheets
c. Adobe Photoshop
d. VLC Media Player
Answer: b. Google Sheetsincludehelp
When connecting to spreadsheets in ML, what type of data structures are spreadsheets typically converted into?
a. Lists
b. Arrays or DataFrames
c. Strings
d. Binary trees
Answer: b. Arrays or DataFramessanfoundry+1
What Python library is popularly used to load spreadsheet data for machine learning tasks?
a. TensorFlow
b. NumPy
c. pandas
d. OpenCV
Answer: c. pandasaticleworld+1
Which of the following methods can pandas use to read spreadsheet data?
a. read_pdf()
b. read_csv()
c. read_excel()
d. Both b and c
Answer: d. Both b and csanfoundry+1
What function in pandas reads Google Sheets data directly if shared as CSV?
a. read_json()
b. read_clipboard()
c. read_csv()
d. read_html()
Answer: c. read_csv()includehelp
What is the benefit of using spreadsheets in ML model training?
a. Easy data entry and manipulation
b. Automatically trains models
c. Generates code
d. Replaces datasets
Answer: a. Easy data entry and manipulationscribd+1
Which format is considered better suited for large dataset handling compared to Excel?
a. .xls
b. .xlsx
c. .csv
d. .docx
Answer: c. .csvcsiplearninghub
What is the purpose of linking spreadsheets in ML workflows?
a. To prevent data duplication
b. To reduce computation
c. To automate data updates
d. To beautify data presentation
Answer: c. To automate data updatesscribd+1
Which option allows you to consolidate data from multiple sheets into a master sheet?
a. Solver
b. Goal Seek
c. Data Consolidation
d. Sort
Answer: c. Data Consolidationcsiplearninghub
What is the result of configuring “Link to source data” in spreadsheet consolidation?
a. Values do not update
b. Changes in source update consolidated data
c. Data gets deleted
d. Spreadsheet crashes
Answer: b. Changes in source update consolidated datacsiplearninghub
What Google Sheets feature enables real-time collaboration on a spreadsheet for ML datasets?
a. Offline mode
b. Sharing permissions
c. Comments only
d. File locking
Answer: b. Sharing permissionsincludehelp
What role does data cleaning in spreadsheets play before feeding data to ML algorithms?
a. Increases model complexity
b. Improves data accuracy and quality
c. Slows processing speed
d. None
Answer: b. Improves data accuracy and qualitysanfoundry
Which spreadsheet function helps in identifying outliers through statistical calculations before ML processing?
a. SUM()
b. AVERAGE()
c. STANDARD DEVIATION()
d. CONCATENATE()
Answer: c. STANDARD DEVIATION()csiplearninghub
What is a common challenge when importing spreadsheet data to ML models?
a. Unsupported data types
b. Too much RAM
c. Freezing the spreadsheet
d. Auto-saving errors
Answer: a. Unsupported data typessanfoundry
What is an efficient way to handle missing data in spreadsheets before training ML models?
a. Ignore missing values
b. Replace with mean or median
c. Leave cells empty
d. Replace with random strings
Answer: b. Replace with mean or medianitfeature+1
Which Python library can read Excel files with multiple sheets for ML data handling?
a. matplotlib
b. openpyxl
c. Flask
d. Pillow
Answer: b. openpyxlsanfoundry
In Google Sheets, what is the term for a group of adjacent cells?
a. Cell range
b. Cell group
c. Cell array
d. Cell list
Answer: a. Cell rangeincludehelp
What type of spreadsheet file extension is generated by Microsoft Excel?
a. .xlsx
b. .csv
c. .tar.gz
d. .json
Answer: a. .xlsxcsiplearninghub
Which method allows importing Google Sheets as a data frame in Python?
a. Sheets API + pandas
b. read_pdf() function
c. HTTP requests only
d. No direct method
Answer: a. Sheets API + pandasincludehelp
What is the first step to connect a machine learning model with spreadsheet data?
a. Model training
b. Data extraction from spreadsheet
c. Data cleaning
d. Dataset splitting
Answer: b. Data extraction from spreadsheetsanfoundry
Why is CSV preferred over Excel for ML pipelines?
a. Easier parsing and compatibility
b. Better formatting
c. More complex functions
d. Graph generation
Answer: a. Easier parsing and compatibilitycsiplearninghub
What feature in spreadsheets allows assigning a name to a cell or range for easy reference?
a. Range naming
b. Cell formatting
c. Data validation
d. Conditional formatting
Answer: a. Range namingcsiplearninghub
What Python function is typically used to save dataframe back to spreadsheet format?
a. to_csv()
b. save_excel()
c. write_sheet()
d. export_file()
Answer: a. to_csv()sanfoundry
What advantage do spreadsheets offer in early-stage ML experiments?
a. Visual data overview
b. Automated ML model building
c. Auto hyperparameter tuning
d. Real-time neural network visualization
Answer: a. Visual data overviewcsiplearninghub
Which function in spreadsheets is helpful for sorting ML dataset columns?
a. FILTER()
b. SORT()
c. SPLIT()
d. MERGE()
Answer: b. SORT()csiplearninghub
What is the risk of manual data entry in spreadsheets for ML?
a. Increased accuracy
b. Human errors leading to poor data quality
c. Faster processing
d. Automated backup
Answer: b. Human errors leading to poor data qualitysanfoundry
How can spreadsheets be integrated into ML workflows for real-time data?
a. API connections or live links
b. Export static files only
c. Manual uploads only
d. No integration possible
Answer: a. API connections or live linksincludehelp+1
What type of data does machine learning typically require from spreadsheets?
a. Text only
b. Structured numeric or categorical data
c. Images
d. Videos
Answer: b. Structured numeric or categorical datasanfoundry
Which spreadsheet feature helps in reducing duplication in ML datasets?
a. Conditional formatting
b. Remove duplicates function
c. Sort ascending
d. Freeze panes
Answer: b. Remove duplicates functioncsiplearninghub
How do spreadsheet formulas contribute to ML data preparation?
a. Automate calculation and transformation of features
b. Replace ML algorithms
c. Store ML models
d. Generate reports only
Answer: a. Automate calculation and transformation of featurescsiplearninghub
What is the maximum number of rows in Excel 2019 that can be used for ML datasets?
a. 1,000
b. 10,000
c. 1,048,576
d. 100 million
Answer: c. 1,048,576csiplearninghub
What is the function to create a link to another worksheet in spreadsheets?
a. VLOOKUP()
b. HYPERLINK()
c. CONCAT()
d. INDIRECT()
Answer: b. HYPERLINK()scribd+1
What is a major limitation of spreadsheets for large-scale ML?
a. Limited data visualization
b. Lack of advanced data versioning and control
c. Too fast computation
d. No functions
Answer: b. Lack of advanced data versioning and controlscribd+1
What is the primary purpose of the “Goal Seek” feature in spreadsheets?
a. Data consolidation
b. Solving for inputs to achieve a desired output
c. Hyperlink creation
d. Sorting data
Answer: b. Solving for inputs to achieve a desired outputcsiplearninghub
What does “Data Consolidation” in spreadsheets do?
a. Merges data from multiple sheets into one sheet
b. Deletes duplicate rows
c. Filters data by condition
d. Creates pivot tables
Answer: a. Merges data from multiple sheets into one sheetscribd+1
When importing spreadsheet data into ML models, which preprocessing step is commonly done first?
a. Feature scaling
b. Data cleaning
c. Model evaluation
d. Hyperparameter tuning
Answer: b. Data cleaningsanfoundry
What spreadsheet feature allows users to freeze top rows while scrolling to keep headers visible?
a. Freeze Panes
b. Split Table
c. Lock Cells
d. Protect Sheet
Answer: a. Freeze Panescsiplearninghub
What is the extension of a macro-enabled Excel spreadsheet?
a. .xlsm
b. .xlsx
c. .csv
d. .xls
Answer: a. .xlsmcsiplearninghub
How can you use Python to update Google Sheets used in ML pipelines?
a. Using Google Sheets API
b. Export as text file only
c. Manually copy data only
d. Not possible
Answer: a. Using Google Sheets APIincludehelp
What is the benefit of using named ranges in spreadsheets for ML models?
a. Increased readability and easier formula management
b. Increased file size
c. Increased loading time
d. None
Answer: a. Increased readability and easier formula managementcsiplearninghub
In machine learning, why might you convert spreadsheet data to JSON?
a. To enable easy data exchange with web APIs
b. To increase file size
c. To obscure data
d. To slow computations
Answer: a. To enable easy data exchange with web APIssanfoundry
What spreadsheet operation helps organize data by multiple criteria, useful in cleaning ML datasets?
a. Sorting by multiple columns
b. Adding comments
c. Data validation
d. Conditional formatting
Answer: a. Sorting by multiple columnscsiplearninghub
What is the function used in spreadsheets to find a cell’s relative address?
a. ADDRESS()
b. RELATIVE()
c. VLOOKUP()
d. INDIRECT()
Answer: a. ADDRESS()csiplearninghub
What spreadsheet feature lets you protect data in certain cells from accidental editing during ML data preparation?
a. Data validation
b. Protect Sheet or Protect Range
c. Hide Cells
d. Freeze Rows
Answer: b. Protect Sheet or Protect Rangecsiplearninghub
Which function helps to import data from web pages or apps directly into spreadsheets?
a. IMPORTHTML()
b. SUM()
c. CONCATENATE()
d. FILTER()
Answer: a. IMPORTHTML()includehelp
What is the purpose of pivot tables in spreadsheets related to ML?
a. Summarize and analyze large datasets
b. Generate charts automatically
c. Create neural network models
d. Filter data by formulas
Answer: a. Summarize and analyze large datasetscsiplearninghub
How do “filters” in spreadsheets assist in ML data preparation?
a. Remove unwanted records based on criteria
b. Increase model accuracy automatically
c. Visualize data as graphs
d. Connect to APIs
Answer: a. Remove unwanted records based on criteriacsiplearninghub
Which spreadsheet function checks conditions and returns corresponding values, useful for feature engineering?
a. IF()
b. MID()
c. LEN()
d. COUNT()
Answer: a. IF()csiplearninghub
What is a best practice when saving spreadsheet data for ML workflows?
a. Store in version-controlled repositories
b. Save only on local hard drive
c. Use scanned images of data
d. Share via email only
Answer: a. Store in version-controlled repositoriessanfoundry+1

Blog

Systemethic Technologies

Leave a Reply Cancel reply

Useful links

Other Terms & Policies

Contact Info