Microsoft Excel Functions & Formulas

Microsoft Excel Functions & Formulas

3rd Grade - Professional Development

15 Qs

quiz-placeholder

Similar activities

Database Concepts

Database Concepts

11th - 12th Grade

15 Qs

Hojas, libros y mas, Excel

Hojas, libros y mas, Excel

7th Grade

20 Qs

NHẬN DẠNG DIODE

NHẬN DẠNG DIODE

University

10 Qs

Final-Computer P.6

Final-Computer P.6

6th Grade

20 Qs

PKT Supply_Week-4_May'21

PKT Supply_Week-4_May'21

Professional Development

10 Qs

kiểm tra tin 8

kiểm tra tin 8

8th Grade

20 Qs

CLASS-III MATHS LENGTH Dt 11.11.2020

CLASS-III MATHS LENGTH Dt 11.11.2020

3rd Grade

10 Qs

Tin học bài 8

Tin học bài 8

12th Grade

20 Qs

Microsoft Excel Functions & Formulas

Microsoft Excel Functions & Formulas

Assessment

Quiz

Computers, Other

3rd Grade - Professional Development

Medium

Created by

Adisa Gwindi

Used 41+ times

FREE Resource

15 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

1. The function that lets you add up a range of cells or values

SUM

MIN

AVERAGE

MAX

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

2. What function was used to find the lowest grade?

average

sum

min

max

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

3. What function was used to find the highest grade?

average

min

sum

max

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

4. SUM, AVERAGE, IF, MIN and MAX are examples of _______.

user-defined functions

table functions

online functions

predefined functions

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

5. All formulas used within the table are seen on the __________

cells

name box

cell reference

formula bar

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

6. The function COUNT is specific for ___________

counting cells

counting text

counting numbers

counting tables

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

7. To sort names in a worksheet, we can use this button.

Media Image
Media Image
Media Image
Media Image

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?