Excel Module 1
What function can you use in Excel to show the current date and time?
=NOW()
What part of a cell can you apply formatting to?
Either all or part of it.
Excel does not allow passwords on Worksheet Protection, just Workbook.
False
True or False: Excel will apply numeric formats to a cell of numeric text.
False
True or False: Moving a scroll bar on one side of a split worksheet also moves the other sheet.
False
True or False: You can only autofill using one cell, not multiple.
False
True or False: You can prevent users from selecting cells, but it has to be all cells in a worksheet, you cannot protect only some cells.
False
True or False: You cannot see the formulas on a protected worksheet.
False
True or False: You must use either hyphens or slashes when entering dates in Excel.
False
What functionality in Excel do you use if you want your headers to remain if you move the rest of the worksheet?
Freeze panes
What is the default number format in the Format Cells area?
General
What is the easiest way to protect your formulas?
Hide them
Excel does not allow what in a numeric format?
Leading zeroes
True or False: Excel functionality includes a mechanism to add notes to a worksheet.
True
True or False: Excel lets you name a range of cells and then use the range elsewhere by its name.
True
True or False: Protecting a worksheet prevents formulas in locked cells from being altered.
True
True or False: You can calculate the number of days between dates in Excel.
True
True or False: You can create your own custom list for a data series you use often
True
True or False: You can have Excel print row and/or column heading information on each printed page.
True
True or False: You can hide an entire worksheet in Excel.
True
True or False: You can impose an unintended format on a cell.
True
True or False: You can show more than one worksheet at a time in Excel.
True
You can view worksheets in the same workbook as two separate files at the same time.
True
What is it important to know when building an Excel workbook?
Who your audience is
What do you use in Excel to choose different formats based on the cell contents?
conditional formatting
What does the DateValue function in Excel do?
convert a date stored as text into a number
Which of the following is NOT a viable option for protecting your formulas in Excel?
including a comment asking that the formula not be changed.
What is the default protection for all cells in a worksheet?
locked
How can you tell that a cell in a worksheet contains a comment?
small red triangle in the upper right hand corner
What default information appears in a comment box?
user information
