S3 Admin Excel Spreadsheet Formatting Assessment

What is a cell in Microsoft Excel?

• The horizontal arrangement of data in a spreadsheet

• The vertical arrangement of data in a spreadsheet

• The intersection of a row and column where data can be entered

• The menu bar at the top of the Excel window

Which of the following best describes a column in Excel?

• A horizontal arrangement of cells denoted by numbers (1, 2, 3, etc.)

• A vertical arrangement of cells denoted by letters (A, B, C, etc.)

• The entire spreadsheet document

• The menu bar at the top of the Excel window

In Excel, how are rows identified?

• By letters (A, B, C, etc.)

• By numbers (1, 2, 3, etc.)

• By colors

• By special symbols

What is the cell reference for the cell located at the intersection of column C and row 5?

• 5C

• C-5

• C5

• 5-C

Which Excel feature allows you to change the background color of cells?

• Font Color

• Cell Shading

• Text Wrap

• Cell Alignment

What happens when you apply "Wrap Text" to a cell in Excel?

• The text is cut off if it exceeds the cell width

• The text automatically continues onto the next cell

• The text is displayed on multiple lines within the cell

• The cell width automatically expands to fit the text

Which alignment option would you use to center text vertically in a cell?

• Horizontal Center

• Vertical Center

When formatting a cell to display currency in Excel, which symbol typically appears?

• %

• $

• #

• @

What is the purpose of tabs in Excel?

• To organize multiple worksheets within a workbook

• To indent text within a cell

• To navigate between different Excel files

• To create spaces between columns

How can you quickly format a range of cells to have the same formatting?

• Use the Format Painter tool

• Press Ctrl+C and then Ctrl+V

• Right-click and select "Apply to All"

• Use the Fill Handle to drag the formatting