exam 2

You just had a great lunch at a nice restaurant and decide to leave a 15% tip on your $18 meal. What will be the total charge on your debit card?

$20.70

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

A smartphone emits approximately ________ watts of microwaves.

0-1

How many people can own a domain name?

1

If you type =8 / 2 * 4 + 1 into a cell in a spreadsheet and then press Enter, what will appear in the cell?

17

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

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

AJAX

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

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++

What function would you use to display how many entries are made in Column A above Cell A37?

COUNT

What are the four most commonly used web browsers?

Chrome Firefox safari

Select the Samsung smartphone.

Galaxy S21

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

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

INTEREST

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

The programming language ________ makes it much quicker to create websites and web pages.

JavaScript

______ 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

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

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)

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

SaaS

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

Spreadsheet

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

Spreadsheets

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

Swift

The acronym URL stands for?

Uniform Resource Locator

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

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

Visual

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

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

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

A program that checks the source code for errors and converts it into machine language is a ________.

compiler

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

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

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+x

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

HTML documents are broken down into sections called _____.

elements

If you see the extension .xlsx, you know that you are looking at a(n) ________ 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

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

interpreter

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

itunes

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

language

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

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

principal

Converting a task into commands that a computer can use to perform the task is one definition of computer ________.

programming

The parts of a URL include

protocol domain name host

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

reads and interpret

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 ________-click 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 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

In a spreadsheet, a horizontal line of cells is called a

row

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

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

A domain is the name of a _____.

website

describe the five steps of the Program Development Life Cycle (PDLC). The five steps are:

1. Defining the problem 2. Creating a plan 3. Writing the code 4. Testing the code 5. Debugging the code

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

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

first

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)

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

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

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

surface pro-8

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

switching

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

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

To change the size of your folder's icon, just right-click on a 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

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