Question 1

You have a spreadsheet containing the sales figures for every sale that has taken place in your organization. The spreadsheet includes the sales person's name, the customer's name, the date of the sale, the amount of the sale, as well as the highest and lowest priced items from the sale.
How can you change the color of the cells that contain values under one dollar in the lowest priced column?

Accepted Answer

The answer of You have a spreadsheet containing the sales...

Question 2

Formulas that contain more than one operator are called ____________________ formulas.

Accepted Answer

The answer of Formulas that contain more than one operator...

Question 3

You can identify the smallest value in a range of cells using the ____________________ function.

Accepted Answer

The answer of You can identify the smallest value in...

Question 4

The COUNT function counts the number of cells in a range containing ____.
A) numbers
B) conditional formatting
C) formulas
D) mathematical operators

Accepted Answer

The COUNT function counts the number of cells in a range that contains numbers.

Question 5

You are working on a spreadsheet that contains many different kinds of calculations. Your supervisor knows that Excel has built-in functions for many of the calculations.
Your spreadsheet contains a list of dates and you need to determine the intervals between the dates in the list. Which set of functions should you use to determine how many days have passed?

Accepted Answer

The answer of You are working on a spreadsheet that...

Question 6

The ____ function returns the current date.
A) CURRENT DATE
B) TIME & DATE
C) DATE
D) TODAY

Accepted Answer

The TODAY function returns the current date in spreadsheet programs like Microsoft Excel and Google Sheets, without including the time.

Question 7

Describe how Microsoft Excel computes formulas containing more than one operator.

Accepted Answer

The answer of Describe how Microsoft Excel computes formulas containing...

Question 8

Which of the following is not part of a function?
A) =
B) Arguments separated by commas
C) [ ]
D) Function name

Accepted Answer

Brackets [ ] are typically used to indicate an array, which can be used within a function but are not necessarily a part of the function syntax itself. The equals sign = is used to assign a value to a variable or to return a value from a function. Arguments separated by commas and the function name are both essential components of the function syntax.

Question 9

You have a spreadsheet containing the sales figures for every sale that has taken place in your organization. The spreadsheet includes the sales person's name, the customer's name, the date of the sale, the amount of the sale, as well as the highest and lowest priced items from the sale.
Your supervisor would like to see the sales figures arranged by total sales and then sales person. How can you rearrange the figures to accomplish her request?

Accepted Answer

The answer of You have a spreadsheet containing the sales...

Question 10

Excel ____________________ let you manage and analyze rows of data that have the same kind of information.

Accepted Answer

The answer of Excel ____________________ let you manage and analyze...

Question 11

List the six common categories of functions in Microsoft Excel.

Accepted Answer

The answer of List the six common categories of functions...

Question 12

You can identify the largest value in a range of cells using the ____________________ function.

Accepted Answer

The answer of You can identify the largest value in...

Question 13

You have a spreadsheet containing the sales figures for every sale that has taken place in your organization. The spreadsheet includes the sales person's name, the customer's name, the date of the sale, the amount of the sale, as well as the highest and lowest priced items from the sale.
Your supervisor has asked you to print out a version of the spreadsheet that only contains sales that are greater than $25,000.00. How can you accomplish his request?

Accepted Answer

The answer of You have a spreadsheet containing the sales...

Question 14

Describe how dates are calculated using serial values.

Accepted Answer

The answer of Describe how dates are calculated using serial...

Question 15

A(n) ____________________ cell reference is a cell reference that always stays the same, even when you copy a formula that contains it to a new location.

Accepted Answer

The answer of A(n) ____________________ cell reference is a cell...

Question 16

The ____________________ function counts the number of cells in a range containing numbers.

Accepted Answer

The answer of The ____________________ function counts the number of...

Question 17

You are working on a spreadsheet that contains many different kinds of calculations. Your supervisor knows that Excel has built-in functions for many of the calculations.
Your spreadsheet contains a set of test results, and your supervisor needs to know information such as the average, maximum, and minimum. Which set of functions should you use in your spreadsheet?

Accepted Answer

The answer of You are working on a spreadsheet that...

Question 18

Match between columns
                        Premises: Argument

Accepted Answer

The Answer of Used to align text within a cell is...

Question 19

____________________ are all of the information a function needs to perform a task.

Accepted Answer

The answer of ____________________ are all of the information a...

Question 20

Match between columns
                        Premises: AutoComplete

Accepted Answer

The Answer of Standard order used in math and To is...

Quiz 4: Excel

Formulas that contain more than one operator are called ____________________ formulas.

You can identify the smallest value in a range of cells using the ____________________ function.

The COUNT function counts the number of cells in a range containing ____.

The ____ function returns the current date.

Describe how Microsoft Excel computes formulas containing more than one operator.

Which of the following is not part of a function?

Excel ____________________ let you manage and analyze rows of data that have the same kind of information.

List the six common categories of functions in Microsoft Excel.

You can identify the largest value in a range of cells using the ____________________ function.

Describe how dates are calculated using serial values.

A(n) ____________________ cell reference is a cell reference that always stays the same, even when you copy a formula that contains it to a new location.

The ____________________ function counts the number of cells in a range containing numbers.

Match each item with the correct description.

____________________ are all of the information a function needs to perform a task.

Match each item with the correct description.