request for tutoring/coaching with homework
1. in the formula =x6+3, what can x6 specify ?
2. in excel, what does today's date minus yesterdays date equal ?
3. how can one change the width of column E ?
4. write a range reference that refers exactly to cells B3,B4,C3,C4 and C5 ?
5. in the formula, what other arithmetic operators have the same order of precedence as *?
6. what is the excel mode if by using a left or right arrow key, the insertion point can be moved one character within the content of a cell?
7. describe the possible cell values, if a cell with a time format has a display of 6:00 PM?
8. what control on the home tab can be used to create and select a format for an excel table ?
9. what is displayed at a cell with value 23.1679, if the cell is formatted 3 decimal places ?
10. within a selected adjacent range, what control on the home tab is used to create and select a format for an excel table ?
11. within a selected range, what control in the home tab is used to highlight cells with values greater than 50,000??
12. what control on the page layout tab can be used to specify that, when a worksheet is printed the first column appears appropriately on all printed pages ?
13. how can a header be entered for the pages of a worksheet ?
14. when does excel use cell reference types that appear within formulas?
Bookmarks