Question 1

Cell formats that are automatically in place unless you specify otherwise are called ________ settings.

Accepted Answer

The answer of Cell formats that are automatically in place...

Question 2

The ________ function returns the number of cells in a cell range that contain numbers.

Accepted Answer

The answer of The ________ function returns the number of...

Question 3

Excel is specifically designed to present information in tabular and graphical formats.

Accepted Answer

A) True 
 B)False

Question 4

Match between columns
                        Premises: Argument
Function
Built-in function
Cell reference
Destination cell

Accepted Answer

The Answer of A function included in Excel that can is...

Question 5

The Comma style is formatted as the Currency style without a monetary symbol.

Accepted Answer

A) True 
 B)False

Question 6

Excel stores time values as decimal portions of one day.

Accepted Answer

A) True 
 B)False

Question 7

A constant is a value that never changes,such as months in a year.

Accepted Answer

A) True 
 B)False

Question 8

A ________ cell is the cell that receive the result of an operation such as Paste or an AutoSum function.

Accepted Answer

A)  active 
B)  source 
C)  destination 
D)  adjacent 
A)  active 
B)  source 
C)  destination 
D)  adjacent

Question 9

A number that never changes is a(n)________.

Accepted Answer

The answer of A number that never changes is a(n)________....

Question 10

The default theme for a workbook is the Excel theme.

Accepted Answer

A) True 
 B)False

Question 11

A(n)________ format is used to present information in charts,graphs,and pictures.

Accepted Answer

The answer of A(n)________ format is used to present information...

Question 12

Which of the following is NOT true about using fill colors?

Accepted Answer

A)  Fill color can be used to categorize information. 
B)  Fill color can be used to band rows or columns as a means of assisting the reader to follow information across or down a worksheet. 
C)  Fill color refers to the border color and style of a cell. 
D)  Fill color can be used to highlight values. 
A)  Fill color can be used to categorize information. 
B)  Fill color can be used to band rows or columns as a means of assisting the reader to follow information across or down a worksheet. 
C)  Fill color refers to the border color and style of a cell. 
D)  Fill color can be used to highlight values.

Question 13

________ color is the background color of a cell.

Accepted Answer

The answer of ________ color is the background color of...

Question 14

Formulas always begin with ________.

Accepted Answer

A)  = 
B)  % 
C)  $ 
D)  ~ 
A)  = 
B)  % 
C)  $ 
D)  ~

Question 15

A destination cell is the location cell to be modified by a move or paste operation.

Accepted Answer

A) True 
 B)False

Question 16

In Excel,formulas and functions always begin with equal sign.

Accepted Answer

A) True 
 B)False

Question 17

To find the smallest numerical value in a range of cells,you would use the ________ function.

Accepted Answer

The answer of To find the smallest numerical value in...

Question 18

To hide a row or column in Excel,click the row or column heading,point to the selected row or column heading(s),right-click,and then select ________ on the displayed shortcut menu.

Accepted Answer

A)  Plain Formatting 
B)  Adjust 
C)  Hide 
D)  Filter 
A)  Plain Formatting 
B)  Adjust 
C)  Hide 
D)  Filter

Question 19

The Comma Style is the ________ format without a monetary symbol.

Accepted Answer

A)  General 
B)  Number 
C)  Currency 
D)  Accounting Number 
A)  General 
B)  Number 
C)  Currency 
D)  Accounting Number

Question 20

When applying a ________,it is best practice to use muted or pastel colors.

Accepted Answer

A)  table style 
B)  theme 
C)  built-in cell style 
D)  fill color 
A)  table style 
B)  theme 
C)  built-in cell style 
D)  fill color

Cell formats that are automatically in place unless you specify otherwise are called ________ settings.

The ________ function returns the number of cells in a cell range that contain numbers.

Excel is specifically designed to present information in tabular and graphical formats.

The Comma style is formatted as the Currency style without a monetary symbol.

Excel stores time values as decimal portions of one day.

A constant is a value that never changes,such as months in a year.

A ________ cell is the cell that receive the result of an operation such as Paste or an AutoSum function.

A number that never changes is a(n)________.

The default theme for a workbook is the Excel theme.

A(n)________ format is used to present information in charts,graphs,and pictures.

Which of the following is NOT true about using fill colors?

________ color is the background color of a cell.

Formulas always begin with ________.

A destination cell is the location cell to be modified by a move or paste operation.

In Excel,formulas and functions always begin with equal sign.

To find the smallest numerical value in a range of cells,you would use the ________ function.

To hide a row or column in Excel,click the row or column heading,point to the selected row or column heading(s),right-click,and then select ________ on the displayed shortcut menu.

The Comma Style is the ________ format without a monetary symbol.

When applying a ________,it is best practice to use muted or pastel colors.

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

Cell References, Named Ranges, and Functions

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 8: Formats, Functions, and Formulas

Cell formats that are automatically in place unless you specify otherwise are called ________ settings.

The ________ function returns the number of cells in a cell range that contain numbers.

Excel is specifically designed to present information in tabular and graphical formats.

The Comma style is formatted as the Currency style without a monetary symbol.

Excel stores time values as decimal portions of one day.

A constant is a value that never changes,such as months in a year.

A ________ cell is the cell that receive the result of an operation such as Paste or an AutoSum function.

A number that never changes is a(n)________.

The default theme for a workbook is the Excel theme.

A(n)________ format is used to present information in charts,graphs,and pictures.

Which of the following is NOT true about using fill colors?

________ color is the background color of a cell.

Formulas always begin with ________.

A destination cell is the location cell to be modified by a move or paste operation.

In Excel,formulas and functions always begin with equal sign.

To find the smallest numerical value in a range of cells,you would use the ________ function.

To hide a row or column in Excel,click the row or column heading,point to the selected row or column heading(s),right-click,and then select ________ on the displayed shortcut menu.

The Comma Style is the ________ format without a monetary symbol.

When applying a ________,it is best practice to use muted or pastel colors.

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

Cell References, Named Ranges, and Functions

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