Excel Functions & Formulas Review

Excel Functions & Formulas Review

9th - 12th Grade

40 Qs

quiz-placeholder

Similar activities

ÔN TẬP GK2 - TIN HỌC 12

ÔN TẬP GK2 - TIN HỌC 12

12th Grade

38 Qs

Have fun with quiz !

Have fun with quiz !

3rd Grade - University

39 Qs

Ujian IoT PTS 2024 45 Soal

Ujian IoT PTS 2024 45 Soal

11th Grade - University

45 Qs

TIN HỌC KHỐI 5 HK1

TIN HỌC KHỐI 5 HK1

1st Grade - University

42 Qs

ULANGAN INFORMATIKA

ULANGAN INFORMATIKA

12th Grade

40 Qs

Ôn tập lý thuyết Nghề THVP - Đề 01 (35 câu)

Ôn tập lý thuyết Nghề THVP - Đề 01 (35 câu)

11th Grade

35 Qs

PRESAF MATPIL XI TKJ

PRESAF MATPIL XI TKJ

9th - 12th Grade

40 Qs

Excel 2016 Introduction

Excel 2016 Introduction

10th - 12th Grade

35 Qs

Excel Functions & Formulas Review

Excel Functions & Formulas Review

Assessment

Quiz

Computers

9th - 12th Grade

Practice Problem

Medium

Created by

Alyson Walls

Used 17+ times

FREE Resource

AI

Enhance your content in a minute

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

40 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

1. Which of the following is not an arithmetic operator?

+

-

*

]

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is an acceptable name for a named range?

C7

subtotal_west

subtotal west

subtotal/west

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is an example of an absolute cell reference?

A9

A$9

$A$9

A9:E9

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is an example of an mixed cell reference?

A9

A$9

$A$9

A9:E9

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

To allow Excel to distinguish formulas from data, all formulas must begin with

+

cell reference

function name

=

6.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

You can create a new range by selecting the cells and typing a name in the Name Box next to the formula bar.

True

False

7.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

The order of operations determines which parts of a formula are calculated before other parts of the formula.

True

False

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

Already have an account?