The document contains a series of multiple choice questions about Excel. It covers topics like cell ranges, the spell check feature, keyboard shortcuts, file compatibility, entering and editing data, and inserting blank rows and columns. The questions test knowledge of the Excel user interface, functions, and basic tasks like formatting, saving files, and manipulating data.
The document contains a series of multiple choice questions about Excel. It covers topics like cell ranges, the spell check feature, keyboard shortcuts, file compatibility, entering and editing data, and inserting blank rows and columns. The questions test knowledge of the Excel user interface, functions, and basic tasks like formatting, saving files, and manipulating data.
The document contains a series of multiple choice questions about Excel. It covers topics like cell ranges, the spell check feature, keyboard shortcuts, file compatibility, entering and editing data, and inserting blank rows and columns. The questions test knowledge of the Excel user interface, functions, and basic tasks like formatting, saving files, and manipulating data.
The document contains a series of multiple choice questions about Excel. It covers topics like cell ranges, the spell check feature, keyboard shortcuts, file compatibility, entering and editing data, and inserting blank rows and columns. The questions test knowledge of the Excel user interface, functions, and basic tasks like formatting, saving files, and manipulating data.
Download as DOCX, PDF, TXT or read online from Scribd
Download as docx, pdf, or txt
You are on page 1/ 3
Date – 16 April 2020 -----First exercise
1. Which of the following responses best defines the notation A1:B15?
a. The contents in cell A1 are identical to the contents in cell B15.
b. The cells between A1 and B15 are hidden.
c. A cell range or contiguous group of cells that begins with cell A1 and include all cells
up to and including cell B15.
d. A cell link that connects cell A1 to B15.
1. The Spell Check feature is in which tab of the Excel Ribbon?
a. Home
b. Review
c. Data
d. Formulas 1. Holding down the CTRL key and pressing the F1 key on your keyboard is used to a. minimize the Ribbon
b. open the Excel Help window
c. save a workbook
d. switch between open workbooks
1. If you are sending an Excel workbook created in Office 2010 to a person who is running Office 2007, you should do the following:
a. Use the Save As command to save the workbook in the Office 2007 file format.
b. Use the Save As command to save the workbook in the Excel 97-2003 file format. c. Use the Save As command to save the workbook in the Universal Compatibility format. d. Nothing. Office 2007 can open files created in Office 2010. 1.2 Entering, Editing, and Managing Data
1. When entering numeric data into an Excel worksheet, you should omit symbols such as commas or
dollar signs because:
a. These numbers will not be usable in mathematical functions or formulas.
b. Excel will convert this to text data.
c. Excel will not accept these entries into a cell location.
d. It slows down the data entry process.
1. Which of the following statements is true with respect to editing the content in a cell location?
a. Activate the cell location and press the F2 key on your keyboard to edit the data in the cell.
b. Double click the cell location to edit the data in a cell location.
c. Activate the cell location, click the Formula Bar, and make any edits for the cell location in the
Formula Bar.
d. All of the above are true.
1. Which of the following will enable you to identify hidden columns in a worksheet?
a. The column letter appears in a tip box when the mouse pointer is moved over a hidden column.
b. Clicking the Page Layout View button in the View tab of the Ribbon shows all columns in the
worksheet and shades hidden columns.
c. The column letters that appear above the columns in a worksheet will be missing for hidden
columns.
d. Click the Hidden Columns indicator in the Status Bar.
1. Which of the following is true with respect to inserting blank rows into a worksheet?
a. Blank rows are inserted above the activated cell or cell range in a worksheet. b. Blank rows are always inserted in the center of a cell range. At least two or more cells in a
worksheet must be highlighted before a row can be inserted.
c. The command for inserting blank rows and columns can be found by clicking the Format button
in the Home tab of the Ribbon.
d. When inserting blank rows into a worksheet, the Undo button is disabled. You must use the
Delete button in the Home tab of the Ribbon to remove unwanted blank rows.
