Question 1

The result of =ROUNDDOWN(98.765,0)is 98.

Accepted Answer

A) True 
 B)False

Question 2

What is the error message when you calculate the following in cell A1: 2756 ÷ 0?

Accepted Answer

A)  #VALUE! 
B)  #DIV/0! 
C)  #REF! 
D)  #N/A 
A)  #VALUE! 
B)  #DIV/0! 
C)  #REF! 
D)  #N/A

Question 3

The YEAR function returns the year in the range ________.

Accepted Answer

A)  0-9000 
B)  1000-9000 
C)  1000-9999 
D)  1900-9999 
A)  0-9000 
B)  1000-9000 
C)  1000-9999 
D)  1900-9999

Question 4

When using a text string in an argument,enclose the string in ________ so Excel will recognize it as a text string rather than a named range.

Accepted Answer

A)  asterisks * * 
B)  brackets [ ] 
C)  parentheses ( ) 
D)  quotes " " 
A)  asterisks * * 
B)  brackets [ ] 
C)  parentheses ( ) 
D)  quotes " "

Question 5

Which of the following is NOT a comparison operator symbol?

Accepted Answer

A)  ≠ 
B)  = 
C)  = 
A)  ≠ 
B)  = 
C)  =

Question 6

A(n)________ is a variable or value the function requires to calculate a solution.

Accepted Answer

The answer of A(n)________ is a variable or value the...

Question 7

Match between columns
                        Premises: Math & Trig
Logical
Lookup & Reference
Web
Text

Accepted Answer

The Answer of Works with mathematics and Evaluates expressions or is...

Question 8

Optional arguments in a function are enclosed in a pair of ________.

Accepted Answer

A)  braces { } 
B)  brackets [ ] 
C)  parentheses ( ) 
D)  quotes " " 
A)  braces { } 
B)  brackets [ ] 
C)  parentheses ( ) 
D)  quotes " "

Question 9

________ refers to the structure and order of the function and the arguments used by Excel to perform a calculation.

Accepted Answer

The answer of ________ refers to the structure and order...

Question 10

Which of the following is NOT a guideline to follow when building formulas and functions?

Accepted Answer

A)  Do not overuse parentheses..For example, use =SUM(Sales) instead of =(SUM(Sales)). 
B)  Avoid unneeded spaces in formulas. 
C)  Always put quotation marks around numeric values. 
D)  Use the negative sign, as in -333, to indicate negative numbers in formulas, rather than (333). 
A)  Do not overuse parentheses..For example, use =SUM(Sales) instead of =(SUM(Sales)). 
B)  Avoid unneeded spaces in formulas. 
C)  Always put quotation marks around numeric values. 
D)  Use the negative sign, as in -333, to indicate negative numbers in formulas, rather than (333).

Question 11

________ is the keyboard shortcut to display a list of named ranges.

Accepted Answer

A)  F1 
B)  F2 
C)  F3 
D)  F4 
A)  F1 
B)  F2 
C)  F3 
D)  F4

Question 12

Match between columns
                        Premises: MODE.SNGL
MEDIAN
MODE.MULT
AVERAGE
MODE

Accepted Answer

The Answer of Returns the most frequently occurring value in is...

Question 13

If the value in B4 = 40,what is the result of =IF( B4>65,"Passing","Failing")?

Accepted Answer

A)  TRUE 
B)  FALSE 
C)  Passing 
D)  Failing 
A)  TRUE 
B)  FALSE 
C)  Passing 
D)  Failing

Question 14

Which of the following is NOT an Excel function category?

Accepted Answer

A)  Educational 
B)  Cube 
C)  Logical 
D)  Financial 
A)  Educational 
B)  Cube 
C)  Logical 
D)  Financial

Question 15

Instead of typing the $ symbol in a cell reference,you can use the ________ keyboard shortcut.

Accepted Answer

A)  F4 
B)  F2 
C)  F7 
D)  F11 
A)  F4 
B)  F2 
C)  F7 
D)  F11

Question 16

To return the number of cells in a range of cells that are not empty,use the ________ function.

Accepted Answer

The answer of To return the number of cells in...

