Question 1

The _____ function replaces text in a text string.​
A) REPLACE
B)SEARCH & REPLACE
C)SUBSTITUTE
D)STRING

Accepted Answer

The SUBSTITUTE function replaces specific text in a specified text string with new text. The REPLACE function is similar but replaces text based on a specific location in the string, not just the content. "SEARCH & REPLACE" is not a specific Excel function. "STRING" is a data type and not a function in Excel.

Question 2

The _____ is an external reference indicator.​
A)percent symbol (%)
B)caret symbol (^)
C)exclamation point (!)
D)asterisk (*)

Accepted Answer

The answer of The _____ is an external reference indicator.​
A)percent...

Question 3

The _____ function calculates the current date and time.​
A)NOW
B)CURRENT
C)TODAY
D)DATE

Accepted Answer

The NOW function returns the current date and time. It is commonly used in date and time calculations, as well as in conditional formatting to display specific time-sensitive information.

Question 4

The ____ refers to where you will be able to use a named cell or range in worksheets.
A) range
B) location
C) scope
D) definition

Accepted Answer

The scope refers to the range of places where a named cell or range can be used within a workbook. It determines where you can reference the named cell or range within formulas and macros.

Question 5

Which button do you click in the Function Library group to select SUMIF from the list of functions?
A) Statistical
B) Math & Trig
C) Math Functions
D) Trig & Calculus

Accepted Answer

SUMIF is categorized under Math & Trig functions in the Function Library group.

Question 6

When used in formulas, names become ____ cell references by default.
A) absolute
B) relative
C) linked
D) unlinked

Accepted Answer

Names in formulas default to absolute cell references, meaning they refer to a specific cell or range of cells regardless of where they are moved or copied within the spreadsheet.

Question 7

Which error code will display if a value in a formula is not available?
A) #NAME?
B) #VAL
C) #NONE
D) #NA

Accepted Answer

#NA is the error code that displays when a value in a formula is not available. #NAME? is used when Excel cannot recognize a formula name, #VAL is used when a formula has an invalid argument, and #NONE is not a valid error code in Excel.

Question 8

Which error code will display if a number is used invalidly in a cell?
A) #NUM!
B) #VAL
C) #VALUE!
D) #NAME?

Accepted Answer

The answer of Which error code will display if a...

Question 9

One way to display formulas is by pressing this key combination.
A) [CTRL][+]
B) [CTRL][`]
C) [CTRL][F]
D) [CTRL][*]

Accepted Answer

Pressing [CTRL][`] will display all the formulas in a worksheet.

Question 10

Which of the following is not a valid named range?
A) Alaska59
B) New quote
C) salary
D) Top_Sales

Accepted Answer

Named ranges cannot have spaces, therefore "New quote" is not a valid option. The other options do not have any invalid characters and are appropriate for naming a range.

Question 11

In the cell entry, =[Product.xlsx]Sales!$C$7, [Product.xlsx] refers to the ____.
A) cell reference
B) worksheet name
C) function name
D) workbook name

Accepted Answer

[Product.xlsx] refers to the workbook name, which is enclosed in square brackets and followed by the worksheet name (Sales) and cell reference ($C$7).

Question 12

A condition that can be answered with a true or false response is called a(n) ____.
A) logical test.
B) what-if analysis.
C) True_False condition
D) IF analysis

Accepted Answer

A logical test is a condition that evaluates to true or false. It is often used in programming and spreadsheet applications to make decisions based on certain criteria.

Question 13

Which error code will display if a formula contains a text error?
A) #NA
B) #NUM!
C) #NAME?
D) #####

Accepted Answer

#NAME? error is displayed if a formula contains a text error, such as misspelling a function name or referring to a cell that doesn't exist.

Question 14

In the  cell entry, =[Product.xlsx]Sales!$C$7, Sales!  refers to the ____.
A) cell name
B) range name
C) worksheet name
D) workbook name

Accepted Answer

Sales! refers to the worksheet name in the workbook named Product.xlsx.

Question 15

Names of cells and ranges cannot use ____.
A) uppercase letters
B) lowercase letters
C) digits
D) spaces

Accepted Answer

Names of cells and ranges cannot use spaces. While uppercase letters, lowercase letters, and digits are all allowed in cell and range names, spaces are not because they can cause errors in formulas and make it difficult to refer to the named range or cell. Instead of spaces, you can use underscores (_) to separate words in a cell or range name.

Question 16

Which of the following is NOT one of the arguments of a PMT function?
A) payment
B) pv
C) nper
D) rate

Accepted Answer

The PMT function in Excel calculates the payment for a loan based on constant payments and a constant interest rate. It does not have an argument specifically named "payment" because the function itself is used to calculate the payment. The other options (pv, nper, rate) are indeed arguments of the PMT function: pv (present value), nper (number of periods), and rate (interest rate per period).

Question 17

Which error code will display if a column is not wide enough to display data?
A) #####
B) #NUM!
C) #NULL!
D) #NA

Accepted Answer

The error code ##### will display if a column is not wide enough to display data. This error occurs when the cell content exceeds the column width and cannot be displayed. It can be fixed by increasing the column width.

Question 18

Which Excel function checks for errors and displays a message you specify if there is an error in a formula.
A) ERROR
B) #ERROR
C) IFERROR
D) #IFERROR

Accepted Answer

The answer of Which Excel function checks for errors and...

Question 19

Which of the following is NOT a comparison operator you can use in Excel?
A).
B) >
C) =
D) $

Accepted Answer

The answer of Which of the following is NOT a...

Question 20

The _____ function calculates the current date only.​
A)NOW
B)CURRENT
C)TODAY
D)DATE

Accepted Answer

The answer of The _____ function calculates the current date...

Quiz 5: Productivity Apps for School and Work Word, Analyzing Data Using Formulasmodifying the Database Structureintegrating Word, Excel, and Access

The _____ function replaces text in a text string.​

The _____ is an external reference indicator.​

The _____ function calculates the current date and time.​

The ____ refers to where you will be able to use a named cell or range in worksheets.

Which button do you click in the Function Library group to select SUMIF from the list of functions?

When used in formulas, names become ____ cell references by default.

Which error code will display if a value in a formula is not available?

Which error code will display if a number is used invalidly in a cell?

One way to display formulas is by pressing this key combination.

Which of the following is not a valid named range?

In the cell entry, =[Product.xlsx]Sales!$C$7, [Product.xlsx] refers to the ____.

A condition that can be answered with a true or false response is called a(n) ____.

Which error code will display if a formula contains a text error?

In the cell entry, =[Product.xlsx]Sales!$C$7, Sales! refers to the ____.

Names of cells and ranges cannot use ____.

Which of the following is NOT one of the arguments of a PMT function?

Which error code will display if a column is not wide enough to display data?

Which Excel function checks for errors and displays a message you specify if there is an error in a formula.

Which of the following is NOT a comparison operator you can use in Excel?

The _____ function calculates the current date only.​

The _____ function replaces text in a text string.

The _____ is an external reference indicator.

The _____ function calculates the current date and time.

The _____ function calculates the current date only.