Advanced Excel KG - University Quiz | Wayground (formerly Quizizz)

Advanced Excel

Quiz

•

Computers

•

KG - University

•

Hard

Used 268+ times

FREE Resource

Enhance your content

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

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?

Similar Resources on Wayground

20 questions

Excel 2016

Quiz

•

6th Grade - Professio...

20 questions

Excel Lesson 4: Using Basic Formulas

Quiz

•

11th Grade

24 questions

Spreadsheets Pre-Quiz

Quiz

•

7th - 9th Grade

15 questions

Google Sheets #1

Quiz

•

6th - 8th Grade

21 questions

P4 MICROSOFT EXCEL QUIZ 1

Quiz

•

4th Grade

15 questions

Spreadsheets

Quiz

•

7th Grade

15 questions

MS Excel

Quiz

•

7th Grade

20 questions

Google Sheets

Quiz

•

10th - 12th Grade

Popular Resources on Wayground

20 questions

Brand Labels

Quiz

•

5th - 12th Grade

10 questions

Ice Breaker Trivia: Food from Around the World

Quiz

•

3rd - 12th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

20 questions

ELA Advisory Review

Quiz

•

7th Grade

15 questions

Subtracting Integers

Quiz

•

7th Grade

22 questions

Adding Integers

Quiz

•

6th Grade

10 questions

Multiplication and Division Unknowns

Quiz

•

3rd Grade

10 questions

Exploring Digital Citizenship Essentials

Interactive video

•

6th - 10th Grade

Discover more resources for Computers

20 questions

Disney Characters

Quiz

•

KG

11 questions

NFL Football logos

Quiz

•

KG - Professional Dev...

20 questions

Place Value

Quiz

•

KG - 3rd Grade

10 questions

Movie Trivia

Quiz

•

KG - 2nd Grade

20 questions

Logos

Quiz

•

KG

6 questions

Things that can move.

Quiz

•

KG

15 questions

Pronouns

Quiz

•

KG - 3rd Grade

15 questions

The Five Senses

Quiz

•

KG