Question 17

Excel's RANDBETWEEN function returns a random number from 0 to less than 1.

Accepted Answer

A) True 
 B)False

Question 18

Excel's AVERAGE function returns the mean of a set of numbers.

Accepted Answer

A) True 
 B)False

Question 19

Match between columns
                        Premises: Name Manager
Function arguments
Syntax
Argument
Function

Accepted Answer

The Answer of A dialog box that provides additional information is...

Question 20

An absolute cell reference is denoted by a(n)________.

Accepted Answer

A)  dollar sign ($) 
B)  asterisk (*) 
C)  number sign (#) 
D)  at sign (@) 
A)  dollar sign ($) 
B)  asterisk (*) 
C)  number sign (#) 
D)  at sign (@)

The result of =ROUNDDOWN(98.765,0)is 98.

What is the error message when you calculate the following in cell A1: 2756 ÷ 0?

The YEAR function returns the year in the range ________.

When using a text string in an argument,enclose the string in ________ so Excel will recognize it as a text string rather than a named range.

Which of the following is NOT a comparison operator symbol?

A(n)________ is a variable or value the function requires to calculate a solution.

Optional arguments in a function are enclosed in a pair of ________.

________ refers to the structure and order of the function and the arguments used by Excel to perform a calculation.

Which of the following is NOT a guideline to follow when building formulas and functions?

________ is the keyboard shortcut to display a list of named ranges.

If the value in B4 = 40,what is the result of =IF( B4>65,"Passing","Failing")?

Which of the following is NOT an Excel function category?

Instead of typing the $ symbol in a cell reference,you can use the ________ keyboard shortcut.

To return the number of cells in a range of cells that are not empty,use the ________ function.

Excel's RANDBETWEEN function returns a random number from 0 to less than 1.

Excel's AVERAGE function returns the mean of a set of numbers.

An absolute cell reference is denoted by a(n)________.

Understanding the Common Features of Microsoft Office

Explore Windows and File Management

Review and Modify a Document

Create and Edit a Document

Include Tables and Objects

Special Document Formatting and Mail Merge

Create, Navigate, Work With, and Print Worksheets

Formats, Functions, and Formulas

Effective Charts

The Four Main Database Objects

Tables,Keys,and Relationships

Queries and Data Access

Using Forms and Reports in Access

Presentation Fundamentals

Text and Graphics

Multimedia and Motion

Customization and Collaboration

Filters

Exam 9: Cell References, Named Ranges, and Functions

The result of =ROUNDDOWN(98.765,0)is 98.

What is the error message when you calculate the following in cell A1: 2756 ÷ 0?

The YEAR function returns the year in the range ________.

When using a text string in an argument,enclose the string in ________ so Excel will recognize it as a text string rather than a named range.

Which of the following is NOT a comparison operator symbol?

A(n)________ is a variable or value the function requires to calculate a solution.

Optional arguments in a function are enclosed in a pair of ________.

________ refers to the structure and order of the function and the arguments used by Excel to perform a calculation.

Which of the following is NOT a guideline to follow when building formulas and functions?

________ is the keyboard shortcut to display a list of named ranges.

If the value in B4 = 40,what is the result of =IF( B4>65,"Passing","Failing")?

Which of the following is NOT an Excel function category?

Instead of typing the $ symbol in a cell reference,you can use the ________ keyboard shortcut.

To return the number of cells in a range of cells that are not empty,use the ________ function.

Excel's RANDBETWEEN function returns a random number from 0 to less than 1.

Excel's AVERAGE function returns the mean of a set of numbers.

An absolute cell reference is denoted by a(n)________.

Understanding the Common Features of Microsoft Office

Explore Windows and File Management

Review and Modify a Document

Create and Edit a Document

Include Tables and Objects

Special Document Formatting and Mail Merge

Create, Navigate, Work With, and Print Worksheets

Formats, Functions, and Formulas

Effective Charts

The Four Main Database Objects

Tables,Keys,and Relationships

Queries and Data Access

Using Forms and Reports in Access

Presentation Fundamentals

Text and Graphics

Multimedia and Motion

Customization and Collaboration

Filters