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