stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
DIT CFE Review 1 Flashcards | StudBud
Explore
/
DIT CFE Review 1
DIT CFE Review 1
45 terms
·
StudBud Administration
·
170 plays
Imported from external platform
Flashcards
45 cards
F
Practice quiz
P
Host live
L
Questions
45
Answers
1
What is the file extension for Excel?
.dotx
.pptx
.doc
.xlsx
2
What is the cell range in the screenshot show below?
B2:F10
B1:F13
B3:F11
B3:F12
3
The Sort & Filter tool is found under which tab of Microsoft Excel?
Data tab
File
Home
Insert Tab
4
What is a server?
a worldwide collection of interconnected networks
A powerful computer providing services to other computers
smallest unit of data
used to test end-to-end connectivity
5
What is the Internet?
A protocol to allow humans to communicate with each other
Rule and instructions for computers to communicate
Applications offered by data centers
A worldwide network of interconnected networks
6
Is this formula correct: =F4 \ F5 ?
No
Yes
7
What does it mean to merge cells?
center the contents of the cells
combine 2 or more cells into a single cell
split a single cell into 2 or more cell
apply a border around a set of cells
8
What is a cover letter?
A letter that tells why you want the job and contact info.
A paper with multiple questions
A list of bullets showing skills and abilities
A letter that thanks somebody for the interview
9
When should you send a cover letter?
when you need to list refernces
only when an ad requests it
every time you send out your resume
none of these
10
What must every formula in Excel start with?
()
Words
sum
=
11
How would you select a cell range of cell adjacent to each other (next to each other)?
Pull fill bar
Select Ctrl, Alt, Delete
Hold Ctrl key, select cell range.
Select first cell in range, hold shift key, select last cell in range.
12
Which part of a Business Letter is this?
Closing
Salutation
Heading
Signature
13
A resume is a
cover letter
bulleted list of your experience
list of professionals who can speak highly of you
block letter
14
What formula would you use to get the lowest number in cell range A1 to A15?
=minA1:A15
=(Min(A1:A15)
=min(A1:A15)
=max(A1:A15)
15
Your cover letter should be addressed to...…
"To whom it may concern"
"Dear Sir or Madam"
A specific person (Mr. Smith)
The company's name
16
Which part of a Business Letter is this?
Body
Signature
Heading
Closing
17
What should be included on a resume?
skills
all of the above
education
past work experience
18
What should you not do in cover letter?
Tell a story about a specific accomplishment
Accentuate your strengths
Focus on the opportunity and the company
Say "Hi, my name is …."
19
You should use standard business format on your cover letter.
False
True
20
A cover letter should be :
friendly and funny
long and detailed
clear and concise
21
After an interview you should...
post a facebook status about it
nothing
bug them asking if you got the job
send them a thank you note via mail or email
22
A RESUME IS
SHORT
Has your experience listed
TO THE POINT
ALL OF ABOVE
23
What should you do while your finalizing your cover letter ?
none above
make it all bold
nothing
check for errors
24
A business letter salutation should look like this...
Dear Mr. Smith, (comma)
Dear Mr. Smith: (colon)
Dear Mr. Smith (no punctuation)
Dear Mr. Smith; (semicolon)
25
What will this formula do =sum(F2:F10)
Divide the numbers in cells (F2:F10)
Average the numbers in cells (F2:F10)
Multiple the numbers in cells (F2:F10)
Add the numbers in cells (F2:F10)
26
Which of the following operating systems does not require file extensions to execute a file?
Windows 10
iOS
Windows 8
Linux
27
What part of the Business Letter is this?
Name
Salutation
Closing
Signature
28
The following formula will do what: =C2 * C5
Multiply
Subtract
Add
Divide
29
How long should a business letter be?
3 Pages
1 Page
2 Pages
30
a computer designed to request information from a server
client
media
server
topology
31
What is an Extranet?
Interconnected servers world-wide
Intranet that is accessible to some people from outside the company
Private network using internet technology, no access to global internet.
Private browser
32
In Excel you have a list of the students and their contact information. What could you use the filter function for?
You want to display a list of the students who live in a particular city.
You want to reorder the list of students by last name in ascending order.
Reorder the list of students by date of birth in descending order
You want to display the list of students in your class.
33
What should be the basics of a cover letter?
Greeting
Signature
All of the above
Contact information
34
How long should a cover letter be?
4 pages
1 page
5 pages
3 pages
35
The font for a business letter should be:
Default
Calibri 11
Times New Roman 12
Times New Roman 10
36
Colors cells based on certain preselected criteria.
Cell coloring
Criteria Coloring
Format Conditions
Conditional Formatting
37
In block format, paragraphs in a business letter are...
either way is fine
indented
other
not indented
38
The extension for a PowerPoint file:
.pptx
none of the above
.xlsx
.mdbx
39
A video file extension produced by Microsoft.
AVI
PDF
.DOC
.XLS
40
What part of a business letter is this?
Body
Salutation
Subject Line
Complimentary Closing
41
What is an Intranet?
Network domains on the internet
Interconnected servers world-wide
Private browser
Private network using internet technology, no access to global internet.
42
Designations at the end of file names such as .docx and .html are called_______.
File Extensions
File Things
File domains
File Ends
43
What should you do before an interview?
Prepare at least two questions to ask.
Go out and celebrate.
Go to a friends house and chill.
Play a video game to relax.
44
What is the file extension for Microsoft word?
.tif
.xis
.doc
.docx
45
Which of the following are graphics files extensions? Select all that apply.
.PNG
.GIF
.xls
.JPEG
