Question 1

Hold down the ________ key to select nonadjacent cells.

Accepted Answer

A) Spacebar 
B) Ctrl 
C) Alt 
D) F2 
A) Spacebar 
B) Ctrl 
C) Alt 
D) F2

Question 2

The range finder feature in Excel is useful for verifying formulas.

Accepted Answer

A) True 
 B)False

Question 3

Match each of the following actions with the tab on which it is activated:
i.display formulas on the screen
II.exporting a document as a PDF file
III.create a recommended chart
IV.AutoFit column widths
v.change a worksheet to landscape orientation

Accepted Answer

A) Formulas tab 
B) Page Layout tab 
C) Insert tab 
D) File tab 
E) Home tab 
A) Formulas tab 
B) Page Layout tab 
C) Insert tab 
D) File tab 
E) Home tab

Question 4

The ________ command moves charted data from the vertical axis to the horizontal axis or vice versa.

Accepted Answer

The answer of The ________ command moves charted data from...

Question 5

Scaling often works well for printing formulas since it shrinks the width and/or height of a printed worksheet.

Accepted Answer

A) True 
 B)False

Question 6

Where is the fill handle located?

Accepted Answer

A) In the top right of an active cell 
B) In the lower right corner of a selected cell 
C) On the Quick Access Toolbar 
D) On the Home tab 
A) In the top right of an active cell 
B) In the lower right corner of a selected cell 
C) On the Quick Access Toolbar 
D) On the Home tab

Question 7

The Formula Bar in Excel 2016 displays the value or formula in the active cell.

Accepted Answer

A) True 
 B)False

Question 8

A(n)________ is a point of light measured in dots per square inch.

Accepted Answer

pixel or p

Question 9

A(n)________ refers to a cell with a fixed position in the worksheet.

Accepted Answer

absolute c

Question 10

The ________ command joins two or more selected cells together into one cell.

Accepted Answer

The answer of The ________ command joins two or more...

Question 11

A(n)________ is a predefined set of colors,fonts,line,and fill effects that coordinate for an attractive look.

Accepted Answer

The answer of A(n)________ is a predefined set of colors,fonts,line,and...

Question 12

Which of the following is NOT one of the default calculations displayed by AutoCalculate?

Accepted Answer

A) Sum 
B) Average 
C) Maximum 
D) Count 
A) Sum 
B) Average 
C) Maximum 
D) Count

Question 13

Match each of the keyboard shortcuts to its action:
i.Shift + Tab
II.Shift + Enter
III.PageDown
IV.Ctrl + End
v.Tab

Accepted Answer

A) moves left one cell 
B) moves right one cell 
C) moves down one full screen 
D) moves one cell up 
E) moves to the last cell in the last column of the active area of a worksheet 
A) moves left one cell 
B) moves right one cell 
C) moves down one full screen 
D) moves one cell up 
E) moves to the last cell in the last column of the active area of a worksheet

Question 14

A cell style often includes font,font size,font color,and cell borders.

Accepted Answer

A) True 
 B)False

Question 15

When two or more cells are merged,the individual cells cannot be selected.

Accepted Answer

A) True 
 B)False

Question 16

A text value in Excel is also referred to as a ________.

Accepted Answer

A) label 
B) formula 
C) constant 
D) cell address 
A) label 
B) formula 
C) constant 
D) cell address

Question 17

Match each of the following terms to its definition:
i.operator
II.pixel
III.number values
IV.underlying value
v.data

Accepted Answer

A) symbol used to specify the type of calculation that you want in a formula 
B) text or numbers in a cell 
C) a dot of light on a screen 
D) constant values consisting only of numbers 
E) data that displays in the Formula bar 
A) symbol used to specify the type of calculation that you want in a formula 
B) text or numbers in a cell 
C) a dot of light on a screen 
D) constant values consisting only of numbers 
E) data that displays in the Formula bar

Hold down the ________ key to select nonadjacent cells.

The range finder feature in Excel is useful for verifying formulas.

Match each of the following actions with the tab on which it is activated: i.display formulas on the screen II.exporting a document as a PDF file III.create a recommended chart IV.AutoFit column widths v.change a worksheet to landscape orientation

The ________ command moves charted data from the vertical axis to the horizontal axis or vice versa.

Scaling often works well for printing formulas since it shrinks the width and/or height of a printed worksheet.

Where is the fill handle located?

The Formula Bar in Excel 2016 displays the value or formula in the active cell.

A(n)________ is a point of light measured in dots per square inch.

A(n)________ refers to a cell with a fixed position in the worksheet.

The ________ command joins two or more selected cells together into one cell.

A(n)________ is a predefined set of colors,fonts,line,and fill effects that coordinate for an attractive look.

Which of the following is NOT one of the default calculations displayed by AutoCalculate?

Match each of the keyboard shortcuts to its action: i.Shift + Tab II.Shift + Enter III.PageDown IV.Ctrl + End v.Tab

A cell style often includes font,font size,font color,and cell borders.

When two or more cells are merged,the individual cells cannot be selected.

A text value in Excel is also referred to as a ________.

Match each of the following terms to its definition: i.operator II.pixel III.number values IV.underlying value v.data

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

Hold down the ________ key to select nonadjacent cells.

The range finder feature in Excel is useful for verifying formulas.

Match each of the following actions with the tab on which it is activated: i.display formulas on the screen II.exporting a document as a PDF file III.create a recommended chart IV.AutoFit column widths v.change a worksheet to landscape orientation

The ________ command moves charted data from the vertical axis to the horizontal axis or vice versa.

Scaling often works well for printing formulas since it shrinks the width and/or height of a printed worksheet.

Where is the fill handle located?

The Formula Bar in Excel 2016 displays the value or formula in the active cell.

A(n)________ is a point of light measured in dots per square inch.

A(n)________ refers to a cell with a fixed position in the worksheet.

The ________ command joins two or more selected cells together into one cell.

A(n)________ is a predefined set of colors,fonts,line,and fill effects that coordinate for an attractive look.

Which of the following is NOT one of the default calculations displayed by AutoCalculate?

Match each of the keyboard shortcuts to its action: i.Shift + Tab II.Shift + Enter III.PageDown IV.Ctrl + End v.Tab

A cell style often includes font,font size,font color,and cell borders.

When two or more cells are merged,the individual cells cannot be selected.

A text value in Excel is also referred to as a ________.

Match each of the following terms to its definition: i.operator II.pixel III.number values IV.underlying value v.data

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