1.Which of the following is an argument used in the VLOOKUP function?

a.

Pivot_table

b.

Type

c.

Rate

d.

Col_index_num

e.

Data_field

2.The protection commands are found in the _____ tab of the Ribbon.

a.

Review

b.

Format

c.

Data

d.

Tools

e.

3.Which of these steps outlines how a trendline equation can be added to a chart?

a.

Select the Demand option from the Add Trendline dialog box and click the OK button.

b.

Click the Format Selection button in the Layout tab of the Chart Tools section of the Ribbon.

c.

Click on the Number format commands in the Home tab of the Ribbon.

d.

Click on the Number section of the Format Axis dialog box.

e.

Open the Format Trendline dialog box to add the line equation to the plot area of the chart.

4.Edith is planning a presentation for the Board of Directors. She uses an Excel spreadsheet to compute the annual sales figures. To add external information from the company website to her Excel sheet, she uses the _____ tab on the Ribbon.

a.

Review

b.

View

c.

Insert

d.

Data

e.

Vlookup

5.Which of the following functions calculates the payments required for a loan or a lease?

a.

COSH

b.

PRICEMAT

c.

SKEW

d.

COVAR

e.

PMT

6.In an Excel spreadsheet, D14 denotes a _____.

Select one:

a.

cell range

b.

cell column

c.

cell row

d.

cell address

e.

7.Which of the following statements is true of a scatter chart?

a.

A scatter chart has only one value axis.

b.

In a scatter chart, the X-axis represents descriptive labels and not numerical values.

c.

In a scatter chart, there cannot be a change in the spacing of any items placed on the X axis.

d.

In a scatter chart, numerical values can be used on both the X and Y axes.

e.

In a scatter chart, the X-axis offers less flexibility to represent numerical values.

8.Which of the following arguments in the PMT function indicates the principle of the loan or the amount of money that is borrowed?

Select one:

a.

nper

b.

rate

c.

[fv]

d.

[type]

e.

pv

9.Which of the following is a valid statistical IF function?

a.

ACCRINTIF

b.

COUNTIF

c.

DELTAIF

d.

COMBINIF

e.

HARMEANIF

Clear my choice

10.Highlight cells on either side of the hidden column(s), then hold the CTRL key and the SHIFT key down while pressing the close parenthesis key ) on your keyboard. What function is served by this command?

a. auto fill

b.save as

c. unhide columns

d. adjust row height

e. adjust column height

Adjust row height

e.

Adjust column height

11.Which of the following is an argument used in the COUNTIF function?

a.

Probability

b.

Mean

c.

Coefficient

d.

Range

e.

Maturity

12.If we test several logical tests in succession and if the output of one of these logical tests is true, then the output of the _____ function will be the word TRUE.

a.

AND

b.

EFFECT

c.

SMALL

d.

OR

e.

13.To navigate around the Save As window, which of the following set of commands is to be used without using the mouse pointer?

a.

Hold down the CTRL key while pressing the arrow keys

b.

Hold down the ALT key while pressing the S key

c.

Press the F12 key while using tab and arrow keys

d.

Hold down the CTRL key and press the F5 key

e.

Hold the CTRL key and press down on the F1 key

14.In Excel, adding custom lines to a worksheet is known as adding _____.

a.

rows

b.

lines

c.

cells

d.

borders

e.

columns

Clear my choice

15.The height of a row is measured by using the metric point, it is approximately:

Select one:

a.

1/3 of an inch

b.

1/16 of an inch

c.

1/36 of an inch

d.

1/72 of an inch

e.

1/66 of an inch

16.Cell, or enter/change the information in the _____.

Select one:

a.

Ribbon tab

b.

column heading

c.

Status Bar

d.

Formula Bar

e.

17.A(n) _____ can be applied to a chart to estimate or predict where plot points may occur at various points along the X and Y axis.

Select one:

a.

axis scale

b.

axis title

c.

trendline

d.

series line

e.

value axis

Clear my choice

18.Which of the following arguments in the PMT function indicates the number of periods?

Select one:

a.

pv

b.

[fv]

c.

[type]

d.

nper

e.

rate

Clear my choice

19.Which of the following is the best way to add a title to the X-axis?

Select one:

a.

Insert a text box in the chart and drag it to the X-axis.

b.

Type in the desired title in the formula bar to create a text box and drag it to the X-axis.

c.

Select the horizontal axis option from the Axis titles button in the Layout tab of the Ribbon.

d.

Activate the X-axis by clicking on it and type in the title in the formula bar of the worksheet.

e.

Right click on the X-axis and click on the Source Data button.

20.Which of the following mouseless commands is used to open the format cell dialog box?

Select one:

a.

Hold the CTRL key while pressing the SHIFT key and the letter F key on your keyboard

b.

Hold the ALT key while pressing the * key and the letter K key on your keyboard

c.

Hold the SHIFT key while pressing the CTRL key and the letter P key on your keyboard

d.

Hold the CTRL key while pressing the ALT key and the letter R key on your keyboard

e.

Hold the ALT key while pressing the SHIFT key and the letter B key on your keyboard

21.Which of the following is an argument for the IF function?

Select one:

a.

Coefficients

b.

Significance

c.

Old_text

d.

[Instance_num]

e.

[Value_if_true]

Clear my choice

22.If you wanted to test whether the word subtract is in cell D8, the logical test would be _____.

Select one:

a.

D8 >< (subtract)

b.

D8 =< {subtract}

c.

D8 = subtract

d.

D8 <> subtract

e.

D8 >= [subtract]

Clear my choice

23.If the value in the cell D9 is 7, the output of the function =SUMIF(B1:B7, D9,C1:C7) is _____.

Select one:

a.

12

b.

28

c.

32

d.

39

e.

45

24.Which of the data given below would be ideally represented using a column chart?

a.

Data projecting the stock trend for a company over a period of 30 weeks.

b.

The rainfall recorded in a location over a period of 24 months.

c.

The sales figures of a hardware store over a span of 30 days.

d.

A comparison of the stock trends of two companies over a period of 24 months.

e.

A chart showing the employees who are top and mid-level performers.

25.The STDEV.S function indicates:

Select one:

a.

the middle number in a group of numbers.

b.

the number of cell locations in a range that contain a text or numeric character.

c.

the standard deviation for a group of numbers.

d.

the result of multiplying all the values in a range of cell locations.

e.

the positive square root of a number.

26.If the value in cell C4 is 9, output of the =SUMIF(A1:A7, C4) function is _____.

Select one:

a.

2

b.

5

c.

7

d.

14

e.

18

Clear my choice

27.Which of the following functions counts the number of cells in a range that contain numeric or text data?

Select one:

a.

CELL

b.

CORREL

c.

COMBIN

d.

COUNTIF

e.

CUBESET

28.The Goal Seek button is found on the _____ tab of the Ribbon in Excel.

Select one:

a.

Page Layout

b.

Formulas

c.

Review

d.

Data

e.

View

29.The rate argument in the PMT function indicates:

Select one:

a.

the principal loan amount.

b.

the interest rate the lender is charging.

c.

the future value of the property for which the loan is taken.

d.

the amount of EMI (equated monthly installment).

e.

the amount of principal paid back each month.

30.Nina has created a chart to demonstrate the months during which the rainfall recorded was lowest. She wishes to rank the recorded numbers from highest to lowest. Which command should she choose?

Select one:

a.

Sort

b.

Arrange

c.

Filter

d.

Function

e.

Consolidate