Question 1

Numbers that extend beyond a cell's width appear as ____ in the cell.

Accepted Answer

A)  (&&&&) 
B)  (????) 
C)  (####) 
D) ( ++++)

Question 2

You can delete a selected chart by pressing the F2 key.

Accepted Answer

A) True 
 B)False

Question 3

Match between columns
                        Premises: A number or text that appears next to a data marker in a chart and allows you to display the value of the data marker.

Accepted Answer

The Answer of Sparkline and Data label and Secondary axis is...

Question 4

On the Format tab in the Labels group, click Chart Title, and then click Above Chart to add a chart title above the chart.

Accepted Answer

A) True 
 B)False

Question 5

Case EX 16-1 George is the manager of a party planning company. He uses an Excel workbook to keep track of the parties that the company is planning or has planned in the past. George is concerned about a competitor gaining access to the information in the workbook. If George wants to make sure that only people who have the proper password can open the workbook, he needs to use the ____ dialog box.

Accepted Answer

A)  Protect Sheet 
B)  Password Protect 
C)  Encrypt Document 
D)  Encrypt Sheet

Question 6

To access SkyDrive, you must have a ____ account.

Accepted Answer

A)  Google 
B)  Windows Live 
C)  LiveJournal 
D)  Facebook

Question 7

To select a button with an assigned macro, you left-click the button.

Accepted Answer

A) True 
 B)False

Question 8

You can enter a formula with the AVERAGE, COUNT, MAX, or MIN function in a selected cell by clicking the Sum button arrow in the ____ group on the Home tab, clicking the function name, selecting the appropriate range, and then pressing the Enter key.

Accepted Answer

A)  Editing 
B)  Formulas 
C)  Cells 
D)  Worksheet

Question 9

The Protect Workbook button is located in the Info section of the ____ window.

Accepted Answer

A)  Home 
B)  File 
C)  Review 
D)  Data

Question 10

When you press F11, Excel generates a chart with ____ data series.

Accepted Answer

A)  primary 
B)  secondary 
C)  linear 
D)  column

Question 11

The Print option called Print ____ prints the worksheet that appears on-screen, or a group of selected worksheets.

Accepted Answer

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

Question 12

What is the difference between a data marker and a data label? Please describe a situation where you would use both at the same time.

Accepted Answer

The answer of What is the difference between a data...

Question 13

If you click a cell that has a SUM function and then click the ____ button, the cells that are used in this function are surrounded by a border.

Accepted Answer

A)  Goal Seek 
B)  Trace Precedents 
C)  Trace Dependents 
D)  What-If

Question 14

____ inform users that the file format is final and cannot be changed.

Accepted Answer

A)  File properties 
B)  Check lines 
C)  Edit seals 
D)  Signature lines

Question 15

Match between columns
                        Premises: The selected cell contents are placed as an item on the Clipboard and are removed from their original location.

Accepted Answer

The Answer of Margins and Copy and Cut and Scale is...

Question 16

Match between columns
                        Premises: The information in the file is scrambled.

Accepted Answer

The Answer of Share Workbook and Track Changes and encrypting is...

Question 17

Case EX 15-2 Shishir has just started working in a Web design firm. He is responsible for managing the contact information and details of all the clients. The person who worked before Shishir had a number of workbooks for the client data. If Shishir wants to bring together the data from the different workbooks into one worksheet, he can ____ the data.

Accepted Answer

A)  track 
B)  consolidate 
C)  trace 
D)  implode

Question 18

To replace cell contents, you can select the cell, type the new data, and then enter the data by ____.

Accepted Answer

A)  pressing the Enter key 
B)  pressing the Tab key 
C)  clicking the Enter button on the Formula bar 
D)  all of the above

Question 19

If you want to save a workbook that has a macro, you will need to save it with the ____ file extension in the Save dialog box.

Accepted Answer

A)  .xlsm 
B)  .xlts 
C)  .xlsx 
D)  .xlmn

Question 20

When the shape is selected, the ____ appear on the Ribbon and contain the Format contextual tab.

Accepted Answer

A)  Drawing Tools 
B)  Shape Tools 
C)  Graphic Tools 
D)  Editing Tools

Exam 2: Microsoft Excel Basics

Numbers that extend beyond a cell's width appear as ____ in the cell.

You can delete a selected chart by pressing the F2 key.

Identify the letter of the choice that best matches the phrase or definition.

On the Format tab in the Labels group, click Chart Title, and then click Above Chart to add a chart title above the chart.

To access SkyDrive, you must have a ____ account.

To select a button with an assigned macro, you left-click the button.

You can enter a formula with the AVERAGE, COUNT, MAX, or MIN function in a selected cell by clicking the Sum button arrow in the ____ group on the Home tab, clicking the function name, selecting the appropriate range, and then pressing the Enter key.

The Protect Workbook button is located in the Info section of the ____ window.

When you press F11, Excel generates a chart with ____ data series.

The Print option called Print ____ prints the worksheet that appears on-screen, or a group of selected worksheets.

What is the difference between a data marker and a data label? Please describe a situation where you would use both at the same time.

If you click a cell that has a SUM function and then click the ____ button, the cells that are used in this function are surrounded by a border.

____ inform users that the file format is final and cannot be changed.

Identify the letter of the choice that best matches the phrase or definition.

Identify the letter of the choice that best matches the phrase or definition.

To replace cell contents, you can select the cell, type the new data, and then enter the data by ____.

If you want to save a workbook that has a macro, you will need to save it with the ____ file extension in the Save dialog box.

When the shape is selected, the ____ appear on the Ribbon and contain the Format contextual tab.