TestOut Excel test questions
and answers(with diagrams)
AutoFit
A feature that automatically adjusts the width and height of a
column, row, cell, or header.
Cell Borders
Draws an outline around a cell or group of cells.
Cell Styles
Predefined formatting options that can be applied to cells or groups
of cells.
Fill Color
The color of the cell background. By default, there is no fill color.
Merge and Center
Combines selected cells into one large cell, then centers the
content.
Number Formatting
Displays numerical information, such as a date, monetary value,
percentage, phone number, etc. Number formatting does not change
the value of the cell.
Wrap Text
When activated, text will begin a new line when it reaches the end
of a cell instead of continuing beyond the cell boundary.
, CSV
The Comma Separated Values extension is frequently used by
spreadsheet programs other than Excel and by data downloaded
from an Internet database
Spreadsheet
A document that stores and manipulates data in columns and rows
Workbook
A file that contains one or more related worksheets
Worksheet
A single spreadsheet within a workbook
XSLX
The default file extension for Excel workbooks
Freeze Panes
A frozen row or column that will stay visible on the screen no matter
where you scroll on the worksheet. A common application is to
freeze row and column titles on large worksheets.
Hide/Unhide
Hiding a row or column removes the information from view.
However, the information is not deleted, and can be viewed by
unhiding
Paste Formatting
This paste option applies the formatting from copied cells to
destination cells
Paste Values
This paste option enters the values of the copied cells. It does not
copy formulas or source formatting
Transpose
and answers(with diagrams)
AutoFit
A feature that automatically adjusts the width and height of a
column, row, cell, or header.
Cell Borders
Draws an outline around a cell or group of cells.
Cell Styles
Predefined formatting options that can be applied to cells or groups
of cells.
Fill Color
The color of the cell background. By default, there is no fill color.
Merge and Center
Combines selected cells into one large cell, then centers the
content.
Number Formatting
Displays numerical information, such as a date, monetary value,
percentage, phone number, etc. Number formatting does not change
the value of the cell.
Wrap Text
When activated, text will begin a new line when it reaches the end
of a cell instead of continuing beyond the cell boundary.
, CSV
The Comma Separated Values extension is frequently used by
spreadsheet programs other than Excel and by data downloaded
from an Internet database
Spreadsheet
A document that stores and manipulates data in columns and rows
Workbook
A file that contains one or more related worksheets
Worksheet
A single spreadsheet within a workbook
XSLX
The default file extension for Excel workbooks
Freeze Panes
A frozen row or column that will stay visible on the screen no matter
where you scroll on the worksheet. A common application is to
freeze row and column titles on large worksheets.
Hide/Unhide
Hiding a row or column removes the information from view.
However, the information is not deleted, and can be viewed by
unhiding
Paste Formatting
This paste option applies the formatting from copied cells to
destination cells
Paste Values
This paste option enters the values of the copied cells. It does not
copy formulas or source formatting
Transpose
