WGU C268 SPREADSHEETS PA 2026 EXAM
PREPARATION PACK KEY FORMULAS PIVOT
TABLES AND DATA VISUALIZATION WITH
SAMPLE QUESTIONS
◉ chief technology officer (CTO). Answer: has ultimate
responsibility for all technology implementation, maintaining
technology compliance regulations, and identifying technology risks
for the company.
◉ chief security officer (CSO). Answer: is the highest level executive
concerned with the overall security functions and policies of a
business.
◉ Systems Analyst. Answer: A change agent who uses design and
analysis techniques to solve organizational problems using
information technology; they report about system development and
keep others informed; should understand overall business
processes; focuses on analysis, design, and implementation
◉ Information Security Analyst. Answer: Their goal is to ensure that
data and systems are secure to prevent breaches.
,◉ Information Security. Answer: The concept of protecting valuable
information assets.
◉ Project Manager. Answer: They deliver quality systems on time,
manage the budget, and plan for the unexpected (they do not train
new users).
◉ Gantt chart. Answer: A visual view of tasks scheduled over time;
used for planning projects.
◉ Dashboard. Answer: A system that is the culmination of
information from many data sources, allowing management to
perform a thorough analysis.
◉ Cultural Particularism. Answer: A societal norm that emotionally
ties people to local brands or habits.
◉ Network Engineer. Answer: Responsible for the layout,
installation, and maintenance of all information technology network
components.
◉ Success of strategic information systems projects. Answer: A
majority fail to meet schedule or budget
,◉ Organizational features that can change the company direction.
Answer: Processes, politics, culture, and environment
◉ Global Business Strategies that form their organizational and
information systems structure. Answer: transnational, multinational,
franchisers, domestic exporter
◉ Transnational. Answer: a commercial enterprise that operates
substantial facilities, does business in more than one country and
does not consider any particular country its national home.
◉ Multinational. Answer: an organization that owns or controls
production of goods or services in one or more countries other than
their home country.
◉ Database Management System (DBMS). Answer: Allows multiple
departments to access, analyze, and modify data that is stored in one
central location.
◉ Total Cost of Ownership (TCO). Answer: Helps establish feasibility.
◉ Platform as a Service (PaaS). Answer: service provider provides
server space, the server, virtualization, operating system, database,
and development environment in a platform that can be used for
, application development. An example would be Amazon Web
Services.
◉ Infrastructure as a Service (IaaS). Answer: A service provider
provides a cloud fabric, or pooled services, including server space,
servers, storage, and all other aspects of the computing platform,
with the exception of the operating system and applications, which
the client organization would install and manage.
◉ Analytics as a Service (AaaS). Answer: A cloud software service
◉ Software as a Service (SaaS). Answer: Software licensed and
hosted on centralized or distributed servers that belong to a service
provider. Users access this software using a connection to the
Internet and a web browser.
◉ Agile software development methodology. Answer: an operational
method by which software developers iteratively gather
requirements, plan, design, develop, test, and implement software.
◉ Information Technology Infrastructure Library (ITIL). Answer:
common set of best practices widely used by businesses to give
guidance to companies on how to use IT as a tool for implementing
change
PREPARATION PACK KEY FORMULAS PIVOT
TABLES AND DATA VISUALIZATION WITH
SAMPLE QUESTIONS
◉ chief technology officer (CTO). Answer: has ultimate
responsibility for all technology implementation, maintaining
technology compliance regulations, and identifying technology risks
for the company.
◉ chief security officer (CSO). Answer: is the highest level executive
concerned with the overall security functions and policies of a
business.
◉ Systems Analyst. Answer: A change agent who uses design and
analysis techniques to solve organizational problems using
information technology; they report about system development and
keep others informed; should understand overall business
processes; focuses on analysis, design, and implementation
◉ Information Security Analyst. Answer: Their goal is to ensure that
data and systems are secure to prevent breaches.
,◉ Information Security. Answer: The concept of protecting valuable
information assets.
◉ Project Manager. Answer: They deliver quality systems on time,
manage the budget, and plan for the unexpected (they do not train
new users).
◉ Gantt chart. Answer: A visual view of tasks scheduled over time;
used for planning projects.
◉ Dashboard. Answer: A system that is the culmination of
information from many data sources, allowing management to
perform a thorough analysis.
◉ Cultural Particularism. Answer: A societal norm that emotionally
ties people to local brands or habits.
◉ Network Engineer. Answer: Responsible for the layout,
installation, and maintenance of all information technology network
components.
◉ Success of strategic information systems projects. Answer: A
majority fail to meet schedule or budget
,◉ Organizational features that can change the company direction.
Answer: Processes, politics, culture, and environment
◉ Global Business Strategies that form their organizational and
information systems structure. Answer: transnational, multinational,
franchisers, domestic exporter
◉ Transnational. Answer: a commercial enterprise that operates
substantial facilities, does business in more than one country and
does not consider any particular country its national home.
◉ Multinational. Answer: an organization that owns or controls
production of goods or services in one or more countries other than
their home country.
◉ Database Management System (DBMS). Answer: Allows multiple
departments to access, analyze, and modify data that is stored in one
central location.
◉ Total Cost of Ownership (TCO). Answer: Helps establish feasibility.
◉ Platform as a Service (PaaS). Answer: service provider provides
server space, the server, virtualization, operating system, database,
and development environment in a platform that can be used for
, application development. An example would be Amazon Web
Services.
◉ Infrastructure as a Service (IaaS). Answer: A service provider
provides a cloud fabric, or pooled services, including server space,
servers, storage, and all other aspects of the computing platform,
with the exception of the operating system and applications, which
the client organization would install and manage.
◉ Analytics as a Service (AaaS). Answer: A cloud software service
◉ Software as a Service (SaaS). Answer: Software licensed and
hosted on centralized or distributed servers that belong to a service
provider. Users access this software using a connection to the
Internet and a web browser.
◉ Agile software development methodology. Answer: an operational
method by which software developers iteratively gather
requirements, plan, design, develop, test, and implement software.
◉ Information Technology Infrastructure Library (ITIL). Answer:
common set of best practices widely used by businesses to give
guidance to companies on how to use IT as a tool for implementing
change
