Upgrade to remove ads
Only $35.99/year

Excel module 2

Terms in this set (10)

If cellA5 displays a time in hours, minutes, and seconds, which of the following functions can you use to display the time as a serial number?
A) HOUR
B) TIME
C)SERIAL
D)NOW
B) TIME
Walter selected data on a worksheet to show in a chart. Which button on the Insert tab can he click to display charts appropriate for the selected data?
A) Pivotchart button
B) Illustrations button
C) Recommend Charts button
D) Appropriate Charts button
C) recommended charts button
Patrick is editing a worksheet with many formulas and functions, making the worksheet slow to update when he changes data. How can he work more efficiently?
A) Select the Manual Calculations option
B) Use the Quick Analysis tool to control calculations
C) round all the decimal values
D) remove any Date functions
A) select the manual calculations option
Eric wants to Rearrange the legend, title, gridlines, and other elements of the bar chart. Which of the following tools can he use to change many chart elements at the same time?
A) Select Chart Elements button
B) Change Colors button
C) Quick Layout button
D) Shape Styles button
C) Quick Layout button
The value in cell B2 cell is 65. In cell C2, the value is 75. Which of the following formulas returns FALSE if any of the conditions are false for the values in cells B2 and C2?
A) =IF(B2>=70, C2>=80)
B) =OR(B2>=70, C2>=80)
C) =AND(B2>=70, C2>=80)
D) =NOT(B2>=70, C2>=80)
C) =AND(B2>=70, C2>=80)
Which of the following elements can you add to a chart to display a line representing the general direction in a data series?
A) axes
B) legend
C) gridlines
D) trend line
D) trend line
Maria has a line chart that shows expense amounts on the vertical axis. What can she do to display the values as dollar amounts?
A) Change the starting and ending values of the vertical axis
B) change the number format of the vertical axis
C) add a vertical axis title
D) add a data table with a legend
B) change the number format of the vertical axis
After selecting a range of data, which can you click to display common chart types based on the range you selected?
A) Chart Options button
B) Paste Options button
C) Flash Fill button
D) Quick analysis button
D) Quick analysis button
Caleb created a column Chart with the lists Numbers from $50,000 to $0 on the left. What can you add to the chart to indicate that these are monthly revenue amounts?
A) Vertical axis title
B) Horizontal axis
C) Data table
D) Mew data series
A) vertical axis title
Which formula can you use to extract the month number from the data entered in cell F5 as July 8, 2016?
A) =MONTH(F5)
B) =MONTH("F5")
C)=MONTH(TODAY(2016,7,0))
D=MONTH(DAY(2016,7,0))
C)=MONTH(TODAY(2016,7,0))
Students also viewed