
PRE-TEST EXCEL FOR PRODUCT SPECIALIST
Authored by Arie Nurman
Education
Professional Development
Used 1+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
5 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Manakah versi Microsoft Excel yang tidak ada ?
2012
2016
2019
365
2.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Apakah rumus/formula yang tidak untuk melakukan Penjumlahan dengan Kondisi ?
SUMIF
COUNTIF
AVERAGEIF
LOOKIF
3.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Apakah rumus/formula yang bukan merupakan fungsi Lookup ?
VLOOKUP
XLOOKUP
CLOOKUP
HLOOKUP
4.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Apakah rumus/formula untuk melakukan ringkasan data menjadi informasi dengan format table ?
SORT
PIVOT
FILTER
FORMULA
5.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Apakah fungsi untuk merubah data pada file format CSV ke tabel multi column di Excel ?
TEXT TO COLUMNS
DATA TO COLUMNS
CONVERT TO COLUMNS
FILTER TO COLUMNS
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?