Both Shift + F11 and Alt + Shift + F1 are officially documented keyboard shortcuts in Microsoft Excel to insert a new worksheet into the active workbook. These shortcuts add a new sheet to the left of the currently selected sheet tab. The shortcut Ctrl + N, listed as option C, performs a different function; it creates an entirely new, blank workbook file, not a new worksheet within the existing file. Therefore, options B and D are the correct answers to the question.

A. Ctrl + Shift + N: This shortcut is not a default command in Excel for inserting a new worksheet. It is commonly used in other applications, like creating a new folder in File Explorer.

C. Ctrl + N: This shortcut creates a new, blank workbook (a separate .xlsx file), not a new worksheet within the currently open workbook.

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.

Specific Location: Under the "Ctrl key combination shortcuts" section

it lists Ctrl+N for "Create a new

blank workbook."

Specific Location: Under the "Function key shortcuts" section

it lists Shift+F11 to "Insert a new worksheet." It also lists Alt+Shift+F1 for the same action.

2. University of Wisconsin-Madison

Division of Information Technology (DoIT). (n.d.). Excel: Keyboard Shortcuts (PC). KB User's Guide. Retrieved from https://kb.wisc.edu/showcase/page.php?id=93553.

Specific Location: In the "Worksheet" section

the document lists Shift + F11 to "Insert a new worksheet." In the "Workbook" section

it lists Ctrl + N to "Create a new workbook."

The question is technically flawed as all listed options are valid chart types in modern versions of Excel (2019/Microsoft 365). However, the question likely distinguishes between fundamental and specialized chart types. Pie, Bar, and Line charts are primary chart types, each with a dedicated icon in the main "Charts" group of the Insert tab. A Histogram is a specialized statistical chart, available since Excel 2016, which is located in the "Insert Statistic Chart" sub-menu. Given this distinction in access and classification within the Excel interface, the Histogram is the intended answer as it is not a primary chart type in the same category as the others.

A. Pie Chart: This is a fundamental, built-in chart type in Excel used to show the proportional distribution of data in a single series.

B. Bar Chart: This is a standard, primary chart type in Excel used to compare values across different categories, with horizontal bars.

C. Line Chart: This is a core chart type in Excel, commonly used to display trends in data over time or ordered categories.

1. Microsoft Support. (n.d.). Available chart types in Office. Microsoft. Retrieved from https://support.microsoft.com/en-us/office/available-chart-types-in-office-a6187218-807e-4103-9e0a-272112e7b08e. This official documentation lists Pie

Bar

Line

and Histogram charts among the available types

confirming all are valid in Excel.

2. Microsoft Support. (n.d.). Create a histogram. Microsoft. Retrieved from https://support.microsoft.com/en-us/office/create-a-histogram-85680173-064b-4024-b39d-85f53b5f2695. This document outlines the specific steps for creating a histogram

noting it is found by clicking "Insert" > "Insert Statistic Chart" > "Histogram

" which differentiates its access from primary chart types like Pie or Line.

The SUMIF() function is specifically designed to calculate the sum of values in a range that meets a single, specified condition or criterion. The function's syntax is SUMIF(range, criteria, [sumrange]), where it evaluates the range against the criteria and sums the corresponding cells in the sumrange. This directly addresses the question's requirement to sum cells based on "a certain condition" (singular).

A. SUMIFS() is designed to sum cells based on multiple conditions or criteria, making it less precise for the single-condition scenario described in the question.

B. While both functions can sum cells, SUMIF() is the specific function for a single condition. The question asks for "the formula," implying the most direct tool.

D. AVERAGEIF() and AVERAGEIFS() are incorrect because they calculate the average of cells that meet criteria, not the sum.

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

Reference Detail: The official documentation states

"Use SUMIF

one of the statistical functions

to sum the values in a range that meet criteria that you specify." This confirms its use for a single criterion.

2. Microsoft Corporation. (n.d.). SUMIFS function. Microsoft Support. Retrieved from https://support.microsoft.com/en-us/office/sumifs-function-c9e748f5-7ea7-455d-9406-611cebce642b

