Which of the following would you do to select a range of cells?

Question

BlackTom AI · Accepted Answer

Question restatement: Which of the following would you do to select a range of cells?

Option 1: 'Ranges cannot be selected.' This is inaccurate because in most spreadsheet tools, ranges can indeed be selected to perform bulk operations.

Option 2: 'Click the first cell in the range, hold Shift, then click the last cell in the range.' This is the standard method for selecting a continuous range: start at one end, hold Shift, and click the opposite end to highlight all cells in between.

Option 3: 'Click each cell to select it.' While this allows selecting multiple cells, it selects them individually or non-contiguously, not as a single continuous range; you would need additional methods (like Ctrl+click) for multiple separate cells, which does not create a single range.

Option 4: 'Click the first cell in the range, hold Alt, then click the last cell in the range.' The Alt key is not used for range selection in common spreadsheet interfaces, so this would not produce a continuous range.

Summary of reasoning across options: The concept of selecting a range hinges on highlighting a continuous block from the first to the last cell. The Shift modifier is the conventional trigger to extend a selection from the initial cell to the terminal cell, covering all intermediate cells. Options 1 and 4 rely on incorrect assumptions about modifiers or capabilities, and Option 3 describes selecting cells individually rather than as a single range. This leaves Option 2 as the valid method for selecting a continuous range of cells.

EXC19E1 - Microsoft Excel 2019 Level 1 Final Exam - Online Exam for Course Content

Which of the following would you do to select a range of cells?

查看解析

登录即可查看完整答案

类似问题

To select a range of non-adjacent cells, click the first cell and then press and hold the _____ key while selecting the remaining cells in the range.

In a consumer society, many adults channel creativity into buying things

Economic stress and unpredictable times have resulted in a booming industry for self-help products

People born without creativity never can develop it

A product has a selling price of $20, a contribution margin ratio of 40% and fixed cost of $120,000. To make a profit of $30,000. The number of units that must be sold is: Type the number without $ and a comma. Eg: 20000

Which of the following statement regarding cost is correct:

Under the assumptions used in cost-volume-profit analysis, as the activity increases:

The CVP and break-even analysis are supported by a range of important assumptions. Which of the following is not an assumption of the CVP:

更多留学生实用工具

考试浏览器助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单