Clipboard
What does the "Clipboard" group in the Home menu contain?
It contains options for Cut, Copy, Paste, and Format Painter
Where can you change the background color of a cell?
Answer: Use the Fill Color option in the Font group.
How can you increase the indentation of text in a cell?
Answer: Click the Increase Indent button in the Alignment group.
What is the "Conditional Formatting" option used for?
Answer: To apply color coding or data bars based on cell values.
How can you quickly apply a theme to a selection of cells?
Answer: Use the Cell Styles dropdown in the Styles group.
How do you copy the format of one cell to another?
Use the Format Painter in the Clipboard group
How do you align text in the center of a cell?
Answer: Use the Center alignment button in the Alignment group.
How do you format numbers as currency in Excel?
Answer: In the Number group, select Currency from the dropdown.
How do you clear the content and formatting of a cell?
Answer: Use the Clear button in the Editing group.
What option allows you to hide gridlines in a worksheet?
Answer: Uncheck Gridlines under the View tab, not the Home tab.
What is the shortcut to copy a cell's content?
Answer: Press Ctrl + C
What function does the "Merge & Center" option serve?
Answer: It merges multiple cells into one and centers the text.
What button quickly adds a sum formula in a column or row?
Answer: The AutoSum button in the Editing group.
How can you sort data from A to Z in Excel?
Answer: Click the Sort A to Z button in the Editing group.
How do you add a new row to a table in Excel?
Answer: Right-click a row number and select Insert, or use the Insert button in the Cells group.
Where can you change the font of a cell's text?
Answer: In the Font group under the Home tab
How can you wrap text in a cell to show all content?
Answer: Click the Wrap Text button in the Alignment group.
How do you change the decimal places in a number?
Answer: Use the Increase Decimal or Decrease Decimal buttons in the Number group.
Where can you find the "Find & Select" feature?
Answer: In the Editing group on the Home tab.
Where can you find the "Delete" option to remove rows or columns?
Answer: In the Cells group under the Home tab.
How do you make text bold in Excel?
Answer: Click the Bold (B) button in the Font group or press Ctrl + B
Where do you adjust cell borders in Excel?
Answer: In the Font group, use the Borders dropdown.
Where can you apply a table style to a selected range of cells?
Answer: Click the Format as Table option in the Styles group.
What does the "AutoFit" feature do?
: It adjusts the width or height of columns and rows to fit the contents.
What does the "Insert" option in the Cells group do?
Answer: It allows you to insert new cells, rows, or columns.