Reference Detail: The documentation for SUMIFS states

"The SUMIFS function adds all of its arguments that meet multiple criteria." This highlights its primary purpose for handling more than one condition.

3. University of Wisconsin-Madison. (n.d.). Excel - SUMIF and SUMIFS Functions. Division of Information Technology (DoIT). Retrieved from https://kb.wisc.edu/showcase/page.php?id=93515

Reference Detail: The article explicitly distinguishes the two functions: "The SUMIF function is used to conditionally sum values based on a single criterion." and "The SUMIFS function is used to conditionally sum values based on multiple criteria."

The IF function is a fundamental logical function in Microsoft Excel used for decision-making. It performs a logical test on a condition you specify. Based on the outcome of this test, it returns one of two possible values. If the condition evaluates to TRUE, the function returns the first specified value (valueiftrue); if the condition evaluates to FALSE, it returns the second specified value (valueiffalse). Its syntax is IF(logicaltest, valueiftrue, valueiffalse).

A. The NOW() and TODAY() functions are used to display the current date and time, not the IF function.

B. The ROUND() function and its variations (ROUNDUP, ROUNDDOWN) are used for rounding numbers, not the IF function.

D. Inserting a picture is a feature accessed via the 'Insert' tab or, in newer versions, the IMAGE function, not the IF function.

1. Microsoft Corporation. (n.d.). IF function. Microsoft 365 Support. Retrieved from https://support.microsoft.com/en-us/office/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2.

Reference Point: The "Description" section states

"The IF function... allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The first result is if your comparison is True

the second if your comparison is False."

2. MIT Libraries. (n.d.). Excel 2016: The Basics - Logical Functions. MIT LibGuides. Retrieved from https://libguides.mit.edu/c.php?g=175963&p=1159043.

Reference Point: Under the "Logical Functions" heading

the guide describes the IF function: "The IF function returns one value if a condition you specify evaluates to TRUE

and another value if that condition evaluates to FALSE."

3. University of Wisconsin-Madison. (n.d.). Excel - The IF Function. UW-Madison KnowledgeBase. Retrieved from https://kb.wisc.edu/showcase/page.php?id=2545.

Reference Point: The introductory paragraph states

"The IF function allows you to test a condition and returns a specific value if the condition is TRUE

or another value if the condition is FALSE."

The vertical spacing between data points (e.g., in a bar chart) is adjusted using the "Gap Width" and "Series Overlap" options. These settings are located in the "Format Data Series" task pane. This pane is accessed by selecting the data series and then clicking the "Format Selection" button on the Format tab, or by double-clicking the data series directly.

While the question incorrectly places the option on the "Design" tab, "Format Selection" is the only command listed that opens the necessary controls for this specific formatting task. The other options apply broader, predefined changes to the chart's overall structure or appearance.

A. Add Chart Element: This command is used to add, remove, or position chart components like titles, legends, and gridlines, not to adjust data point spacing.

C. Chart Styles: This applies a predefined gallery of visual styles, including colors and effects, to the entire chart, but does not offer direct control over data spacing.

D. Choose Chart Layout: This option (known as "Quick Layout") applies a predefined arrangement of chart elements, not the granular spacing between individual data points in a series.

1. Microsoft Support Documentation: In the article "Change the gap width in a chart

" the official procedure is detailed: "Right-click a data series

and then click Format Data Series." The "Format Data Series" pane that opens is the same one launched by the "Format Selection" command on the Format tab. This document confirms that neither the Design tab nor the other options are used for this task.

Source: Microsoft 365 Support

"Change the gap width in a chart

" Section: "Change the gap width and overlap."

2. Microsoft Learn (Official MO-211 Path): The learning path for the MO-211 exam

"Excel: Creating and formatting charts

" specifies the method for detailed formatting: "To format any element of a chart

you can double-select it to open a formatting task pane." This action opens the same pane as "Format Selection" and is the correct procedure for modifying series options like gap width.

