Which feature will prevent the annual interest earnings total from duplicating monthly interest earnings totals?
Distinct X-Y data points are plotted but not connected. A - bar graph✔ B - scatter plotC - line chartD - pie chart
Discrete categories of data can be compared using a ✔ A - bar graphB - scatter plotC - line chartD - pie chart.
Parts of a whole can be shown with a A - bar graphB - scatter plotC - line chart✔ D - pie chart.
Question text not available
Match the description below to the correct chart or graph to the right by using the drop-down menus.Distinct X-Y data points are plotted and connected to emphasize changes between data points over time. A - bar graphB - scatter plot✔ C - line chartD - pie chart
Which range of cells represents the Lookup Table for finding which award each student received? ✔ E7:F12A2:B7C2:C7E7:E12
Which of the following are characteristics of conditional formatting? Choose all that apply.
Complete each of the following sentences by choosing the most appropriate chart or graph for the scenario.A ✔ pie chartline graphscatter plotbar graph
What function is used to return the results in column D? ✔ IF statementnested IF statementVLookupHLookup
Which spreadsheet feature could the scholarship committee use to locate applicants who meet the criteria? Lookup Tablesconditional formatting✔ nested IF statement
Which lookup function would you use to fill C2:C7? ✔ VLookupHLookup
Which of the following are advantages of using cell protection in spreadsheets? Choose all that apply.
A pie chart✔ line graphscatter plotbar graph
What function is used to return the results in column E? IF statement✔ nested IF statementVLookupHLookup
Based on the essays, the committee selected five applicants to each receive a $10,000 scholarship from ABC Foundation. Rows containing the names of the winners are highlighted in yellow. The spreadsheet is sent to the college’s financial department so that checks can be mailed to the winners. Which feature should the committee use to prevent any further changes to the spreadsheet? conditional formatting✔ cell protectionnested IF statement
What is your lookup value for student C? ✔ 64None1
A pie chartline graph✔ scatter plotbar graph
Vehicles that are $20,000 or less and are the color red describes the data in which column?BCD✔ E
A pie chartline graphscatter plot✔ bar graph
Did you find these answers helpful?