Answer:
=vlookup(h14, a5:h11,8,false)
Explanation:
Here, h15 is the cell in which we need the output and the value to be matched in rows to find the exact row is h14, and the range is expressed as a5:h11. Now to find the column number, we need to figure out the first and the concerned column. So, the concerned column is in which the total attendance is being listed and it is h(h14), and the first column is a. So, the column number is a=1 h=8, =8. And since we need the exact match, the value of the fourth argument is false. And thus, we have the above formula. Remember. vlookup formula is:
=vlookup(cell where the result is to be placed, range, column number in the same row as h14, exact match or approximate match). For exact match it's false, and for the approximate match, it's true.
hi there
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
<em><u>it c the ribbon tab. just want to help .</u></em>
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
hope this helps. if you want please mark brainlyist. enjoy
All options in the Advanced tab in the Share Workbook dialog box.
- Don’t keep change history
- Show comments made by all users
- Update changes when file is saved
- Track changes for certain amount of days
- Allow changes by more than one user at a time
- Automatically update changes in certain time periods
<u>Explanation:</u>
In shared workbook in advanced tab it has following options. Based on end user selection changes are applied on shares workbook.
1. Either keep the history for certain period or don’t keep the history on shared workbook.
2. On share work Save changes on period schedule (automatically update) or just see other user changes.
3. Before changes are made for share workbook either prompt for save option or last modified saved.
4. Printer review and filter setting for personal view.
Answer: C 475
Explanation: These choices are A. 375, B. 276, and D. 575. so that wolde mean it would be C 475.
