Advanced Excel

Advanced Excel

KG - University

20 Qs

quiz-placeholder

Similar activities

Penggunaan Fungsi IF dan VLOOKUP

Penggunaan Fungsi IF dan VLOOKUP

7th Grade

20 Qs

Final Excel #1

Final Excel #1

9th Grade

20 Qs

Quiz Excel Dasar_Ovick Computer Academy

Quiz Excel Dasar_Ovick Computer Academy

9th - 12th Grade

20 Qs

Excel Formulas Básicas

Excel Formulas Básicas

8th - 9th Grade

15 Qs

TIK Kelas V ( Kamis, 29 April 2021 )

TIK Kelas V ( Kamis, 29 April 2021 )

5th Grade

20 Qs

Excel

Excel

University

20 Qs

Uji Kompetensi ANALISIS DATA

Uji Kompetensi ANALISIS DATA

8th Grade

15 Qs

QUIZ MICROSOFT EXCEL_LEVEL MUDA

QUIZ MICROSOFT EXCEL_LEVEL MUDA

11th Grade

20 Qs

Advanced Excel

Advanced Excel

Assessment

Quiz

Computers

KG - University

Hard

Used 268+ times

FREE Resource

20 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If a column has joint-data (such as last name, first name), you can automatically "pull" sections of the data into a new column by using:
Flashfill
Autofill
Merge & Center
Copy and Paste

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The shortcut key for AutoSUM is:
Ctrl + =
Alt =
= SUM
Shift +

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

To quickly highlight an entire range within a column, you can click on the first cell of that range and:
Press Ctrl + Shift + ↓
Press Ctrl + Alt + ↓
Double-click cell border
Hold the shift key

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The formula that adds values in a specified range that meet a certain condition or criteria is called:

SUMIFS

SUMIF

COUNTIF

SUBTOTAL

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Under the order of arithmetic operators, Excel will calculate division before exponents.

TRUE

FALSE

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

When creating a VLOOKUP function, the table array area can be pre-named to make it easier to type into the formula. To name this range, you would go to the Formulas tab and select:
Name Manager
Create from selection
Define name
Data validation

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The formula used to make the error return value of a function look "pretty" or clean and non-confusing is:
IFERROR
IF
ERROR
VLOOKUP

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?