CIS 2210 - Test 2

The stylist just did a great job and your hair is going to look good for weeks. The stylist charged $70 and you decide to ass a 15% cash tip. How big is the tip?

$10.50

What are the four most commonly used web browsers?

- Chrome - Safari - Firefox - Edge

The parts of a URL include...

- Protocol - Domain name - Host - an optional query string

What are the two main parts of a webpage?

- head - body

What file extension is commonly used for term papers and other word processing task?

.docx

The term "server" has two meanings. One is a physical server that stores files and web pages, the other meaning refers to ______ that manages and processes server requests and delivers data to other computers.

Computer software.

When you need to link two tables in a database that don't have a field in common, on solution is to create a _______ in one table that links to the primary key in the other table.

Foreign key

Although not programming language technically, ______, related to the protocols that enables content to be displayed on the internet.

HTML

Computer hardware and software used by an organization to improve its performance is called its _______.

IT System

What program, by parsing XML documents, makes information more readable for programmers?

JSON

The programming language _______ makes it much quicker to create websites and webpages.

JavaScript

______ is a computer programing language that enables the client-server (browser) to interact with users, change document content communicate asynchronously, and more.

JavaScript

Microsoft offers free cloud storage of everyone who has a Microsoft e-email account. The storage is called Microsoft _______.

OneDrive

What is the acronym for Hypertext PreProcessor?

PHP

The term used for designing websites to be viewed on all types of devices is known as ______

RWD (Responsive Web Design)

When displaying financial information, the accepted practice is that ______ indicated negative values.

Red

What refers to the distribution of computer applications over the internet and is commonly referred to as web apps?

SaaS

Writing in the English language and as a flowchart, a programmer uses a(n) ________ to describe the problem to be solved by the program.

algorithm

One of the first stages of the PDLC testing method is a test of fresh software performance by the programmers themselves or contract evaluators working alongside the programmers. This is called the _____ test.

alpha

The devices inside your phone that convert analog waves (such as sound waves) into digital signals that you phone can process are called __________.

digital analog converters

Because they make it east to arrange, display, and calculate numerical data, ______ programs are commonly used in nearly every business setting.

spreadsheet

Programs such as Microsoft Excel, iWork's (Apple) Numbers, Google Sheets, OpenOffice Calc, that allows users to arrange numerical data are called...

spreadsheets

Adding a microSD card (when possible) increases your phones _______ capacity.

storage

A Cascading Style Sheet (or a CSS) uses ______ to define many properties of elements including visual properties such as color, size, and fonts as well as where and how elements are positioned on a page.

styles

Apple developed ______, a programming language for Mac OS and iOS writing software because Objective-C was hard to write.

swift

The cell tower's base transmission station is connected to a mobile ______ station.

switching

Connecting you phone to your laptop to transfer photos, videos, or music files is referred to as _________.

syncing

Ironically, the expenses for calling and ______ are amount the smallest charges around on a cell phone bill.

texting

What is the purpose of saving an Excel file as a .cvs (comma-separated format) file?

to share data with other spreadsheet users regardless of which spreadsheet program is being used.

You might consider constructing a wireframe when designing a website. A wireframe is a ______ representation of the user interface for a web page.

two-dimensional

Some apps that use a surprising amount of data are those that include embedded _______.

videos

In Apple iWork's Numbers the freeze options are located under the Table tab. In Microsoft Excel and Google sheets the freeze cells or panes options are found in the _____ menu.

view

To change the size of your folder's icon, just right-click on the blank area of the Contents pane and click ______.

view

The term "Search Engine Optimization" (SEO) refers to the process of making a website ______ in a user's search results.

visible

In urban areas, the cell towers become more numerous and the cell signals transmitted by the cell towers are ______, than those in less populated areas.

weaker

A domain is the name of a ______.

website

An IP address is a string of number that tells a computer where to look for a ______.

website

A search engine has a database of _______, and when a users types in a search word, the search engine searches its database for a match.

websites

What extension, will probably install software onto your computer? Be careful!

.exe

Which of the following file extensions is commonly used for drawings?

.gif

How many people can own a domain name?

1

A web page has _____ main parts.

2

LTE and ________ are best for streaming or uploading photos or videos.

5G

A friend asks if you want to go see the new avengers move but you say it's too expensive. "No it's not, tickets have only gone up $2.00 since last year," says your friend. You reply, "tickets went from $8 to $10 for a matinee." That is a large percentage increase. What formula would provide the percentage increase?

= (10 - 8) / 8 * 100

Select the spreadsheet formula that would correctly calculate the average (mean) of the following values: 3, 2, 6, and 8.

= (3 + 2 + 6 + 8) / 4

If you want to find the mean of a set of values, what function would you use?

= AVERAGE

To quickly show if the values in a column or row are greater than, less than, or equal to a certain value, use the _____ function.

= IF

To determine how much a recurring monthly payment would be for a care loan or a mortgage, use the ______ function.

= PMT

Versions of the _________ used to be assigned sweets/candy names, such as Oreo or Pie.

Android OS

