FINAL Flashcards
Why would you press Ctrl+’ in Excel?
To display cell formulas
If you want to balance a title over several columns, what do you do?
Merge and center the data over all columns
If you want to see a preview of how a worksheet will appear on a hard copy, what do you do?
Click the File tab, and then click Print
What should you do if you see a column of pound signs (###) instead of values or results of formulas?
Increase the column width.
What function would most appropriately accomplish the same thing as =(B5+C5+D5+E5+F5)/5?
=AVERAGE(B5:F5)
A formula containing the entry =$B3 is copied to a cell one column to the right and two columns down. How will the entry appear in its new location?
=$B5
Given that cells A1, A2, and A3 contain values 2, 3, and 10, respectively, and B6, C6, and D6 contain values 10, 20, and 30, respectively, what value will be returned by the function =IF(B6>A3,C6A1,D6A2)?
90
The function =PMT(C5,C7,-C3) is stored in cell C15. What must be stored in cell C7?
Number of payment periods
What is not an acceptable range name?
Goal for 2012
What is a typical sequence for creating a chart?
Select the data source, select the chart type, and then size and position the chart.
If you want to show exact values for a data series in a bar chart, what chart elements should you display?
Data labels
You want to create a single chart that shows each of five divisions’ proportion of yearly sales for each year for five years. Which type of chart can accommodate your needs?
100% stacked column chart.
Which tab contains commands to apply a predefined chart layout that controls what elements are included, where, and their car scheme?
Design
Which of the following is not a way to display the Format Data Series dialog box for the Arts data series in a column chart?
Press and hold shift as you click each Arts column
What Excel interface item is not displayed until you start typing or editing data in a cell?
Enter
