Question 1

Match each of the following terms to its definition:
i.volatile
II.freeze
III.sort
IV.split
v.filter

Accepted Answer

A) separates a window into panes 
B) updates automatically 
C) arranges data in a specific order 
D) keeps rows or columns fixed 
E) displays only a portion of data that matches a criteria 
A) separates a window into panes 
B) updates automatically 
C) arranges data in a specific order 
D) keeps rows or columns fixed 
E) displays only a portion of data that matches a criteria

Question 2

The ________ function determines the largest value in a range of cells.

Accepted Answer

The answer of The ________ function determines the largest value...

Question 3

In the Excel window,where does [Group] display when worksheets are grouped?

Accepted Answer

A) On the status bar 
B) On the ribbon 
C) On the title bar 
D) On the sheet tab 
A) On the status bar 
B) On the ribbon 
C) On the title bar 
D) On the sheet tab

Question 4

Sheet tab names are ________ when they are grouped.

Accepted Answer

A) underlined 
B) bolded 
C) italicized 
D) in red 
A) underlined 
B) bolded 
C) italicized 
D) in red

Question 5

The keyboard shortcut to enter the current date is Ctrl + #.

Accepted Answer

A) True 
 B)False

Question 6

Sparklines are large charts stored on a separate worksheet that display a data trend of the adjacent worksheet.

Accepted Answer

A) True 
 B)False

Question 7

You can leave the year off entirely when typing a date into a cell.

Accepted Answer

A) True 
 B)False

Question 8

Match each of the following terms to its definition:
i.logical test
II.IF function
III.comparison operator
IV.conditional format
v.data bar

Accepted Answer

A) checks whether a condition is met and returns a true or false value 
B) compares values in an Excel function or formula 
C) formatting applied to a cell based on a criteria 
D) a shaded bar that provides a visual cue about the value of a cell relative to other cells 
E) any value or expression with a true or false result 
A) checks whether a condition is met and returns a true or false value 
B) compares values in an Excel function or formula 
C) formatting applied to a cell based on a criteria 
D) a shaded bar that provides a visual cue about the value of a cell relative to other cells 
E) any value or expression with a true or false result

Question 9

Match each of the following terms to its definition:
i.NOW function
II.Freeze Panes command
III.Split command
IV.Scale to Fit command
v.Find and Replace command

Accepted Answer

A) divides a window into multiple resizable panes 
B) a command that enables you to select one or more rows or columns and lock them into place 
C) stretch or shrink the width,height,or both of printed output 
D) inserts the date stored on the computer calendar and clock 
E) searches the cells of a worksheet 
A) divides a window into multiple resizable panes 
B) a command that enables you to select one or more rows or columns and lock them into place 
C) stretch or shrink the width,height,or both of printed output 
D) inserts the date stored on the computer calendar and clock 
E) searches the cells of a worksheet

Question 10

To rotate text in a worksheet,in the Format Cells dialog box,you can click and drag the ________.

Accepted Answer

A) red circle 
B) blue diamond 
C) red diamond 
D) black,bold triangle 
A) red circle 
B) blue diamond 
C) red diamond 
D) black,bold triangle

Question 11

A(n)________ is a worksheet where totals from other sheets are displayed.

Accepted Answer

The answer of A(n)________ is a worksheet where totals from...

Question 12

The SUM function adds all numbers in a selected range of cells.

Accepted Answer

A) True 
 B)False

Question 13

The Find and Replace feature searches the cells in a worksheet-or in a selected range-for matches,and then replaces each match with a replacement value of your choice.

Accepted Answer

A) True 
 B)False

Question 14

In a large worksheet,which two Excel commands help to make the worksheets attractive and easier to read?

Accepted Answer

A) Print Titles and Scale to Fit 
B) Print Titles and Summary sheet 
C) Detail sheet and Summary sheet 
D) Print titles and Conditional format 
A) Print Titles and Scale to Fit 
B) Print Titles and Summary sheet 
C) Detail sheet and Summary sheet 
D) Print titles and Conditional format

Question 15

Ctrl + P is the keyboard shortcut for Paste.

Accepted Answer

A) True 
 B)False

Question 16

The ________ command enables you to specify rows and columns that will be duplicated on each printed page.

