The .xltx file format is the standard extension for an Excel template in versions of Microsoft Excel 2007 and later. When a user saves a workbook as an .xltx file, it creates a template that can be used as a starting point for new workbooks. Opening a .xltx file creates a new, unsaved workbook (.xlsx) based on the template's layout, formatting, and formulas, leaving the original template file unchanged. This ensures consistency and efficiency when creating similar documents repeatedly.

A. .pdf (Portable Document Format) is a file format used for presenting and exchanging documents reliably, independent of software, hardware, or operating system. It is not an Excel template format.

C. .mdb is a file extension for a Microsoft Access Database, a database management system. It is unrelated to Excel templates.

D. .pot is a file extension for a Microsoft PowerPoint template (specifically for versions prior to 2007). It is used to create presentations, not Excel workbooks.

1. Microsoft Corporation. (n.d.). File formats that are supported in Excel. Microsoft Support. Retrieved from https://support.microsoft.com/en-us/office/file-formats-that-are-supported-in-excel-0943ff2c-6014-4e8d-aaea-b83d51d46247.

Reference Point: In the section "Excel file formats

" the table explicitly lists .xltx with the description

"Excel Template. The default Excel template file format for an Excel workbook."

2. University of Wisconsin-Madison

Division of Information Technology (DoIT). (2020

July 22). Microsoft - File Extensions for Office 2016/2013/2010/2007. UW-Madison KnowledgeBase. Retrieved from https://kb.wisc.edu/helpdesk/page.php?id=9398.

Reference Point: The table under the "Excel" section identifies .xltx as the "Excel Template" file extension.

3. Indiana University

University Information Technology Services (UITS). (2018

April 18). File formats for saving documents in Office 2016. UITS Knowledge Base. Retrieved from https://kb.iu.edu/d/aofp.

Reference Point: The section on "Excel 2016" lists .xltx and describes it as "Excel Template." It also correctly identifies .potx (and by extension

the legacy .pot) as a PowerPoint Template.

The primary function of the Table Styles feature in Excel is to apply a predefined collection of formatting attributes—such as colors, fonts, borders, and banded rows—to a structured table. This allows for the quick and efficient application of a uniform and professional appearance. By using the same style across multiple tables within a workbook or across different workbooks, users can ensure visual consistency, which improves readability and adherence to branding or reporting standards. Users can also create custom table styles for reuse.

A. This is too general. While styles do create a visual representation, their specific function is to apply a consistent, pre-packaged set of formatting rules efficiently.

B. This is incorrect. Charts and graphs are entirely separate features in Excel used for data visualization; they are not created or managed by the Table Styles feature.

D. This is inaccurate. Table Styles are designed specifically for Excel Table objects (created via Insert > Table or Ctrl+T), not for arbitrary areas or ranges on a worksheet.

1. Microsoft 365 Support Documentation. In the article "Format an Excel table

" it states

"Excel has several predefined table styles that you can use to quickly format a table." It further explains how to modify and create custom styles

emphasizing the application of a consistent format. (Microsoft Corporation. (n.d.). Format an Excel table. Microsoft Support. Retrieved from support.microsoft.com)

2. Microsoft 365 Support Documentation. The article "Create or delete a custom table style" details the process of creating a new style that can be reused. It notes

"After you create a custom table style

it is available... to apply to any new tables that you create in that workbook." This directly supports the function of applying consistent formatting. (Microsoft Corporation. (n.d.). Create or delete a custom table style. Microsoft Support. Retrieved from support.microsoft.com)

3. University of Wisconsin-Madison

Courseware. In Excel training materials

the purpose of table styles is described as a way to "quickly add professional-level formatting to a table of data." The reusability of these styles is a key benefit highlighted for maintaining a consistent look. (University of Wisconsin-Madison. (n.d.). Excel: Tables. Software Training for Students. Retrieved from sts.doit.wisc.edu/excel-tables/)

The AVERAGE function is a fundamental statistical function in Microsoft Excel. Its purpose is to calculate the arithmetic mean of a set of numeric values. The function sums the numbers provided as arguments (which can be numbers, cell references, or ranges) and then divides by the count of those numbers. It is important to note that the function ignores text, logical values, and empty cells, but it does include cells containing the value zero in its calculation.

A. This describes the functionality of the MATCH function, which is used to find the relative position of an item in a range.

