CIS Exam 2

In an Excel file, if a label (such as the word "panda") is used in a formula, what will appear in the cell when the enter key is pressed?

#VALUE!

Select the spreadsheet formula that would correctly calculate the average (mean) of the following values: 25, 50, and 70.

(25+50+75)/3

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 drawing

.gif

If you type =3+2^2*6 into a cell in a spreadsheet and then press Enter, what will appear in the cell?

27

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

4 GB-16GB

LTE and ______ are best for streamining or uploading photos or videos

5G

Every time you go to the gas station you're amazed by how much prices have increased. At this time last year, the price was $3.20 per gallon and now the price is $.25 per gallon. Which of the following spreadsheet formulas correctly calculates the percentage change?

=((4.25 - 3.20) / 3.20) * 100

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

Which of these operating systems is based on Linux and used of smartphones?

Android

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

Android OS

What does the symbol above represent in spreadsheets?

AutoSum

To remove a file from one folder and place it in another, click on the item and press ___, then move your cursor to the new location and press CTRL + V.

CTRL + X

What is the purpose of using color in spreadsheets?

Color makes data easier to read.

The second step in the PDLC is to create the plan or algorithm. This plan is usually written in_____

English

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

Select the Samsung smartphone.

Galaxy S21

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

The method used in the development and maintenance of an IT scheme is called the SDLC. SDLC stands for System Development _____ Cycle.

Life

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

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

Problem

If you accidentally delete a file it's not lost forever! Just go to your recycling bin, select the item, and click ____

Restore

Which of the following refers to the distribution of computer applications over the Internet and is commonly referred to as web apps.

SaaS

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

To look for a file or folder in Windows 10, just type the file name in the _____box.

Search

Choose the program you would be using if you would like to write iPhone applications.

Swift

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

View

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

absolute

In order to change sound waves into digital signals, smartphones contain ___ - digital converter.

analog

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

Testing and documenting the software are the final steps in the PDLC process. When testing is carried out by the software's potential customers, is called an ______ test.

beta

In the financial world, which color represents credits or profits

black

Saving a spreadsheet file in .cvs format only saves the

cell values

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

A program that checks the source code for errors and converts into machine language is a____

complier

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

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

data

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

debugging

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 system ____

design

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

digital-analog converters

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

Defining the problem is the ___ step in the Program Development Life Cycle.

first

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

folders

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

freeze

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

game apps

What are the two main parts of a webpage?

head and body

Which is an example of a correct URL?

https://www.amazon.com

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

interest

A program that can be used to turn a single line of C# into a machine language without the complete program being complied is called a C#

interpreter

While many third-party apps are available through its App Store, apps for __ must first be tested and approved before they are made available for downloading.

iphones

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

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

An initial value process, a process and a test condition which can potentially return to the initial value is called a ________.

loop

Even a small degree of programming skill can be beneficial. Many apps allow you to create mini-programs that reduce the number of routine steps required to complete a task. These mini-programs are called ___ .

macros

Cell phones send and receive extremely weak _____ signals to and from cell towers.

microwave

JSON stands for JavaScript ______________ Notation

object

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

one-drive

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

Written in natural language, but often including shorthand to help write the program itself, ___ is the term that defines an intermediate step in generating a flowchhart algorithm.

pseudocode

When displaying financial information, the accepted practice is that_____indicates negative values.

red

A common method to delete a column or row in most spreadsheet programs is to____on the column or row headings, and then select Delete from the menu.

right-click

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

right-click

The common method of renaming files and folders 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

Sometimes, particularly when travelling, 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

Pseudocode is written in natural language but often includes programming______to assist in writing the program itself.

shorthand

A small computer within your phone that enhances the sound quality of your cell is called a digital ____processor

signal

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

spreadsheet

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

syncing

Ironically, the expenses for calling and ___ are among the smallest charges found 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

The term "search engine optimizer" (SEO) refers to the processof making a website____ in a user's search results

visible

In urban areas, the cell towers become more numerous and cell signals transmitted by the cell towers are_____than those in less popular areas.

weaker

A domain is the name of 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