Question 1

Excel's Scale to Fit commands enable you to stretch or shrink the width,height,or both of a printed page.

Accepted Answer

A) True 
 B)False  True

Question 2

Which symbols does Excel use to indicate that a cell is not wide enough to display a formula or function result?

Accepted Answer

A) * 
B) @ 
C) # 
D) - 
A) * 
B) @ 
C) # 
D) - C

Question 3

Deleting the ________ of a cell deletes the value or formula,but does not clear formatting of that cell.

Accepted Answer

contents

Question 4

What is a pane bounded by?

Accepted Answer

A) A solid red line 
B) Vertical or horizontal bars 
C) The status bar 
D) The ribbon 
A) A solid red line 
B) Vertical or horizontal bars 
C) The status bar 
D) The ribbon

Question 5

An Excel ________ is a range of cells converted in Excel used to analyze a group of related data.

Accepted Answer

The answer of An Excel ________ is a range of...

Question 6

You cannot clear an entire worksheet in Excel.

Accepted Answer

A) True 
 B)False

Question 7

If a cell is too narrow to display a result of a formula or function,the ##### message displays.

Accepted Answer

A) True 
 B)False

Question 8

Match each of the following terms to its definition:
i.split
II.navigate
III.scale
IV.hide
v.copy

Accepted Answer

A) divide a worksheet into panes 
B) remove a worksheet from view 
C) place cell contents on the Clipboard 
D) move among worksheets 
E) fit a worksheet on a printed page 
A) divide a worksheet into panes 
B) remove a worksheet from view 
C) place cell contents on the Clipboard 
D) move among worksheets 
E) fit a worksheet on a printed page

Question 9

All formulas start with + (a plus sign).

Accepted Answer

A) True 
 B)False

Question 10

Ctrl + F1 is the is the keyboard shortcut for Print Preview.

Accepted Answer

A) True 
 B)False

Question 11

The COUNT function counts the number of cells in a range that ________.

Accepted Answer

A) contain a number or text 
B) contain a number 
C) contain text 
D) match a given value 
A) contain a number or text 
B) contain a number 
C) contain text 
D) match a given value

Question 12

The COUNTIF function has two arguments ________.

Accepted Answer

A) the range of cells to check and the criteria 
B) the range of cells to check and the sum of the range 
C) a value as the criteria and an average of a range of cells 
D) the range of cells to sum and the criteria 
A) the range of cells to check and the criteria 
B) the range of cells to check and the sum of the range 
C) a value as the criteria and an average of a range of cells 
D) the range of cells to sum and the criteria

Question 13

Hiding a worksheet prevents it from displaying,but the sheet is still part of the workbook.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following Excel features recognizes a pattern in the data of a worksheet?

Accepted Answer

A) Find and Replace 
B) Flash Fill 
C) IF function 
D) COUNTIF function 
A) Find and Replace 
B) Flash Fill 
C) IF function 
D) COUNTIF function

Question 15

Scaling reduces the width of a worksheet;it does not reduce the height.

Accepted Answer

A) True 
 B)False

Question 16

When excel enters a current date into a cell,it is accessed from your computer's internal calendar.

Accepted Answer

A) True 
 B)False

Question 17

How do banded rows display?

Accepted Answer

A) Even rows are formatted differently from odd rows 
B) Even rows are bolded;odd rows are not 
C) With a sold border around each row 
D) Even rows are have a different background and font color than do odd rows 
A) Even rows are formatted differently from odd rows 
B) Even rows are bolded;odd rows are not 
C) With a sold border around each row 
D) Even rows are have a different background and font color than do odd rows

Question 18

Which of the following is NOT a way to insert the SUM function into a cell?

Accepted Answer

A) Alt + = 
B) Insert the AutoSum function from the Home tab 
C) Insert the AutoSum function from the Formulas tab 
D) Ctrl + = 
A) Alt + = 
B) Insert the AutoSum function from the Home tab 
C) Insert the AutoSum function from the Formulas tab 
D) Ctrl + =

Question 19

The ,and  can be described as ________.

Accepted Answer

A) logical tests 
B) comparison operators 
C) criteria 
D) arguments 
A) logical tests 
B) comparison operators 
C) criteria 
D) arguments

Question 20

Which of the following is FALSE about the NOW function?

Accepted Answer

