Question 1

The action of copying or moving cells contents to another location is called ________.

Accepted Answer

The answer of The action of copying or moving cells...

Question 2

The ________ command divides a window into multiple panes.

Accepted Answer

The answer of The ________ command divides a window into...

Question 3

Where does Excel's NOW function retrieve the date from?

Accepted Answer

A) The Internet 
B) The Excel program 
C) The computer's clock 
D) The Office 2016 suite 
A) The Internet 
B) The Excel program 
C) The computer's clock 
D) The Office 2016 suite

Question 4

A(n)________ is a predefined formula such as SUM or MEDIAN.

Accepted Answer

The answer of A(n)________ is a predefined formula such as...

Question 5

You can sort a table in ascending or descending order.

Accepted Answer

A) True 
 B)False

Question 6

Arguments are surrounded by brackets in a function.

Accepted Answer

A) True 
 B)False

Question 7

The NOW function formats the result as a date and time.

Accepted Answer

A) True 
 B)False

Question 8

A filter icon displays next to column headings when a sort is invoked in a table.

Accepted Answer

A) True 
 B)False

Question 9

A large + sign icon displays next to column headings when a filter is invoked in a table.

Accepted Answer

A) True 
 B)False

Question 10

A(n)________ illustrates the value of a cell relative to other cells in the worksheet.

Accepted Answer

The answer of A(n)________ illustrates the value of a cell...

Question 11

Match each of the following functions to its descriptions:
i.SUM
II.MEDIAN
III.AVERAGE
IV.COUNTIF
v.COUNT

Accepted Answer

A) counts the number of cells in a range that meet the given condition 
B) counts the number of cells in a range that contain numbers 
C) adds a range of cells and divides by the number of values in the range 
D) adds a range of cells 
E) locates the middle value in a range of cells 
A) counts the number of cells in a range that meet the given condition 
B) counts the number of cells in a range that contain numbers 
C) adds a range of cells and divides by the number of values in the range 
D) adds a range of cells 
E) locates the middle value in a range of cells

Question 12

The ________ is the temporary storage location for cell contents copied from a worksheet.

Accepted Answer

A) Clipboard 
B) Office Pane 
C) Paste area 
D) Excel table 
A) Clipboard 
B) Office Pane 
C) Paste area 
D) Excel table

Question 13

The paste area is the target destination for data that has been cut or copied using the Clipboard.

Accepted Answer

A) True 
 B)False

Question 14

By ________ several sheets,you can view all sheets in Print Preview.

Accepted Answer

The answer of By ________ several sheets,you can view all...

Question 15

Match the following shortcut keys with the correct action:
i.Ctrl + X
II.Ctrl + V
III.Alt + =
IV.F4
v.Ctrl + F2

Accepted Answer

A) SUM function 
B) repeat 
C) cut 
D) paste 
E) print preview 
A) SUM function 
B) repeat 
C) cut 
D) paste 
E) print preview

Question 16

SUM,AVERAGE,and MIN are formats.

Accepted Answer

A) True 
 B)False

Question 17

What does a data bar in a cell represent?

Accepted Answer

A) The value of a cell relative to other cells 
B) The values in a range of cells 
C) The values of the two cells to the left of the cell with the data bar 
D) The sum of the values above the data bar cell 
A) The value of a cell relative to other cells 
B) The values in a range of cells 
C) The values of the two cells to the left of the cell with the data bar 
D) The sum of the values above the data bar cell

Question 18

Each worksheet in a workbook can have different formatting.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following is FALSE about worksheet tabs?

Accepted Answer

A) You can change the color of worksheet tabs. 
B) You can rename a tab by double-clicking on it. 
C) The active worksheet tab displays in red font. 
D) A worksheet tab can be copied. 
A) You can change the color of worksheet tabs. 
B) You can rename a tab by double-clicking on it. 
C) The active worksheet tab displays in red font. 
D) A worksheet tab can be copied.

Question 20

The Freeze Panes command enables you to select one or more rows or columns and then (lock)them into place.

Accepted Answer

A) True 
 B)False

The action of copying or moving cells contents to another location is called ________.

The ________ command divides a window into multiple panes.

Where does Excel's NOW function retrieve the date from?

A(n)________ is a predefined formula such as SUM or MEDIAN.

You can sort a table in ascending or descending order.

Arguments are surrounded by brackets in a function.

The NOW function formats the result as a date and time.

A filter icon displays next to column headings when a sort is invoked in a table.

A large + sign icon displays next to column headings when a filter is invoked in a table.

A(n)________ illustrates the value of a cell relative to other cells in the worksheet.

Match each of the following functions to its descriptions: i.SUM II.MEDIAN III.AVERAGE IV.COUNTIF v.COUNT

The ________ is the temporary storage location for cell contents copied from a worksheet.

The paste area is the target destination for data that has been cut or copied using the Clipboard.

By ________ several sheets,you can view all sheets in Print Preview.

Match the following shortcut keys with the correct action: i.Ctrl + X II.Ctrl + V III.Alt + = IV.F4 v.Ctrl + F2

SUM,AVERAGE,and MIN are formats.

What does a data bar in a cell represent?

Each worksheet in a workbook can have different formatting.

Which of the following is FALSE about worksheet tabs?

The Freeze Panes command enables you to select one or more rows or columns and then (lock)them into place.

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

The action of copying or moving cells contents to another location is called ________.

The ________ command divides a window into multiple panes.

Where does Excel's NOW function retrieve the date from?

A(n)________ is a predefined formula such as SUM or MEDIAN.

You can sort a table in ascending or descending order.

Arguments are surrounded by brackets in a function.

The NOW function formats the result as a date and time.

A filter icon displays next to column headings when a sort is invoked in a table.

A large + sign icon displays next to column headings when a filter is invoked in a table.

A(n)________ illustrates the value of a cell relative to other cells in the worksheet.

Match each of the following functions to its descriptions: i.SUM II.MEDIAN III.AVERAGE IV.COUNTIF v.COUNT

The ________ is the temporary storage location for cell contents copied from a worksheet.

The paste area is the target destination for data that has been cut or copied using the Clipboard.

By ________ several sheets,you can view all sheets in Print Preview.

Match the following shortcut keys with the correct action: i.Ctrl + X II.Ctrl + V III.Alt + = IV.F4 v.Ctrl + F2

SUM,AVERAGE,and MIN are formats.

What does a data bar in a cell represent?

Each worksheet in a workbook can have different formatting.

Which of the following is FALSE about worksheet tabs?

The Freeze Panes command enables you to select one or more rows or columns and then (lock)them into place.

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