AJAX stands for ________ JavaScript and XML.

Asynchronous

Σ (sigma) What does the symbol (upper-case Sigma) represent in spreadsheets?

AutoSUM

The PDLC's coding phase uses which of the following languages?

C++

The cost of borrowing money, quoted as an annual percentage rate (APR), is a loan's...

Interest

You're tired of losing documents so you've decided to save your research paper to your desktop where you know you'll be able to locate it quickly. To save it to the desktop, you first click the File tab to open the file menu. Next you select ______.

Save As

Because it comes with a full computer operating system, some consider ______ a laptop computer rather than a tablet computer.

Surface Pro 8

The acronym URL stands for?

Uniform Resource Locator

Although not a programing language technically, _______ pertains to the protocols that enables content to be displayed on the internet.

XML

In spreadsheets, all functions and calculations begin with...

an equal sign (=)

The second step of the SDLC phase is to collect information on current hardware and software, analyze this information, and prepare system requirements. This is called the phase of the _______ scheme.

analysis

Your computer is the client when you type a URL into your browser. A request is sent to a server by your ______.

browser

Web programming write the ______ that creates the pages that viewers will see.

code

If you wish to e-mail a file to a friend, but find that it's too big for your e-mail server, you can always ______ the file.

compress

To select nonadjoining cells in a spreadsheet, hold down the ______ key while selecting cells.

control (Ctrl)

Before you can start tethering, verify that it's included in your cell phone's _____ plan.

data

Pivot tables provide a quick way to organize information. In most spreadsheet programs, click the ______ tab to create a pivot table.

data

There are almost always errors after the code has been written. The PDLC's fourth step involves finding and correcting these errors in a process. This process is called ______.

debugging

A website usually has a lot of folders, also known as ______.

directories

When you _______ a file Windows automatically open it. If it can't Windows will prompt you to select the contact app to open the file.

double-click

If you have two folders open on your desktop and you want to move a file from one folder to the other, simply _______ the file.

drag

HTML documents are broken down into sections called _____.

elements

If you see the extension .xlsx, you know that you are looking at an _______ file.

excel

You created a flyer and saved it in your documents folder. To find this file you could open Cortana (in Windows 10) and type the flyer's name in the search window, or you could click on the _______ icon (all Windows versions, on your toolbar) and access the documents folder from there.

file explorer

Defining the problem is the ______ step in the program development life cycle (PDLC).

first

The ______ step in software development is: What should the program do?

first

After the problem has been clearly defined, the third step in the PDLC is to create the plan or algorithm. This plan is usually written as a _______ and is written in an ordinary language, such as English.

flowchart

In order to keep your files organized, it's a good idea to create ______ and place your files in them.

folders

The largest category of apps, both in terms of active downloads and in terms of revenue generated is ______.

game apps

Third-party apps must be reviewed and approved by apple before being available for the ______.

iOS

In order to sync iPhone to you MacBook you must first open the _______ app.

iTunes

The first step in the SDLC is to define the problems to be addressed by the IT system, examine different alternatives, and report the findings. This is called the ______. step.

investigation

Instructions (software) that allows a computer (hardware) to be used are written using specific symbols, letters and numbers known as code or programming ______.

language

Because of the large infrastructure cost of building antennae and mobile switching stations, as well as leasing the rights to use radio frequencies, only _____ companies can compete nationally as cell phone providers.

large

On advantage that the Samsung tablets have over the iPads is that you can add ________ to the Note or Tab.

microSD storage

Website video, audio, and slide shows are examples of what type of files?

multimedia

A ________ - oriented assessment operates well when inputs can readily;y be put into distinct categories or classes.

object

Changing the appearance to your can make it easier to keep your folder information organized. To change your folder's appearance, first click pm the folder, and then go to the Command bar and click ______.

organize

To watch an .mpeg file, you'll need an app such as Windows Media Player or QuickTime. These apps are called video _____.

players

The amount of money borrowed in a loan is often referred to as the loan's balance or the ______ of the loan.

principle

The initial phase in the program improvement life cycle is "Defining the ______."

problem

Converting a task into commands that a computer can use to perform the task is called ______.

programming

Before a browser displays your web page, it first ______ and ______ all the HTML, CSS and other codes.

reads and interprets

If you accidentally delete a file it's not lost forever! Just go to your Recycle Bin, select the item, and click _______.

restore

An easy way to create a new folder in Windows is to _____ on any area in the contents pane, and then click New and Folder.

right-click

An easy way to rename a folder in Windows is to _______ on the folder and then click rename.

right-click

The most common method of renaming files and folders is to simply ________ on the item and select rename.

right-click

If you're in an area where you home network has no cell coverage, you may need to use the cellular network of a different provider. This is called _______.

roaming

Sometimes, particularly when traveling, you may find yourself in an area where your home network has no cell coverage, but another network does have service. Using a different network is referred to as ______.

roaming

The two major concerns regarding cloud storage are reliability and ________.

security

A _______ is a large computer that stores files, including web pages, that can be accessed over the internet.

server

A web hosting company will store all the files and folders for a website on a _______.

server