A) It updates each time the workbook is opened. 
B) It is a volatile function. 
C) It remains constant even when the workbook is opened. 
D) It uses the computer's calendar and clock to display the date and time. 
A) It updates each time the workbook is opened. 
B) It is a volatile function. 
C) It remains constant even when the workbook is opened. 
D) It uses the computer's calendar and clock to display the date and time.

Excel's Scale to Fit commands enable you to stretch or shrink the width,height,or both of a printed page.

Which symbols does Excel use to indicate that a cell is not wide enough to display a formula or function result?

Deleting the ________ of a cell deletes the value or formula,but does not clear formatting of that cell.

What is a pane bounded by?

An Excel ________ is a range of cells converted in Excel used to analyze a group of related data.

You cannot clear an entire worksheet in Excel.

If a cell is too narrow to display a result of a formula or function,the ##### message displays.

Match each of the following terms to its definition: i.split II.navigate III.scale IV.hide v.copy

All formulas start with + (a plus sign).

Ctrl + F1 is the is the keyboard shortcut for Print Preview.

The COUNT function counts the number of cells in a range that ________.

The COUNTIF function has two arguments ________.

Hiding a worksheet prevents it from displaying,but the sheet is still part of the workbook.

Which of the following Excel features recognizes a pattern in the data of a worksheet?

Scaling reduces the width of a worksheet;it does not reduce the height.

When excel enters a current date into a cell,it is accessed from your computer's internal calendar.

How do banded rows display?

Which of the following is NOT a way to insert the SUM function into a cell?

The <,>,and <> can be described as ________.

Which of the following is FALSE about the NOW function?

Introduction to Microsoft Office 2016 Features

Excell: Creating a Worksheet and Charting Data

Excell: Analyzing Data With Pie Charts, Line Charts, and What-If Analysis Tools

Excell: Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets

Excell: Managing Large Workbooks and Using Advanced Sorting and Filtering

Excell: Creating Charts, Diagrams, and Templates

Excell: Creating Pivottables and Pivotcharts

Excell: Using the Data Analysis, Solver, and Scenario Features, and Building Complex Formulas

Excell: Using Macros and Visual Basic for Applications

Excell: External Data, Database Functions, and Side-By-Side Tables

Excell: Collaborating With Others and Preparing a Workbook for Distribution

Filters

Exam 2: Excell: Using Functions, Creating Tables, and Managing Large Workbooks

Excel's Scale to Fit commands enable you to stretch or shrink the width,height,or both of a printed page.

Which symbols does Excel use to indicate that a cell is not wide enough to display a formula or function result?

Deleting the ________ of a cell deletes the value or formula,but does not clear formatting of that cell.

What is a pane bounded by?

An Excel ________ is a range of cells converted in Excel used to analyze a group of related data.

You cannot clear an entire worksheet in Excel.

If a cell is too narrow to display a result of a formula or function,the ##### message displays.

Match each of the following terms to its definition: i.split II.navigate III.scale IV.hide v.copy

All formulas start with + (a plus sign).

Ctrl + F1 is the is the keyboard shortcut for Print Preview.

The COUNT function counts the number of cells in a range that ________.

The COUNTIF function has two arguments ________.

Hiding a worksheet prevents it from displaying,but the sheet is still part of the workbook.

Which of the following Excel features recognizes a pattern in the data of a worksheet?

Scaling reduces the width of a worksheet;it does not reduce the height.

When excel enters a current date into a cell,it is accessed from your computer's internal calendar.

How do banded rows display?

Which of the following is NOT a way to insert the SUM function into a cell?

The <,>,and <> can be described as ________.

Which of the following is FALSE about the NOW function?

Introduction to Microsoft Office 2016 Features

Excell: Creating a Worksheet and Charting Data

Excell: Analyzing Data With Pie Charts, Line Charts, and What-If Analysis Tools

Excell: Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets

Excell: Managing Large Workbooks and Using Advanced Sorting and Filtering

Excell: Creating Charts, Diagrams, and Templates

Excell: Creating Pivottables and Pivotcharts

Excell: Using the Data Analysis, Solver, and Scenario Features, and Building Complex Formulas

Excell: Using Macros and Visual Basic for Applications

Excell: External Data, Database Functions, and Side-By-Side Tables

Excell: Collaborating With Others and Preparing a Workbook for Distribution

Filters