excel final exam ii

Cell A5 is the active cell. You want to make cell B10 the active cell. Which of the following is not a method for going to cell B10?

(d) Type B10 in the Formula Bar and press Enter.

Which step is not part of planning a worksheet design?

(b) Enter labels, values, and formulas.

Cell A2 contains the regular price $100. Cell B2 contains the discount rate 15%. Cell C3 contains =A2*(1-B2) to calculate the sale price of $85. Which of the following formulas

produces the same result?

(b) =A2-(A2*B2)

What should you do if you see pound signs (###) instead of values or results of formulas?

Increase the column width.

You just copied a range of data containing formulas. However, you want to preserve the formula results and the original number and text formatting in the pasted range. Which paste option would you select?

(c) Values & Source Formatting

The label Souvenir Shop is in cell A1, and April Sales Report is in cell B1. You select the range A1:E1 and click Merge Center. What is the result?

(d) Souvenir Shop is centered over the range A1:E1, and April Sales Report is deleted.

What number format places a dollar sign on the left side of the cell, includes commas to

separate thousands, displays two decimal places, and displays zero values as hyphen?

(d) Accounting Number Format

You want to copy the March worksheet to use it to enter data for April. After you right-click the March sheet tab and select Move or Copy, you click OK in the Move or Copy dialog box without changing any settings. What happens?

(c) The March sheet is moved to the left of the first sheet tab. The worksheet is not copied.

The Header & Footer Tools tab contains commands that insert codes into a header or footer. These codes enable the header or footer text to change automatically. You can insert a code for all of the following except:

(a) Your Name.

Assume that the data on a worksheet consume a whole printed page and a couple of columns on a second page. You can do all of the following except what to force the data to print all on one page?

(b) Increase the left and right margins

If cell E15 contains the function =PMT(B$15/12,C7*12,-D8), what type of cell

reference is B$15?

(c) Mixed reference

What function would most efficiently accomplish the same thing as =(B5+C5+D5+E5+F5)?

(a) =SUM(B5:F5)

When you start to type =AV, what feature displays a list of functions and defined

names?

(b) Formula AutoComplete

A formula containing the entry =J$7 is copied to a cell three columns to the right and four

rows down. How will the entry display in its new location?

(a) =M$7

Which of the following functions should be used to insert the current date and time

in a cell?

(c) =NOW()

Which of the following is not a comparison operator?

(c) &

Which of the following is not true about the VLOOKUP function?

(b) The lookup table must be in descending order.

The function =PMT(C5,C7,-C3) is stored in cell C15. What must be stored in cell C5?

(b) Periodic interest rate

Which of the following is not an appropriate use of the MAX function?

(d) =MAX(D15-C15)

What is the keyboard shortcut to create an absolute reference?

(c) F4

Which type of chart is the least appropriate for depicting yearly rainfall totals for five cities for four years?

(a) Pie chart

Why would Series 1 and Series 2 display in a chart legend?

(c) Column headings were not selected when creating a chart.

You moved a chart to its own chart sheet. What chart element can you add to provide a grid that contains a copy of the data source at the bottom of the chart?

(b) Data table

You want to create a single chart that shows the proportion of yearly sales for five divisions for each year for five years. Which type of chart can accommodate your needs?

(d) 100% stacked column chart

A combo chart displays the number of new jobs on the primary value axis, percentage growth on the secondary value axis, job titles in the category axis, "New Job Growth by 2026" as the chart title, but no legend. Which is the least important title to include in the chart?

(c) The category axis Job Titles

The value axis currently shows increments such as 50,000 and 100,000. What option would you select to display the values in increments of 50 and 100?

(a) Show Axis in Thousands

If you want to show exact values for a data series in a bar chart, which chart element should you display?

(d) Data labels

You applied a chart style to a clustered column chart. However, you want to experiment with other settings to change the colors used in the chart without individually changing colors. Which of the following does not apply changes to the entire chart?

(b) Change colors in the Format Data Series task pane.

Currently, a column chart shows values on the value axis, years on the category axis, and state names in the legend. What should you do if you want to organize data with the states on the category axis and the years shown in the legend?

(a) Click Switch Row/Column in the Data group on the Design tab.

You created a worksheet that tracks data for a basketball team. The range B10:F10 contains the difference in final points between your team and the other team. What is the recommended sparkline to create to represent this data?

(c) Win/Loss

You have a large dataset that will print on several pages. You want to ensure that related records print on the same page with column and row labels visible and that confidential information is not printed. You should apply all of the following page setup options except which one to accomplish this?

(d) Change the print page order.

You are working with a large worksheet. Your row headings are in column A. Which command(s) should be used to see the row headings and the distant information in columns X, Y, and Z?

(a) Freeze Panes command

Which statement is not a recommended guideline for designing and creating an Excel table?

(c) Leave one blank row between records in the table.

Which of the following characters are wildcards in Excel?

(a) *

What should you do to ensure that records in a table are unique?

(b) Use the Remove Duplicates command.

Which Conditional Formatting rule is best suited to highlight sales value greater than $5,000?

(c) Greater Than

Which date filter option enables you to restrict the view to only dates between April 1, 2021 and April 30, 2021?

(d) Between

Which of the following is a fully qualified structured reference?

(b) =Sales[@Purchase_Price]-Sales[@Down_Payment]

Which of the following is not an aggregate function that can be applied in a total row?

(d) VLOOKUP

If you would like to set a conditional formatting rule based on the function =AND(G6="Finance", H7<7000) which formatting rule type is needed?

(c) Use a formula to determine which cells to format.