Excel Proficiency Quiz AFS

A range in computer programming refers to a group of cells or values within a spreadsheet or document. Each range has an address called a range address, which helps identify and locate the specific range within the document. Therefore, the statement that a range has an address called a range address is true.

If you choose a larger font size, the height of the row is automatically made taller. This is because the font size determines the amount of vertical space that each character occupies. When the font size is increased, the characters become larger and require more vertical space, thus causing the row height to increase.

Labels are aligned at the left edge of the cell.

The format painter button allows you to copy cell formats from one cell to another. This tool is useful when you want to apply the same formatting, such as font style, font size, and cell 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 then apply the formatting to other cells by clicking on them.

The correct answer is A1:B3 because it represents a range of cells in a spreadsheet. The "A1" refers to the top-left cell of the range, and the "B3" refers to the bottom-right cell of the range. This notation is commonly used in spreadsheet programs to specify a group of cells that are adjacent to each other and need to be selected or manipulated together.

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 worked on. This visual indicator helps the user identify which range they are currently working with and ensures that any actions or changes made will apply to that specific range. The other options, having a marquee around it or the data changing to bold, are not mentioned as indicators of an active range, making them incorrect choices.

A range is a group of cells that form a rectangle on the screen. It can be a selection of cells, a specific row or column, or even multiple rows and columns. Ranges are commonly used in spreadsheet programs to perform calculations, apply formatting, or manipulate data within a specific area of a worksheet.

The default font in a new workbook is 10 pt. Arial.

Pressing "enter", "tab", "shift+tab", an arrow key, or moving to another cell are all ways to complete a cell entry in a spreadsheet. Therefore, the correct answer is "All of the Above" as all of these options can be used to finalize a cell entry.

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 you visually identify and indicate the cells that you are selecting. It allows you to easily choose multiple cells or a range of cells in a spreadsheet or document.