Exam

Name___________________________________

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question.
1)	Which of the following is contained in text files?	1) ______

	A)  Video
	B)  Characters
	C)  Sound
	D)  Formatting

2)

A table in Excel is most similar to a:

2) ______

	A)  worksheet.
	B)  Word table.
	C)  query.
	D)  database.

3)

The ________ function will convert Executive Asst. 1 to EXECUTIVE ASST. 1.

3) ______

	A)  CONCANTENATE
	B)  PROPER
	C)  UPPER
	D)  SUBSTITUTE

4)

Guidelines for construction of a data table in Excel include all of the following EXCEPT:

4) ______

	A)  Field names should be in the top row.
	B)  Do not format field names.
	C)  Keep field names short and descriptive.
	D)  It is helpful to separate the table from other spreadsheet elements.

5)

CSV files contain fields that are separated by:

5) ______

	A)  periods.
	B)  tabs.
	C)  commas.
	D)  colons.

6)

When a delimited file is imported into Excel, fields become:

6) ______

	A)  records.
	B)  rows.
	C)  columns.
	D)  tabs.

7)

In the figure above, ________ conditional formatting is used.

7) ______

	A)  Icon Sets
	B)  Top/Bottom Rules
	C)  Color Scales
	D)  Data Bars

8)

Which of the following statements is FALSE about range names?

8) ______

	A)  Range names can have spaces.
	B)  Range names can have numbers and letters.
	C)  A range can be a single cell.
	D)  They must be unique within a workbook.

9)

Which of the following is NOT an example of a text string?

9) ______

	A)  Last Name
	B)  3/11/1960
	C)  33 S. Main St.
	D)  450.00

10)

=IF(A3>10,B3*C3,IF(A<100,B3*D3,0) is known as a(n):

10) ______

	A)  enclosed IF.
	B)  multiple criteria IF.
	C)  IF statement.
	D)  nested IF.

11)

If you have =MONTH(B3)-1 in cell C3 and March 1, 2008 is in cell B3, what will the function return?

11) ______

	A)  March 1, 2008
	B)  February 1, 2008
	C)  March 1, 2007
	D)  February 1, 2007

12)

Which of the following is TRUE about using range names in formulas?

12) ______

	A)  Range names create an absolute reference.
	B)  Range names create a relative reference.
	C)  =julies_sales+store sales is a valid formula.
	D)  You can only use range names on the same worksheet as the formula you are creating.

13)

If you delete a PivotChart, what happens to the PivotTable?

13) ______

	A)  Nothing
	B)  An error message appears
	C)  It is deleted also
	D)  The data in it is deleted

14)

The ________ separates imported data into columns.

14) ______

	A)  delimiter
	B)  ampersand (&)
	C)  field indicator
	D)  CONCATENATE function

15)

What is the first step in identifying duplicate rows in a table?

15) ______

	A)  Select a column in the table to be checked for duplicates.
	B)  Select the duplicate row.
	C)  Select the entire table that will be checked for duplicates.
	D)  Click the Home tab and click the Conditional Formatting button.

16)

After you have chosen the formatting to show duplicate rows in a table, what happens?

16) ______

	A)  Each duplicate row is highlighted one-by-one.
	B)  All duplicate rows are highlighted.
	C)  An error message comes up prior to deleting all duplicate rows.
	D)  The duplicate rows are deleted.

17)

When using the Subtotal command, what is displayed after the last record of a table?

17) ______

	A)  An empty row
	B)  A summary report
	C)  A grand total
	D)  A subtotal

18)

Why is a minus sign (-) usually used with the PMT function?

18) ______

	A)  So it can easily be reduced from the previous month’s balance
	B)  So it can easily be deducted from a checking account balance
	C)  So it appears as a positive number
	D)  Because you should see it in red with parentheses

19)	In the figure above, what is the delimiter in the chap5_ho1_hremployee.txt file?	19) ______

	A)  Name
	B)  Title
	C)  Tabs
	D)  Commas

20)

In the figure above, how many fields are there?

20) ______

	A)  4
	B)  5
	C)  13
	D)  14

21)	In the figure above, what function is likely in cell H4?	21) ______

	A)  PMT
	B)  INDEX
	C)  PAYMENT
	D)  AVERAGEIF

TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false.
22)	Data can only be imported to Excel from Access.	22) ______

23)

Names for fields in an Excel table should be in the top row.

23) ______

24)

To highlight all cells which contain sales over $5,000, use conditional formatting.

24) ______

25)

Multiple range names can be created at the same time.

25) ______