Deck 8: Working With Trendlines, pivot Table Reports, pivotchart Reports, and Slicers

Question 1

Scott is an aspiring software developer.During an interview for a new job,his prospective employer asks what kind of program he could develop that,if needed,the company could use,modify and redistribute without restrictions.Which of the following would be an answer that would impress the interviewer?

A) A freeware program
B) An open source program
C) A Software as a Service (SaaS)program
D) A retail program

Answer 1

B

Question 2

Which of the following programs are distributed for little or no cost,or for a brief trial period?

A) Shareware
B) Public domain
C) Open source
D) Freeware

Answer 2

A

Question 3

___________ might include additional features not available in the version you currently are running.They are new releases of the program or app,and may require an additional fee to enable the program to install.

A) Service Packs
B) Patches
C) Upgrades
D) Restorers

Answer 3

C

Question 4

__________________ refers to unique and original works,such as ideas,inventions,art,writings,processes,company and product names,and logos.

A) Copyright
B) Intellectual property
C) License agreement
D) Digital Rights Management

Question 5

An organization intends to purchase the license of a software to provide access to as many users as it wants,either by individual installations or network access or Internet passwords.Which of the following should the organization purchase?

A) Single user license agreement
B) End user license agreement
C) Site license
D) Multiple user license agreement

Question 6

Archie wants to use a newly launched web browser on his computer.What steps should he ideally follow to get it on his system?

A) Download the setup program from the manufacturer's website and use it directly without installation.
B) Copy the program from a friend onto a USB flash drive and install it on his own computer.
C) Download the program from the manufacturer's website and install it on his computer.
D) Open the link that is advertised in the pop up and install it on his computer.

Question 7

Which of the following is a common infringement on copyright where people illegally copy software,movies,music,and other digital materials.

A) Piracy
B) License agreement
C) Digital rights management
D) Access control

Question 8

A banking app requires stringent access control measures for security reasons.Which of the following techniques could be used to define who can use it and what actions they can perform?

A) Incorporate biometrics and the need for passwords to access the application
B) Ensure installation of antivirus software on every customer's computer
C) Define the license agreements of the application appropriately
D) List out copyright policies to be taken into account while using the application clearly

Question 9

When we create a program or app,we are protected under copyright laws even before we apply for them because programs and apps are considered the intellectual property of the creator(s).

Question 10

Alexis changed a few default settings on a program she was using on her computer.Afterward,however,she did not like the results and preferred to get it back to default settings.Unfortunately,Alexis does not remember exactly what she changed.Which of the following types of tools could help her in this scenario?

A) Process managers
B) Auditing tools
C) Patch finders
D) Restorers

Question 11

If a software app is identified with a critical error after release,the development team can release a patch to address this single issue only.

Question 12

Why should we use an uninstaller that comes with an operating system rather than the system's file management program to delete the folder containing the program's files to remove a software or app from a device?

A) Deleting using system's program could introduce malware in the device; therefore,uninstaller is preferred.
B) An uninstaller removes the program files,as well as any associated entries in the system files.
C) An uninstaller takes up less time and storage than system's program to delete.
D) A system's program to delete is tougher to access and requires more steps.

Question 13

While starting a software application,Ian encountered an error that the version was no longer supported.Which of the following options can resolve the issue?

A) Ian could visit the company website and install the latest version or updates on his computer.
B) Ian should restart the application again and check if the problem is resolved.
C) Ian could troubleshoot by replacing the operating system as a standard procedure whenever an application crashes.
D) Ian should immediately delete the program from the system file management and never attempt to use it again.

Question 14

A license agreement specifies the number of devices on which you can install the product,any dates of expiration,and other restrictions.

Question 15

Devices like cars and TVs require software programs to control them,but without including computers,tablets,or smartphones.In such cases,embedded software could be used.

Question 16

What kind of products are accessible from the Internet without requiring permission to use them,thereby free from being subjected to copyright violations?

A) Public domain products
B) Freeware
C) Open source
D) Shareware

Question 17

____________ is the process of setting up the program or app to work with your computer,mobile device,and other hardware.

A) Activation
B) Registration
C) Installation
D) Upgrading

Question 18

A software development team was asked to release a banking app by a certain date.The app is vast with high security access controls and multiple other features.The team could not meet the deadline with all of the features in it.Which of the following options is the best possible way to troubleshoot this scenario?

A) Release an initial stable version with important features prioritized,and then add features as upgrades.
B) Ignore the planning or analysis phase and focus more on the implementation phase.
C) Omit a few features from the development plan,and release a single version,thereby saving time and cost.
D) Postpone the due date and release a single and final version of the product with all features.