Accepted Answer

The answer of The ________ command enables you to specify...

Question 17

Data can be edited on more than one worksheet at a time.

Accepted Answer

A) True 
 B)False

Question 18

Match each of the tab names to an action found on that tab:
i.Home tab
II.Formulas tab
III.View tab
IV.Insert tab
v.File tab

Accepted Answer

A) Freeze panes 
B) Flash Fill command 
C) More Functions 
D) Document Properties 
E) Create a table 
A) Freeze panes 
B) Flash Fill command 
C) More Functions 
D) Document Properties 
E) Create a table

Question 19

On your keyboard,which two symbols function identically in date formats?

Accepted Answer

A) The forward slash key and the period 
B) The dollar sign and the ampersand 
C) The comma and the forward slash key 
D) The hyphen key and the forward slash key 
A) The forward slash key and the period 
B) The dollar sign and the ampersand 
C) The comma and the forward slash key 
D) The hyphen key and the forward slash key

Question 20

If the result of a logical test is false,Excel will always display YES in the cell.

Accepted Answer

A) True 
 B)False

Match each of the following terms to its definition: i.volatile II.freeze III.sort IV.split v.filter

The ________ function determines the largest value in a range of cells.

In the Excel window,where does [Group] display when worksheets are grouped?

Sheet tab names are ________ when they are grouped.

The keyboard shortcut to enter the current date is Ctrl + #.

Sparklines are large charts stored on a separate worksheet that display a data trend of the adjacent worksheet.

You can leave the year off entirely when typing a date into a cell.

Match each of the following terms to its definition: i.logical test II.IF function III.comparison operator IV.conditional format v.data bar

Match each of the following terms to its definition: i.NOW function II.Freeze Panes command III.Split command IV.Scale to Fit command v.Find and Replace command

To rotate text in a worksheet,in the Format Cells dialog box,you can click and drag the ________.

A(n)________ is a worksheet where totals from other sheets are displayed.

The SUM function adds all numbers in a selected range of cells.

The Find and Replace feature searches the cells in a worksheet-or in a selected range-for matches,and then replaces each match with a replacement value of your choice.

In a large worksheet,which two Excel commands help to make the worksheets attractive and easier to read?

Ctrl + P is the keyboard shortcut for Paste.

The ________ command enables you to specify rows and columns that will be duplicated on each printed page.

Data can be edited on more than one worksheet at a time.

Match each of the tab names to an action found on that tab: i.Home tab II.Formulas tab III.View tab IV.Insert tab v.File tab

On your keyboard,which two symbols function identically in date formats?

If the result of a logical test is false,Excel will always display YES in the cell.

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

Match each of the following terms to its definition: i.volatile II.freeze III.sort IV.split v.filter

The ________ function determines the largest value in a range of cells.

In the Excel window,where does [Group] display when worksheets are grouped?

Sheet tab names are ________ when they are grouped.

The keyboard shortcut to enter the current date is Ctrl + #.

Sparklines are large charts stored on a separate worksheet that display a data trend of the adjacent worksheet.

You can leave the year off entirely when typing a date into a cell.

Match each of the following terms to its definition: i.logical test II.IF function III.comparison operator IV.conditional format v.data bar

Match each of the following terms to its definition: i.NOW function II.Freeze Panes command III.Split command IV.Scale to Fit command v.Find and Replace command

To rotate text in a worksheet,in the Format Cells dialog box,you can click and drag the ________.

A(n)________ is a worksheet where totals from other sheets are displayed.

The SUM function adds all numbers in a selected range of cells.

The Find and Replace feature searches the cells in a worksheet-or in a selected range-for matches,and then replaces each match with a replacement value of your choice.

In a large worksheet,which two Excel commands help to make the worksheets attractive and easier to read?

Ctrl + P is the keyboard shortcut for Paste.

The ________ command enables you to specify rows and columns that will be duplicated on each printed page.

Data can be edited on more than one worksheet at a time.

Match each of the tab names to an action found on that tab: i.Home tab II.Formulas tab III.View tab IV.Insert tab v.File tab

On your keyboard,which two symbols function identically in date formats?

If the result of a logical test is false,Excel will always display YES in the cell.

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