Excel Assessment

Excel Assessment

Professional Development

•

55 Qs

quiz-placeholder

Similar activities

TES CALON GURU SIT AN NAHL

TES CALON GURU SIT AN NAHL

Professional Development

•

50 Qs

Repaso 1er parcial EDSO (UD1-UD5)

Repaso 1er parcial EDSO (UD1-UD5)

Professional Development

•

50 Qs

TRIVIA

TRIVIA

Professional Development

•

50 Qs

Servicios en Red - Repaso UT2

Servicios en Red - Repaso UT2

Professional Development

•

53 Qs

CIDESCO: Miscellaneous - 50

CIDESCO: Miscellaneous - 50

Professional Development

•

50 Qs

Dwelling (DP)

Dwelling (DP)

Professional Development

•

55 Qs

KESELAMATAN DI TEMPAT KERJA

KESELAMATAN DI TEMPAT KERJA

Professional Development

•

50 Qs

Excel Assessment

Excel Assessment

Assessment

Quiz

•

Other

•

Professional Development

•

Practice Problem

•

Medium

Created by

Gibburion Analytics

Used 2+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

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?