$.$ Using the IF Function. A logical function that evaluates a single condition and results in only one value. Returns one value if the condition is true and another value if the condition is false $$ Syntax: IF$($logical$\_$test, value$\_$if$\_$true, value$\_$if$\_$false$)$ True O False COUNTIF, SUMIF, are functions that can be used to calculate a conditional count, sum, using only cells that meet a particular condition$*$ True False A hyperlink is a link in a file to information within that file or another file. Can be used to: $.$ Quickly jump to a specific cell or range within the active worksheet, another worksheet, or another workbook. Jump to other files $(.$e$.,$ a Word document, a PowerPoint presentation, or a site on the web$)$ True False To ensure that correct data is entered and stored in a worksheet, you can use data validation. Each validation rule defines criteria for the data that can be entered and stored in a cell or range. You can add input and error alert messages for the user to that cell or range$*$ True False $.$ Creating a Workbook Based on an Existing Template $$ Excel has many templates available. Some are automatically installed on your hard drive when you install Excel. Other templates are available to download from the Office.com site True O False $$ Creating a chart is a several$-$step process: Selecting the data to display in the chart. Choosing the chart type. Moving the chart to a specific location. Sizing the chartFormatting the chart's appearance $*$ True O False The records in an Excel table initially appear in the order they were entered: you can view the same records in a different order. Ascending order arranges text alphabetically from A to Z numbers from smallest to largest, and dates from oldest to newest $.$ Descending order arranges text in reverse alphabetical order from Z to A numbers from largest to smallest, and dates from newest to oldest True False