Question 19

__________ are types of tools that track the memory usage,status,and errors of currently running software.

A) System information lists
B) Auditing instruments
C) Patch finders
D) Process managers

Question 20

Hector wants to purchase a new laptop.Which of the following is the most important pre-installed program that he should check for on the laptop before buying it,so that he can start to use the laptop as soon as he owns it?

A) System software
B) Productivity software
C) Web browser
D) Media player

Question 21

Which of the following is an implementation of OOP concepts?

A) Producing each functionality in a structured approach
B) Writing objects and creating instances based on functional need
C) Creating methods to define data format of object and create class to define the behavior of an object
D) Writing one program with all functionality,behavior,data and actions

Question 22

_________ software creates a personal security zone around your computer by monitoring all incoming and outgoing traffic and blocking suspicious activity.

A) Antivirus
B) Antispyware
C) Firewall
D) Antispam

Question 23

Assembly languages are the second generation of languages.With an assembly language,the programmer uses symbolic instruction codes,such as A for add,M for multiply,and L for load.

Question 24

During the planning phase of a software design project,the team members working on it were identified.While identifying a designer,the committee contemplated if an inexpensive and underqualified person could be used.Which of the following statements are valid and based on the premise that the decision,if taken,would be a bad one?

A) A designer writes code or uses a product development app to create the program's specifications.As he creates the product,a designer is necessary.
B) A designer reviews every aspect and functionality of a program to ensure it works as intended.As he ensures a working product,a designer is necessary.
C) A designer develops the program's user interface,including colors,fonts,and layout.As he focuses on the user experience,ease of product use and navigation of the software,a designer is necessary.
D) A designer interacts with customers and users of the product to assist them with any issues that arise.As he assists the customers,a designer is necessary.

Question 25

When Russ opened a website on his browser,he saw an error that the site was not compatible with the browser version he was running it on.What tools could Russ use to troubleshoot this issue?

A) Restorers
B) Auditing tools
C) Process managers
D) Patch finders

Question 26

What defines the behavior of an object in object-oriented programming ?

A) Object by itself
B) Class
C) Method
D) Device or platform on which the program runs

Question 27

Is it advisable to enable automatic updates on security software?

A) Yes; this helps in catching and quarantining any new malware before they harm the computer.
B) No; it is better to have user control to be aware of what is being updated.
C) No; updates may take up considerable amounts of storage space and slow the computer down.
D) Yes; but it is better to use free trial versions than to pay for those with complete features.

Question 28

A class is a type of object that defines the format of the object and the actions an object can perform.

Question 29

Which generation language provides a graphical environment in which the programmer uses a combination of English-like instructions,graphics,icons,and symbols to create code?

A) Machine language
B) Assembly language
C) Procedural language
D) Fourth generation language

Question 30

Which type of security software prevents,detects,and removes the malware program that tries to collect personal information or change computer settings without your consent?

A) Antivirus
B) Antispyware
C) Antispam
D) Firewall

Question 31

Simon established a startup.He wanted to secure a domain name and have a website to market and sell his products.In this regard,which of the following should be the first step?

A) Acquire trademarks and copyrights in order to protect against piracy and to develop license agreements.
B) Develop an impressive digital graphical user interface to market the products on the website.
C) Provide contact information and good product catalogs.
D) Market the products using advertisements and build a brand name.

Question 32

Multiple issues were reported by the users over a chat application's version 1.0.Which of the below should the company release to address all these in a single issue?

A) Service pack
B) Patches
C) Upgrades
D) Restorers

Question 33

Which of the following is an implementation of OOP concepts?

A) Producing each functionality in a structured approach
B) Writing objects and creating instances based on functional need
C) Creating methods to define data format of object and create class to define the behavior of an object
D) Writing one program with all functionality,behavior,data and actions

Question 34

It is often required to transfer huge files across locations within businesses and corporate offices.Email usually cannot handle such large files which is why file transfer tools are available to perform such tasks.Which of the following categories of programs and apps do these tools belong to?

A) Productivity (business and personal)
B) Communications
C) Security
D) File,disk,and system management

Question 35

A company develops a gaming application that it intends to sell.One of the scenarios that the sales team is concerned about is when multiple users use the app from multiple devices for a single fee if the login credentials or security access key is shared among the members.What is the best solution to prevent this?

A) Use the registration technique.
B) Use the activation technique.
C) Define copyrights to prohibit access on multiple devices.
D) Uninstall the app automatically on one device,if it is accessed from another.

