True/False
Indicate whether the
statement is true or false.
|
|
|
1.
|
To format cells, you select the cell or cell range and then you apply the
formatting.
|
|
|
2.
|
Formatting commands are found on the Formatting toolbar and in the Format Cells
dialog box.
|
|
|
3.
|
You can modify font typeface, size, color, and effect.
|
|
|
4.
|
You can modify only font typeface and not size, color, and effect.
|
|
|
5.
|
You can align cells horizontally and not vertically.
|
|
|
6.
|
Cell shading and borders can group data visually on a worksheet.
|
|
|
7.
|
You can choose from a variety of border colors and line styles.
|
|
|
8.
|
You can choose from only three border colors and line styles.
|
|
|
9.
|
Adding a graphic is not possible in a worksheet.
|
|
|
10.
|
Number formatting is critical to communicate to the reader what type of data is
being presented.
|
|
|
11.
|
Number formatting is not critical to communicate to the reader what type of data
is being presented.
|
|
|
12.
|
Important Page Setup options include page orientation, page centering and
headers and footers.
|
|
|
13.
|
Important Page Setup options include page centering, headers and footers, but
not page orientation.
|
|
|
14.
|
The Header and Footer dialog boxes include buttons tom insert a variety of
common options such as file name, date, and page size.
|
|
|
15.
|
The AutoFormat feature applies predesigned formats to data that conforms to a
simple structure.
|
|
|
16.
|
A style is a collection of formats that you can apply to data.
|
|
|
17.
|
The Format Painter button copies formatting from one cell and applies it other
cells.
|
|
|
18.
|
Excel is a spreadsheet application that organizes and manipulates data.
|
|
|
19.
|
Excel is a spreadsheet application that organizes and manipulates numbers
only.
|
|
|
20.
|
Excel files are called workbook and the default extension is .xls
|
|
|
21.
|
Excel files are called workbook and the default extension is .exl
|
|
|
22.
|
A workbook contains three worksheets by default.
|
|
|
23.
|
A workbook contains thirteen worksheets by default.
|
|
|
24.
|
Excel creates Spreadsheet1 when it is launched.
|
|
|
25.
|
A data in a worksheet is contained in cells.
|
|
|
26.
|
A data in a worksheet is contained in rows and columns.
|
|
|
27.
|
A worksheet can have infinite columns.
|
|
|
28.
|
A worksheet can have infinite rows.
|
|
|
29.
|
A worksheet has 256 columns.
|
|
|
30.
|
A worksheet has 65536 rows.
|
Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
31.
|
Which of the following copies formatting from a cell and applies it to other
cells?
a. | Format Painter Button | c. | Currency Style | b. | Copy Format | d. | AutoFormat |
|
|
|
32.
|
Which of the following is not a font Format?
a. | size | c. | percent | b. | font face | d. | bold |
|
|
|
33.
|
Which chart type is best for representing parts of a whole?
|
|
|
34.
|
The first step in creating a chart
a. | clicking the Chart Wizard button | c. | selecting the cell range or ranges
that your chart will be based upon | b. | moving your data so that it is in adjacent
cells | d. | formatting your
data |
|
|
|
35.
|
The Chart Wizard displays apreview of your chart
a. | if you click Press and Hold to View Sample | c. | if you select a chart
sub-type | b. | automatically | d. | only on the Custom Types tab |
|
|
|
36.
|
Which chart type is best for displaying trends over time?
|
|
|
37.
|
What will print if an embedded chart is selected?
a. | the worksheet and the chart | c. | the chart only | b. | the worksheet
only | d. | the worksheet on
Sheet1 and chart on Sheet2 |
|
|
|
38.
|
A page break can be inserted
a. | above the selected cell | c. | in the Page Break dialog
box | b. | below the selected cell | d. | none of the above |
|
|
|
39.
|
Which toolbar do you use to add a text box to a worksheet or chart?
a. | Standard | c. | Drawing | b. | Formatting | d. | Graphics |
|
|
|
40.
|
The active cell is the
a. | the one containing text | c. | not available until you decativate
it | b. | the selected cell | d. | a protected cell |
|
|
|
41.
|
The vertical dimension of an Excel worksheet is called a
a. | cell | c. | address | b. | column | d. | row |
|
|
|
42.
|
Gridlines in a worksheet
a. | do not print by default | c. | cannot be
printed | b. | always print | d. | can be printed if the printer has the option |
|
|
|
43.
|
To edit existing data in a cell
a. | select the cell and press F3 | c. | select the cell and choose Edit
| Cell | b. | double click the cell | d. | click in the cell |
|
|
|
44.
|
To enter data into a cell and move up one cell, what key combination would you
use?
a. | Tab | c. | Enter | b. | Shaift + Tab | d. | Shift + Enter |
|
|
|
45.
|
A worksheet has _______ rows.
a. | 300 | c. | 20000 | b. | 3000 | d. | 65536 |
|
|
|
46.
|
A worksheet has _____ columns
|
|
|
47.
|
Another name for a columnar work sheet
a. | workbook | c. | cell | b. | spreadsheet | d. | booksheet |
|
|
|
48.
|
The maximum number of worksheets a workbook can have is:
|
|
|
49.
|
The size of an Excel worksheet is:
a. | 128 columns by 9,999 rows | c. | over 256 million
cells | b. | 65,536 columns by 256 rows | d. | 256 columns by 65,536 rows |
|
|
|
50.
|
Which of the following applications would most likely be created in
Excel?
a. | a letter | c. | a memo | b. | a budget | d. | a metting
report |
|
|
|
51.
|
The maximum number of cells in a worksheet can be:
a. | 16.77 million | c. | 10,000 | b. | over 1 million | d. | as many as you
want |
|
|
|
52.
|
Using the order of precedence, solve the formula 5 - 2*(8+2)
|
|
|
53.
|
To move the cell below the active cell, press:
a. | ENTER key | c. | Tab key | b. | Page Down Key | d. | CTRL key |
|
|
|
54.
|
Which of the following is a range address?
a. | D1;D10 | c. | D1-D10 | b. | D1,D10 | d. | D1:D10 |
|
|
|
55.
|
Which of the following is an example of scientific notation?
a. | 1.5E+11 | c. | 7.8! | b. | 1^10 | d. | $A$2 |
|
|
|
56.
|
If A1 is 10, A2 is 15 and A3 is 20, what is the result of
=SUM(A1:A2)
|
|
|
57.
|
If A1 is 300 and A2 is 15%, what will be result of =A1*A2 in A3
|
|
|
58.
|
If A1 is 300 and A2 is 200, what will be the result of =(A1*0.5 +
A2/5-100) in A3.
|
|
|
59.
|
If A1 is 25 what will be the result of =A1^2 in A3.
|
|
|
60.
|
What is the reason of #####.## being displayed in any cell?
a. | wrong formula | c. | you entered #####.## | b. | wrong format | d. | cell width
insufficient |
|