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 AutoSum button on the Standard toolbar is a quick and convenient way to add up a column of numbers. By clicking on this button and then pressing ENTER, the sum of the numbers in the column will be calculated and displayed in the selected cell. This eliminates the need to manually enter a formula or use other functions to calculate the sum.
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 only the formula result to another cell without the underlying formula, 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. Finally, you would select "Values" from the options that appear. This will paste only the calculated value of the formula to the desired cell.
3.
How do you change 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 automatically adjusts the width of the column to accommodate the widest content within it.
4.
There are three worksheets with every new workbook. You can change that automatic number if you want to.
Correct Answer
A. True
Explanation
The statement is true because when you create a new workbook in Excel, it automatically comes with three worksheets. However, if you want to change the number of worksheets, you have the option to do so.
5.
###### means:
Correct Answer
C. The cell is not wide enough.
Explanation
The given correct answer suggests that the meaning of "######" in this context is that the cell is not wide enough. This means that the cell in a spreadsheet or table does not have enough width to display the entire content, resulting in the appearance of "######" to indicate that the content is truncated. This commonly occurs when the content is longer than the width of the cell or when the cell formatting is not adjusted properly.
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 a cell in the row immediately below where you want the new row. Clicking a cell in the row above where you want the new row 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 nonadjacent worksheets?
Correct Answer
B. SHIFT
Explanation
To group two or more nonadjacent worksheets, you would press the SHIFT key. By holding down the SHIFT key and clicking on the worksheet tabs you want to group, you can select multiple nonadjacent worksheets at once. This allows you to 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.
A user wishes to remove a spreadsheet from a
workbook. Which is the correct sequence of events that will do this ?
Correct Answer
A. Go to FILE - SAVE AS - SAVE AS TYPE - Excel 4.0 Work Sheet
10.
Which formula can add the 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 Sum formula can be used to add all the numeric values in a range of cells and place the result in a different cell. It ignores any non-numeric values in the range and only adds the numeric values.
11.
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 in Excel, clicking on the "Pictures" option, and then choosing the desired image file from the file explorer. The image will then be inserted into the spreadsheet and can be resized, moved, or formatted as needed.
12.
Can an Excel spreadsheet be used as the
"data source" for a Word Mail Merge ?
Correct Answer
A. Yes
Explanation
An Excel spreadsheet can be used as the "data source" for a Word Mail Merge. This means that the data from the Excel spreadsheet can be merged into a Word document to create personalized letters, labels, or other documents. The Excel spreadsheet acts as a database of information that can be easily accessed and merged with the Word document.
13.
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 entry or formatting. It stands out from the other cells and provides a visual cue to the user. The dark wide border is a common feature in spreadsheet software and is widely used to improve user experience and efficiency.
14.
A Formula and a function are the same thing.
Correct Answer
A. True
Explanation
A formula and a function are not the same thing. A formula is a mathematical expression that performs calculations, while a function is a predefined formula that performs a specific task. Functions can be used within formulas to simplify calculations and automate tasks. Therefore, the correct answer is False.
15.
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 (*). This symbol is the multiplication operator in Excel and is used to perform mathematical calculations. By using the asterisk symbol, you can multiply the values of different cells or numbers in Excel formulas and functions.
16.
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%).
17.
If cells:
A1=90
A2=85
A3=80
A4=75
A5=75
What will be your formula if you are going to get the average?
Correct Answer
=AVERAGE(A1:A5), =(A1+A2+A3+A4+A5)/5, =average(a1:a5), =(a1+a2+a3+a4+a5)/5
Explanation
The correct formula to calculate the average of the given cells is =AVERAGE(A1:A5) or =(A1+A2+A3+A4+A5)/5. Both formulas will give the same result, which is the average of the values in cells A1 to A5.
18.
If cells:
A1=90
A2=85
A3=80
A4=75
A5=75
What will be your formula if you are going to get the total?
Correct Answer
=SUM(A1:A5), =A1+A2+A3+A4+A5, =sum(a1:a5), =a1+a2+a3+a4+a5
Explanation
The correct formula to get the total of the cells A1 to A5 is =SUM(A1:A5) or =A1+A2+A3+A4+A5 or =sum(a1:a5) or =a1+a2+a3+a4+a5. These formulas will add up the values in the given range of cells and give the total.