Question 1

The Quick Analysis button appears whenever you select a range of ____ or more cells.

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4 
A)  1 
B)  2 
C)  3 
D)  4 B

Question 2

The AVERAGE ____ lets you calculate the average of a range of cells.

Accepted Answer

A)  function 
B)  formula 
C)  operator 
D)  criterion 
A)  function 
B)  formula 
C)  operator 
D)  criterion A

Question 3

Custom Sort is available by clicking the Sort & Filter button on the ____ tab.

Accepted Answer

A)  HOME 
B)  SORT 
C)  DATA 
D)  INSERT 
A)  HOME 
B)  SORT 
C)  DATA 
D)  INSERT A

Question 4

Calculations in parentheses are always evaluated last.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A)  numbers 
B)  conditional formatting 
C)  formulas 
D)  mathematical operators 
A)  numbers 
B)  conditional formatting 
C)  formulas 
D)  mathematical operators

Question 6

You can apply _____ formatting to individual cells based on certain conditions being met.

Accepted Answer

A)  automatic 
B)  conditional 
C)  thematic 
D)  temporary 
A)  automatic 
B)  conditional 
C)  thematic 
D)  temporary

Question 7

All date and time functions produce recognizable text values that you can display "as is" in your worksheets.

Accepted Answer

A) True 
 B)False

Question 8

Match between columns
                        Premises: (4+7)
3^2
*5
+3
-2

Accepted Answer

The Answer of Third and Fifth and First and Second is...

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 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

Click the drop down list that will appea

Question 10

The accompanying figure is an example of ____.

Accepted Answer

A)  using themes 
B)  conditional formatting 
C)  sorting 
D)  filtering 
A)  using themes 
B)  conditional formatting 
C)  sorting 
D)  filtering

Question 11

When you create worksheets that contain many calculations, you rarely need to create formulas that contain more than one mathematical operator.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following is not part of a function?

Accepted Answer

A)  = 
B)  arguments separated by commas 
C)  [ ] 
D)  function name 
A)  = 
B)  arguments separated by commas 
C)  [ ] 
D)  function name

Question 13

When you are ready to convert a range of cells to a table, select the range, and then click the Format as Table button in the ____ group.

Accepted Answer

A)  Format 
B)  Data 
C)  Styles 
D)  Tables 
A)  Format 
B)  Data 
C)  Styles 
D)  Tables

Question 14

The COUNT function adds values in a range of cells

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

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

Question 16

A range reference, such as A12:G30, can be part of a(n) argument

Accepted Answer

A) True 
 B)False

Question 17

The ____ function returns the current date.

Accepted Answer

A)  CURRENT DATE 
B)  TIME & DATE 
C)  DATE 
D)  TODAY 
A)  CURRENT DATE 
B)  TIME & DATE 
C)  DATE 
D)  TODAY

Question 18

In the accompanying figure, which item displays the Date & Time button?

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4 
A)  1 
B)  2 
C)  3 
D)  4

Question 19

An Excel table is similar to a table in a ____because you can sort data in much the same way.

Accepted Answer

A)  Word document 
B)  chart 
C)  database 
D)  gallery 
A)  Word document 
B)  chart 
C)  database 
D)  gallery

Question 20

The formula =C6+D6+E6-F6 is an example of a complex formula.

Accepted Answer

A) True 
 B)False

The Quick Analysis button appears whenever you select a range of ____ or more cells.

The AVERAGE ____ lets you calculate the average of a range of cells.

Custom Sort is available by clicking the Sort & Filter button on the ____ tab.

Calculations in parentheses are always evaluated last.

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

You can apply _____ formatting to individual cells based on certain conditions being met.

All date and time functions produce recognizable text values that you can display "as is" in your worksheets.

The accompanying figure is an example of ____.

When you create worksheets that contain many calculations, you rarely need to create formulas that contain more than one mathematical operator.

Which of the following is not part of a function?

When you are ready to convert a range of cells to a table, select the range, and then click the Format as Table button in the ____ group.

The COUNT function adds values in a range of cells

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

A range reference, such as A12:G30, can be part of a(n) argument

The ____ function returns the current date.

In the accompanying figure, which item displays the Date & Time button?

An Excel table is similar to a table in a ____because you can sort data in much the same way.

The formula =C6+D6+E6-F6 is an example of a complex formula.

Getting Started With Windows 8

Understanding File Management

Getting Started With Microsoft Office 2013

Creating a Document

Enhancing a Document

Adding Special Elements to a Document

Creating and Enhancing a Worksheet

Working With Charts

Creating a Database

Working With Data

Creating Database Reports

Creating a Presentation

Polishing and Running a Presentation

Integrating Office Programs

Working in the Cloud

Understaning Essential Unit Concepts

Filters

Exam 8: Using Complex Formulas, Functions, and Tables

The Quick Analysis button appears whenever you select a range of ____ or more cells.

The AVERAGE ____ lets you calculate the average of a range of cells.

Custom Sort is available by clicking the Sort & Filter button on the ____ tab.

Calculations in parentheses are always evaluated last.

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

You can apply _____ formatting to individual cells based on certain conditions being met.

All date and time functions produce recognizable text values that you can display "as is" in your worksheets.

The accompanying figure is an example of ____.

When you create worksheets that contain many calculations, you rarely need to create formulas that contain more than one mathematical operator.

Which of the following is not part of a function?

When you are ready to convert a range of cells to a table, select the range, and then click the Format as Table button in the ____ group.

The COUNT function adds values in a range of cells

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

A range reference, such as A12:G30, can be part of a(n) argument

The ____ function returns the current date.

In the accompanying figure, which item displays the Date & Time button?

An Excel table is similar to a table in a ____because you can sort data in much the same way.

The formula =C6+D6+E6-F6 is an example of a complex formula.

Getting Started With Windows 8

Understanding File Management

Getting Started With Microsoft Office 2013

Creating a Document

Enhancing a Document

Adding Special Elements to a Document

Creating and Enhancing a Worksheet

Working With Charts

Creating a Database

Working With Data

Creating Database Reports

Creating a Presentation

Polishing and Running a Presentation

Integrating Office Programs

Working in the Cloud

Understaning Essential Unit Concepts

Filters