Question 1

The symbol stands for "equal to."

Accepted Answer

The symbol <> stands for "not equal to" in many programming languages and mathematical contexts.

Question 2

The CONCATENATE function joins two or more ____ into one.
A) strings
B) formulas
C) cells
D) functions

Accepted Answer

The CONCATENATE function is used to join two or more strings of text into one. It is often used to join the contents of multiple cells into one cell.

Question 3

Cell references that reference other sheets behind the summary sheet are known as ____ references.
A) 3-D
B) Mirror
C) Backstage
D) Stage

Accepted Answer

Cell references that reference other sheets are called 3-D references because they refer to data in three dimensions, including the sheet name, row number, and column number.

Question 4

Which Excel function counts the number of cells in a range?
A) SUMIF
B) AVERAGEIF
C) COUNTIF
D) TOTALSUM

Accepted Answer

The COUNTIF function counts the number of cells within a range that meet a certain criteria or condition. The other options listed (SUMIF, AVERAGEIF, and TOTALSUM) are used for calculating the sum or average of cells within a range based on a certain condition.

Question 5

If the formula, =IF(B3>B1,5,0) is entered in cell C3,​ the value 0 will be stored in cell C3 if the logical test is false. ____________________

Accepted Answer

The IF function in Excel returns the second argument (in this case, 0) if the logical test (B3>B1) is false.

Question 6

If the formula, =IF(B3>B1,5,0) is entered in cell C3,​ the value 0 will be stored in cell C3 if the logical test is true. ____________________

Accepted Answer

The value 0 will be stored in cell C3 only if the logical test (B3>B1) is false, not true. If the logical test is true, the value 5 will be stored in cell C3.

Question 7

If the value in cell A1 is 10 and the value in cell B1 is 20, the formula, =OR(A1>5,B1>25) will return a result of TRUE . ____________________

Accepted Answer

The OR function returns TRUE if any of the conditions are TRUE. In this case, A1>5 is TRUE because 10 is greater than 5, and B1>25 is FALSE because 20 is not greater than 25. However, since there is at least one TRUE condition (A1>5), the OR function overall returns TRUE.

Question 8

Symbols, such as less than ( ), and equal to (=), are all examples of comparison operators.

Accepted Answer

Symbols like less than and equal to are comparison operators that are used to compare two values or variables.

Question 9

Which Excel feature is used to break a data field into separate columns?
A) Break
B) Separate Columns
C) Convert Text to Columns
D) Concatenate

Accepted Answer

The Convert Text to Columns feature can be used to split a data field into separate columns based on a specified delimiter, such as a comma or space. This feature allows for greater flexibility in organizing and analyzing data.

Question 10

A common example of a text delimiter is ____.
A) ,
B) =
C) +
D) (

Accepted Answer

The comma (,) is a commonly used delimiter in text files to separate different values or fields. It is often used in CSV (comma-separated values) files for data exchange between different programs.

Question 11

To avoid a circular reference, you can enable the iteration feature​. ____________________

Accepted Answer

By enabling iteration, Excel can recalculate the workbook multiple times until the values converge without causing a circular reference.

Question 12

Which Excel function averages cells in a range based on a specified condition?
A) AVERAGEIF
B) AVERAGE
C) COUNTIF
D) SUMIF

Accepted Answer

The AVERAGEIF function allows you to find the average of cells in a range that meet a specified condition. It takes two arguments: the range of cells to evaluate, and the condition to be met. For example, AVERAGEIF(A1:A10,">=5") would find the average of all cells in A1 through A10 that are greater than or equal to 5.

Question 13

The AND function returns a value of TRUE if every logical test in the formula is true.

Accepted Answer

The AND function requires all logical tests in the formula to be true in order to return a value of TRUE.

Question 14

Which text function capitalizes the first letter in a string of text?
A) UPPER
B) CAPITAL
C) FIRST
D) PROPER

Accepted Answer

The PROPER function capitalizes the first letter in each word of a string of text, making it the best choice for this question.

Question 15

What Excel features uses worksheet data to predict what should be entered into similar column cells?
A) Auto Complete
B) Flash Fill
C) Quick Fill
D) Auto Fill

Accepted Answer

Flash Fill uses the data in the worksheet to predict and automatically enter values in similar column cells based on a pattern. Auto Complete suggests possible values based on previously entered data, Quick Fill fills in a series of sequential data, and Auto Fill fills a series of data based on a selected pattern.

Question 16

Which Excel function totals only the cells in a range that meet given criteria?
A) COUNTIF
B) CONCATENATE
C) SUMIF
D) TOTALNUM

Accepted Answer

