Microsoft Excel Unit 5

Microsoft Excel Unit 5

9th Grade

10 Qs

quiz-placeholder

Similar activities

Image Representation Lesson 2

Image Representation Lesson 2

9th Grade

10 Qs

3rd week g9 summative

3rd week g9 summative

7th - 12th Grade

15 Qs

Microsoft Excel

Microsoft Excel

6th Grade - University

15 Qs

The Dark Side

The Dark Side

KG - University

13 Qs

Heritage Students

Heritage Students

7th - 9th Grade

15 Qs

Intro to Software and Technology Test review

Intro to Software and Technology Test review

9th Grade

11 Qs

Impact of Technology

Impact of Technology

9th Grade

11 Qs

Microsoft Excel Unit 5

Microsoft Excel Unit 5

Assessment

Quiz

Computers

9th Grade

Hard

Created by

Thomas Martinez

FREE Resource

AI

Enhance your content

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

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following calculates the total from the adjacent cell through the first nonnumeric cell by default, using the SUM function in its formula?

AVERAGE

AutoSum

COUNTA

MAX

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The arguments of a function are contained within which of the following?

brackets

asterisks

commas

parentheses

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

You want to calculate the number of nonblank cells in your worksheet. Which function

do you use?

SUM

COUNT

COUNTA

MAX

4.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

The COUNT and MIN functions are examples of which category of functions?

text

statistical

financial

logical

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

You want to sum multiple noncontiguous cell ranges that are named. Which of the following is best to use?

AutoSum

SUBTOTAL

MAX

MIN

6.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

You want to create a formula that calculates the number of years you have lived. You were born in 1991. Which of the following formulas is correct?

=YEAR(TODAY())-1991

=YEAR(TODAY())+1991

=YEAR(COUNT())-1991

=YEAR(COUNT())+1991

7.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

In the PMT function, the Nper argument is the total number of payments for the loan.

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

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

Already have an account?