MS Excel

MS Excel

Professional Development

15 Qs

quiz-placeholder

Similar activities

Repair Quiz

Repair Quiz

Professional Development

15 Qs

PRE-TEST OPEX 02 - RCA

PRE-TEST OPEX 02 - RCA

Professional Development

20 Qs

#SQC2022INNOCREATIVATION

#SQC2022INNOCREATIVATION

Professional Development

16 Qs

SQL Statements and Queries

SQL Statements and Queries

Professional Development

15 Qs

TES ASESMEN

TES ASESMEN

Professional Development

20 Qs

INTO Artificial Intelligence

INTO Artificial Intelligence

University - Professional Development

10 Qs

Term 1 Reflection

Term 1 Reflection

KG - Professional Development

11 Qs

Interpersonal Skills

Interpersonal Skills

Professional Development

11 Qs

MS Excel

MS Excel

Assessment

Quiz

Professional Development

Professional Development

Practice Problem

Hard

Created by

MARY DANDING

Used 149+ times

FREE Resource

AI

Enhance your content in a minute

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

15 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

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

AVERAGE

SUM

MIN

MAX

2.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

The function COUNTA is used for counting cells that contain

numbers and logical values only

text, numbers and logical values only

text, numbers, logical values and error values only

text, numbers, logical values, error values, and empty text (" ")

3.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

What function is used to find the lowest data ?

MIN

MAX

SUM

AVERAGE

4.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

What function Is used to find the highest data ?

SUM

MIN

MAX

AVERAGE

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

To alert Excel that you are entering a formula and not text, type a(n) _________________ proceeding the formula

@

=

'

#

6.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

The function COUNT is specific for counting _________________

text

numbers

cells

tables

7.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

In a worksheet, the horizontal spaces with the headings 1, 2, 3 and so on

row

column

label

cell address

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?