Which of these changes would make the following section of code scalable if additional data was added to a file? ActiveSheet.Sort.SortFields.Add Key:=Range("B1:B265") _ A. Change the range "B1:B265" to "B:B" B. Change the range "B1:B265" to "A1:Z265" C. Change "ActiveSheet" to "ActiveAllSheet" D. All of the above

Which of these changes would make the following section of code scalable if additional data was added to a file? ActiveSheet.Sort.SortFields.Add Key:=Range("B1:B265") _ A. Change the range "B1:B265" to "B:B" B. Change the range "B1:B265" to "A1:Z265" C. Change "ActiveSheet" to "ActiveAllSheet" D. All of the above

Microsoft Visual C#

7th Edition

ISBN:9781337102100

Author:Joyce, Farrell.

Publisher:Joyce, Farrell.

Chapter14: Files And Streams

Section: Chapter Questions

Problem 1CP

See similar textbooks

Similar questions

In Chapter 11, you created the most recent version of the MarshallsRevenue program, which prompts the user for customer data for scheduled mural painting. Now, save all the entered data to a file that is closed when data entry is complete and then reopened and read in, allowing the user to view lists of customer orders for mural types.
Please fix this JAVA code so that it will not overwrite the contents of the file every time I click on a row @Overridepublic void valueChanged(ListSelectionEvent event) {File file = new File("sample json file");int row = table.getSelectedRow();JSONObject obj = (JSONObject) jsonArray.get(row);ObjectMapper mapper = new ObjectMapper();mapper.enable(SerializationFeature.INDENT_OUTPUT);try {JsonGenerator g = mapper.getFactory().createGenerator(new FileOutputStream(file));mapper.writeValue(g, obj);g.close();} catch (IOException e) {throw new RuntimeException(e);}}});
from collections import defaultdictfilename = "tvshows.txt"# replace this with your filename#creating empty dictionaryshows = defaultdict(list)#open the filefile = open(filename)i = 1for line in file:line = line.rstrip()#stripping over extra white spacesif i%6 == 1:title = line.upper()#movie titles as keyselif i%6 == 2:msg = linefirst_aired_code = int(msg[0:2])first_aired = 0if 0 <= first_aired_code <= 18:first_aired = 2000+ first_aired_codeelse:first_aired = 1900+ first_aired_codeshows[title].append(first_aired)#appednig first aired yearseasons = int(msg[2:4])last_aired = first_aired + seasonsshows[title].append(last_aired)# appending last aired yearnetwork = int(msg[4])network_channel = ""if network == 1:network_channel = "ABC"elif network == 2:network_channel = "CBS"elif network == 3:network_channel = "NBC"elif network == 4:network_channel = "FOX"shows[title].append(network_channel)#appending network channelelif i%6 == 3 or i%6 == 4 or i%6 == 5 or i%6 ==…
Assuming that M is already a variable in the workspace and M contains numeric data in a matrix format, which of the following lines of code changes the value of M? Write your answer in a comment in your m file. List all correct answers. There could be more than one. M(:) x = M(end,:) M = M’ transpose(M) M = 1:10
Which of the following code segments will use vectorisation to reduce the time taken to calculate the sum of two NumPy arrays: A and B? (Select ALL that apply) 1. ) C = np.empty(A.size) for index in range(A.size): C[index] = A[index] + B[index] 2.) A.tolist()+B.tolist() 3.) np.sum([A, B]) 4.) A+B
How can I change this function ? I need to open the file and can write the name I want to delete . And be deleted. void removeContact(){fstream file;file.open("Contact'sBook.txt");browse();int delChoice;cout << "Enter Contact to be deleted by index no"<< endl;cin >> delChoice;for(int i =delChoice-1; i < count-1;i++){Person[i].FullName = Person[i+1].FullName;Person[i].Birthday =Person[i+1].Birthday;Person[i].Address = Person[i+1].Address;Person[i].Email= Person[i+1].Email;Person[i].PhoneNumber = Person[i+1].PhoneNumber;}count--;cout<< "AddressBook after deletion is " <<endl;browse();} Textfile contains for ex Helena but my function dosn´t find it.
msleep**** For this assignment, you must name your R file msleep.R (using Rstudio) For all questions you should load tidyverse. You should not need to use any other libraries. Load tidyverse with suppressPackageStartupMessages(library(tidyverse)) The actual data set is called msleep Round all float/dbl values to two decimal places. If your rounding does not work the way you expect, convert the tibble to a dataframe by using as.data.frame() All statistics should be run with variables in the order I state E.g., “Run a regression predicting mileage from mpg, make, and type” would be: lm(mileage ~ mpg + make + type...) Before attempting to answer these, or if you lose points upon an attempt, please review all CodeGrade information provided in the CodeGrade overview submodule - if you do not you are likely to lose points. What is the variance in total sleep for carni vores and those whose conservation status is lc? Your answer should be in a 1 X 1 data frame with a value…
In this assignment, you should work with books.csv Download books.csvfile. This file contains the detailed information about books scraped via the Goodreads . The dataset is downloaded from Kaggle website. Each row in the file includes ten columns. Detailed description for each column is provided in the following: bookID: A unique Identification number for each book. title: The name under which the book was published. authors: Names of the authors of the book. Multiple authors are delimited with -. average_rating: The average rating of the book received in total. isbn: Another unique number to identify the book, the International Standard Book Number. isbn13: A 13-digit ISBN to identify the book, instead of the standard 11-digit ISBN. language_code: Helps understand what is the primary language of the book. num_pages: Number of pages the book contains. ratings_count: Total number of ratings the book received. text_reviews_count: Total number of written text reviews the book received.…
Which of the following references will get the last element in an array of n elements named a? A a[n – 1] B a[n] C a[n + 1] D a
In Python: Which of the following set methods removes an element, but does NOT raise an exception if the element is not found? discard( ) remove( ) delete( ) erase( )
In this task, we would like to generate a keyed hash (i.e. MAC) for a file. We can use the “-hmac” option (this option is currently undocumented, but it is supported byopenssl). The following example generates a keyed hash for a file using the HMAC-MD5 algorithm. The string following the “-hmac” option is the key. “openssl dgst -md5 -hmac "abcdefg" filename” Please generate a keyed hash using HMAC-MD5, HMAC-SHA256, and HMAC-SHA1 for any file that you choose. Please try several keys with different lengths. 1. Do we have to use a key with a fixed size in HMAC? 2. If so, what is the key size? 3. If not, why?
Which of the following statements can be used to insert an array of documents into a collection? A. Any of the other answers will work B. > var arrayname = [{},{},{}];> db.collectionname.insert(arrayname); C. > db.collectionname.insertMany([{},{},{}]); D. > var arrayname = [{},{},{}];> db.collectionname.insertMany(arrayname);