Accounting Information Systems (AIS) Midterm Exam Study Guide – Practice Questions, Internal Controls & Business Cycles Review

Accounting Information Systems (AIS) Midterm Exam Study Guide –
Practice Questions, Internal Controls & Business Cycles Review



Which of the following Python libraries are commonly used to automate
accounting tasks? – Answer ✅️ ✅NumPy
️

Pandas



Web scraping is the automation of the extraction of large volumes of data
from websites. Using Python, which of the following web scraping activities
can be conducted? – Answer ✅️ ✅Conduct
️ price comparisons

Collect data from social media sites

Conduct research and development



Which of the following Python libraries are commonly used for data
processing and data visualization? – Answer ✅️ ✅Seaborn
️

Matpplotlib



Which of the following Python libraries are used in marketing analytics and
SEO? – Answer ✅️ ✅TensorFlow
️

ExPan



The Python programming language was developed in the 1980s by
Blank______. – Answer ✅️
✅Guido
️ van Rossum



Microsoft Excel was first introduced in 1982 as a program called ______. –
Answer ✅️ ✅Multiplan
️

,Data manipulation in Python using the wide variety of libraries that are
available offer accountants the ability to automate which of the following
tasks? – Answer ✅️ ✅Generate
️ reports

Perform calculations

Analyze financial data



In Microsoft Excel, a statement written by a user that is designed for a
specific calculation is referred to as a ______. – Answer ✅️
✅formula
️



Put the process for web scraping using Python in the correct order – Answer
✅️✅1.️Identify the URL to scrape

2. Identify the data that needs to be scraped

3. Inspect the page

4. Locate the data that needs to be extracted

5. Write/use Python code to extract the data

6. Run the code and extract the data

7. Compile structured reports/visualizations of the data



A subset of data analysis that covers creating visual representations of data
is referred to as data ______. – Answer ✅️
✅visualization
️



Marketing analytics are used to measure marketing performance and
effectiveness and to make decisions on different strategies to increase
marketing efficiency and impact. The analysis of marketing performance
data can be enhanced using Python. Python is used for the analysis of which
marketing related tasks? – Answer ✅️ ✅Predictive
️ analytics

A/B Testing

Customer segmentation analysis

, Which of the following is Microsoft Excel frequently used for? – Answer
✅️
✅Data
️ analytics

Data visualization

Data entry



Visual Basic for _____ (VBA) is included in Excel and offers the capability to
create custom macros and functions that are designed to accomplish
organizational specific tasks. – Answer ✅️ ✅applications
️



Select the true statements about the scalability of Microsoft Excel. – Answer
✅️✅When
️ large volumes of data are introduced into Microsoft Excel, issues
may occur.

The management of small and medium scale data sets can be accomplished
relatively smoothly.

As the amount of spreadsheet tabs in a workbook increases, so does
potential data management issues.



In Python, a collection of related programming modules that include
precompiled bundles of code that can be used repetitively in different
programs and applications are referred to as a Python ______. They often
contain configuration data, templates, classes, values, and documentation. –
Answer ✅️ ✅library
️



Which of the following are popular Python IDEs? – Answer ✅️
✅PyCharm
️

Spyder

Visual Studio Code



Microsoft Excel is a spreadsheet software application that consists of a grid
interface of columns and ______ where data can be entered, structured, and
manipulated. – Answer ✅️ ✅rows
️