CIS Excel Quiz

Which of the following is the correct syntax for the VLOOKUP function in Excel?

=VLOOKUP(lookup_value, table_array, column_index, range_lookup)

Which Excel function can be used to determine if a cell meets a specified condition and returns one value if true and another value if false?

IF()

Which of the following combinations would allow you to view formulas as they were typed into a worksheet as opposed to the formula outputs?

Click the Show Formula button in the Formula tab of the Ribbon.

Which of the following is a feature of Excel for range formatting?

Applying a custom number format to display values in a specific way, such as adding commas to large numbers.

A1 is an example of a cell address:

True

Which Excel feature is used to highlight cells based on their values or conditions?

Conditional Formatting

What is the difference between a workbook and worksheet in Excel?

A workbook in Excel is a file that contains multiple worksheets

In Excel, which of the following statements about VLOOKUP function is correct?

VLOOKUP is used to search for a value in the first column of a range and return a corresponding value from a specified column.

When you open a new workbook it could contain multiple worksheets with cells, rows, and columns.

True

What is the main purpose of a Pivot Table?

It enables summarizing and analyzing large datasets by grouping and aggregating data.

Which keyboard command can be used to format data as a table?

Command +T( MAC)/ CTRL+ T (WINDOWS)

If the criteria for COUNTIF is entered directly into the formula, it must be a text string.

True

The following was entered into an Excel worksheet:=SUM(A7:A17). Which of the following is true with this entry?

The values in cell A7 and cells up to and including A17 will be summed.

Which of the following statements about the VLOOKUP function in Excel is true?

VLOOKUP can only return a value from a column located to the right of the lookup column

Which Excel feature is used to organize and analyze large amounts of data in a structured format?

PivotTable

=B$6/B$10 is an example of what reference type?

Mixed reference

Which Excel feature is used to combine multiple cells into a single cell?

Merging

Which of the following is a valid cell reference in Excel?

A$1

Which of the following is a feature of Excel "PasteSpecial"

Transporting the data from rows to columns or vice versa.

What is the primary purpose of the "Filter" feature in Microsoft Excel?

Displaying specific data that meets certain criteria, while hiding the rest.

Which Paste Special option pastes just the cell contents without any formatting?

Values

What is the main purpose of the COUNTIF function in Excel?

Counting the numbers of cells within a range that meets a specific condition.

What is the main purpose of the SOLVER?

It solves optimization problems by finding the best possible solution based on specified constraints.

Which feature allows you to find the input value needed to achieve a specific goal or target for a formula?

Goal Seek

An absolute reference is used to turn off relative referencing so that when the formula is copied or to a different location it doesn't change.

True

Which type of chart in Microsoft Excel is best suited for displaying trends over time?

Line Chart

Which of the following is a special feature of Excel tables?

Automatic data sorting and filtering capabilities.

What is the main difference between Solver and Goal Seek?

Solver is a tool that can handle complex problems with multiple variables while Goal Seek is a simpler tool that can only find a single input value to achieve a specific target output.

What does the "Sort" feature in Microsoft Excel allow you to do?

Rearrange data in a selected range based on specified criteria, such as alphabetical order or numerical value.

What does the "PIE CHART" in Microsoft Excel represent?

The proportion of each data point in a series to the sum of all data points, shown as slices of a circle.

What is the relation between function and formula in Excel?

A function is a pre-built formula that performs specific calculations or operations on data.

If you have a single-variable, "what if" analysis what is the appropriate Excel tool to use?

Goal Seek

What is the primary benefit of using the "Sort" feature in Microsoft Excel?

It organizes data in a specific order, making it easier to analyze and find information.

What is the file extension for an Excel workbook in the latest version of Microsoft Excel?

.xlsx

Which of the following is a common mathematical operator used in Excel formulas?

*

What is the purpose of the "Values" field in a Pivot Table?

It specifies the calculations to be performed on the data, such as sum, average, or count.

The filter command lets you reorder rows based on the contents of a selected column.

False

What do you create when you use one field in the source data for your pivot table row labels and another source field for pivot table column labels?

Cross-tabulation

If a column is too narrow for the data in it, numbers will appear as what type of string?

#####

If the fourth parameter in a VLOOKUP function is set as FALSE it forces VLOOKUP to look for an exact match to the lookup value.

True

What type of chart is best suited for showing the relationship between two sets of numerical data in Microsoft Excel?

Scatter Chart