MS Excel

MS Excel

Professional Development

15 Qs

quiz-placeholder

Similar activities

Deepening Pedagogy: Active Learning

Deepening Pedagogy: Active Learning

Professional Development

10 Qs

Project Scope Management

Project Scope Management

Professional Development

15 Qs

Unit1_MS

Unit1_MS

University - Professional Development

20 Qs

History of Philippine Broadcasting

History of Philippine Broadcasting

Professional Development

20 Qs

Scheduled Waste Management

Scheduled Waste Management

Professional Development

11 Qs

AIFF Beach Soccer

AIFF Beach Soccer

Professional Development

20 Qs

Pre-Test BRAP NCR

Pre-Test BRAP NCR

Professional Development

15 Qs

3-D Printing Day-4

3-D Printing Day-4

Professional Development

10 Qs

MS Excel

MS Excel

Assessment

Quiz

Professional Development

Professional Development

Hard

Created by

MARY DANDING

Used 149+ times

FREE Resource

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?

Discover more resources for Professional Development