1.
Labels are aligned at the ________ edge of the cell.
Correct Answer
A. Left
Explanation
Labels are aligned at the left edge of the cell.
2.
You can complete a cell entry by pressing
Correct Answer(s)
A. Enter
B. Tab
C. Shift+tab
D. An arrow key
E. Another cell
Explanation
You can complete a cell entry in a spreadsheet by pressing the enter key, which moves the cursor to the cell below. Alternatively, you can press the tab key, which moves the cursor to the cell on the right. Shift+tab can be used to move the cursor to the cell on the left. An arrow key can also be used to move the cursor in any direction. Finally, you can also complete a cell entry by selecting another cell, which automatically saves the current entry.
3.
The default font keyed in a new workbook is
Correct Answer
B. 10 pt. Arial
Explanation
The default font in a new workbook is 10 pt. Arial.
4.
If you choose a larger font size, the height of the row is automatically made taller.
Correct Answer
A. True
Explanation
When selecting a larger font size, the height of the row is automatically adjusted to accommodate the larger text. This means that if you choose a larger font size, the row will become taller in order to properly display the larger text. Therefore, the statement "If you choose a larger font size, the height of the row is automatically made taller" is true.
5.
Which button allows you to copy cell formats from one cell to another?
Correct Answer
C. Format painter
Explanation
The format painter button allows you to copy cell formats from one cell to another. This feature is useful when you want to quickly apply the same formatting, such as font style, color, and borders, to multiple cells without manually adjusting each one. By selecting the cell with the desired format and clicking on the format painter button, you can easily apply the same format to other cells by clicking on them.
6.
A_______ is a group of cells that form a rectangle on the screen.
Correct Answer
E. Range
Explanation
A range is a group of cells that form a rectangle on the screen. It can include multiple rows and columns, allowing for the selection and manipulation of a specific area of a spreadsheet. Ranges are commonly used in spreadsheet applications to perform calculations, apply formatting, or manipulate data within a specific area of a worksheet.
7.
How do you know a range is active?
Correct Answer
A. It is highlighted on the screen.
Explanation
The correct answer is that a range is active when it is highlighted on the screen. This means that the range is currently selected or being used for a specific operation. This visual indicator helps the user identify which range is currently active and allows them to perform actions or make changes within that range.
8.
A range has an address called a range address.
Correct Answer
A. True
Explanation
A range in this context refers to a group of cells in a spreadsheet or a specific section of data. Each range is identified by its address, which is known as a range address. This address helps to locate and reference the range when performing operations or calculations. Therefore, the statement that a range has an address called a range address is true.
9.
An example of a range address.
Correct Answer
A. A1:B3
Explanation
The correct answer is A1:B3 because it represents a range of cells in a spreadsheet. The format A1:B3 indicates that the range starts from cell A1 and ends at cell B3, including all the cells in between. This range can be used to perform calculations or apply formatting to multiple cells at once.
10.
When you start to select a range of cells, you will see a thick white, cross-shaped pointer called a ________________.
Correct Answer
C. Selection pointer
Explanation
When you start to select a range of cells, you will see a thick white, cross-shaped pointer called a selection pointer. This pointer helps to indicate that you are in the process of selecting cells and allows you to easily drag and highlight the desired range.