1.
Which of the choices demonstrates the correct way to reference a range of values?
Correct Answer
C. A1:A5
Explanation
The correct way to reference a range of values is by using the format A1:A5. This notation represents a range starting from cell A1 and ending at cell A5, inclusive.
2.
CTRL + V is the shortcut combination for PASTE.
Correct Answer
A. True
Explanation
The statement is true because the shortcut combination CTRL + V is commonly used to paste text or other content from the clipboard onto a document or application. This combination is widely recognized and used in various operating systems and software programs.
3.
Pressing ENTER on a cell will move the typing selection down a row.
Correct Answer
A. True
Explanation
Pressing ENTER on a cell in a spreadsheet program such as Excel will indeed move the typing selection down a row. This is a commonly used shortcut to quickly move to the next row and enter data. It allows for efficient data entry in a tabular format, as users can simply press ENTER to move to the next row instead of manually clicking on the next cell.
4.
Every formula in Excel starts with _____
Correct Answer
B. An equal sign
Explanation
In Excel, every formula must start with an equal sign. This is because the equal sign is used to indicate to Excel that the following characters are part of a formula and not just regular text. Without the equal sign, Excel will treat the characters as text and not perform any calculations. Therefore, it is essential to always remember to start a formula with an equal sign in Excel.
5.
Which part of this math problem will Excel calculate first: =30/5*3?
Correct Answer
A. Divide 30/5
Explanation
Excel follows the order of operations, which is also known as PEMDAS (Parentheses, Exponents, Multiplication and Division from left to right, Addition and Subtraction from left to right). In this problem, the division operation (30/5) will be calculated first, as it comes before the multiplication operation (5*3). Therefore, Excel will calculate the division 30/5 first, resulting in an answer of 6.
6.
If you want to add the values that are in cells C1 and C2 (93 and 14), why would you use cell references in the formula (=C1+C2) instead of just writing the formula like this: =93+14?
Correct Answer
C. The formula result will automatically update when cell values change
Explanation
By using cell references in the formula (=C1+C2), the formula result will automatically update when the cell values change. This means that if the values in cells C1 and C2 are modified, the formula will recalculate and reflect the updated result. This is beneficial in scenarios where the values in the cells are frequently changing, as it saves time and effort by not having to manually update the formula each time.
7.
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 apply the same formatting, such as font style, color, and cell borders, to multiple cells without having to manually format each one. By selecting the format painter button, you can easily copy the formatting from one cell and apply it to another cell with a single click.
8.
To select a column the easiest method is to:
Correct Answer
C. Click the column heading
Explanation
The easiest method to select a column is by clicking the column heading. The column heading is typically located at the top of the column and clicking on it will automatically select the entire column. This method is quick and efficient as it allows you to easily select the desired column without having to manually select each cell individually.
9.
If you press____, the cell accepts your typing as its contents, but the focus stays in the cell.
Correct Answer
B. CTRL + ENTER
Explanation
Pressing CTRL + ENTER allows the cell to accept the typing as its contents, but the focus remains in the cell. This means that after typing in the cell, you can press CTRL + ENTER to confirm the input without moving to the next cell or losing focus on the current cell. This can be useful when you want to quickly enter data in multiple cells without constantly moving the focus to the next cell.
10.
To add multiple cells together, your formula would be as follows:
Correct Answer
C. SUM(A1:A3)
Explanation
The correct answer is SUM(A1:A3) because the SUM function in Excel is used to add up the values in a range of cells. In this case, the range A1:A3 represents the cells A1, A2, and A3. By using the SUM function with this range, it will calculate the sum of the values in these three cells and give the result.