1.
_______, ________ and _______ are what you see when you open Excel
Correct Answer
C. Columns, rows, and cells
Explanation
When you open Excel, you will see columns, rows, and cells. Columns are the vertical sections labeled with letters, rows are the horizontal sections labeled with numbers, and cells are the individual rectangular boxes formed by the intersection of columns and rows. These elements are the basic building blocks of an Excel spreadsheet and allow you to organize and input data in a structured manner.
2.
Ribbon is MS Excel is
Correct Answer
B. The band at the top of the Excel 2007 window is the Ribbon
Explanation
The correct answer is "The band at the top of the Excel 2007 window is the Ribbon." This statement accurately describes the Ribbon in MS Excel as the band located at the top of the Excel 2007 window. It is where commands are organized in small related groups, allowing users to easily access and navigate through different features and functionalities in Excel.
3.
When you start Excel, you open a file that's called a workbook. Each new workbook comes with_____________ worksheet(s), like pages in a document. You enter data into the worksheets. (Worksheets are sometimes called spreadsheets.)
Correct Answer
C. Three
Explanation
When you start Excel, you open a file that's called a workbook. Each new workbook comes with three worksheet(s), like pages in a document. You enter data into the worksheets. (Worksheets are sometimes called spreadsheets.)
4.
___________ are where you get down to business and enter data in a worksheet.
Correct Answer
A. Cells
Explanation
Cells are where you get down to business and enter data in a worksheet. In a spreadsheet program like Microsoft Excel, a cell is a basic unit of a worksheet that is used to store and manipulate data. It is identified by a unique combination of a column letter and a row number. Cells allow you to input text, numbers, formulas, and perform various calculations. They are the building blocks of a worksheet and are essential for organizing and analyzing data.
5.
In a new worksheet, you must start by typing in cell A1.
Correct Answer
B. False
Explanation
In a new worksheet, you are not required to start by typing in cell A1. You can start typing in any cell of your choice.
6.
You can use Excel to create budgets, to work with taxes, or to record student grades
Correct Answer
A. True
Explanation
Excel is a powerful tool that can be used for various purposes, including creating budgets, working with taxes, and recording student grades. It provides features such as formulas, functions, and formatting options that make it easy to organize and analyze data. By using Excel, users can create and manage budgets, calculate taxes, and track student grades efficiently. Therefore, the statement "You can use Excel to create budgets, to work with taxes, or to record student grades" is true.
7.
You can enter two basic kinds of data into worksheet cells:
Correct Answer
A. Numbers and text
Explanation
In a worksheet, you can enter two basic kinds of data: numbers and text. Numbers can be used for calculations and mathematical operations, while text can be used for labels, descriptions, or any non-numeric information. This allows for a versatile and comprehensive representation of data in the worksheet.
8.
To enter a date in a cell, you should use a slash or a hyphen to separate the parts: 7/16/2009 or 16-July-2009. Excel will recognize this as a text
Correct Answer
B. False
Explanation
When entering a date in a cell in Excel, you should use a slash or a hyphen to separate the parts. For example, 7/16/2009 or 16-July-2009. Excel will recognize this as a date value, not as text. Therefore, the correct answer is False.
9.
You learned in the practice that ###### means:
Correct Answer
C. The cell is not wide enough
Explanation
The correct answer is "The cell is not wide enough." This means that when entering data into a cell in a spreadsheet or table, the width of the cell is not sufficient to display the entire content. This can result in the data being cut off or displayed in a way that is not fully visible. To fix this issue, the cell width needs to be adjusted to accommodate the content.
10.
What do you type into an empty cell to start a formula?
Correct Answer
A. An equal sign (=)
Explanation
To start a formula in an empty cell, you need to type an equal sign (=). This is because the equal sign is used to indicate that the cell will contain a formula and not just a regular value. By typing the equal sign, you are telling the spreadsheet software that you want to perform a calculation or use a function in that cell.
11.
A formula result is in cell C6. You wonder how you got the result. To see the formula, you:
Correct Answer
C. Click in cell C6.
Explanation
Clicking in cell C6 allows you to select the cell and view its contents, including any formula that may be present. This will allow you to see the formula that was used to calculate the result in cell C6.
12.
To divide 853 by 16 in a formula in Excel, you would use what math operator?
Correct Answer
D. /
Explanation
To divide 853 by 16 in a formula in Excel, you would use the "/" math operator. The "/" operator is used for division in Excel formulas.
13.
Cell Reference:A10,A20Refer to values in
Correct Answer
B. Cell A10 and cell A20
Explanation
The correct answer is "cell A10 and cell A20." This is because the cell reference "A10" refers to the specific cell in column A and row 10, and the cell reference "A20" refers to the specific cell in column A and row 20. Therefore, the answer is that the cell reference refers to both cell A10 and cell A20.
14.
A10:A20Refer to values in
Correct Answer
C. The range of cells in column A and rows 10 through 20
Explanation
The correct answer is "the range of cells in column A and rows 10 through 20". This answer indicates that the reference A10:A20 refers to a range of cells in column A, specifically from row 10 to row 20.