Excel Skills Assessment

What is Flash Fill used for in Excel?

• Flash Fill is used for automatically filling in data based on detected patterns.

• Flash Fill is used for performing complex calculations.

• Flash Fill is used for creating charts in Excel.

• Flash Fill is used for managing Excel file permissions.

What is the purpose of the Paste Special feature?

• To merge multiple documents into one.

• To provide advanced options for pasting data in a document.

• To delete data from a document.

• To copy data without formatting.

Explain the difference between absolute and relative referencing.

• Absolute referencing keeps the reference fixed; relative referencing adjusts based on the new location.

• Absolute referencing is used only in spreadsheets, while relative referencing is for programming.

• Both absolute and relative referencing are the same in functionality.

• Absolute referencing changes with the location; relative referencing remains fixed.

What is a common use case for conditional formatting?

• Creating pivot tables for analysis.

• Filtering rows based on specific criteria.

• Sorting data in ascending order.

• Highlighting cells based on their values.

What is multilevel sorting and how is it performed?

• It involves sorting data based on a single criterion only.

• Multilevel sorting is only applicable to numerical data.

• Multilevel sorting is a method for merging datasets without any sorting.

• Multilevel sorting is sorting data based on multiple criteria, performed by sorting first by the primary key and then by secondary keys.

What is the function of the COUNTA formula?

• The COUNTA formula calculates the average of a range.

• The COUNTA formula counts non-empty cells in a range.

• The COUNTA formula counts only empty cells in a range.

• The COUNTA formula finds the maximum value in a range.

How does mixed referencing work in Excel?

• Mixed referencing is a feature that only applies to text formatting in Excel.

• Mixed referencing is used to create charts in Excel.

• Mixed referencing allows you to lock both the row and column simultaneously.

• Mixed referencing allows you to lock either the row or the column in a cell reference using the dollar sign ($).

What is the difference between COUNT and COUNTA?

• COUNT counts numeric values; COUNTA counts all non-empty cells.

• COUNT counts unique values; COUNTA counts duplicates.

• COUNT counts text values; COUNTA counts only empty cells.

• COUNT counts all cells; COUNTA counts only numeric values.

How can you use Flash Fill to clean up data?

• Use Flash Fill to automatically format or extract data by typing an example of the desired output next to your data.

• Use Flash Fill to manually enter data for each cell.

• Use Flash Fill to create a new spreadsheet from scratch.

• Use Flash Fill to delete all data in a column.

What is the significance of using absolute references in formulas?

• They allow for automatic updates of cell references.

• Absolute references are not necessary in complex formulas.

• Absolute references lock the cell reference, ensuring consistent data usage in formulas.

• Absolute references are only used for text formatting.