Question 36

A software company is working on a new project for a mutual fund organization.The client expects the scope of the project to be flexible; their goals are evolving and they needed to test the product as and when components are finished.Which type of project development methodology should be adopted?

A) Waterfall model
B) Agile development
C) Rapid application development
D) Predictive development

Question 37

In which phase of the SDLC life cycle is the feasibility study done to determine if the project is worth pursuing?

A) Planning phase
B) Analysis phase
C) Design phase
D) Implementation phase

Question 38

Movies,music,and other digital content can be illegally distributed.What laws or strategy are designed to prevent this illegal distribution?

A) Access controls
B) Intellectual Property rights
C) Digital Rights Management
D) License Agreement

Question 39

Open source is a type of program and app that is copyrighted and provided at no cost,but the developer retains all rights to the product.

Question 40

In which category of software do Microsoft Office Word and Excel belong?

A) Productivity
B) Graphics and media
C) Personal interest
D) Security

Question 41

Programmers use compilers to test code in one section,or an entire program,to determine any errors and provide suggestions to fix them.

Question 42

Which of the following is a general guideline for developers?

A) Group the activities into phases.
B) Involve users for whom the program is being developed.
C) Define the standards,or sets of rules and procedures,to create a standard product.
D) Create a system proposal,interact with customer and ensure the project kick off.

Question 43

A project was successfully implemented for a banking customer.The team that worked on the project was deallocated on the closure of the project.However,the client came back after a couple of months with a few functionality changes and the company could not allocate the same set of developers back to the project.The new team of developers had a tough time understanding the existing code and functionalities.What could be the reason?

A) Prototype was missing and hence the new team had a tough time.
B) Proper documentation was missing that would have helped the new team understand the product better.
C) The system proposal was missing and the new team could not be briefed adequately about the product.
D) The feasibility study of the product was inadequate.

Question 44

Which of the following translation tools does NOT produce or store object code but translates instructions statement by statement?

A) Compilers
B) Debuggers
C) Interpreters
D) Eclipse

Question 45

During which phase does the program or app receive necessary maintenance,such as fixing errors or improving its functionality,performance monitoring to ensure the efficiency of the program or app?

A) Implementation phase
B) Support and security phase
C) Design phase
D) Analysis phase

Question 46

A company received a proposal for the development of a new software.While analyzing the specifications,it was found that there was no clear goal and the scope of the project could evolve.Which methodology should the company adopt to execute this project?

A) Rapid Application development model
B) Predictive development model
C) Agile development methodology
D) Waterfall model

Question 47

Designers use ___________,which are blueprints of different aspects of the program that also indicate how a user gets from one area of the program to another.

A) code
B) computer hardware
C) wireframes
D) Microsoft office

Question 48

Connie opened a link that she received in an email.It led to a webpage that congratulated her on winning $1 million.The webpage instructed her to follow a few steps after which she found her laptop functioning erratically.Connie had restricted access to her own folders and the data was encrypted.She was asked to pay for an access key to release them.What kind of malware attack is this?

A) Ransomware
B) Spyware
C) Virus
D) Spam

Question 49

A company intends to improve the productivity of its developers so that the programming is easier and can be finished quickly with fewer syntax errors.What should the company provide to its developers to work?

A) Integrated development environment (IDE)
B) Procedural languages training
C) Compiler/interpreter
D) Code repositories

Question 50

During which phase and by whom should the software product be tested for security,hacking,and proper functionality?

A) Testing happens during last phase of project and is done by the developers before releasing to the client.
B) Testing starts at the first phases of development and continues throughout by quality assurance testers.
C) Testing is started and completed during the design phase by the designers.
D) Testing starts at the first phases of development and continues throughout by developers and project managers.

Question 51

At the monthly meeting,Che,Director of Development,realized that deadlines were disregarded and program codes were missed during development of the department's new interface.The product's budget and schedule were inconsistent so Che was having trouble getting a clear picture of the project and its progress.Whose role and responsibility was all of this?

A) IT department
B) Designer
C) Project manager
D) Programmer

Question 52

Which commonly used programming language is used to manage,access,and search for database content?

A) Java
B) C++
C) SQL
D) HTML

Question 53

What is the working procedure of DevOps methodology?

A) It uses a linear and structured development cycle.
B) It uses a condensed or shortened development process to produce a quality product.
C) It produces programs quickly,and then offers continuous updates to increase the functionality of the program.
D) It develops a finalized and functional product at one shot without scope for future upgrades.