Всем привет!
Продолжаем про LinkedIn:
Темы, которые затрагивают вопросы теста:
Formulas and Functions
Working with Data
Formatting
User Interface
Charts
Files and Workbooks
Worksheet Layout
Macros
PivotTables
Statistics
Вот, к примеру, несколько вопросов на английском языке - здесь приведу только те, к которым не нужны картинки. Помните, на тесте на каждый вопрос не больше 1.5 минут на раздумья!
Вопрос1. If cell A3 contains the text THE DEATH OF CHIVALRY, that will the function =PROPER(A3) return?
1. the death of chivalry
2. The death of Chivalry
3. THE DEATH OF CHIVALRY
4. The Death Of Chivalry
Вопрос2. You need to add a line chart showing a sales trends over the last 12 months and you have only a little space to work with. How can you convey the required information within a single cell?
1. Add an image of the chart to a comment.
2. Add a hyperlink to another worksheet that displays a chart when clicked.
3. Add an image of the chart to the worksheet.
4. Add a sparkline, a graphic that summarizes data visually within a single worksheet cell.
Вопрос3. Which format will display the value 27,500,000 as 27.5?
1. ##,###,,
2. ###.0,,
3. 999.9,,
4. ###,###.0,
Вопрос4. Which formula is NOT equivalent to all of the others?
1. =A3+A4+A5+A6
2. =SUM(A3:A6)
3. =SUM(A3,A6)
4. =SUM(A3,A4,A5,A6)
Вопрос5. Which function returns a reference to a cell (or cell range) that is a specified distance from a base cell?
1. OFFSET
2. VLOOKUP
3. INDEX
4. MATCH
Вопрос6. Of the four chart types listed, which works best for summarizing time-based data?
1. pie chart
2. line chart
3. XY scatter chart
4. bar chart
Вопрос7. You want to be able to restrict values allowed in a cell and need to create a drop-down list of values from which users can choose. Which feature should you use?
1. Protect Worksheet
2. Conditional Formatting
3. Allow Users to Edit Ranges
4. Data Validation
Вопрос8. To round up a value to the nearest increment of your choice, such as the next five cents, what function should you use?
1. ROUNDUP
2. MAX
3. ROUND
4. CEILING
Вопрос9. Which function returns the largest value amongst all values within the range H2:H30?
1. =MAX(H2:H30)
2. =MAXIMUM(H2:H30)
3. =LARGE(H2:H30,29)
4. =UPPER(H2:H30,1)
Вопрос10. Which formula returns the value in cell A1 of the worksheet named MySheet?
1. =MySheet!A1
2. =MySheet_A1
3. =MySheet&A1
4. =MySheet@A1
Вопросы с картинками, ответы и варианты на русском языке буду выкладывать дальше в серии постов. Отмечу их все хэштегами #LinkedInExcel
Пробуйте свои силы - пока жду ваши ответы в комментариях! И можем подумать вместе, как лучше подходить к таким вопросам!
Продолжаем про LinkedIn:
Темы, которые затрагивают вопросы теста:
Formulas and Functions
Working with Data
Formatting
User Interface
Charts
Files and Workbooks
Worksheet Layout
Macros
PivotTables
Statistics
Вот, к примеру, несколько вопросов на английском языке - здесь приведу только те, к которым не нужны картинки. Помните, на тесте на каждый вопрос не больше 1.5 минут на раздумья!
Вопрос1. If cell A3 contains the text THE DEATH OF CHIVALRY, that will the function =PROPER(A3) return?
1. the death of chivalry
2. The death of Chivalry
3. THE DEATH OF CHIVALRY
4. The Death Of Chivalry
Вопрос2. You need to add a line chart showing a sales trends over the last 12 months and you have only a little space to work with. How can you convey the required information within a single cell?
1. Add an image of the chart to a comment.
2. Add a hyperlink to another worksheet that displays a chart when clicked.
3. Add an image of the chart to the worksheet.
4. Add a sparkline, a graphic that summarizes data visually within a single worksheet cell.
Вопрос3. Which format will display the value 27,500,000 as 27.5?
1. ##,###,,
2. ###.0,,
3. 999.9,,
4. ###,###.0,
Вопрос4. Which formula is NOT equivalent to all of the others?
1. =A3+A4+A5+A6
2. =SUM(A3:A6)
3. =SUM(A3,A6)
4. =SUM(A3,A4,A5,A6)
Вопрос5. Which function returns a reference to a cell (or cell range) that is a specified distance from a base cell?
1. OFFSET
2. VLOOKUP
3. INDEX
4. MATCH
Вопрос6. Of the four chart types listed, which works best for summarizing time-based data?
1. pie chart
2. line chart
3. XY scatter chart
4. bar chart
Вопрос7. You want to be able to restrict values allowed in a cell and need to create a drop-down list of values from which users can choose. Which feature should you use?
1. Protect Worksheet
2. Conditional Formatting
3. Allow Users to Edit Ranges
4. Data Validation
Вопрос8. To round up a value to the nearest increment of your choice, such as the next five cents, what function should you use?
1. ROUNDUP
2. MAX
3. ROUND
4. CEILING
Вопрос9. Which function returns the largest value amongst all values within the range H2:H30?
1. =MAX(H2:H30)
2. =MAXIMUM(H2:H30)
3. =LARGE(H2:H30,29)
4. =UPPER(H2:H30,1)
Вопрос10. Which formula returns the value in cell A1 of the worksheet named MySheet?
1. =MySheet!A1
2. =MySheet_A1
3. =MySheet&A1
4. =MySheet@A1
Вопросы с картинками, ответы и варианты на русском языке буду выкладывать дальше в серии постов. Отмечу их все хэштегами #LinkedInExcel
Пробуйте свои силы - пока жду ваши ответы в комментариях! И можем подумать вместе, как лучше подходить к таким вопросам!