Test 1.
1. EXCEL is
A. A graphic editor
B. A word processor
C. Operating system
D. A spreadsheet processor
2. To select multiple areas with the mouse, press the key
A. Esc
B. Shift
C. Ctrl
D. Alt
3. The rows of a spreadsheet are usually labeled
A. numbers (1, 2, 3…)
B. letters of the Latin alphabet (A, B, C, D…)
C. letters of the Russian alphabet (A, B, C, D…)
D. letters and numbers (A1, A2, A3…)
4. Is it possible to change the name of a worksheet and the name of a workbook?
A. worksheet
B. Workbook only
C. Both the worksheet and the workbook
D. Can’t do both
5. On which line are the buttons related to the document window Collapse, Expand/Restore, Close, if this window was expanded (the Expand button was clicked)
A. In the title bar of the document window
B. In the title bar of the program window
C. In the main menu bar of the program window
D. In the main menu bar of the document window
6. Formulas for calculations are entered
A. Only “manually” – from the keyboard
B. Only through the References menu
C. Manually (from keyboard) or via Insert->Function menu
D. Only through the menu Insert->Function
7. Which row and column names will not change when you copy formula=$A23+C$21:
A. A
B. C
C. 12
D. 23
8. In cell C4 the formula =B4/B2. What will it look like if you move it to cell C5?
A. B4/B2
B. C4/C2
C. B5/B3
D. C4/B2
9. The contents of the active cell are displayed in:
A. the clipboard
B. status bar
C. the application window title bar
D. formula line
10. What is the number of ranges to summarize in the formula: =SUM(F2;F6:F15;$A$6:C13;H1:H5;J1;L1;N1)
A. 10
B. 7
C. 6
D. 20
11. The formula in the cell looked like this: =CUM(B2:C8) The worksheet of the table removed the first column and inserted a new row before the first row. What did the formula look like?
A. =SUM(B2:C8)
B. =SUM(A3:B9)
C. =SUM(A2:B8)
D. =SUM(B3:C9)
12. To highlight an element in a diagram you can:
A. From the Diagram menu, select the Options command.
B. Single-click on the element
C. From the Format menu, select the Object command
D. In the Diagram context menu select the Format diagram area command.
13. Text has been entered in a cell. Its length exceeds the size of the cell. The cell to the right is occupied. What will be displayed in the cell with the text?
A. An error message
B. A fragment of typed text. As many characters are displayed as entered in the cell. Signs that are not included are not visible, but are not lost.
C. Fragment of the entered text. The number of characters that are included in the cell is displayed. The missing characters are missing.
D. All of the entered text, only in the minimum font size.
14. To create a forced transition of the text content of a cell to another line of the same cell, use the key combination:
1. ALT+ENTER
2. CTRL+ENTER
3. TAB+ENTER
4. SHIFT+TAB
15. Can you change the font format of header text?
A. Yes, all format attributes
B. No
C. Size only
D. Lettering only
Test 2.
1. The columns of a spreadsheet are usually designated
A. numbers (1, 2, 3…)
B. letters of the Latin alphabet (A, B, C, D…)
C. letters of the Russian alphabet (A, B, C, D…)
D. Letters and numbers (A1, A2, A3…)
2. In a spreadsheet, you cannot delete:
A. The contents of a cell
B. The formatting of the cell
C. Column
D. Cell address
3. A number 0.70 is entered into the cell and a percentage format is applied. What will be the result displayed in the cell?
A. 0,7%
B. 70%
C. 7000%
D. 700%
4. The default alignment of a number in a cell is
A. left edge
B. right edge
C. center
D. by the position of the decimal point
5. Which result appears in cell C4 when you copy the Excel formula =A2*B$1 from cell B2 into it?
A. 12
B. 24
C. 144
D. 8
6. How many numbers can be written in one cell?
A. Only one
B. No more than two
C. More than two
D. Three
7. Which row and column names will change when you copy the formula =$F15+K$44:
A. F
B. K
C. 51
D. 44
8. Which of the formulas prints the date of the next day
A. =Today(1)
B. =Today()+1
C. =Today()+ Today()
D. =Today()*2
9. The formula =B4/B2 is copied from cell C4 to cell C5. What is the result in cell C5?
A. 12,00р.
B. #value
C. #del/0
D. #link
10. The names of the days of the week: “Monday”, “Tuesday”, “Wednesday” are entered in consecutive cells of an Excel table column. The last cell is active.list. The mouse is pointing to the lower right corner of a cell in the list, with a “Plus” sign visible below the right corner of the cell. What happens if you “drag” the mouse down a couple of cells?
A. The next two cells will be filled with the text: “Wednesday”.
B. The next two cells will be formatted the same as the last cell in the list, and their contents will remain blank
C. The contents of the active cell will be copied.
D. The next two cells of the column will be filled with the continuation of the day of the week list: “Thursday”, “Friday”.
11. Two columns are highlighted in the table. What happens when you try to change the width of a column:
A. The width of the first column of the highlighted column will change
B. The width of all the highlighted columns will change
C. The width of the last column of the highlighted column will change
D. Changes the width of all columns in the table
12. A text has been entered into a cell. Its length exceeds the size of the cell. The cell to the right is not occupied. What will be displayed in the cell with the text?
A. An error message
B. A fragment of typed text. As many characters are displayed as entered in the cell.
C. All of the entered text, only in the smallest font size.
D. All entered text in a standard font. Text that is not included in a cell overlaps the contents of the neighboring cell to the right.
13. Which of the following expressions can be Excel formulas?
A. =$R1
B. +$C$45/A1+4
C. A5*$C6
D. *F12+D6
14. Which of the formulas contains an absolute reference
A. F45/$H$12
B. G4 + J6
C. R74*E63
D. B5$+C25
15. To confirm the entry in a cell, you must:
A. press the ENTER key.
B. press the F key
C. press the Esc key
D. press the Alt key
Answers
| Вопрос | Тест 1 | Тест 2 |
| 1. | D | B |
| 2. | C | D |
| 3. | A | B |
| 4. | C | B |
| 5. | C | B |
| 6. | C | A |
| 7. | A | B |
| 8. | C | B |
| 9. | D | B |
| 10. | B | D |
| 11. | B | B |
| 12. | B | D |
| 13. | B | A |
| 14. | A | A |
| 15. | A | A |
