NEW
Font size
WorksheetsS3 Admin Excel Spreadsheet Formatting Assessment
Total questions: 10
Worksheet time: 5mins
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