Source: Microsoft Learn

Module: "Excel: Creating and formatting charts

" Unit: "Format charts."

3. University of Wisconsin-Madison Courseware: In their Excel 2019 course materials

the process for modifying chart data series is outlined. It specifies using the "Format" tab and the "Format Selection" button or right-clicking the element to access the format pane where gap width can be changed.

Source: University of Wisconsin-Madison

"Excel 2019 - Part 4: Charts

" Page 7

Section: "Formatting a Data Series."

The officially documented keyboard shortcut to insert a new worksheet in Microsoft Excel is Shift+F11. This command adds a new sheet to the left of the currently active sheet. An alternative shortcut for the same action is Alt+Shift+F1. The other options listed are not standard, default shortcuts for this function within Excel.

A. Ctrl+Alt+N is not a default keyboard shortcut for inserting a new sheet or any other common function in Microsoft Excel.

C. Ctrl+Shift+K is not a recognized default shortcut for inserting a new worksheet within the standard Excel environment.

D. Ctrl+Shift+N is a common shortcut in Windows File Explorer to create a new folder, not for inserting a new sheet in Excel.

1. Microsoft Support Documentation: "Keyboard shortcuts in Excel". Under the section "Work with worksheets

" the official documentation lists Shift+F11 and Alt+Shift+F1 as the shortcuts to "Insert a new worksheet."

2. University of Wisconsin-Madison

Division of Information Technology: "Excel: Keyboard Shortcuts (PC)". This university resource lists Shift + F11 under the "Worksheet" category with the description "Insert a new worksheet."

The Compatibility Checker is a diagnostic tool in Microsoft Excel designed to identify potential issues when a workbook is saved in an older file format (e.g., .xls for Excel 97-2003). It scans the workbook for features, functions, and formatting that are not supported or will function differently in the selected earlier version. The tool generates a report detailing any "significant loss of functionality" or "minor loss of fidelity," allowing the user to make informed decisions before saving to ensure the file remains usable for recipients with older software.

A. Creating a digital signature is handled by the 'Add a Digital Signature' feature, which is used for security and authentication.

C. Highlighting cells with errors is the function of the 'Error Checking' tool or can be achieved with conditional formatting rules.

D. Protecting a workbook from editing is accomplished using features like 'Protect Sheet,' 'Protect Workbook,' or 'Mark as Final.'

1. Microsoft Corporation. (n.d.). Check file compatibility with earlier versions of Excel. Microsoft Support. Retrieved from support.microsoft.com.

Reference Details: The article explicitly states

"When you create a workbook in a newer version of Excel

but it will be opened in an earlier version of Excel

it's a good idea to run the Compatibility Checker... The Compatibility Checker finds potential compatibility issues and helps you create a report so that you can resolve them."

2. University of Michigan. (n.d.). Saving Microsoft Excel Workbooks for Backwards Compatibility. ITS Documentation.

Reference Details: In the section on saving for older versions

the documentation explains that Excel automatically runs a "Compatibility Checker" to warn users about features that may be lost or changed when saving to the Excel 97-2003 (.xls) format. This confirms the tool's purpose is to check for version-specific feature compatibility.

The ROWS function is designed to return the total number of rows within a specified range, array, or table reference. When applied to a structured Excel table (e.g., ROWS(TableName)), it accurately returns the count of all data rows. This count directly corresponds to the index number of the last row in that table. This value is then frequently used as an argument within other functions, like INDEX, to dynamically reference the contents of the table's final row. Therefore, ROWS is the fundamental function for identifying the last row's position.

A. INDEX retrieves a value from a specified row number; it does not determine which row is the last one on its own.

B. COUNTA counts non-empty cells and is unreliable for finding the last row if the table contains blank cells within its data body.

C. VLOOKUP is a lookup function that searches for a specific value in a column, not one that references a row by its position.

