Excel Assessment

Excel Assessment

Professional Development

55 Qs

quiz-placeholder

Similar activities

Y50 THE NEW BLOCKBUSTER

Y50 THE NEW BLOCKBUSTER

Professional Development

50 Qs

QUIZ BEASISWA 2025

QUIZ BEASISWA 2025

Professional Development

50 Qs

Soal UP 2022

Soal UP 2022

Professional Development

52 Qs

Moody's Analytics- Exit Test

Moody's Analytics- Exit Test

Professional Development

50 Qs

NPA 1130 - unit 4

NPA 1130 - unit 4

Professional Development

50 Qs

Ôn tập Thiếu 3 năm 2025 (P2)

Ôn tập Thiếu 3 năm 2025 (P2)

Professional Development

60 Qs

Verifica 1

Verifica 1

Professional Development

58 Qs

Steam Properties

Steam Properties

University - 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)

Create a free account and access millions of resources

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

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

Already have an account?