stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
DIT End of Year Review Flashcards | StudBud
Explore
/
DIT End of Year Review
DIT End of Year Review
48 terms
·
StudBud Administration
·
756 plays
Imported from external platform
Flashcards
48 cards
F
Practice quiz
P
Host live
L
Questions
48
Answers
1
In Microsoft Excel what is the button used to calculate or "total" a large range of data?
Fill Handle
AutoFill
AutoSum
AutoFormat
2
Which option(s) below are animation available in PowerPoint? (Select ALL that apply)
Emphasis
Exit
Entrance
Motion Paths
3
What view in PowerPoint allows you to enter speaker comments or "notes"?
Normal View
Notes Page View
Slide Show View
Slide Sorter View
4
Which of the following are NOT Microsoft applications? (Select ALL that apply)
Acrobat
Photoshop
Word
Flash
5
Adobe Dreamweaver is an Adobe program that can help you create what?
Spreadsheets
HTML
Word Documents
Presentations
6
A webpage is?
A single document on the World Wide Web
A search engine
Set of pages that all have a common purpose
Software that shows webpages
7
What tab in Microsoft Excel do you find the options for viewing your "gridlines".
Page Layout
View
Review
Home
8
PowerPoint is an application with which of the following? (Select ALL that apply)
Outlines
Notes
Handouts
Slides
9
What allows you to draw, illustrate or diagram information such as graphics or bulleted lists?
Graphics
Text Box
Shapes
SmartArt
10
What symbol do you use to multiply in Microsoft Excel?
*
+
-
/
11
Which of the following are input devices? (Select ALL that apply)
Mouse
Speaker
Keyboard
CPU
12
What does the error "#####" in Excel mean?
A number is entered wrong
The cell is not wide enough for the value
Formula is incorrect
There is a misspelling
13
What is the bar at the bottom of a Microsoft Application called. It shows zoom controls and other options.
Task Bar
Status Bar
Ribbon Bar
Document Bar
14
In PowerPoint how do you set the timing for animation on an object?
View - Custom Transition
View - Custom Animation
Slide Show - Transition
Slide Show - Animation
15
Which of the following are output devices? (Select ALL that apply)
Headphone
CPU
Monitor
Speaker
16
What tools does backstage view give you access to?
Insert Tables & Text Boxes
Page Color & Page Backgrounds
Font Color
Properties "Options"
17
A transition is an effect used to change or move slides in a slideshow.
False
True
18
Which formula(s) below are examples of a range in Excel? (Select ALL that apply)
=B5;C10*A1
=SUM(A1:A10)
=MAX(B5:F10)
=A1+A10
19
What is the name of the additional tab on the ribbon when a shape is selected?
Drawing Tools - Design
Drawing Tools - Format
Drawing Tools - Options
Drawing Tools - Shapes
20
What is the main difference between using a chart or table?
There is no difference
A chart is rows/columns - A table is a graphical representation
A chart is graphical - A table is rows/columns
A table and chart are both graphical representations
21
In PowerPoint how can you make a slide be repeated continuously?
Repeat continuously
Loop continuously until "Esc"
Press "Enter"
Esc
22
A note providing additional information at the end of a section or document is a?
Footnote
Endnote
Bibliography
Citation
23
What is SUMIF used for in Microsoft Excel?
Divide all cells
Add all cells
Add cells "if" they meet criteria
Divide cells "if" they meet criteria
24
A group of computers that expand over a LARGE geographic area is known as?
LAN
MAN
PAN
WAN
25
How do web browsers
track your history
and gather information to
advertise specifically to you
?
Hyperlinks
History Feed
Cookies
Web Crawlers
26
A note in your document at the bottom of a page that provides more information such as a comment/citation is known as?
Footnote
Bibliography
Comment
Citation
27
What is the file extension for an Excel file?
.xls
.xlsx
.pdf
.doc
28
What indicates that a picture or text is animated on PowerPoint?
There is a number next to it
The text or picture is highlighted in yellow
It is labeled as "animated"
There is no indicator
29
What does the "$" mean in the formula in Excel? (=SUM(A1+$A+$2)
Relative Reference
Absolute Reference
Currency
Money
30
Anything you discuss within email is "private" information and cannot be viewed by anyone else.
False
True
31
A website is?
Set of pages that all have a common purpose
A search engine
A single document on the World Wide Web
Software that shows webpages
32
A group of computers that are located
NEAR
each other is known as?
LAN
PAN
MAN
WAN
33
A spider is a type of malware or malicious software?
True
False
34
What options are found in the
editing group
on the
home tab
? (Select ALL that apply)
Insert
Select
Replace
Find
35
TCP & IP are the most common protocols for the internet what do they stand for?
Total Control Protocol & Internet Protocol
Transmission Control Protocol & Internet Provider
Transmission Control Providerl & Internet Provider
Transmission Control Protocol & Internet Protocol
36
What is the function of the following formula? (=B5
-
B2)
Multiplication
Subtraction
Division
Addition
37
How do you identify and active cell in Microsoft Excel?
A dark green border
It is highlighted yellow
A blinking border
A dotted border
38
What is the BCC "
Blind
Carbon Copy" field in email used for?
These are people who will receive the email second
This is the subject line of your email
These are the direct people in your email message
Any recipients in the BCC will NOT be visible
39
If you press the tab key in Excel where does it move to?
Down
Right
Up
Left
40
What is the name of the small box in the corner of a group on the ribbon called?
Command
Dialog Box Launcer
More Options
Group
41
How do you change the AutoRecover file location?
File -> Options -> Save
File -> Options -> Display
File -> Save As
File -> Account -> Sign In
42
A hyperlink in a document can take you to: (Select ALL that apply)
Website
Different location in the same document
Email Address
New Document
43
Which is NOT a formula function in Excel?
Max
Sum
Low
Average
44
If you have a built-in bibliography how do you add a new source?
Home Tab
View Tab
Insert Tab
Layout Tab
45
In the
information processing cycle
what happens during the "
storage
" phase? (retains information or manipulates data)
Retains information
Processeses Information
Inputs information
Outputs information
46
When you open Word, PowerPoint and Excel what are the files called that are predefined and already formatted?
Themes
Design Styles
Blank document, presentation and workbook.
Template
47
What blocks, filters, or keeps data from being transmitted through a port?
Spyware
Defender
Virus
Antivirus Software
48
How can you create a new slide show using the same slides but arrange them in a different order?
Custom Slide Show
Slide Show Set Up
Rehearsal
Slide Show View
