AES Excel 2: Fundamentals : Module Test

AES Excel 2: Fundamentals : Module Test

9th - 12th Grade

•

28 Qs

quiz-placeholder

Similar activities

CNN Semester 2 Review

CNN Semester 2 Review

10th - 12th Grade

•

24 Qs

Business Law Chapter 9

Business Law Chapter 9

9th - 12th Grade

•

24 Qs

Taglines

Taglines

KG - Professional Development

•

25 Qs

OCR Business - Influences on a business

OCR Business - Influences on a business

10th - 11th Grade

•

25 Qs

lesson 10

lesson 10

12th Grade - University

•

23 Qs

9 EMS - Economic Sectors

9 EMS - Economic Sectors

9th Grade

•

25 Qs

Forms of Business Test

Forms of Business Test

9th - 12th Grade

•

25 Qs

Certificates of Deposit and Money Market Accounts Quiz

Certificates of Deposit and Money Market Accounts Quiz

9th - 12th Grade

•

24 Qs

AES Excel 2: Fundamentals : Module Test

AES Excel 2: Fundamentals : Module Test

Assessment

Quiz

•

Business

•

9th - 12th Grade

•

Practice Problem

•

Easy

Created by

Ms. Wallum

Used 16+ times

FREE Resource

AI

Enhance your content in a minute

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

28 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Microsoft Excel can use Headers and Footers, just like Microsoft Word.

True

False

2.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

If D3=30 and D4=20, what is the result of the function =IF(D4 < D3, D3-D4, "FULL")?

Full

-10

10

Unknown

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If A3=10 and B6=14, what is the result of the logical expression A3=B6?

False

True

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which set of data is in descending order?

horses, ducks, dogs, cats

4, 3, 1, 2

4/1/2018, 4/1/2017, 3/29/2017, 6/18/2018

apples, oranges, bananas, grapes

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does filtering data in a spreadsheet do?

Hides data that you do not want to see

Hides the data you are looking for

Shows data that did not meet the criteria

Shows all the data in the spreadsheet

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is a way to search for a function?

Browse in the Function Library group

Click Insert Function and enter a search phrase

All of the above

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

What formula would you enter in C3 that combines A3 and B3 to get a result like in C2?

=CONCAT(B3," ",A3)

=CONCAT(A3," ",B3)

=B3,&,&,A3

=A3,&,&,B3

Access all questions and much more by creating a free account

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?