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
What does the above symbol (upper-case Sigma) represent in spreadsheets?
AutoSUM
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
________ 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
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
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
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
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
Connecting your phone to your laptop to transfer photos, videos, or music files is referred to as ________.
syncing
