Excel chapter 1-3
What is the keyboard shortcut to create an absolute reference?
F4
Which of the following is not a comparison operator?
&
Cell C6 contains the value 1.2546. How does the value display if you format the cell with Percent Style with 1 decimal place?
125.5%
What type of chart would display the names of seven city names (such as Jefferson City and Salt Lake City) on a cat-egory axis that is the easiest to read?
Bar chart
Which of the following is not impacted when you apply a chart style?
Chart elements may display or be removed.
Which chart element should you display to show exact val-ues for a data series in a bar chart?
Data labels
What should you do if you see pound signs (###) instead of values or results of formulas?
Increase the column width.
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.
A worksheet contains columns listing new movie releases, total production costs, week 1 gross revenue, and week 2 gross revenue. Which of the following would least likely form a data series in a column chart?
Movie names
The function =PMT(C5,C7,-C3) is stored in cell C15. What must be stored in cell C5?
Periodic interest rate
You just selected and cut column D. Now you want to move it to be located before data in column B. What should you do next?
Right-click the column B heading and select Insert Cut Cells.
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?
Switch the rows and columns in the chart.
What is an advantage of using the Recommended Charts command?
The Insert Chart dialog box displays recommended chart types based on the selected data.
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
Which function is best utilized to perform a lookup when the lookup array and return array are in different tables within the workbook?
XLOOKUP
A colleague emailed an Excel workbook that contains monthly sales data with each month on a separately named worksheet tab. When you print the workbook, the header always prints January. What caused this problem in which the other monthly worksheet printouts do not dis-play the correct worksheet name in the header?
Your colleague entered January in the header rather than inserting the Sheet Name field.
Why would you add Alt Text to a combo chart?
To adhere to accessibility compliance for screen reader capabilities
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
When you start to type =AV, what feature displays a list of functions and defined names?
Formula AutoComplete
If the function =XLOOKUP(H13,C4:C10,B4:B10,"Item Not Found",1,1) is used, what will happen if an exact match is not found?
The function will return the next smaller item.
Which situation is the most logical for using the Go To command?
Cell D10 is the active cell, and you want to go to cell D50.
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
The label Souvenir Shop is in cell A1, and April Sales Report is in cell B1. What happens when you select the range A1:E1 and click Merge & Center?
Souvenir Shop is centered over the range A1:E1, and April Sales Report is deleted.
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.
When is Auto Fill appropriate to use?
To enter the days of the week down a column
What value will the MAXA function return if given the val-ues -.02, -.07, -.09, and NA?
0
When using the 1900 date system, the date 1/1/1900 is equivalent to what number?
0
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 function would most efficiently accomplish the same thing as =(B5+C5+D5+E5+F5)/5?
=AVERAGE(B5:F5)
Which of the following functions should be used to insert the current date and time in a cell?
=NOW()
