Question 1

Match each of the following terms to its definition:
i.data series
II.data point
III.data marker
IV.y-axis
v.x-axis

Accepted Answer

A) a symbol in a chart that represents a single data point 
B) related data points 
C) also known as the category axis 
D) also known as the value axis 
E) a value that originates in a cell 
A) a symbol in a chart that represents a single data point 
B) related data points 
C) also known as the category axis 
D) also known as the value axis 
E) a value that originates in a cell

Question 2

Tiny charts embedded in a cell that display a visual trend summary alongside your data are called ________.

Accepted Answer

A) Sparklines 
B) Data labels 
C) Data series 
D) Data markers 
A) Sparklines 
B) Data labels 
C) Data series 
D) Data markers

Question 3

The value axis is also known as the ________.

Accepted Answer

A) x-axis 
B) y-axis 
C) category axis 
D) legend 
A) x-axis 
B) y-axis 
C) category axis 
D) legend

Question 4

A defined set of formatting characteristics such as font,font size,and font color are known as a ________.

Accepted Answer

A) label 
B) theme 
C) cell style 
D) series 
A) label 
B) theme 
C) cell style 
D) series

Question 5

The ________ gallery displays a set of predefined characteristics that change the overall visual look of a chart.

Accepted Answer

The answer of The ________ gallery displays a set of...

Question 6

Using a touchscreen,which of the following actions is the same as right-clicking the mouse?

Accepted Answer

A) Slide right 
B) Slide right and then press 
C) Press and hold for a few seconds 
D) Touch the screen with two fingers 
A) Slide right 
B) Slide right and then press 
C) Press and hold for a few seconds 
D) Touch the screen with two fingers

Question 7

Match each of the following terms to its definition:
i.row
II.column
III.formula
IV.label
v.value

Accepted Answer

A) an equation that performs mathematical calculations 
B) a text value 
C) group of vertical cells on a worksheet 
D) group of horizontal cells on a worksheet 
E) a number,date,or time of day 
A) an equation that performs mathematical calculations 
B) a text value 
C) group of vertical cells on a worksheet 
D) group of horizontal cells on a worksheet 
E) a number,date,or time of day

Question 8

After column Z in an Excel worksheet,the next column is AA.

Accepted Answer

A) True 
 B)False

Question 9

The AutoCalculate feature display three calculations by default: Sum,Subtraction,and Multiplication.

Accepted Answer

A) True 
 B)False

Question 10

The Wrap Text command displays numbers or formulas on multiple lines as well as text.

Accepted Answer

A) True 
 B)False

Question 11

In Excel 2016,row heading are identified by ________.

Accepted Answer

A) uppercase letters 
B) lowercase letters 
C) roman numerals 
D) numbers 
A) uppercase letters 
B) lowercase letters 
C) roman numerals 
D) numbers

Question 12

When using a touchscreen,which of the following actions is the same as clicking an item?

Accepted Answer

A) Slide right 
B) Tap the item 
C) Press and hold for a few seconds 
D) Touch the item with two fingers 
A) Slide right 
B) Tap the item 
C) Press and hold for a few seconds 
D) Touch the item with two fingers

Question 13

The Show Formulas button is a toggle button-it is either on or off.

Accepted Answer

A) True 
 B)False

Question 14

When preparing a document for printing,a ________ indicates that only the columns to the left will be printed on the first page.

Accepted Answer

A) vertical dotted line between columns 
B) vertical bolded,black line between columns 
C) horizontal bolded line between rows 
D) vertical red,bold line between columns 
A) vertical dotted line between columns 
B) vertical bolded,black line between columns 
C) horizontal bolded line between rows 
D) vertical red,bold line between columns

Question 15

The ________ displays the name given to a selected cell,table,chart,or object.

Accepted Answer

The answer of The ________ displays the name given to...

Question 16

Typically,you should include totals when creating a chart.

Accepted Answer

A) True 
 B)False

Question 17

Sparklines cannot be formatted.

Accepted Answer

A) True 
 B)False

Question 18

All formulas begin with a(n)________.

Accepted Answer

A) = sign 
B) % sign 
C) + sign 
D) # sign 
A) = sign 
B) % sign 
C) + sign 
D) # sign

Question 19

The Percent Style can have fewer or more places after the decimal that the default setting.

Accepted Answer

A) True 
 B)False

Question 20

What are the two contextual tabs that display under Chart Tools when a chart is selected?

Accepted Answer

A) Insert and Format 
B) Format and Design 
C) Insert and Design 
D) Home and Design 
A) Insert and Format 
B) Format and Design 
C) Insert and Design 
D) Home and Design

Match each of the following terms to its definition: i.data series II.data point III.data marker IV.y-axis v.x-axis

Tiny charts embedded in a cell that display a visual trend summary alongside your data are called ________.

The value axis is also known as the ________.

A defined set of formatting characteristics such as font,font size,and font color are known as a ________.

The ________ gallery displays a set of predefined characteristics that change the overall visual look of a chart.

Using a touchscreen,which of the following actions is the same as right-clicking the mouse?

Match each of the following terms to its definition: i.row II.column III.formula IV.label v.value

After column Z in an Excel worksheet,the next column is AA.

The AutoCalculate feature display three calculations by default: Sum,Subtraction,and Multiplication.

The Wrap Text command displays numbers or formulas on multiple lines as well as text.

In Excel 2016,row heading are identified by ________.

When using a touchscreen,which of the following actions is the same as clicking an item?

The Show Formulas button is a toggle button-it is either on or off.

When preparing a document for printing,a ________ indicates that only the columns to the left will be printed on the first page.

The ________ displays the name given to a selected cell,table,chart,or object.

Typically,you should include totals when creating a chart.

Sparklines cannot be formatted.

All formulas begin with a(n)________.

The Percent Style can have fewer or more places after the decimal that the default setting.

What are the two contextual tabs that display under Chart Tools when a chart is selected?

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

Match each of the following terms to its definition: i.data series II.data point III.data marker IV.y-axis v.x-axis

Tiny charts embedded in a cell that display a visual trend summary alongside your data are called ________.

The value axis is also known as the ________.

A defined set of formatting characteristics such as font,font size,and font color are known as a ________.

The ________ gallery displays a set of predefined characteristics that change the overall visual look of a chart.

Using a touchscreen,which of the following actions is the same as right-clicking the mouse?

Match each of the following terms to its definition: i.row II.column III.formula IV.label v.value

After column Z in an Excel worksheet,the next column is AA.

The AutoCalculate feature display three calculations by default: Sum,Subtraction,and Multiplication.

The Wrap Text command displays numbers or formulas on multiple lines as well as text.

In Excel 2016,row heading are identified by ________.

When using a touchscreen,which of the following actions is the same as clicking an item?

The Show Formulas button is a toggle button-it is either on or off.

When preparing a document for printing,a ________ indicates that only the columns to the left will be printed on the first page.

The ________ displays the name given to a selected cell,table,chart,or object.

Typically,you should include totals when creating a chart.

Sparklines cannot be formatted.

All formulas begin with a(n)________.

The Percent Style can have fewer or more places after the decimal that the default setting.

What are the two contextual tabs that display under Chart Tools when a chart is selected?

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