ISTC Final

which of the following functions would oyu use to calculate the arithmetic mean of a price list?

AVERAGE

Sam wants to count the number of cells between B1 and B20 that contain numbers in them. Write a formula for him to use.

COUNT(B1:B20)

Ben has created a source for a quotation in the citation manager. To inset a citation using this source, he should do what?

Click the insert citation button and select the desired source

to select non-adjacent cells or ranges on a worksheet, you can press and hold ___ while selecting each one.

Ctrl key

A picture on the title slide in Jacob's presentation is too large for the space. To change its size, he dragged the sizing handle on the right side of the picture. Now the picture looks distorted. What went wrong?

He dragged a side handle instead of a corner sizing handle. the image change in one direction but no the other.

To combine multiple cells into one combined cell, which of the following do you use?

Merge cells OR CONCAT function

Emma downloaded a new game from an unfamiliar website. A few days later, Emma realized her system had been hacked and her credit card numbers were stolen. Without Emma knowing. What type of malware might she have downloaded to her computer?

Trojan

"https" as the protocol in the URL tells you the website is secure

True

A strong password is a longer combination of letters, number, and/or symbols that unlocked access to electronic data

True

To reverse the last action you took in a database, click the ___ button.

Undo

What is a JPEG?

a commonly used method of lossy compression for digital images, particularly for those images produced by digital photography.

After you enter text in a placeholder, what does the placeholder become?

a text object

In APA format, a works cited list is called

bibliography

To format a range so that all values greater than $500 appear in red, which of the following can you use?

conditional formatting

to have text appear at the bottom of each page in a document, do which of the following?

double-click the footer region of the page and enter the desired text

During a slideshow, Luis wants a picture to appear on one of his slides after the slide appears on the screen. Which type of animation should he use?

entrance effect

an animation causes an object to appear on a slide after the slide appears during a slide show is an emphasis animation

false

to prevent a laptop from being stolen, you use a surge protector

false

to change the name of the worksheet, you rename the

file

A(n)___ is a small picture that represents a program, file, or hardware device

icon

Isiah needs to insert a copyright symbol (the C one). What are the steps to do this?

insert a symbol from the symbol gallery

what is the main purpose of an operating system?

is to provide a platform on which a user can execute programs on convenient and efficient manner

What is a search site

it is a search engine, a website dedicated to searching things and helping people find what they need

In a complex formula, how does Excel determine which calculation to perform first?

order of operations

what unit is text size measured in?

pt. (points)

In the formula = A8*$A$1, which of the following describes A8?

relative cell reference

where can you pin frequently used apps for eas asccesss?

taskbar

write a formula to total the cells B6, B7, B8, B9, and B10 most efficiently

the formula =SUM(B6:B10)

How does an encryption work?

the process of converting info or data into a code especially to prevent unauthorized access.

Cloud storage refers to the storage data on ___

the webs app' server

A chart title summarizes the data shown in the chart

true

currency is an example of a number format

true

if you want to move a reference form one paragraph, you can use the copy and paste commands

true

output methods include speakers, headphones, and interactive whiteboards

true

peripheral devices, like USB flash drive, are generally connected to your computer through ports

true

to provide emphasis to text, you can apply bold

true

to specify how a shape interacts with the text around it, modify the text wrapping of the shape

true

How is an executable file different from a data file?

unlike a data file, you can manipulate an executable file

Jazmyn cannot find the paper that she wrote last night. She is in a panic and you want to help her. What advice would you give her?

use the search tool to locate the file by name, content, or date

Compressing a file is also called __ the file.

zip file