1.
A fast way to add up this column of numbers is to click in the cell below the numbers and then:
Correct Answer
C. Click the AutoSum button on the Standard toolbar, then press ENTER.
Explanation
The correct answer is "Click the AutoSum button on the Standard toolbar, then press ENTER." This option suggests using the AutoSum feature in the software to quickly add up the column of numbers. By clicking the AutoSum button and pressing ENTER, the software will automatically calculate the sum of the selected range of cells and display the result. This method saves time and effort compared to manually entering the formula or using other options mentioned in the question.
2.
Say that you want to paste a formula result — but not the underlying formula — to another cell. You would copy the cell with the formula, then place the insertion point in the cell you want to copy to. What next?
Correct Answer
C. Click the arrow on the Paste button on the Standard toolbar, then click Values.
Explanation
To paste a formula result without the underlying formula to another cell, you would first copy the cell with the formula. Then, you would place the insertion point in the cell where you want to paste the result. Next, you would click the arrow on the Paste button on the Standard toolbar. From the options that appear, you would select "Values". This will paste only the calculated result of the formula into the selected cell, without including the actual formula itself.
3.
How do you change the column width to fit the contents?
Correct Answer
B. Double-click the boundary to the right of the column heading.
Explanation
To change the column width to fit the contents, you need to double-click the boundary to the right of the column heading. This action will automatically adjust the width of the column to accommodate the widest content within it. Single-clicking the boundary to the left of the column heading or pressing ALT and single-clicking anywhere in the column will not achieve the desired result. Therefore, the correct option is to double-click the boundary to the right of the column heading.
4.
There are three worksheets with every new workbook. You can change that automatic number if you want to.
Correct Answer
A. True
Explanation
By default, when a new workbook is created in Excel, it comes with three worksheets. However, it is possible to change this automatic number of worksheets if desired. Therefore, the statement that "you can change that automatic number if you want to" is true.
5.
###### 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 a number or text into a cell, if the cell is not wide enough to display the entire content, it will show only a portion of it. This can lead to confusion or incorrect interpretation of the data. To ensure that all the content is visible, the cell width should be adjusted accordingly.
6.
To add a new row, click a cell in the row immediately above where you want the new row.
Correct Answer
B. False
Explanation
To add a new row in a table, you need to click on a cell in the row immediately below where you want the new row. Clicking on a cell in the row above will not add a new row. Therefore, the statement "To add a new row, click a cell in the row immediately above where you want the new row" is false.
7.
Which key do you press to group two or more non-adjacent worksheets?
Correct Answer
B. SHIFT
Explanation
To group two or more non-adjacent worksheets in Microsoft Excel, you need to press the SHIFT key. This allows you to select multiple worksheets that are not next to each other in the workbook. By grouping them, you can perform actions on all the selected worksheets simultaneously, such as formatting, entering data, or applying formulas.
8.
To copy an entire worksheet and all its data, you should click the worksheet tab of the sheet that you want to copy, hold down SHIFT, and then drag the selected sheet along the row of sheet tabs.
Correct Answer
B. False
Explanation
To copy an entire worksheet and all its data, you should click the worksheet tab of the sheet that you want to copy, hold down CTRL, and then drag the selected sheet along the row of sheet tabs.
9.
Which formula can add all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
Correct Answer
C. Sum
Explanation
The correct answer is "Sum" because the SUM formula in Excel can add all the numeric values in a range of cells. It ignores any non-numeric values and only adds the numeric ones. The result of the sum can be placed in a different cell by specifying the range of cells to be summed as the argument of the SUM formula, and then referencing the cell where the sum should be displayed.
10.
Is it possible to insert an image from a file into an Excel spreadsheet?
Correct Answer
A. Yes
Explanation
It is possible to insert an image from a file into an Excel spreadsheet. This can be done by selecting the "Insert" tab, clicking on "Pictures" and then choosing the desired image file from the file explorer. The image will then be inserted into the spreadsheet and can be resized or positioned as needed.
11.
Can an Excel spreadsheet be used as the "data source" for a Word Mail Merge?
Correct Answer
A. Yes
Explanation
Yes, an Excel spreadsheet can be used as the "data source" for a Word Mail Merge. This is because Word has the capability to import data from Excel and use it to populate fields in a mail merge document. By linking the Excel spreadsheet as the data source, Word can easily merge the data into the desired document, such as letters, labels, or envelopes, saving time and effort in manually entering the data.
12.
On an Excel sheet, the active cell is indicated by ____.
Correct Answer
A. A dark wide border
Explanation
The active cell on an Excel sheet is indicated by a dark wide border. This border helps the user identify which cell is currently selected and ready for data input or manipulation. The dark wide border stands out from the other cells, making it easy to locate and work with the active cell.
13.
A Formula and a function are the same things.
Correct Answer
B. False
Explanation
A formula and a function are not the same things. A formula is a mathematical expression that performs calculations, while a function is a predefined set of instructions that performs a specific task. A function can be used within a formula to carry out a specific operation, but they are distinct concepts.
14.
In order to multiply items in Excel, you would use:
Correct Answer
C. *
Explanation
To multiply items in Excel, you would use the asterisk symbol (*). The asterisk is the multiplication operator in Excel and is used to perform multiplication calculations between two or more cells or values. By using the asterisk symbol, you can easily multiply numbers, formulas, or cell references in Excel.
15.
The formula = ((A2+B5)*5% is valid.
Correct Answer
B. False
Explanation
The given formula is not valid because it is missing a closing parenthesis. The correct formula should be ((A2+B5)*5%).