Search Header Logo

Excel Assessment

Authored by Gibburion Analytics

Other

Professional Development

Used 2+ times

Excel Assessment
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

55 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

10 sec • 2 pts

What is the shortcut for creating a new workbook?

Ctrl + P

Ctrl + O

Ctrl + N

Ctrl + S

2.

MULTIPLE CHOICE QUESTION

10 sec • 2 pts

Which function is used to find the average of a range of numbers?

AVG

SUM

AVERAGE

MIN

3.

MULTIPLE CHOICE QUESTION

10 sec • 2 pts

What symbol is used to start a formula in Excel?

@

+

=

#

4.

MULTIPLE CHOICE QUESTION

10 sec • 2 pts

How do you create an absolute cell reference?

&A1

A1

#A1

$A$1

5.

MULTIPLE CHOICE QUESTION

10 sec • 2 pts

Which of the following is a valid cell reference?

A1

1A

$1A

A#1

6.

MULTIPLE CHOICE QUESTION

10 sec • 2 pts

What does the VLOOKUP function do?

Calculates the sum of a range of cells

Searches for a value in a horizontal row

Looks for a value in a vertical column

Finds the average of a set of numbers

7.

MULTIPLE CHOICE QUESTION

10 sec • 2 pts

Which of these formulas will add the values in cells A1 through A5?

=SUM(A1:A5)

=SUMMATION(A1:A5)

=ADD(A1:A5)

=SUM(A1;A5)

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?