Question 1

When you reposition a worksheet, a placement ____________________ indicates the new location.

Accepted Answer

The answer of When you reposition a worksheet, a placement...

Question 2

The Signature Line button is found in the Text group on the ____________________ tab.

Accepted Answer

The answer of The Signature Line button is found in...

Question 3

When you create a PivotTable, you need to use all of the data in the worksheet.

Accepted Answer

A) True 
 B)False

Question 4

Match between columns
                        Premises: Displays a subset of the data that meets certain criteria and temporarily hides the rows that do not meet the specified criteria.

Accepted Answer

The Answer of Sort and Conditional formatting and Comment and is...

Question 5

Click the Ctrl+C keys to ____ selected cells.

Accepted Answer

A)  copy 
B)  cut 
C)  paste 
D)  move 
A)  copy 
B)  cut 
C)  paste 
D)  move

Question 6

The Print option called Print ____ prints the range or ranges selected within a single worksheet.

Accepted Answer

A)  Active Sheets 
B)  Selection 
C)  Entire Workbook 
D)  Range 
A)  Active Sheets 
B)  Selection 
C)  Entire Workbook 
D)  Range

Question 7

Case EX 7-1 Kristin wants to arrange multiple workbooks in a way where she can compare figures. Kristin wants to move the February worksheet from the February Statement workbook to the Annual Statement workbook. She intends to place the February worksheet after the January worksheet in the Annual Statement workbook. What should she do?

Accepted Answer

A)  In the Annual Statement workbook, right-click the January sheet tab, and then click Move or Copy on the shortcut menu. 
B)  In the Annual Statement workbook, double-click the January sheet tab, and then click Arrange on the shortcut menu. 
C)  In the February Statement workbook, double-click the February sheet tab, and then click Arrange on the shortcut menu. 
D)  In the February Statement workbook, right-click the February sheet tab, and then click Move or Copy on the shortcut menu. 
A)  In the Annual Statement workbook, right-click the January sheet tab, and then click Move or Copy on the shortcut menu. 
B)  In the Annual Statement workbook, double-click the January sheet tab, and then click Arrange on the shortcut menu. 
C)  In the February Statement workbook, double-click the February sheet tab, and then click Arrange on the shortcut menu. 
D)  In the February Statement workbook, right-click the February sheet tab, and then click Move or Copy on the shortcut menu.

Question 8

The rounding operation requires two arguments, which are separated by a comma.

Accepted Answer

A) True 
 B)False

Question 9

Excel ____ all numbers.

Accepted Answer

A)  right-aligns 
B)  left-aligns 
C)  top-aligns 
D)  bottom-aligns 
A)  right-aligns 
B)  left-aligns 
C)  top-aligns 
D)  bottom-aligns

Question 10

Worksheets printed in landscape orientation are longer than they are wide.

Accepted Answer

A) True 
 B)False

Question 11

If you want to use a name range with two words, you will need to use a(n) ____ to separate the words.

Accepted Answer

A)  comma (,) 
B)  space 
C)  underscore (_) 
D)  period (.) 
A)  comma (,) 
B)  space 
C)  underscore (_) 
D)  period (.)

Question 12

Named ranges are helpful if you need to use a range in several functions.

Accepted Answer

A) True 
 B)False

Question 13

The Top/Bottom Rules format cells based on their rank, such as the top 10 items, the bottom 15%, or those that are above average.

Accepted Answer

A) True 
 B)False

Question 14

To use the HLOOKUP function, you will need the row number from the table that has the data you want returned to the cell with the HLOOKUP function.

Accepted Answer

A) True 
 B)False

Question 15

After you type data in a cell, the active cell changes, depending on how you enter the data. Please describe what happens if you click the Enter button on the Formula bar, if you press the Enter key, and if you press the Tab key. Also, give an example of when you would use each method of entering data.

Accepted Answer

- If you click the Enter button on the F

Question 16

Numbers that do not fit in the cell are shown as a series of question marks (??????).

Accepted Answer

A) True 
 B)False

Question 17

Case EX 4-1 Kayden wants to preview calculations in the status bar so she can quickly glance at them and know some of the basics about a particular range of numbers. What should Kayden do to show the default calculations for a range of cells?

Accepted Answer

A)  Select the range and the calculations will appear in the status bar 
B)  Select the range and click the Calculate button 
C)  Select the range and click the Number button 
D)  Select the range and click the Sum button 
A)  Select the range and the calculations will appear in the status bar 
B)  Select the range and click the Calculate button 
C)  Select the range and click the Number button 
D)  Select the range and click the Sum button

Question 18

Match between columns
                        Premises: Easy-to-read sentences that represent the actions of a macro.

Accepted Answer

The Answer of virus and code and shortcut key and is...

Question 19

To create a sparkline, in the Sparklines group on the ___________________ tab, click the button corresponding to the type of sparkline you want to create.

Accepted Answer

The answer of To create a sparkline, in the Sparklines...

Question 20

Match between columns
                        Premises: Functions used to analyze loans and investments.

Accepted Answer

The Answer of Mathematical functions and Text functions and Financial is...

When you reposition a worksheet, a placement ____________________ indicates the new location.

The Signature Line button is found in the Text group on the ____________________ tab.

When you create a PivotTable, you need to use all of the data in the worksheet.

Click the Ctrl+C keys to ____ selected cells.

The Print option called Print ____ prints the range or ranges selected within a single worksheet.

The rounding operation requires two arguments, which are separated by a comma.

Excel ____ all numbers.

Worksheets printed in landscape orientation are longer than they are wide.

If you want to use a name range with two words, you will need to use a(n) ____ to separate the words.

Named ranges are helpful if you need to use a range in several functions.

The Top/Bottom Rules format cells based on their rank, such as the top 10 items, the bottom 15%, or those that are above average.

To use the HLOOKUP function, you will need the row number from the table that has the data you want returned to the cell with the HLOOKUP function.

Numbers that do not fit in the cell are shown as a series of question marks (??????).

Case EX 4-1 Kayden wants to preview calculations in the status bar so she can quickly glance at them and know some of the basics about a particular range of numbers. What should Kayden do to show the default calculations for a range of cells?

To create a sparkline, in the Sparklines group on the ___________________ tab, click the button corresponding to the type of sparkline you want to create.

Microsoft Access Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters

Exam 2: Microsoft Excel Basics

When you reposition a worksheet, a placement ____________________ indicates the new location.

The Signature Line button is found in the Text group on the ____________________ tab.

When you create a PivotTable, you need to use all of the data in the worksheet.

Click the Ctrl+C keys to ____ selected cells.

The Print option called Print ____ prints the range or ranges selected within a single worksheet.

The rounding operation requires two arguments, which are separated by a comma.

Excel ____ all numbers.

Worksheets printed in landscape orientation are longer than they are wide.

If you want to use a name range with two words, you will need to use a(n) ____ to separate the words.

Named ranges are helpful if you need to use a range in several functions.

The Top/Bottom Rules format cells based on their rank, such as the top 10 items, the bottom 15%, or those that are above average.

To use the HLOOKUP function, you will need the row number from the table that has the data you want returned to the cell with the HLOOKUP function.

Numbers that do not fit in the cell are shown as a series of question marks (??????).

Case EX 4-1 Kayden wants to preview calculations in the status bar so she can quickly glance at them and know some of the basics about a particular range of numbers. What should Kayden do to show the default calculations for a range of cells?

To create a sparkline, in the Sparklines group on the ___________________ tab, click the button corresponding to the type of sparkline you want to create.

Microsoft Access Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters