ITE 115 - EXCEL EXAM QUESTIONS AND ANSWERS LATEST 2025
Which of the following removes only the contents of a selected row or column? - Answers The Delete
key
An Excel 2013 workbook has the file extension .xml. - Answers False
Labels are numbers, formulas, and functions that can be used in calculations. - Answers False
Charts are updated automatically in Excel whenever data changes. - Answers True
____ shows you how a fill color will look before you apply it. - Answers Live Preview
A small, ____ triangle appears in the upper-right corner of a cell containing a comment. - Answers Red
Which of the following will not be affected or rearranged by choosing a new layout on the Chart Tools
Design tab? - Answers Data
Excel's Formula AutoComplete feature suggests functions depending on the letters typed by the user. -
Answers True
In Excel, the electronic spreadsheet you work in is called a ____. - Answers Worksheet
The default Accounting number format adds dollar signs and ____ decimal places to the data. - Answers
Two
The ____ option helps fit the data on a single page without making changes to individual margins. -
Answers Scale to fit
The ____ size is the physical size of the text. - Answers Font
A chart must be located in a specific cell or at a specific address range. - Answers False
You can create an absolute cell reference by placing a ____ in front of both the column letter and the
row number of the cell address. - Answers $
You can add a text box using the Chart Tools ____tab. - Answers Format
Sub guidelines show the values between the tick marks in a chart. - Answers False
After you use the fill handle to copy cell contents, the Quick Copy Options button appears, which can be
used to fill the cells with only specific elements of the copied cell, if you wish. - Answers False
Text annotations are ____ that you can add to further describe the data in your chart. - Answers Labels
The default file extension for an Excel 2013 workbook is ____. - Answers .xlsx
A bar chart and a column chart are equivalent chart types in Excel. - Answers False
Which of the following removes only the contents of a selected row or column? - Answers The Delete
key
An Excel 2013 workbook has the file extension .xml. - Answers False
Labels are numbers, formulas, and functions that can be used in calculations. - Answers False
Charts are updated automatically in Excel whenever data changes. - Answers True
____ shows you how a fill color will look before you apply it. - Answers Live Preview
A small, ____ triangle appears in the upper-right corner of a cell containing a comment. - Answers Red
Which of the following will not be affected or rearranged by choosing a new layout on the Chart Tools
Design tab? - Answers Data
Excel's Formula AutoComplete feature suggests functions depending on the letters typed by the user. -
Answers True
In Excel, the electronic spreadsheet you work in is called a ____. - Answers Worksheet
The default Accounting number format adds dollar signs and ____ decimal places to the data. - Answers
Two
The ____ option helps fit the data on a single page without making changes to individual margins. -
Answers Scale to fit
The ____ size is the physical size of the text. - Answers Font
A chart must be located in a specific cell or at a specific address range. - Answers False
You can create an absolute cell reference by placing a ____ in front of both the column letter and the
row number of the cell address. - Answers $
You can add a text box using the Chart Tools ____tab. - Answers Format
Sub guidelines show the values between the tick marks in a chart. - Answers False
After you use the fill handle to copy cell contents, the Quick Copy Options button appears, which can be
used to fill the cells with only specific elements of the copied cell, if you wish. - Answers False
Text annotations are ____ that you can add to further describe the data in your chart. - Answers Labels
The default file extension for an Excel 2013 workbook is ____. - Answers .xlsx
A bar chart and a column chart are equivalent chart types in Excel. - Answers False
