Parcial 2

Question 1

In Excel, when a cell is formatted to ______ text, any data in the cell automatically breaks to the fit the column width.

Answer 1

Wrap

Question 2

A cell may include contents, comments, hyperlinks and ____.

Answer 2

Formats

Question 3

In Excel, when merging cells, only data in the ______ will remain.

Answer 3

Upper-left cell

Question 4

In Excel, the __________ tab contains formatting commands.

Answer 4

Home

Question 5

In Excel, to copy the selected cells, hold down _________ and drag it with your mouse.

Answer 5

[Control]

Question 6

Which of the following steps will display formulas in Excel, rather than formula results, on the screen?

a) On the View tab, in the Formula Auditing group, click Insert Function.
b) On the Formulas tab, in the Formula Auditing group, click Insert Formulas
c) On the Formulas tab, in the Formula Auditing group, click Show Formulas
d) On the View tab, in the Formula Auditing group, click Show Formulas

Answer 6

C

Question 7

In Excel, which format should be chosen to display a cell value as $15,000.00?

Answer 7

Currency

Question 8

Select two options of the Excel’s Clear button:

A) Clear charts
B) Clear trendlines
C) Clear comments
D) Clear formats

Answer 8

C and D

Question 9

Select two of the Excel Paste Special options:
A) Perform mathematical operations
B) Transpose columns to rows and rows and columns
C) Paste the copied or cut cells as an image
D) Apply a style to the pasted cells

Answer 9

A and B

Question 10

In Excel, to erase the contents of cell M25, select the cell and then press ______.

Answer 10

[Delete]

Question 11

In Excel, for what does the “H” in HLOOKUP stand?

Answer 11

Horizontal

Question 12

In Excel, how can you rename a worksheet?
A) Double-click the worksheet tab, key the name, and press Enter.
B) Key the new name in the Name Box, and press Enter
C) Click Format, key the new name, and press Enter
D) Right-click the Name Box, select New Name, key the new name, and press Enter

Answer 12

A

Question 13

When you remove duplicates in an Excel worksheet, any duplicate value is ________ the worksheet.

Answer 13

Permanently deleted from

Question 14

In Excel, use ________ when you need to find things in a table or range by row.

Answer 14

HLOOKUP

Question 15

In Excel, you can _______ worksheets to enter and edit data in several worksheets at the same time.

Answer 15

Group

Question 16

Color scales, icon sets, and data bars make up Excel’s _______.

Answer 16

…. preset conditional format options.

Question 17

In Excel, the _______ is used to test a value bases on a condition, and determines whether is true or false.

Answer 17

IF function

Question 18

In Excel, the _______ tool remove duplicate values in a worksheet.

Answer 18

Remove Duplicates

Question 19

In Excel, which function would probably be most helpful if you needed to apply a specific tax rate to employees’ gross incomes based on the sizes of their salaries?

Answer 19

VLOOKUP

Question 20

In Excel, a duplicate value occurs when the data in at least two different _________ are identical.

Answer 20

Rows

Question 21

In Excel, to _______ a filter from a set of data (and see all the data in the worksheet again), you click on the Filter button again.

Answer 21

Remove

Question 22

In Excel, filtering data enables you to ________.

Answer 22

Hide rows you do not want to see.

Question 23

In Excel, what is the result of the following function? =IF(15<> (20+10)*3, “Different”, “Equal”)

Answer 23

Different

Question 24

In Excel, you can ________ a worksheet tab and select Insert on the shortcut menu to insert a worksheet.

Answer 24

Right click

Question 25

In Excel, for what does the “V” in VLOOKUP stand?

Answer 25

Vertical