C. This describes the purpose of lookup functions like VLOOKUP or XLOOKUP, which search for a value and retrieve a corresponding value from another column.

1. Microsoft Corporation. (n.d.). AVERAGE function. Microsoft Support. Retrieved from https://support.microsoft.com/en-us/office/average-function-047bac88-d466-426c-a32b-8f33eb960cf6

Reference Detail: In the "Description" section

the document states

"Returns the average (arithmetic mean) of the arguments."

2. University of California

Berkeley Library. (n.d.). Commonly Used Excel Formulas. UC Berkeley Library Data Lab. Retrieved from https://guides.lib.berkeley.edu/excel/formulas

Reference Detail: In the "Commonly Used Formulas" table

the AVERAGE function is defined as: "Finds the average of the numbers in a range of cells. =AVERAGE(A2:A10)".

The keyboard shortcut Ctrl + Shift + # is used in Microsoft Excel to apply the Date format to the selected cell or range of cells. This command formats the cell's content to display as a date in the dd-mmm-yy format. For example, if a cell contains the serial number 45000, applying this shortcut will change the display to 17-Jul-23. This is a quick method for formatting numerical data into a standard date representation without navigating through the Format Cells dialog box.

B. The shortcut to apply the Time format is Ctrl + Shift + @.

C. The shortcut to apply the Currency format is Ctrl + Shift + $.

D. The shortcut to apply the Number format (with two decimal places and a thousands separator) is Ctrl + Shift + !.

1. Microsoft Support. (n.d.). Keyboard shortcuts in Excel. Microsoft. Retrieved from https://support.microsoft.com/en-us/office/keyboard-shortcuts-in-excel-1798d9d5-842a-42b8-9c99-9b7213f0040f.

Reference Location: Under the section "Ctrl combination shortcut keys

" the table lists Ctrl+Shift+# with the description "Applies the Date format with the day

month

and year."

2. Indiana University. (2023

October 25). Excel keyboard shortcuts. University Information Technology Services Knowledge Base. Retrieved from https://kb.iu.edu/d/aacc.

Reference Location: In the "Formatting" section

the table entry for "Date format" specifies the shortcut Ctrl+Shift+#.

3. University of Wisconsin-Madison. (2020

July 20). Excel - Keyboard Shortcuts. Division of Information Technology (DoIT) KnowledgeBase. Retrieved from https://kb.wisc.edu/showcase/page.php?id=92544.

Reference Location: Under the "Formatting" subsection

the shortcut Ctrl+Shift+# is listed for applying the "Date format (dd-mm-yy)."

The keyboard shortcut Ctrl + ; (Control key plus the semicolon key) is the designated command in Microsoft Excel to insert the current system date into the active cell. This action inserts the date as a static value, meaning it will not update automatically like the TODAY() function. This is a fundamental and widely documented data entry shortcut within the application.

B. Ctrl + Shift + ;

This shortcut inserts the current system time, not the date, into the active cell.

C. Shift + ;

This key combination simply types a colon (:) character into the cell.

D. Alt + ;

This shortcut is used to select only the visible cells within a selected range, ignoring any hidden rows or columns.

1. Microsoft Corporation. (n.d.). Keyboard shortcuts in Excel. Microsoft Support. Retrieved from support.microsoft.com. In the section "Ctrl key combination shortcuts

" the documentation explicitly states: "Ctrl+; (semicolon) Enter the current date." and "Ctrl+Shift+; (semicolon) Enter the current time."

2. Indiana University. (2023

October 24). Keyboard shortcuts for Microsoft Excel. University Information Technology Services Knowledge Base. Retrieved from kb.iu.edu/d/acik. The "Data entry" section lists: "Ctrl+; Insert the current date."

3. University of Wisconsin-Madison. (2019

July 1). Excel - Keyboard Shortcuts. Division of Information Technology (DoIT). Retrieved from kb.wisc.edu/showcase/page.php?id=93310. The document lists "Ctrl + ;" with the description "Insert current date."

The "Remove Duplicates" function is the designated tool in Microsoft Excel for permanently deleting rows that contain duplicate values. Located on the 'Data' tab within the 'Data Tools' group, this feature allows the user to select one or more columns to check for duplicate information. When executed, Excel removes the entire row for all duplicate entries found after the first instance, thus cleaning the dataset.

B. The “Fill Handle” function is used to copy cell contents or to continue a data series into adjacent cells; it does not remove data.

