What are the three ways you can consolidate data across worksheets? When would you use each of the three different ways?
What will be an ideal response?
Consolidating by position is used when you have data in similar layouts on multiple worksheets. The consolidated data will be in the same layout as the source data. Consolidating by category finds categories of data and will group by those categories. The consolidated data will not necessarily be in the same layout as the source data. Consolidating with links will consolidate by position and will show the details behind the consolidated cells. The links will be in rows that are hidden and can be expanded or collapsed as needed.
You might also like to view...
You can hide information entered by the user with a __________ component; by default, an asterisk (*) will be displayed for every character entered by the user.
a) JTextField b) JPassword c) JMaskedField d) JPasswordField
Justify alignment is a feature that is used to automatically adjust spacing between pairs of characters so that words and letters display equally spaced
Indicate whether the statement is true or false
You cannot change the color of the laser pointer in a custom show.? ____________________
Answer the following statement true (T) or false (F)
Which of the following statements is true of videoconferencing?
A. ?It conducts real-time, face-to-face meetings between individuals physically located in different places. B. ?It does not require Internet connection to connect to other users. C. ?It uses less bandwidth than audio conferencing and hence always provides video clips with high quality. D. ?It allows participants to attend a meeting even if the hardware breaks down.