Excel 2

Which one is copy cells?

• 
• 
• 
• 

Which one did not use Fill Series but other functions?

• 
• 
• 
• 

Which one is Fill without formatting?

• 
• 
• 
• 

Column H is filled by texts and numbers, Column I is filled by only numbers. The numbers are same in both columns. How can I change contents of Column H to I?

• Flash Fill

• Change Number Formats

• Fill Series

• Wrap text

What is the content of Column F?

• Pure Number Series

• Random number series made by functions, the numbers showed will be change by refreshing

• Random number series made by functions, the numbers showed will NOT be change by refreshing

• Text

which selected cell is filled by number?

• 
• 
• 

How can I change number formats from column I to J?

• Add % after each number in Column J

• Find Number Formats->Percentage

• Find Number Formats->More Number Formats->Costum-> Add % after #,##0

• Find Number Formats->More Number Formats->Costum-> Add "%" after #,##0

What functions are added from the left column to the right one?(They are both numbers)

• Table, data bars (from conditional formats), $ (from number formats)

• Table, data bars (from conditional formats), $ ( typed in cells)

• Table, colour scales (from conditional formats), $ (from number formats)

• Table, data bars (from table), $ ( typed in cells)

What is function which changed the background colour of this list?

• Colour layer

• Colour Scales

• Shades

• data bars

Where can I find this function (filling the whole column by stars with one operation)?

• Home-> Conditional formats-> Icon sets

• Insert-> Icons

• Insert Table

• Home->Table