C. The “Find and Replace” function is used to locate specific values and substitute them with others, not to identify and remove duplicate rows.

D. The “Filter” function temporarily hides rows that do not meet specified criteria but does not permanently delete the duplicate data from the worksheet.

1. Microsoft Corporation. (n.d.). Find and remove duplicates. Microsoft Support. Retrieved from https://support.microsoft.com/en-us/office/find-and-remove-duplicates-00e35321-5e25-404d-9199-6e7353882713. (This official documentation directly describes the "Remove Duplicates" command under the "Data Tools" group on the "Data" tab.)

2. University of California

Berkeley Library. (n.d.). Excel: Remove Duplicates. Data-services. Retrieved from https://data-services.hosting.berkeley.edu/training/excel-remove-duplicates. (This university guide explicitly details the step-by-step process for using the "Remove Duplicates" feature to clean data.)

3. MIT Libraries. (n.d.). Excel 2016: Data Cleaning and Preparation. LibGuides at MIT Libraries. Retrieved from https://libguides.mit.edu/c.php?g=559451&p=3848248. (Under the "Removing Duplicates" section

this resource confirms that the "Remove Duplicates" tool on the Data tab is the standard method for this task.)

In Microsoft Excel, the caret symbol ^ is an arithmetic operator used for exponentiation (raising a number to a power). It is not a logical, or comparison, operator. Logical operators are used to compare values and result in a Boolean value of TRUE or FALSE. The symbols >, >=, and < are all valid logical operators in Excel used for "greater than," "greater than or equal to," and "less than" comparisons, respectively.

B: The > (greater than) symbol is a valid logical comparison operator used to test if one value is greater than another.

C: The >= (greater than or equal to) symbol is a valid logical comparison operator in Excel.

D: The < (less than) symbol is a valid logical comparison operator used to test if one value is less than another.

1. Microsoft Corporation. (n.d.). Calculation operators and precedence in Excel. Microsoft Support. Retrieved from https://support.microsoft.com/en-us/office/calculation-operators-and-precedence-in-excel-48be406d-4975-4d31-b2b8-7af9e0e2878a.

Reference Details: Under the section "Types of operators

" the article lists ^ (caret) as an "Arithmetic operator" for "Exponentiation." The operators >

>=

and < are listed under the "Comparison operators" section.

2. Indiana University. (2023

October 10). Operators in Excel formulas. University Information Technology Services (UITS) Knowledge Base. Retrieved from https://kb.iu.edu/d/afrq.

Reference Details: The document provides a table of operators. It lists ^ as the "Exponent" operator. It separately lists >

>=

and < in the "Comparison" operators category.

3. University of Wisconsin-Madison. (n.d.). Excel - Formulas and Functions - The Basics. Software Training for Students. Retrieved from https://sts.doit.wisc.edu/wp-content/uploads/sites/133/2020/01/Excel-Formulas-and-Functions-The-Basics.pdf.

Reference Details: On page 2

under the "Operators" section

the document lists "Comparison Operators" (=

>

<

>=

<=

) and "Arithmetic Operators" (+

-

/

%

^)

clearly distinguishing the caret ^ as arithmetic

not logical/comparison.

The SUMIF function is used to sum values in a range that meet a specific criterion. This criterion can be expressed in relation to a percentage. For example, the formula =SUMIF(A1:A10, ">50%") would sum all the values in the range A1:A10 that are greater than 0.5. This directly addresses the "add values based on a specified percentage" part of the question. While no single function listed performs both addition and subtraction in this context, SUMIF is the only one that performs conditional summation based on criteria, which can include percentages.

A. AVERAGEIF: This function calculates the conditional average of values that meet a specific criterion; it does not sum or subtract them.

C. PMT: This is a specialized financial function for calculating loan payments based on an interest rate (a percentage), not for general conditional arithmetic.

D. PERCENTILE: This statistical function finds the value at a specific percentage rank within a dataset (e.g., the 90th percentile). It does not add or subtract values.

1. Microsoft 365 Support Documentation. The official documentation for the SUMIF function states its purpose is to "sum the values in a range that meet criteria that you specify." The examples demonstrate its use with logical operators

which can be applied to percentage criteria.

Source: Microsoft Corporation. (n.d.). SUMIF function. Microsoft 365 Support. Retrieved from https://support.microsoft.com/en-us/office/sumif-function-169b8c99-c05c-4483-a712-1697a653039b

