True or false questions
All functions use a range of cells for the argument. There are no single
cell referenced formulas?
When Excel calculates averages, blank cells or cells containing text are
ignored?
The NOW function can be used to display the current date, time, or a
combination of the two in several different formats.
The cell containing the NOW function will always display the point in
time when the function was entered into the cell?
When using the PMT function, if the payments are to be monthly, then the
interest rate you supply to the PMT function needs to be a monthly rate?
You cannot use the IF function as the true or false answer to another IF
function?
In the Page Setup dialog box, you can choose to center a worksheet
horizontally but not vertically on the page?
Headers and footers do not show up in the worksheet area; to see them
you have to Print or Print Preview the worksheet.
The Chart toolbar will automatically be displayed whenever a chart is
selected on the worksheet.
Pictures inserted into a worksheet must reside within one cell. If you
want the picture to take up a large area, you must resize the column
and/or row to create a larger area within the cell.
Once an object, such as an arrow or a text box, has been inserted into a
worksheet, data cannot be inserted into the cells “behind” the
object without deleting the object first.
Formulas created in a worksheet can reference cells in another sheet if
the other sheet is in the same workbook; cells in other workbook files
cannot be referenced?
Computer Science Homework Solutions
#55467
Microsoft Excel
True or false questions
1. All functions use a range of cells for the argument. There are no single cell referenced formulas?
2. When Excel calculates averages, blank cells or cells containing text are ignored?
3. The NOW function can be used to display the current date, time, or a combination of the two in several different formats.
4. The cell containing the NOW function will always display the point in time when the function was entered into the cell?
5. When using the PMT function, if the payments are to be monthly, then the interest rate you supply to the PMT function needs to be a monthly rate?
6. You cannot use the IF function as the true or false answer to another IF function?
7. In the Page Setup dialog box, you can choose to center a worksheet horizontally but not vertically on the page?
8. Headers and footers do not show up in the worksheet area; to see them you have to Print or Print Preview the worksheet.
9. The Chart toolbar will automatically be displayed whenever a chart is selected on the worksheet.
10. Pictures inserted into a worksheet must reside within one cell. If you want the picture to take up a large area, you must resize the column and/or row to create a larger area within the cell.
11. Once an object, such as an arrow or a text box, has been inserted into a worksheet, data cannot be inserted into the cells "behind" the object without deleting the object first.
12. Formulas created in a worksheet can reference cells in another sheet if the other sheet is in the same workbook; cells in other workbook files cannot be referenced?
What is this?
By OTA - Overall OTA Rating
Stephen Allen, MSc - 4.9/5
Purchase Cost Now
$2.19 CAD (was ~$7.98)
Included in Download
- Plain text response
- Attached file(s):
- Microsoft Excel True or false questions 1-12_answers.doc
Why you can trust BrainMass.com
- Your Information is Secure
- Best Online Academic Help Service
- Students find real academic Success
- star configuration & 802.3 LAN - A seven-story office building has 15 adjacent offices per floor. Each office contains a wall socket for a terminal in the front wall, so the sockets form a rectangular grid in the vertical plane, with ...
- code spatial and temporal locality - What would be examples of spatial and temporal locality in the following code: for (i = 0; i < 20; i++) for(j=0; j<10;j++ a[i] =a[i]*j
- Form - 3 additional question for OTA 101620 - Dear OTA 101620 Thank you for your response. For the second question,I would like to ask how to automatically assign a specific value to a label for a text box. ( automatically assigns a label that r ...
- Explain Rules for Referential Integrity Constraints - Describe the default rules for enforcing referential integrity constraints. Explain how referential integrity actions can be used to override the default referential integrity constraints.
- Enforcing referential integrity constraints - Describe the default rules for enforcing referential integrity constraints. Explain how referential integrity actions can be used to override the default referential integrity constraints. Please ...
