Excel Quiz 2

What is the purpose of linking cells from one sheet to another in Excel?

• To create a copy of the data in the target sheet

• To apply formatting to cells in the target sheet

• To hide the data in the source sheet

• To display data from another sheet without duplicating it

In Excel, what is an absolute cell reference indicated by?

• A dollar sign ($) before the column letter and row number

• An asterisk (*) before the cell address

• An exclamation mark (!) before the cell address

• A pound sign (#) before the cell reference

When you copy a formula in Excel with relative addressing, how are cell references adjusted?

• They update based on the new position of the formula

• They convert to R1C1 style references

• They remain fixed as they are

• They become absolute references

In Excel, what is the purpose of creating a note (comment) in a cell?

• To highlight the cell with color

• To display additional information or context about the cell's content

• To lock the cell and prevent further editing

• To change the font size of the cell's content

How can you link to a cell in another workbook in Excel?

• Right-click the cell and choose 'Link to Workbook.'

• Use the 'Insert Hyperlink' option from the Ribbon

• Press Ctrl + L to open the Link dialog box

• Type the workbook name in the formula bar followed by an exclamation mark

When using 'Paste Special: Values' in Excel, what is copied and pasted?

• Only the numerical values from the cells

• The original formatting of the cells

• Formulas and their calculated results

• The comments and notes in the cells

In Excel, what is the purpose of using numeric filters?

• To filter data based on numeric criteria

• To change the font color of numeric values

• To hide all text values

• To sort data in ascending order

What is the purpose of Quick Sort in Excel?

• To sort data numerically from high to low

• To automatically apply cell formatting

• To quickly alphabetize text in a range

• To sort data based on multiple criteria

What does the 'Paste Special: Transpose' option do in Excel?

• Swaps rows and columns of the selected range

• Changes the font style of the copied data

• Copies the selected range to a different sheet

• Copies the formula in reverse order

What is the title of a chart in Excel?

• Chart Axis

• Chart Series

• Chart Title

• Chart Legend