1. Microsoft Corporation. (n.d.). ROWS function. Microsoft Support. Retrieved from https://support.microsoft.com/en-us/office/rows-function-b592593e-3f42-4620-b60b-20bdba34ae37. The documentation states

"Returns the number of rows in a reference or array

" which is the core requirement for identifying the last row's index in a table.

2. Microsoft Corporation. (n.d.). Using structured references with Excel tables. Microsoft Support. Retrieved from https://support.microsoft.com/en-us/office/using-structured-references-with-excel-tables-f5ed2452-2337-4f71-bed3-c8ae6d2b276e. This official guide explains how functions operate on table objects

where ROWS(Table1) would count the data rows.

3. Microsoft Corporation. (n.d.). INDEX function. Microsoft Support. Retrieved from https://support.microsoft.com/en-us/office/index-function-a5dcf0dd-996d-40a4-a822-b56b061328bd. The syntax INDEX(array

rownum

[columnnum]) shows it requires the rownum as an input

which the ROWS function would provide to target the last row.

The COUNTIF function is the correct formula for this task. It is designed to count the number of cells within a specified range that meet a single, user-defined criterion. The syntax is COUNTIF(range, criteria), where 'range' is the group of cells to evaluate and 'criteria' is the condition, such as specific text, that a cell must meet to be counted. For example, the formula COUNTIF(A2:A10, "London") counts how many cells in the range A2:A10 contain the exact text "London".

A. COUNT() only counts cells that contain numerical values and ignores any cells containing text.

B. COUNTA() counts all non-empty cells in a range, regardless of their content (text, numbers, etc.), and cannot filter by specific criteria.

C. COUNTIFS() is used to count cells that meet multiple criteria across one or more ranges; COUNTIF is the more direct function for a single criterion.

1. Microsoft Corporation. (n.d.). COUNTIF function. Microsoft Support. Retrieved from https://support.microsoft.com/en-us/office/countif-function-e0de10c6-f885-4e71-abb4-1f464816df34.

Reference Point: The first paragraph states

"The COUNTIF function counts the number of cells that meet a criterion..." The article provides syntax and examples for counting cells with specific text.

2. Microsoft Corporation. (n.d.). COUNT function. Microsoft Support. Retrieved from https://support.microsoft.com/en-us/office/count-function-a59cd7fc-b623-4d93-87a4-d23bf411294c.

Reference Point: The "Syntax" section and initial description clarify that this function only counts cells containing numbers.

3. University of Wisconsin-Madison. (n.d.). Excel: Formulas - Using COUNTIF. Software Training for Students. Retrieved from https://it.wisc.edu/services/software-training-for-students-sts/self-study-training-resources/excel-formulas/using-countif/.

Reference Point: The section "Using COUNTIF with Text" explicitly demonstrates how to use the function to count cells based on a text criterion

stating

"The COUNTIF function can also be used to count the number of cells that contain a certain text."

The keyboard shortcut Ctrl + N is used to create a new, blank workbook in Microsoft Excel. A new workbook, by default, contains at least one new worksheet. While the specific shortcut to insert a new worksheet into an existing workbook is Shift + F11, this option is not provided. Among the given choices, Ctrl + N is the only command that results in the creation of a new worksheet, making it the correct answer in this context.

A. Ctrl + A: This shortcut selects all cells and objects in the active worksheet; it does not create a new one.

B. Ctrl + W: This shortcut closes the active workbook window.

C. Ctrl + S: This shortcut saves the active workbook.

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. (See the section "Ctrl key combination shortcuts

" which lists Ctrl+N for "Create a new

blank workbook.")

2. MIT Sloan School of Management. (2016). Excel 2016 Core: Part 1. Massachusetts Institute of Technology. Page 6

"File Tab & Backstage View

" lists Ctrl+N as the shortcut for "New Workbook."

3. University of Wisconsin-Madison. (n.d.). Excel: Keyboard Shortcuts. Software Training for Students. Retrieved from https://it.wisc.edu/services/software-training-for-students-sts/. (This resource

under its Excel materials

confirms Ctrl+N for creating a new workbook.)