Question 1 of 20 5.0 Points
Which of the following is NOT a way to change column width and height?
A. Press F2 while the column is selected
B. Using the mouse to drag the border of the column
C. Using the Format menu
D. Double-click on the column border with your mouse
Question 2 of 20 5.0 Points
Numbers, formulas, and functions in a spreadsheet are classified as:
A. text.
B. values.
C. constants.
D. operators.
Question 3 of 20 5.0 Points
When entering data into a spreadsheet, you need to make sure that you are in __________ mode.
A. Ready
B. Active
C. Function
D. Edit
Question 4 of 20 5.0 Points
Which one of the following methods CANNOT be used to store data that has been input in a cell?
A. Press ENTER
B. Press an arrow key
C. Click the Confirm box
D. Click the OK box
Question 5 of 20 5.0 Points
__________ is the first step in creating a worksheet.
A. Formatting columns
B. Entering data
C. Naming the file
D. Formatting cells
Question 6 of 20 5.0 Points
Which one of the following methods CANNOT be used to exit Excel?
A. Press CTRL+X
B. Click Excel icon at left end of Title bar
C. Select File, Exit from Menu bar
D. Click X at right end of Title bar
Question 7 of 20 5.0 Points
In an Excel worksheet, the columns are:
A. not labeled.
B. labeled by you.
C. labeled numerically.
D. labeled alphabetically.
Question 8 of 20 5.0 Points
To enter numbers as text:
A. type in the word, not the number (e.g., six, not 6).
B. align the data to the left.
C. enter an apostrophe (') before the number.
D. enter a pound, or number, sign (#) before the number.
Question 9 of 20 5.0 Points
The term what if analysis refers to the ability to:
A. determine how big the worksheet will be.
B. decide if the worksheet is saved.
C. recalculate values when new data is entered.
D. recalculate text when new data is entered.
Question 10 of 20 5.0 Points
Which one of these statements about worksheets and workbooks is TRUE?
A. A workbook consists of one of more workbooks.
B. A worksheet consists of one of more workbooks.
C. A worksheet consists of one of more worksheets.
D. A workbook consists of one of more worksheets.
Question 11 of 20 5.0 Points
A value is a numeric quantity or it can be a:
A. data field.
B. calculation.
C. formula.
D. function.
Question 12 of 20 5.0 Points
A bold outline around a cell means it is:
A. the active cell.
B. a formula.
C. a function.
D. not usable.
Question 13 of 20 5.0 Points
Input is not actually stored in the cell until you:
A. press the ENTER key.
B. press one of the arrow keys.
C. click the Enter box in the Formula bar.
D. All of the above
Question 14 of 20 5.0 Points
Using the mouse, you can start Excel by:
A. clicking on the workbook.
B. double-clicking on the Excel icon on the Windows Desktop.
C. clicking on the worksheet.
D. double-clicking the Begin icon.
Question 15 of 20 5.0 Points
Which one of the following settings CANNOT be changed from the Page Setup dialog box?
A. Margins
B. Width and height of a worksheet
C. Header and footer
D. What portion of the worksheet to print
Question 16 of 20 5.0 Points
The Toolbar button is used to:
A. make the data bigger.
B. make the data bold.
C. color the data blue.
D. color the data black.
Question 17 of 20 5.0 Points
Which one of the following keys can be used to correct an error in data entry into a cell?
A. END
B. HOME
C. ESC
D. ENTER
Question 18 of 20 5.0 Points
If you print a worksheet by clicking the printer icon on the Toolbar, the:
A. entire worksheet will print.
B. active worksheet will print.
C. worksheet will not print.
D. active workbook will print.
Question 19 of 20 5.0 Points
Which of the following moves the active cell?
A. pressing the space bar.
B. using the keys marked PG UP and PG DN.
C. pressing CTRL and ALT.
D. pressing the backspace key.
Question 20 of 20 5.0 Points
Saving your workbook:
A. prevents losing your work.
B. is not necessary.
C. should never be done.
D. is automatic.
