Which of the following statements best describes the difference between the COUNT and COUNTA functions in Excel?

b) COUNT counts the number of cells in a range that are not empty, while COUNTA counts the number of cells in a range that contain numbers.

a) COUNT counts the number of cells in a range that contain numbers, while COUNTA counts the number of cells in a range that are not empty.

c) There is no difference between the COUNT and COUNTA functions.

Which of the following statements best describes the difference between the COUNTIF and COUNTIFS functions in Excel?

a) COUNTIF counts the number of cells in a range that meet a single criteria, while COUNTIFS counts the number of cells in a range that meet multiple criteria.

b) COUNTIF counts the number of cells in a range that meet multiple criteria, while COUNTIFS counts the number of cells in a range that meet a single criteria.

c) There is no difference between the COUNTIF and COUNTIFS functions.

d) COUNTIF counts the value of cells in a range that meet a single criteria, while COUNTIFS counts the number of cells in a range that meet multiple criteria.

Which of the following best describes an absolute cell reference in Excel?

b) A reference that remains fixed regardless of where the formula is located

a) A reference that changes when the formula is copied to a new location

c) A reference that mixes the relative and absolute references in a formula

Which of the following best describes a relative cell reference in Excel?

a) A reference that changes when the formula is copied to a new location

b) A reference that remains fixed regardless of where the formula is located

c) A reference that mixes the relative and absolute references in a formula

Which of the following best describes a relative cell reference in Excel?

c) A reference that mixes the relative and absolute references in a formula

a) A reference that changes when the formula is copied to a new location

b) A reference that remains fixed regardless of where the formula is located

What is the NOW function used for in Excel?

c) To return the current date and time as a formatted date and time value

a) To return the current date and time as a serial number

b) To return the current time as a serial number

Which of the following formulas can be used to count the number of cells in the "Score" column that contain a value greater than or equal to 80 in the dataset above?

c) =COUNTIF(Score, ">=80", Score)

Which of the following formulas can be used to calculate the sum of the "Score" column for all rows where the "Age" is greater than or equal to 28 in the dataset above?

b) =SUMIFS(Score, Age, ">=28", Score)

c) =SUMIFS(Score, Age, ">=28", Age, "<=35")

Which of the following formulas can be used to calculate the average age of all individuals in the dataset above?

c) =AVERAGEIFS(Age, Score, ">0")

In Excel, how can you determine the number of days between two dates?

c) By subtracting the later date from the earlier date

a) By subtracting the two dates

b) By multiplying the two dates together

d) By subtracting the earlier date from the later date

In Excel, how can you determine the number of days between two dates?

c) By subtracting the later date from the earlier date

a) By subtracting the two dates

b) By multiplying the two dates together

d) By subtracting the earlier date from the later date

What is the difference between sorting and filtering in Excel?

Sorting rearranges data based on specified criteria, while filtering hides data based on specified criteria.

Sorting and filtering cannot be done simultaneously in Excel.

Sorting and filtering are the same thing in Excel.

Sorting hides data based on specified criteria, while filtering rearranges data based on specified criteria.

In Excel, how can you determine the number of days between two dates?

c) By subtracting the later date from the earlier date

a) By subtracting the two dates

b) By multiplying the two dates together

d) By subtracting the earlier date from the later date

Excel Pre assessment test

Authored by Deon Strydom

Computers

Professional Development

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

37 questions

Show all answers

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

What function is used to find the largest value in a range of cells?

A. MAX

B. MIN

C. SUM

D. AVERAGE

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

What function is used to find the average value in a range of cells?

A. MAX

B. MIN

C. SUM

D. AVERAGE

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

What is the formula for adding the values in cells A1 through A5?

A. =A1+A2+A3+A4+A5

B. =SUM(A1:A5)

C. =A1A2A3A4A5

D. =AVERAGE(A1:A5)

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

What is the formula for subtracting the value in cell A1 from the value in cell A2?

A. =A1-A2

B. =A2-A1

C. =A1+A2

D. =A2/A1

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

What function is used to count the number of cells in a range that contain numbers?

A. COUNT

B. SUM

C. AVERAGE

D. MAX

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

What function is used to find the smallest value in a range of cells?

A. MAX

B. MIN

C. SUM

D. AVERAGE

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

What function is used to count the number of cells in a range that are not empty?

A. COUNTA

B. COUNT

C. SUM

D. AVERAGE

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

35 questions

Cyber Security

Quiz

•

Professional Development

40 questions

AZ-900 1 de 3

Quiz

•

Professional Development

41 questions

TIN HỌC 11 HKII

Quiz

•

Professional Development

39 questions

Lvl 1 Introduction DBMS (QB)

Quiz

•

Professional Development

39 questions

Ôn tập Học Kỳ 2 Mạng máy tính- Khối 10

Quiz

•

Professional Development

33 questions

Eletrônica Básica para Robótica

Quiz

•

Professional Development

40 questions

CYBER SECURITY

Quiz

•

Professional Development

Popular Resources on Wayground

8 questions

Spartan Way - Classroom Responsible

Quiz

•

9th - 12th Grade

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

14 questions

Boundaries & Healthy Relationships

Lesson

•

6th - 8th Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

3 questions

Integrity and Your Health

Lesson

•

6th - 8th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

9 questions

FOREST Perception

Lesson

•

20 questions

Main Idea and Details

Quiz

•

5th Grade

Discover more resources for Computers

15 questions

LOTE_SPN2 5WEEK3 Day 2 Itinerary

Quiz

•

Professional Development

6 questions

Copy of G5_U6_L5_22-23

Lesson

•

KG - Professional Dev...

10 questions

March Quiz

Quiz

•

Professional Development

5 questions

Copy of G5_U6_L8_22-23

Lesson

•

KG - Professional Dev...

10 questions

suffixes FUL OR LESS

Quiz

•

Professional Development

Excel Pre assessment test

What function is used to find the largest value in a range of cells?

What function is used to find the average value in a range of cells?

What is the formula for adding the values in cells A1 through A5?

What is the formula for subtracting the value in cell A1 from the value in cell A2?

What function is used to count the number of cells in a range that contain numbers?

What function is used to find the smallest value in a range of cells?

What function is used to count the number of cells in a range that are not empty?

What function is used to round a number to a specific number of decimal places?

Which of the following is not a ribbon in Excel?

Which of the following keyboard shortcuts is used to save a workbook in Excel?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers