CSMA DIT Final Exam
Which symbol would you use in order to multiply in excel
*
What is the default file extension when you save a workbook in Excel 2016? 20sec
.xlsx
What is the difference betweem a chart and a table?
A table uses rows and columns while a chart is a graphical representation.
Which of the following is an example of a data range?
A1:B3
What is the software program written by Adobe that can help to create HTML?
Adobe Dreamweaver
In order to apply a Motion Path in Microsoft Powerporint, which of the
Animations>Animations dropdown(more)>More motion paths
in excel you can total a large range of data by selecting which tool button
AutoSum
Which of the following is NOT an input device?
CPU
On the Home Tab in Microsoft Word, the Editing subgroup includes all of
Change
Which option can be used to create a new slide show with the same slides, but presented in a different order
Custom Slide Show
When you have a shape selected, an extra contexual tab is added to the
Drawing Tools>Format
Which of the following are the four types of animation avaliable in
Entrance, Emphasis, Exit, Motion Paths
Which of the following is a Microsoft Office software application
Excel
Anything you discuss using any type of email; personal, business, or school, is private/cannot be viewed by anyone else.
False
If you press the "Tab" key while in Excel, the active cell moves one cell to the left.
False
Which path should you follow to change the AutoRecover file location?
File> Options>Save
Which of the following functions in NOT provided in Excel?
HIGH
A list of information can be converted to a table by clicking the _______tab
Insert, Table
How would you add a Clustered Column Chart to a Powerpoint slide
Insert>Chart>Column
What is the most common type of network that refers to any group of computers linked near each other?
LAN
How can a slide be repeated continuously
Loop continuously until "Esc"
Which view in Powerpoint can be used to enter speaker comments
Notes page
Which of the following is the protocol used to send emails?
SMTP
Where can you set the timing for each object
Slide Show > Custom Animation
Which allows the diagram of content & graphics & to reconfigure bulleted list
SmartArt
Which is the most common applied collection of protocols/foundation of the internet?
TCP/IP
How would you know an item in a slide has an animation applied to it
The animated item has a number next to it.
What happens during the storage stage of the "Information Processing Cycle"?
The computer retains information for recall at a later time.
Which tab of the excel ribbon should you go to in order to remove gridlines from a worksheet?
View
on an excel worksheet, an active cell is indicated by which of the following
a dark, wide border
What is a slide transition
a special effect used to change slides in a slideshow
In the following formula, what does the "$" mean? =SUM(B8*$R$6)
absolute reference
An intranet is
an internal private network belonging to an organization/employees.
Text stored in a web browser that attaches to a user in order to gather information and advertise is called a
cookie.
The small box in the corner of a tab's subgroup is known as the
dialog box launcher
A note giving more info in your document, like a comment/citation, that appears at the end of document is called a(n)
endnote
Which of the following operates by blocking, filtering, and/or encrypting data that is transmitted through a port?
firewalls
A note providing more info, such as a comment or citation, that appears at
footnote
Adding a new source to a built-in bibliography can be done through the
layout
In Word, the Backstage view allows global changes and gives access to
properties
Powerpoint is a collection of
speaker notes, outlines, slides, and handouts
The # of pages, word count, page layout, and document zoom are the
status
What function is performed in the following formula? =C7-C9
subtraction
What is a pre created document that already has some formatting included?
template
If you get a value ###### when in excel then
the cell is not wide enough for the entry.
The BCC component of an email message is a text field to enter
the email address is sent to "tertiary" recipients
Through the Insert tab, text can be converted into a hyperlink that will
to a website, new document, and another place in the document
Why is the SUMIF function used?
to add all the cells in a range that meet a specified criteria
Which choice includes three types of malware, or malicious software?
viruses, trojans, spyware
What is the difference between a web page and a website?
website=set of pages with common theme; web page=a single document page
