CIS exam 2

What are the four most commonly used web browsers?

- chrome - safari - edge - firefox

What are the two main parts of a webpage?

- head - body

The parts of a URL include

- protocol - host - domain name - path - optional query string

Which of the following file extensions is commonly used for term papers and other word processing tasks?

.docx

Which of these extensions, if you open it, 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

The number 27 in the cell depicted above is a value, not a formula. If the user drags the cursor to the right, what will appear in the cell to the right?

27

Most new cell phones today come with approximately ________ of RAM.

500 MB-2 GB

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

5G

A friend asks if you want to go see the new Avengers movie 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

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

= (4 + 2 + 5 + 5) / 4

A set of programs for exchanging data on a website without altering the display of the website is ________.

AJAX

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

Android OS

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

AutoSUM

If you want to find the mean of the values in cells above A37 in the above spreadsheet, what function would you place in A37?

Average

The programming language of the third generation learned by most students when most computers used MS DOS was ________. It continues as a secure programming language to use 3rd party code and offers a standard for coding that readily integrates with other programming languages.

BASIC

If you are planning to write PC games software, you might need to know C or ________.

C++

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

C++

One way to copy and paste a file to a new location is to click on the file and press CTRL + C to copy, then move your cursor to the new site and press ________ to paste.

CTRL + V

If you see the extension .xlsx, you know that you are looking at a(n) ________ file.

Excel

This version of the HTML set of protocols designed to display documents on the web provides a smooth interface between natural language and machine language by wrapping data for web display in "tags".

Extensible Markup Language

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

If you wish to keep a column visible while you scroll through the rest of a spreadsheet file, you can use the ________ options.

Freeze

To retain a row or column, but remove it from view, right-click on the row or column heading and select

Hide

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

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

IT system

Which of these programs, by parsing XML documents, makes information more readable for programmers?

JSON

An object-oriented programming language used by Android phones and tablets to write apps is ________.

Java

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

JavaScript

Microsoft offers free cloud storage for everyone who has a Microsoft e-mail account. This storage is called Microsoft ________.

OneDrive

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

Organize

What is the acronym for Hypertext Preprocessor?

PHP

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

PMT

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

RWD (Responsive Web Design)

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

________ programming is a programming design that breaks a issue into a sequence of functions.

Top-down

The acronym URL stands for?

Uniform Resource Locator

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

View

________ Basic is a programming language of the third generation that enables BASIC to be used with the benefits of a graphical user interface.

Visual

Although not a programming language technically, ________ pertains to the protocols that enable content to be displayed on the Internet.

XML

To make a calculation always refer to a specific cell when copying it using the fill handle, make the cell a(n) ________ reference.

absolute

Written 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 performed by the programmers themselves or contract evaluators working alongside the programmers. This is called the ________ test.

alpha

In order to change sound waves into digital signals, smartphones contain a(n) ________-digital converter.

analog

A question that is answered as either yes or no, or true or false, is called ________.

binary

In the financial world, which color represents credits or profits?

black

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

browser

The basic unit of any spreadsheet, essentially a box where data can be entered, is called a(n)

cell

To select a folder, simply put your cursor on it and ________.

click

Web programmers 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

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

The SDLC's third step consists of three phases, specifically developing multiple system proposals, selecting the most feasible proposal, and reporting on the system to be developed. This is called the system ________.

design

The fourth step in the life cycle of system growth is to get the required equipment and ensure that it operates properly. This is called the system ___________ step.

development

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

directories

When you ________ a file Windows should automatically open it. If it can't Windows will prompt you to select the correct 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

The ________ step in software development is: What should this program do?

first

A process's graphical representation is called a ________.

flowchart

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

folders

The Rule of 72 states that dividing 72 by the interest rate approximates the time for the investment to double. This calculates the ________ of the investment.

future value (FV)

Which is an example of a correct URL?

https://www.amazon.com

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

iOS

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

One 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(n) ________-oriented assessment operates well when inputs can readily be put into distinct categories or classes.

object

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

players

If you just need a phone for emergencies, you might consider a ________ phone.

prepaid

Bankers and other lenders refer to the initial amount of the loan (the principal) as the loan's

present value (PV)

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

reads and interpret

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

recover

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

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 your home network has no cell coverage, you may need to use the cellular network of a different provider. This is called ________.

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

Pseudocode is written in natural language but often includes programming ________ to assist in writing the program itself.

shorthand

Sports analysts often use ________ to keep track of statistics, times, and scores of nearly every sporting event.

spreadsheets

Adding a microSD card (when possible) increases your phone's ________ capacity.

storage

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

styles

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

switching

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

syncing

You see ###### in a cell. This means that

this is not an error. The cell needs to be expanded in order to display the entire value

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

Because of the popularity and bandwidth demands of video streaming, ________ data plans became very expensive. Tough competition for customers forced cell phone service providers to increase available bandwidth, so now these data plans are fairly common.

unlimited

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

videos

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 numbers that tells a computer where to look for a _____.

website

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

websites