stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Duplicate of DIT Final Exam Review Flashcards | StudBud
Explore
/
Duplicate of DIT Final Exam Review
Duplicate of DIT Final Exam Review
50 terms
·
StudBud Administration
·
1 play
Imported from external platform
Flashcards
50 cards
F
Practice quiz
P
Host live
L
Questions
50
Answers
1
Which of the following functions in NOT provided in Excel?
HIGH
MIN
AVERAGE
MAX
2
Which allows the diagram of content & graphics & to reconfigure bulleted lists into a diagram w/ connecting shapes?
Text Box
SmartArt
Shapes
Table
3
A list of information can be converted to a table by clicking the _____ tab, under the _____ dropdown.
Insert, Table
Table, Design
Table, Insert
Review, Table
4
Adding a new source to a built-in bibliography can be done through the _______ tab.
View
References
Review
Layout
5
What is the default file extension when you save a workbook in Excel 2016?
.excel
.exe
.xls
.xlsx
6
In Excel, you can total a large range of data by selecting which tool button?
AutoFill
AutoFormat
AutoSum
AutoCorrect
7
The small box in the corner of a tab's subgroup is known as the
dialog box launcher.
group.
template.
extra options.
8
Which option can be used to create a new slide show with the same slides, but presented in a different order?
Custom Slide Show
Rehearsal
Slide Show Set Up
Slide Show View
9
How can a slide be repeated continuously?
not possible
Repeat Continuously
Loop continuously until "Esc"
Loop more
10
When you have a shape selected, an extra contextual tab is added to the ribbon. What is the tab named?
Drawing Tools > Format
Drawing Tools > Edit
Drawing Tools > Change
Drawing Tools > Design
11
What is a slide transition?
a special effect used to change slides in a slideshow
letters on a slide
an animation used to move items around on a slide
the way a slide looks
12
Anything you discuss using any type of email; personal, business, or school, is private/cannot be viewed by anyone else.
False
True
13
PowerPoint is a collection of
outlines.
slides and handouts.
all of the above.
speaker notes.
14
Which of the following operates by blocking, filtering, and/or encrypting data that is transmitted through a port?
viruses
firewalls
trojans
defenders
15
Which symbol would you use in order to multiply in Excel?
/
@
*
$
16
If you get a value "####" when in Excel, then
you have misepelled something.
the formula is incorrect.
the cell is not wide enough for the entry.
you have entered a number wrong.
17
How would you know an item in a slide has an animation applied to it?
The animated item says "animated" next to it.
You only know once you play the presentation.
The slide has a notation that says "animation" at the bottom.
The animated item has a number next to it.
18
Through the Insert tab, text can be converted into a hyperlink that will take the reader
to all of the above.
to a new document.
to a website.
to another place in the document.
19
What happens during the storage stage of the "Information Processing Cycle"?
The computer presents the information to the user.
The user enters data into the computer.
The computer manipulates data inputs based on instructions.
The computer retains information for recall at a later time.
20
If you press the "Tab" key while in Excel, the active cell moves one cell to the left.
False
True
21
The # of pages, the word count, page layout, and document zoom are at the bottom of the document screen on the ____ bar.
bottom
ribbon
document
status
22
Which of the following is the protocol used to send emails?
TCP/IP
SMTP
RDP
POP3
23
Which path shoud you follow to change the AutoRecover file location?
File > Options > Save
File > Manage Document > Recover Unsaved Documents
File > Save As
File > Options > Display
24
A note providing more info, such as a comment or citation, that appears at the bottom of the page is called a(n)
footnote
bibliography
endnote
citation
25
In order to apply a Motion Path in Microsoft PowerPoint, which of the following paths should you use?
Transitions > Add Animations
Transitions > Animations dropdown (more) > More Motion Paths
Animations > Add Animations
Animations > Animations dropdown (more) > More Motion Paths
26
What is the difference between a chart and a table?
A table is a graphical representation while a chart uses rows and columns.
There is no difference.
A table is an example of a chart.
A table uses rows and columns while a chart is a graphical representation.
27
Which of the following is NOT an input device?
microphone
keyboard
mouse
CPU
28
Why is the SUMIF function used?
to multiply all the cells in a range that meet a specified criteria
to multiply all the cells in a range
to add all the cells in a range that meet a specified criteria
to add all the cells in a column range
29
What is the difference between a web page and a website?
website=software program; web page=a document
website=set of pages with common theme; web page=a single document page
web page=software program; website=set of pages with a common theme
web page=set of pages with a common theme; website= a single document page
30
What is the most common type of network that refers to any group of computers linked near each other?
WAN
MAN
LAN
PAN
31
Which choice includes three types of malware, or malicious software?
spiders, viruses, snakes
viruses, trojans, spyware
spiders, trojans, spyware
viruses, trojans, snakes
32
What function is performed in the following formula? =C7-C9
multiplication
subtraction
addition
division
33
Text stored in a web browser that attaches to a user in order to gather information and advertise is called a
firewall.
cookie.
virus.
control.
34
A note giving more info in your document, like a comment/citation, that appears at the end of document is called a(n)
footnote
endnote
bibliography
citation
35
An intranet is
a group of computers connected within a small office environment.
another name for the internet.
an internal private network belonging to an organization/employees.
an internal private network accessed by outside users w/ username/password.
36
On an Excel worksheet, an active cell is indicted by which of the following?
none of the above
a blinking border
a dotted border
a dark, wide border
37
Which of the following is a Microsoft Office software application?
Photoshop
Acrobat
Flash
Excel
38
Which is the most common applied collection of protocols/foundation of the internet?
TCP/IP
RDP
DNS
IMAPV4
39
Which of the following are the four types of animation available in Microsoft PowerPoint?
Entrance, Exit, Motion Paths, Dance
Entrance, Emphasis, Exit, Motion Paths
Entrance, Emphasis, Move, Exit
Entrance, Preview, Move, Exit
40
Which of the following is an example of a data range?
A1;B3
A1=B3
A1*B3
A1:B3
41
The BCC component of an email message is a text field to enter
the email address is sent to "secondary" recipients.
the specific topic of your email or a descriptive word.
the email address is to the direct audience
the email address is sent to "tertiary" recipients
42
In the following formula, what does the "$" mean? =SUM(B8*$R$6)
relative reference
absolute reference
currency
nothing
43
Which view in PowerPoint can be used to enter speaker comments?
Outline View
Notes Page
Normal
Slide Sorter
44
Where can you set the timing for each object?
View > Custom Animation
View > Slide Sorter
Slide Show > Custom Animation
Slide Show > Custom Transitions
45
On the Home tab in Microsoft Word, the Editing subgroup includes all of the following except
Find.
Change.
Select.
Replace.
46
How would you add a Clustered Column Chart to a PowerPoint slide?
Layout > Table > Column
Insert > Chart > Column
Layout > Chart > Column
Insert > Table > Column
47
Which tab of the Excel ribbon should you go to in order to remove gridlines from a worksheet?
Insert
Page Layout
View
Review
48
What is the software program written by Adobe that can help to create HTML?
Adobe Acrobat
Adobe Dreamweaver
Adobe Photoshop
Adobe Illustrator
49
In Word, the Backstage view allows global changes and gives access to tools such as document protection, options, and
tables
references
font color
properties
50
What is it called when a file contains a predefined style that can be used for a presentation?
Template
Wizard
AutoStyle
Styles