Question 1

A(n)________ is a vertical group of cells in an Excel worksheet.

Accepted Answer

column

Question 2

An outlined cell in a worksheet is the active cell.

Accepted Answer

A) True 
 B)False  True

Question 3

A relative cell reference is a reference based on the relative position of a cell that contains the formula and the cells referred to in the formula.

Accepted Answer

A) True 
 B)False  True

Question 4

Which of the following does not display to the right side of a selected chart?

Accepted Answer

A) Chart Styles button 
B) Chart Filters button 
C) Chart Elements button 
D) Move Chart button 
A) Chart Styles button 
B) Chart Filters button 
C) Chart Elements button 
D) Move Chart button

Question 5

The Sum button resides on both the Home tab and the Formulas tab.

Accepted Answer

A) True 
 B)False

Question 6

The Sum function is so frequently used that it has its own button on the Quick Access Toolbar.

Accepted Answer

A) True 
 B)False

Question 7

A data series is a collection of related data points.

Accepted Answer

A) True 
 B)False

Question 8

To indicate a range,include a dash between the two cell references.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following is NOT a way to create a formula?

Accepted Answer

A) By typing 
B) By using the point-and-click technique 
C) By using a Function button located on the ribbon 
D) By using a Function button on the status bar 
A) By typing 
B) By using the point-and-click technique 
C) By using a Function button located on the ribbon 
D) By using a Function button on the status bar

Question 10

Auto Fill works only with alphabetic values.

Accepted Answer

A) True 
 B)False

Question 11

Ctrl + = starts the Sum function in a worksheet.

Accepted Answer

A) True 
 B)False

Question 12

You can create a custom footer in Excel.

Accepted Answer

A) True 
 B)False

Question 13

The category axis is also known as the y-axis.

Accepted Answer

A) True 
 B)False

Question 14

The Quick Analysis tool displays in the lower right corner of a selected range in a worksheet.

Accepted Answer

A) True 
 B)False

Question 15

Text that is typed in a cell that extends into the next cell only displays if the two cells are merged.

Accepted Answer

A) True 
 B)False

Question 16

________ is the keyboard shortcut for the Spelling command.

Accepted Answer

A) F1 
B) F2 
C) F7 
D) F12 
A) F1 
B) F2 
C) F7 
D) F12

Question 17

When you select a range of data,the ________ button displays.

Accepted Answer

The answer of When you select a range of data,the...

Question 18

If two cells are merged into one,the cell contents are automatically left justified in the new,merged cell.

Accepted Answer

A) True 
 B)False

Question 19

AutoFit adjusts the width of a column to fit the cell content of the widest cell in the column.

Accepted Answer

A) True 
 B)False

Question 20

A(n)________ is a graphic representation of data in a worksheet.

Accepted Answer

The answer of A(n)________ is a graphic representation of data...

A(n)________ is a vertical group of cells in an Excel worksheet.

An outlined cell in a worksheet is the active cell.

A relative cell reference is a reference based on the relative position of a cell that contains the formula and the cells referred to in the formula.

Which of the following does not display to the right side of a selected chart?

The Sum button resides on both the Home tab and the Formulas tab.

The Sum function is so frequently used that it has its own button on the Quick Access Toolbar.

A data series is a collection of related data points.

To indicate a range,include a dash between the two cell references.

Which of the following is NOT a way to create a formula?

Auto Fill works only with alphabetic values.

Ctrl + = starts the Sum function in a worksheet.

You can create a custom footer in Excel.

The category axis is also known as the y-axis.

The Quick Analysis tool displays in the lower right corner of a selected range in a worksheet.

Text that is typed in a cell that extends into the next cell only displays if the two cells are merged.

________ is the keyboard shortcut for the Spelling command.

When you select a range of data,the ________ button displays.

If two cells are merged into one,the cell contents are automatically left justified in the new,merged cell.

AutoFit adjusts the width of a column to fit the cell content of the widest cell in the column.

A(n)________ is a graphic representation of data in a worksheet.

Introduction to Microsoft Office 2016 Features

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

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 1: Excell: Creating a Worksheet and Charting Data

A(n)________ is a vertical group of cells in an Excel worksheet.

An outlined cell in a worksheet is the active cell.

A relative cell reference is a reference based on the relative position of a cell that contains the formula and the cells referred to in the formula.

Which of the following does not display to the right side of a selected chart?

The Sum button resides on both the Home tab and the Formulas tab.

The Sum function is so frequently used that it has its own button on the Quick Access Toolbar.

A data series is a collection of related data points.

To indicate a range,include a dash between the two cell references.

Which of the following is NOT a way to create a formula?

Auto Fill works only with alphabetic values.

Ctrl + = starts the Sum function in a worksheet.

You can create a custom footer in Excel.

The category axis is also known as the y-axis.

The Quick Analysis tool displays in the lower right corner of a selected range in a worksheet.

Text that is typed in a cell that extends into the next cell only displays if the two cells are merged.

________ is the keyboard shortcut for the Spelling command.

When you select a range of data,the ________ button displays.

If two cells are merged into one,the cell contents are automatically left justified in the new,merged cell.

AutoFit adjusts the width of a column to fit the cell content of the widest cell in the column.

A(n)________ is a graphic representation of data in a worksheet.

Introduction to Microsoft Office 2016 Features

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

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