excel module 4, excel module 6, excel module 5
Because of their compact size, you cannot apply a style to a sparkline. True or False
False
Bruno has a table with four fields and dozens of records. To make the fields easier to distinguish, he can apply filtered columns. True False
False
By default, table styles override the formatting applied to individual table cells. a. True b. False
False
References to fields in an Excel table are called table references. a. True b. False
False
Splitting the workbook window affects all the worksheets in the workbook. a. True b. False
False
The best way to locate records with duplicates in more than one field is to apply conditional formatting. True False
False
To align the upper-left corner of a chart with the upper-left corner of a cell, press and hold CTRL as you drag the chart. True or False
False
To compare data from different categories where the values are indicated by the height of the data series,select a Stock chart on the Recommended Charts tab in the Insert Chart dialog box. True or False
False
To expand data views using the Outline feature, select the rows with similar data by clicking and dragging on the rows numbers to the left of your data. Then click on Data tab > Group > - sign. True False
False
To find every cell that satisfies the criteria you enter in the Fine and Replace dialog box, you click the Find Next button. a. True b. False
False
To locate duplicate values in a selected range, start by clicking the Duplicate Formatting button on the Home tab. a. True b. False
False
To resize the panes, right-click the pane split bar. a. True b. False
False
When you split a worksheet pane, its contents are always visible, though you cannot scroll in the pane. a. True b. False
False
You cannot add totals to an Excel table because the table structure of fields and records must be preserved. a. True b. False
False
You should move a chart to a chart sheet when you want the source data to appear with the chart
False
trendline is a line that extends from the chart's horizontal or vertical axis into the plot area, making it easier to identify the values in the chart. True or False
False
Which of the following options can you set when you create or edit a data bar conditional formatting rule?Select all the options that apply. a. value used for the longest data bar b. fill color of the data bars c. how to display negative values d. font color of the text
a. value used for the longest data bar b. fill color of the data bars c. how to display negative values
A _____ chart tracks the addition and subtraction of values within a sum. a. waterfall b. histogram c. scatter d. combo
a. waterfall
Bree added data labels to a pie chart, where they appear on each slice. She wants the data labels to appearoutside of the pie chart but close to each slice. Which Label Position option should she select for the datalabels? a. center b. Inside End c. Outside End d. Overlay
c. Outside End
Which of the following dialog boxes do you use to remove a data series from a chart? a. Chart Elements dialog box b. Format Data Source dialog box c. Select Data Source dialog box d. Insert Chart dialog box
c. Select Data Source dialogue box
Will has a table that includes a field with four product types. What kind of filtterm-26er would be best to create for the table? a. Date filter b. Custom number filter c. Slicer d. Advanced filter
c. Slicer
A range of data Excel treats as a single object that can be managed independently from other data in the workbook I a(n) _________. a. Outline b. Summary c. Table d. Dashboard
c. Table
A combination chart combines two chart types and can plot data on primary and secondary axes True or False
True
A teacher creates a table for Sports Day events. The table includes columns for Event, Rank, First Name,and Last Name. To find the top-ranking participants for each event, the teacher can sort the table first by Eventand then by Rank. True False
True
A teacher creates a table of student data that contains columns for First Name, Last Name, and Date of Birth. To list the students in alphabetical order by last name, she can sort the Last Name column in ascending order. True False
True
Alicia created a chart that shows months in rows and prices in columns. She can switch the rows and columns to show prices in rows and months in columns. True or False
True
Before inserting sparklines into cells, make sure the cells are blank because sparklines replace cell contents. True or False
True
Binay wants to create an X-Y scatter plot. To do so, he should select the data he wants to plot in the scatter chart, then click the Insert tab, and then click Insert Scatter (X, Y) or Bubble Chart. True or False
True
Cedric has a table listing customer data, including the date of their purchase. He can sort the Date data in descending order to quickly find customers with recent purchases. a. True b. False
True
Column and line sparklines show a general trend without a legend, title, or gridlines
True
In a chart, a data table displays the data series in rows and the category values in columns. True or False
True
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. Trendline
d. Trendline
Which of the following can you do to make a chart title stand out on a chart? a. Change the text direction b. Resize the chart. c. Display the title on the outside end of the data series. d. Increase the font size
d. increase the font size
What can you change to coordinate the values represented by sparklines with the values of other charts and graphic objects on a worksheet? a. sparkline type b. sparkline color c. show or hide data markers d. scale of the sparkline axis
d. scale of the sparkline axis
In the formula = SUBTOTAL(1, Customers_Table(ID]), what does the 1 refer to? a. the first field to analyze b. the number of the column to analyze c. the number of values to analyze d. the number of the function to use
d. the number of the function to use
Liza has a table with six fields and 50 records. To make it easier to distinguish the records, she can apply banded rows. True False
True
Niki wants to insert a Line sparkline in Excel. To do this, she can click on the cell she wants to insert a Sparkline, then click Insert tab, select Line Sparkline from the Sparklines group and then OK. True or False
True
The Remove Duplicates tool locates and deletes records that are duplicated across multiple fields. True False
True
To change a chart title, you click the chart title, type the new title, and then press ENTER. True or False
True
To count only records that match a filter criteria, you use the SUBTOTAL function. a. True b. False
True
To display a preview of a table style applied to the selected table, point to a style in the Table Styles gallery. True False
True
To outline data, select the rows or columns you want to group, and then click the Group button on the Datatab. a. True b. False
True
You can add data markers to sparklines to indicate the high and low points in the chart. True or False
True
Use a sunburst chart to track the addition and subtraction of values in a sum. True or False
false
A Line sparkline displays a green block for increasing values and a red block for declining values. True or False
False
A treemap chart is a type of waterfall chart. True or False
False
Antonio wants to calculate the sum of values in the Order Amt column in a table. What should he do? a. Add a total row and then choose Sum in the Order Amt column. b. Add a calculated field to the table that uses the SUM function. c. Use the SUBTOTAL function at the bottom of the Order Amt column. d. Add a total column and then choose Total to calculate all totals for the table
a. Add a total row and then choose Sum in the Order Amt column.
Tracy created a table where the odd and even-numbered columns are formatted differently. She wants to remove this formatting. What setting should she change? a. Banded columns b. Calculated columns c. Odd/Even columns d. First column
a. Banded columns
Which of the following do Excel tables provide that data ranges do not? Select all the options that apply. a. Built-in sorting and filtering tools b. What-if analysis tools c. Styles that format different parts of the table d. Automatic subtotal rows
a. Built-in sorting and filtering tools c. Styles that format different parts of the table
Which features do Excel tables support that are not available with data ranges? Select all the options that apply. a. Built-in sorting and filtering tools b. Number formats c. Table styles d. Totals row
a. Built-in sorting and filtering tools c. Table styles d. Totals row
Which of the following are ways you can format a slicer? Select all the options that apply. a. Change the size of the slicer buttons. b. Change the number of columns in the slicer. c. Apply a color scheme. d. Format the slicer button text
a. Change the size of the slicer buttons. b. Change the number of columns in the slicer. c. Apply a color scheme
Dmitri created a table of employee data and wants to list the records in order by most recent hire date.Which of the following should he do? a. Sort the records in descending order by hire date. b. Sort the records in ascending order by hire date. c. Sort the records first by name and then by hire date. d. Filter the records by hire date.
a. Sort the records in descending order by hire date.
Josh wants to insert a column in an Excel table to add the values from two other columns. Which of the following methods can he use to insert a table column? a. Click a column header and then click the Insert button on the Home tab. b. Right-click a column header, click Format Cells on the shortcut menu, and then click Add New Column. c. Click a column header, click the filter arrow, and then click Insert. d. Double-click a column header and then click Insert on the shortcut menu.
a. Click a column header and then click the Insert button on the Home tab.
How can you hide the filter buttons in a table? a. Click the Filter Button check box in the Table Styles Options group. b. Clear the filters from the table. c. Right-click a filter button and then click Remove. d. Click a filter button and then click Hide
a. Click the Filter Button check box in the Table Styles Options group.
How can you remove the split bars from a worksheet? a. Click the View tab, and then click the Split button in the Windows group. b. Click the Page Layout tab, and then click the Bring Forward button in the Arrange group. c. Click the View tab, and then click the Hide button in the Windows group. d. Click the Page layout tab, and then click the Remove Breaks button in the Page Setup group
a. Click the View tab, and then click the Split button in the Windows group.
Which of the following can you apply to an Excel table? Select all the options that apply. a. Header row b. Total column c. Banded rows d. Table name
a. Header row c. Banded rows d. Table name
Which of the following are ways Excel provides to identify duplicate records in a table? Select all the options that apply. a. Highlight Duplicate Values conditional formatting b. Duplicate Values Wizard c. Remove Duplicates tool d. Circle Duplicates tool
a. Highlight Duplicate Values conditional formatting c. Remove Duplicates tool
What does the Highlight Duplicate Values conditional formatting rule do when you apply it to a range? a. It highlights duplicate values in the range. b. It deletes duplicate values from the range. c. It converts duplicate values so they are unique. d. It moves the duplicate values to another area of the worksheet
a. It highlights duplicate values in the range.
Which of the following statements describe a histogram chart? Select all the options that apply. a. It is a column chart showing the distribution of values from a single data series. b. Use it to display distribution of scores on an exam. c. Data values are allocated to bins. d. It includes a secondary line chart
a. It is a column chart showing the distribution of values from a single data series. b. Use it to display distribution of scores on an exam. c. Data values are allocated to bins.
When you create a custom combination chart, which of the following chart types can you use for the primary and secondary axis? Select all the options that apply a. Line b. Clustered Column c. Tree map d. Waterfall
a. Line b. Clustered Column
Which of the following are ways to format the appearance of a slicer? Select all the options that apply. a. Number of columns b. Slicer size c. Button size d. Slicer style
a. Number of columns b. Slicer size c. Button size d. Slicer style
To which of the following chart types can you not add axis titles? a. Pie chart b. Line chart c. Area chart d. Column chart
a. Pie Chart
Michelle finished a 5 kilometer run in 180th position. The organizers shared an Excel spreadsheet withnames of all the participants and the time they took to complete the race. The top 15 finishers are listed in rows2 to 16. Michelle wants to compare her time against theirs. How can she do so? a. Select row 17 and click View tab > Window group > Split. b. Select rows 2 to 16 and click View tab > Window group > Split. c. Select rows 2 to 16 and click View tab > Window group > New Window > Split. d. Select row 16 and click View tab > Window group > Split > Arrange All.
a. Select row 17 and click View tab > Window group > Split.
Which of the following boxes will you check after clicking on a table and then selecting Table Tools >Design, to add a row to the table that will display summary statistics of the different table columns.? a. Total Row b. Header Row c. Footer Row d. Banded Rows
a. Total Row
When you freeze the top row of a worksheet, what part of the worksheet can you scroll? a. all rows below the top row b. columns starting with column C c. rows starting with row 4 d. only the lower-right pane of the worksheet
a. all rows below the top row
A label that appears as a text bubble attached to a data marker is called which of the following? a. data callout b. histogram c. data bar d. sparkline
a. data callout
Which type of sparklines can most clearly display the daily fluctuations of the selling price of goods or commodities ? a. Line b. Win/Loss c. Column d. Combo
a. line
You can add data markers to sparklines to highlight which of the following values? Select all the options that apply. a. low values b. high values c. ending values d. negative values
a. low values b. high values c. ending values d. negative values
Which of the following changes can you apply to a chart legend? Select all the options that apply. a. Position b. Data Series colors c. Fill color d. Number formatting
a. position c. fill color
Which of the following can help you quickly format a cell range with labels in the left column and top row,and totals in the bottom row? a. table style b. cell style c. font style d. number format
a. table style
Which of the following can you change in a combination chart? Select all the options that apply. a. The bounds of the secondary axis b. The major tick marks on the primary axis c. The minor tick marks on all axes d. The orientation of the axis titles
a. the bounds of the secondary axis b. the major tick marks on the primary axis d. the orientation of the axis titles
Which of the following parts of a worksheet can you freeze? Select all the options that apply. a. top row b. first column c. middle column d. specified pane
a. top row b. first column d. specified pane
To use the SUBTOTAL function to calculate the sum of filtered table records, set the Function_Numargument to _____. a. 1 for AVERAGE b. 9 for SUM c. 2 for COUNT d. 10 for TOTAL
b. 9 for SUM
Adele wants to filter a Customers table to show customers in Denver or customers with invoices over$2500. What type of filter should she use?a. Number AutoFilter b. Advanced filter c. Text with wildcard filter d. Date AutoFilter
b. Advanced filter
Leigh-Ann used a slicer to filter a table on the Department field. Which of the following buttons should she click on the slicer to redisplay data for all the departments? a. Multi-Select button b. Clear Filter button c. Slicer Settings button d. Slicer Styles button
b. Clear Filter button
Stacey filtered a table on the Product Type field and now wants to filter on the Price field instead. What should she do next? a. Click a filter button and then click Price. b. Clear the existing filter from the table. c. Use a Number filter. d. Sort by the Price field
b. Clear the existing filter from the table.
After splitting a worksheet window into four panes, how can you display a single pane? Select all the options that apply. a. Freeze the top row. b. Click the Split button on the View tab. c. Double-click the split bar. d. Click the Arrange All button on the View tab.
b. Click the Split button on the View tab. c. Double-click the split bar.
Which type of conditional formatting rule would you create to add a horizontal bar to a cell background,where the length of the bar reflects the value in the cell? a. Top Values b. Data Bar c. Icon Sets d. Color Scales
b. Data Bar
Amir wants an exploded pie chart. Which of the following should he do? a. Click the Explode Pie button b. Drag the pie slice(s) away from the pie. c. Right-click on the slice(s) of pie and select Explode Piece. d. There is no way he can explode the pie chart
b. Drag the pie slice(s) away from the pie.
Gwen wants to locate cells that contain the date 11/14/21. Which of the following tools should she use? a. Locate & Change b. Find & Select c. Fill d. Filter
b. Find & Select
Helen wants to resize slicer buttons to exact dimensions. What can she use to do so? a. Slicer Settings button in the Slicer group b. Height and Width boxes in the Buttons group c. Slicer Styles gallery d. Slicer Size box in the Slicer group
b. Height and Width boxes in the Buttons group
Annemarie lists 12 months of product sales data in the range A3:M7. The products are listed in the rangeA3:A7 and the monthly sales data in the range B3:M7. She wants to display a simple chart at the end of eachrow in column N to track the monthly sales for each product. What can she insert in the range N3:N7? a. Line chart b. Line sparklines c. Scatter chart d. Data bars
b. Line sparklines
Which of the following are options you can select when using the Find and Replace dialog box to find text?Select all the options that apply. a. Type of criteria b. Look in c. Match case d. Within
b. Look in c. Match case d. Within
Shelley creates a table containing the marks of Language Arts students in her class with these columns:Names of Students and Marks. She now wants to see the names of students who scored exactly 60 marks. What will Shelley do after selecting the column header arrow for the column with heading Marks? a. Check the box beside Select All and the number 60 and click OK. b. Uncheck (Select All), select the box beside the number 60 and click OK. c. Select Number Filters > Between > (Enter value 0 in dialog box on top) > (Enter value 60 in dialog box below it) > OK. d. Select Number Filters > Less Than or Equal To > (Enter value 0 in dialog box on top) > (Enter value 60 in dialog box below it) > OK
b. Uncheck (Select All), select the box beside the number 60 and click OK.
Which of the following summary statistics can you display in a total row in an Excel table? Select all the options that apply. a. lookup b. average c. minimum d. sum
b. average c. minimum d. sum
What can you do to make data series easier to distinguish from one another? a. Change the chart type. b. Change the color of the data series. c. Apply additional text styles. d. Increase the size of the data series
b. change the color of the data series
To add a field to a table, what can you do? a. Click a row heading and then click the Insert button. b. Click a column header and then click the Insert button. c. Click the Insert button and then click Field. d. Click the Field check box in the Table Style Options group.
b. click a column header and then click the insert button
Maya created a table with the totals in the last column on the right. Which of the following table style options should she apply to call attention to the totals? a. Total Row b. Last Column c. Banded Columns d. Header Row
b. last column
Which type of chart combines a column chart and a line chart to indicate which factors are the largest contributors to the whole? a. sunburst b. Pareto c. area d. doughnut
b. pareto
To explicitly indicate that a range contains fields and records, you create a(n) _____. a. outline b. table c. advanced filter d. chart
b. table
Which of the following is an unacceptable name for an Excel table? a. Employee_Tbl b. _SalesTable c. (Customers) d. ProductTable
c. (Customers)
An Excel table contains columns named Salary and Commission. Which of the following formulas uses a structural reference to sum the values in the Salary through Commission fields?a. =SUM(Salary:Commission) b. =SUM(Salary!Commission) c. =SUM([Salary]:[Commission]) d. =SUM("Salary":"Commission")
c. =SUM([Salary]:[Commission])
Mia inserted a plain table in a worksheet. She wants to change the black borders and white fill to make thetable more attractive and easier to use. What is the quickest way for her to change the appearance of the table? a. Change the shading and border colors of the cells. b. Filter the table. c. Change the table style. d. Convert the table to a range.
c. Change the table style.
Which of the following buttons on the Home tab can you use to insert a row in a table? a. Format as Table b. Insert & Merge c. Insert d. Add Row
c. Insert
Kylie created a table with a Skill Number column that contains values from 400 to 500. What type of filter can she use to select records with skill numbers less than 450? a. Text filter b. Top Values filter c. Number filter d. Form filter
c. Number filter
Descriptive text that appears next to a chart's horizontal or vertical axis is called which of the following? a. major tick mark b. display units c. axis title d. data label
c. axis title
If you see cells with blue fills of varying lengths representing the values, the cells most likely have________ applied to them. a. themes b. icon sets c. data bars d. cell styles
c. data bars
If you want to sort data first by department, and then by last name, the last name field is the _____ sortfield. a. primary b. limited c. secondary d. minor
c. secondary
In the formula =[SalesPrice]*.05, what do you call [SalesPrice]? a. 3-D reference b. external reference c. structural reference d. absolute reference
c. structural reference
Which of the following chart types show how two numeric data series are related to each other? a. Pie b. Bar c. Line d. Scatter
d. Scatter