2. Microsoft 365 Support Documentation. The documentation for the PERCENTILE.INC function clarifies that it "Returns the k-th percentile of values in a range

where k is in the range 0..1

inclusive

" confirming its purpose is for statistical ranking

not arithmetic operations like adding or subtracting.

Source: Microsoft Corporation. (n.d.). PERCENTILE.INC function. Microsoft 365 Support. Retrieved from https://support.microsoft.com/en-us/office/percentile-inc-function-680f9539-45eb-410b-9953-74f40290a86b

3. University of Washington

Foster School of Business. Course materials for "Excel for Business" (e.g.

OPMGT 301) describe the use of conditional functions. They explain that SUMIF is used for "summing cells in a range that meet a single criterion

" distinguishing it from arithmetic formulas used for increasing or decreasing a value by a percentage.

Source: Foster School of Business. (n.d.). Excel 2016: Core Part 3: Formulas and Functions. University of Washington. (Specific course materials illustrate the distinct applications of SUMIF vs. basic percentage calculations).

The shortcut Ctrl+X executes the "Cut" command in Excel. This action removes the content and formatting of the selected cell(s) and places it on the clipboard. While the primary shortcut to open the "Delete" dialog box (which removes the cell itself and shifts adjacent cells) is Ctrl+- (Control and the minus sign), this option is not provided. Among the given choices, the "Cut" command is the only one that involves removing the cell's contents from its original location, making it the best fit for the question's intent.

A. Ctrl+C: This is the shortcut for "Copy." It duplicates the cell's content to the clipboard without altering the original cell.

B. Ctrl+Z: This is the shortcut for "Undo." It reverses the last action performed and is not a primary deletion command.

C. Ctrl+D: This is the shortcut for "Fill Down." It copies the content and format from the top cell of a selected range into the cells below it.

1. Microsoft Corporation. (n.d.). Keyboard shortcuts in Excel. Microsoft Support. Retrieved from https://support.microsoft.com/en-us/office/keyboard-shortcuts-in-excel-1798d9d5-842a-42b8-9c99-9b7213f0040f.

Reference Point: In the "Frequently used shortcuts" section

the documentation explicitly states: Ctrl+X is used to "Cut the selected cells." It also lists Ctrl+C for "Copy

" Ctrl+Z for "Undo

" and Ctrl+D to "Use the Fill Down command."

2. University of Wisconsin-Madison. (n.d.). Excel: Keyboard Shortcuts. Software Training for Students.

Reference Point: The courseware document lists common editing shortcuts

identifying Ctrl + X as "Cut

" Ctrl + C as "Copy

" and Ctrl + Z as "Undo

" confirming their distinct functions from deletion.

A macro in Microsoft Excel is a set of instructions or a recorded sequence of user actions (such as keystrokes, mouse clicks, and commands) that can be saved and executed repeatedly. The primary purpose is to automate repetitive or complex tasks, thereby saving time, reducing the potential for human error, and improving efficiency. By recording a series of steps, a user can perform that entire sequence with a single command, such as a button click or a keyboard shortcut.

A. Inserting a hyperlink is a specific, singular action that can be done without a macro; it is not the fundamental purpose of the macro feature.

B. Sorting data is a built-in Excel function. While a macro can include a sorting step, its core purpose is to automate a sequence of tasks, not just one.

C. Illustrating data with charts is a primary function of Excel's charting tools, not the macro feature itself, which is designed for automation.

1. Microsoft Corporation. (n.d.). Automate tasks with the Macro Recorder. Microsoft Support. Retrieved from support.microsoft.com. In the introductory paragraph

it states

"If you have tasks in Microsoft Excel that you do repeatedly

you can record a macro to automate those tasks. A macro is an action or a set of actions that you can run as many times as you want."

2. University of Washington

Foster School of Business. (n.d.). Introduction to Macros. In the section "What is a Macro?"

it is defined as: "A macro is a series of commands and functions that are stored in a Microsoft Visual Basic module and can be run whenever you need to perform the task."

3. University of Wisconsin-Madison. (n.d.). Excel - Getting Started with Macros. DoIT Academic Technology. In the "What is a macro?" section

it states

"A macro is a tool that allows you to automate tasks... You can record a sequence of actions in Excel to create a macro."