WorksheetsExcel and Email Drafting
Total questions: 10
Worksheet time: 5mins
1) Formulas in MS Excel must begin with
An () sign
An Equal Sign
A Plus Sign
A > Sign
2) What type of chart is useful for comparing values over categories
Pie Chart
Column Chart
Line Chart
Dot Graph
3) The process of arranging the items of a column in some sequence or order is known as :
Arranging
Autofill
Sorting
Filtering
4) In Excel, which one denoted a range from B1 through E5
B1 - E5
B1:E5
B1 to E5
B1$E5
5) Which of the formulas below contain the correct syntax (formula arguments) for the VLOOKUP function?
=VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
=VLOOKUP(table_array, lookup_value, col_index_num, range_lookup)
=VLOOKUP(lookup_value, table_array, col_index_num, value)
=VLOOKUP(lookup_value, table_array, col_index_num, row_index)
6) Study the screenshot above. If I entered the formula: =INDEX(A2:A10,5) into a blank cell, what would the result be?
The result would be the number 5.
The result would be Casey.
The result would be Julian.
The result would be Lane.
7) Study the screenshot above. Using the INDEX-MATCH function, which of the formulas below, when entered into the highlighted cell (E3), will yield the result Group result (32A)?
=MATCH(B2:B9,INDEX(D3,A2:A9,0))
=INDEX(B2:B9,MATCH(D3,A2:A9,0))
=INDEX(B2:B9,MATCH(A2:A9,0))
=INDEX(MATCH(D3,A2:A9,0))
8) Which of the following options allows us to access our e-mail from anywhere?
Forum
Weblog
Message board
Webmail interface
9) Junk E-mail is also called ..............
Spam
Spoof
sniffer script
copple crumbs
10) What is a Bulk Email?
It is a marketing email sent by a brand to multiple recipients at once
It is a marketing email sent by a person to other person
It is a marketing email sent by a brand to multiple recipients at multiple times
None of the above