SUMIF is the Excel function that allows you to specify certain criteria and only sum the cells in a range that meet those criteria. COUNTIF counts the number of cells in a range that meet a certain criteria, but does not add up their values. CONCATENATE merges two or more text strings into one. TOTALNUM is not a valid Excel function.

Question 17

If the value in cell A1 is 10 and the value in cell B1 is 20, the formula, =AND(A1>5,B1>25) will return a result of TRUE . ____________________

Accepted Answer

The statement in the formula includes a requirement that both A1 and B1 meet certain criteria - A1 must be greater than 5 and B1 must be greater than 25. In this case, while A1 meets the criteria, B1 does not, as it is only 20. Therefore, the result of the formula will be FALSE.

Question 18

A linked IF function contains IF functions inside other IF functions.​ ____________________

Accepted Answer

The answer of A linked IF function contains IF functions...

Question 19

What is the calculated result of the formula =PROPER("john smith")?
A) JOHN SMITH
B) John Smith
C) john smith
D) John smith

Accepted Answer

The answer of What is the calculated result of the...

Question 20

Cell and range names can have spaces.​

Accepted Answer

The answer of Cell and range names can have spaces.​...

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

The symbol stands for "equal to."

The CONCATENATE function joins two or more ____ into one.

Cell references that reference other sheets behind the summary sheet are known as ____ references.

Which Excel function counts the number of cells in a range?

If the formula, =IF(B3>B1,5,0) is entered in cell C3, the value 0 will be stored in cell C3 if the logical test is false. ____________________

If the formula, =IF(B3>B1,5,0) is entered in cell C3, the value 0 will be stored in cell C3 if the logical test is true. ____________________

If the value in cell A1 is 10 and the value in cell B1 is 20, the formula, =OR(A1>5,B1>25) will return a result of TRUE . ____________________

Symbols, such as less than ( ), and equal to (=), are all examples of comparison operators.

Which Excel feature is used to break a data field into separate columns?

A common example of a text delimiter is ____.

To avoid a circular reference, you can enable the iteration feature. ____________________

Which Excel function averages cells in a range based on a specified condition?

The AND function returns a value of TRUE if every logical test in the formula is true.

Which text function capitalizes the first letter in a string of text?

What Excel features uses worksheet data to predict what should be entered into similar column cells?

Which Excel function totals only the cells in a range that meet given criteria?

If the value in cell A1 is 10 and the value in cell B1 is 20, the formula, =AND(A1>5,B1>25) will return a result of TRUE . ____________________

A linked IF function contains IF functions inside other IF functions. ____________________

What is the calculated result of the formula =PROPER("john smith") ?

Cell and range names can have spaces.

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

The symbol stands for "equal to."

The CONCATENATE function joins two or more ____ into one.

Cell references that reference other sheets behind the summary sheet are known as ____ references.

Which Excel function counts the number of cells in a range?

If the formula, =IF(B3>B1,5,0) is entered in cell C3,​ the value 0 will be stored in cell C3 if the logical test is false. ____________________

If the formula, =IF(B3>B1,5,0) is entered in cell C3,​ the value 0 will be stored in cell C3 if the logical test is true. ____________________

If the value in cell A1 is 10 and the value in cell B1 is 20, the formula, =OR(A1>5,B1>25) will return a result of TRUE . ____________________

Symbols, such as less than ( ), and equal to (=), are all examples of comparison operators.

Which Excel feature is used to break a data field into separate columns?

A common example of a text delimiter is ____.

To avoid a circular reference, you can enable the iteration feature​. ____________________

Which Excel function averages cells in a range based on a specified condition?

The AND function returns a value of TRUE if every logical test in the formula is true.

Which text function capitalizes the first letter in a string of text?

What Excel features uses worksheet data to predict what should be entered into similar column cells?

Which Excel function totals only the cells in a range that meet given criteria?

If the value in cell A1 is 10 and the value in cell B1 is 20, the formula, =AND(A1>5,B1>25) will return a result of TRUE . ____________________

A linked IF function contains IF functions inside other IF functions.​ ____________________

What is the calculated result of the formula =PROPER("john smith") ?

Cell and range names can have spaces.​

If the formula, =IF(B3>B1,5,0) is entered in cell C3, the value 0 will be stored in cell C3 if the logical test is false. ____________________

If the formula, =IF(B3>B1,5,0) is entered in cell C3, the value 0 will be stored in cell C3 if the logical test is true. ____________________

To avoid a circular reference, you can enable the iteration feature. ____________________

A linked IF function contains IF functions inside other IF functions. ____________________

Cell and range names can have spaces.