BCIS 1305 Word & Excel Exam
Questions and Answers
In Microsoft Excel, the file you create & edit is called? - Answer-Workbook
By default, Excel 2019 files are saved with this extension? - Answer-.xlsx
Text in a worksheet that displays a name, a main title, row or column titles, and similar descriptive
information is called a(n): - Answer-label
When you click on a cell to activate it, the cell address appears in the: - Answer-name box
When you want to delete characters in a cell to the left of the insertion point press: - Answer-Backspace
A new Excel workbook uses the default theme named: - Answer-office
A rectangle group of cells in Excel is called a(n): - Answer-Range
The thin black plus sign pointer is used to: - Answer-Copy cell contents or complete a series
, To quickly select all the cells in a worksheet: - Answer-Press Clt+A
After you select and cut cells, the cells are temporarily placed - Answer-On the Clipboard
In Excel worksheet dates and times are: - Answer-Values
When you want column and row headings displayed whether you are at the top, bottom, left, right, of
the spreadsheet, select: - Answer-Freeze Panes
Use this button to combine two or move cells into one cell and center the text over a group of columns -
Answer-Merge and Center
A quick way to insert a new column or row is an existing worksheet is to select a column or row and
press: - Answer-Ctrl+plus sign (+)
The default view in Excel is: - Answer-Normal
Saves workbook with a different name - Answer-Save As
A common file format that can be opened by many applications - Answer-.csv
The extension for a web page workbook - Answer-.html
Displays the name of the worksheet at the bottom left - Answer-Worksheet tab
Applies a border or shading to selected cells - Answer-Format Cells
Questions and Answers
In Microsoft Excel, the file you create & edit is called? - Answer-Workbook
By default, Excel 2019 files are saved with this extension? - Answer-.xlsx
Text in a worksheet that displays a name, a main title, row or column titles, and similar descriptive
information is called a(n): - Answer-label
When you click on a cell to activate it, the cell address appears in the: - Answer-name box
When you want to delete characters in a cell to the left of the insertion point press: - Answer-Backspace
A new Excel workbook uses the default theme named: - Answer-office
A rectangle group of cells in Excel is called a(n): - Answer-Range
The thin black plus sign pointer is used to: - Answer-Copy cell contents or complete a series
, To quickly select all the cells in a worksheet: - Answer-Press Clt+A
After you select and cut cells, the cells are temporarily placed - Answer-On the Clipboard
In Excel worksheet dates and times are: - Answer-Values
When you want column and row headings displayed whether you are at the top, bottom, left, right, of
the spreadsheet, select: - Answer-Freeze Panes
Use this button to combine two or move cells into one cell and center the text over a group of columns -
Answer-Merge and Center
A quick way to insert a new column or row is an existing worksheet is to select a column or row and
press: - Answer-Ctrl+plus sign (+)
The default view in Excel is: - Answer-Normal
Saves workbook with a different name - Answer-Save As
A common file format that can be opened by many applications - Answer-.csv
The extension for a web page workbook - Answer-.html
Displays the name of the worksheet at the bottom left - Answer-Worksheet tab
Applies a border or shading to selected cells - Answer-Format Cells
