Business tech

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?

Type B10 in the Formula Bar and press Enter.

Which step is not part of planning a worksheet design?

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?

=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?

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?

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 hyphens?

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?

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:

Your Name.

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

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?

Mixed reference

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

=SUM(B5:F5)

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

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?

=M$7

Which of the following functions should be used to insert the current date and time in a cell?

=NOW()

Which of the following is not a comparison operator?

&

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

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?

Periodic interest rate

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

=MAX(D15-C15)

What is the keyboard shortcut to create an absolute reference?

F4

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

Pie chart

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

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?

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?

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?

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?

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?

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?

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?

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?

Win/Loss

The date 8/3/2021 is stored in cell C1. What function is used to extract just 3?

=DAY(C1)

The date February 16, 2021 is stored in cell B1. The last day of the semester (May 7, 2021) is stored in cell B2. Which function calculates the number days until the end of the semester?

=DAYS(B2,B1)

A workbook contains a list of houses and the months that they were sold in Florida. You are interested in determining the average price of sold houses in June in Ft. Lauderdale. What function is best suited for this calculation?

AVERAGEIFS

A dataset contains a list of U.S. Representatives, the states they represent, the years they were elected, and their salaries. You want to identify the highest-paid representative who was elected before 1/1/2020. What is the best function to use?

MAXIFS

A local police chief wants to create a rule that a person will be ticketed if an officer pulls over a person for exceeding the speed limit by at least five miles per hour or if that person has two or more speeding violations on record. Which function should be used?

OR

Which of the following functions should be used to determine how far the sample data is spread around the mean?

STDEV.S

A worksheet contains sales dollars for agents with your company. The values are $1,250, $1,090, $985, $985, $880, $756, $675, $650, and $600. What function could be used to return the third largest value?

LARGE

What function would you use to calculate the strength of a relationship between two or more variables?

CORREL

You hypothesize that there is a relationship between lack of regular exercise and illness. To research this theory, you have compiled a sample set of data that contains numbers of days in which an hour or more of exercise is completed as well as numbers of days sick within a calendar year. What tool in Excel could you use to investigate the relationships between the data?

CORREL

What is the difference between STDEV.S and STDEV.P?

STDEV.S calculates the standard deviation of a sample; STDEV.P calculates the standard deviation of a population.

What is the difference between a sample and a population?

A population contains all data you want to evaluate, while a sample contains a portion of the data.

What keystroke combination is required to calculate a Frequency data array?

Ctrl+Shift+Enter

You have a workbook that contains sales data where each sales rep's data is stored on a separate worksheet. Which task is the least likely to be done while the worksheets are grouped?

Enter specific values for the first sales rep.

A worksheet contains over 400 rows. The first 10 rows contain input data, and functions containing summary statistics are in the last 10 rows. What is the most efficient method to see the input area and summary statistics at the same time without having to scroll back and forth between sections?

Use the Split command and adjust one pane to see the input section and another pane to see the summary statistics.

Which function correctly adds data in cell D25 across multiple worksheets?

=SUM(Monday:Friday!D25)

The SalesQtr2 workbook contains links to data in the April, May, and June workbooks. Which workbook is the destination file?

SalesQtr2