How can you use conditional formatting to highlight cells that contain values greater than 90?

Use conditional formatting to highlight cells greater than 90 by creating a new rule with the condition 'greater than 90'.

Create a rule to highlight cells with values between 80 and 90.

Use conditional formatting to highlight cells equal to 90.

Highlight cells that contain values less than 90.

The formula =VLOOKUP(A1, B1:C10, 2, FALSE) does what?

It looks up a value in A1 in column B and returns the value from column C.

It looks up a value in A1 and returns the corresponding value from column B.

It calculates the sum of values in column C based on A1.

It checks if the value in A1 exists in column C and returns TRUE or FALSE.

What does the standard deviation formula =STDEV(A1:A10) measure?

How much the values vary from the mean

It measures the range of a dataset.

It measures the total number of data points.

It measures the average of a dataset.

How can you link data from Sheet2 cell A1 into Sheet1?

Link data by copying and pasting from Sheet2 to Sheet1.

Reference Sheet2 cell A1 by typing 'Sheet2.A1' in Sheet1.

Which formula can restrict entries in a cell to a whole number between 1 and 100?

Use Data Validation > Allow > Whole number between 1 and 100

Use Conditional Formatting > Whole number between 1 and 100

The is a tool that helps you amounts of data by , averages, or

grouping and calculating totals

What does the Excel function =LEN(A1) return?

The length of the text in cell A1.

The number of words in cell A1.

The number of cells in range A1.

What is the purpose of the Excel function =CONCATENATE(A1, B1) ?

To merge the text from cells A1 and B1 into one cell.

To add the values in cells A1 and B1.

To find the average of the values in cells A1 and B1.

To compare the values in cells A1 and B1.

How can you freeze the top row in an Excel worksheet?

Go to View > Freeze Panes > Freeze Top Row.

Go to Home > Format > Freeze Top Row.

Go to Insert > Freeze Panes > Freeze Top Row.

Go to Data > Freeze Panes > Freeze Top Row.

What does the AVERAGE function do?

The AVERAGE function computes the mean of a range of values.

The AVERAGE function calculates the total of a range of values.

The AVERAGE function finds the maximum value in a set of numbers.

The AVERAGE function counts the number of entries in a dataset.

What does the MIN function return?

The smallest value from a set of values.

The median value from a set of values.

The average value from a set of values.

The largest value from a set of values.

What is the purpose of the IF function?

The purpose of the IF function is to evaluate a condition and return different values based on whether the condition is true or false.

The IF function is designed to create charts and graphs.

The IF function calculates the sum of a range of numbers.

The IF function is used to format text in a cell.

What does the COUNTA function count?

Cells with text only in a range.

Which function is used to combine the contents of multiple cells?

=CONCATENATE function or & operator

What does the NOW or TODAY function display?

NOW displays the current date and time; TODAY displays the current date.

NOW and TODAY both display the current time only.

NOW shows the last modified date; TODAY shows the last modified time.

NOW displays the current time only; TODAY displays the current month.

If today’s date is November 28, 2024, what will =NOW() return?

November 28, 2024, current time

November 28, 2025, current time

November 28, 2023, current time

Data Science-Spreadsheet Functions

Authored by Roger Thompson

Information Technology (IT)

12th Grade

Used 8+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

50 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which formula is used to find the average of a set of numbers in Excel?

=SUM(A1:A10)

=MIN(A1:A10)

AVERAGE(A1:A10)

=AVERAGE(A1:A10)

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The formula =IF(A1>50, "Pass", "Fail") will return "Pass" if:

A1 contains the text 'Pass'.

A1 contains a number greater than 50.

A1 is empty or contains no value.

A1 contains a number less than 50.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function is used to round a number to two decimal places?

=TRUNC(A1,2)

=ROUND(A1,2)

ROUND(A1,2)

=RND(A1,2)

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the $ symbol do in a cell reference, such as $A$1?

The $ symbol makes the cell reference relative, allowing it to change when copied.

The $ symbol is used to format the cell as currency.

The $ symbol indicates a formula error in the cell reference.

The $ symbol makes the cell reference absolute, preventing it from changing when copied.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What formula is used to calculate the sum of a range of cells in Excel?

=SUMIF(A1:A10)

=TOTAL(A1:A10)

=SUM(A1:A10)

=ADD(A1:A10)

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In Excel, which formula returns the highest value in a range?

=MIN(A1:A10)

MAX(A1:A10)

=MAX(A1:A10)

=SUM(A1:A10)

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function can be used to find the rank of a number in a list?

=RANK(A1,A1:A10)

RANK(A1,A1:A10)

=MATCH(A1,A1:A10,0)

=INDEX(A1:A10,3)

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 Microsoft

or continue with

Facebook

Apple

Others

Already have an account?

Similar Resources on Wayground

50 questions

Latihan USP Informatika IX paket 2

Quiz

•

9th Grade - University

50 questions

Software Development Quiz

Quiz

•

12th Grade

51 questions

Python Basics Quiz

Quiz

•

12th Grade

51 questions

Computer Architecture Quiz

Quiz

•

9th - 12th Grade

50 questions

2nd Summative Test in Computer Programming

Quiz

•

12th Grade

Popular Resources on Wayground

24 questions

PBIS-HGMS Day 10

Quiz

•

6th - 8th Grade

10 questions

HCS SCI 03 Summer School Review 3

Quiz

•

3rd Grade

11 questions

Home Scope

Quiz

•

7th - 8th Grade

15 questions

HCS SCI 05 Summer School Assessment 3 Review

Quiz

•

5th Grade

35 questions

Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz

•

7th Grade

18 questions

Geo 11.3 Area of Circles and Sectors

Quiz

•

9th - 11th Grade

Data Science-Spreadsheet Functions

Which formula is used to find the average of a set of numbers in Excel?

The formula =IF(A1>50, "Pass", "Fail") will return "Pass" if:

Which function is used to round a number to two decimal places?

What does the $ symbol do in a cell reference, such as $A$1?

What formula is used to calculate the sum of a range of cells in Excel?

In Excel, which formula returns the highest value in a range?

Which function can be used to find the rank of a number in a list?

How can you use conditional formatting to highlight cells that contain values greater than 90?

Which formula would count the number of cells in a range that contain numbers?

In a pivot table, which area is used to add the values you want to summarize?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground