Case-Based Critical Thinking Questions
?
Case 5-1
You are a student who is new to the more advanced features of Excel.
?
?
Which of the following is true about Excel tables (as opposed to structured ranges of data)?
A. You cannot format quickly using a table style.
B. You cannot enter a formula in one table cell that is automatically copied to all other cells in that table column.
C. You cannot add new rows and columns that automatically expand the range.
D. You cannot freeze the top row of the worksheet.
Answer: D
You might also like to view...
Suppose that you obtained a certificate of your own. Explain how you could use that certificate to deal with situations in which an intruder might steal your credit card number.
What will be an ideal response?
What change do you notice for the Memory Logs icon?
Configuring Administrative Tools
a. Click Control Panel > Administrative Tools > Performance Monitor. The Performance Monitor window opens. Expand Data Collector Sets. Right-click User Defined, and select New > Data Collector Set.
b. The Create new Data Collector Set window opens. In the Name field, type Memory Logs. Select the Create manually (Advanced) radio button, and click Next.
c. The What type of data do you want to include? screen opens. Check the Performance counter box then click Next.
d. The Which performance counters would you like to log? screen opens. Click Add.
e. From the list of available counters, locate and expand Memory. Select Available MBytes and click Add>>.
f. You should see the Available MBytes counter added in the right pane. Click OK.
g. Set the Sample interval field to 4 seconds. Click Next.
h. In the Where would you like the data to be saved? screen, click Browse.
i. The Browse For Folder window opens. Select your (C:) drive, which is Local Disk (C:) in the figure on the next page. Select PerfLogs and click OK.
j. The Where would you like the data to be saved? window opens with the directory information that you selected in the previous step. Click Next.
k. The Create the data collector set? screen opens. Click Finish.
l. Expand User Defined, and select Memory Logs. Right-click Data Collector01and select Properties.
m. The DataCollector01 Properties window opens. Change the Log format: field to Comma Separated.
n. Click the File tab.
o. Click OK.
p. Select the Memory Logs icon in the left pane of the Performance Monitor window. Click the green arrow icon to start the data collection set. Notice a green arrow is placed on top of the Memory Logs icon.
q. To force the computer to use some of the available memory, open and close a browser.
r. Click the black square icon to stop the data collection set.
Infiltration
What will be an ideal response?
A method's ____ includes the method identifier and possibly other necessary identifying information.
A. title B. space C. header D. opener