Use Data Structures — Cumulative exam Answers

A company chooses blue and green for its signs and employee uniforms. It decides to write the company name in all capital letters with fancy letters. The company wants to show the new colors and lettering in the annual report. Which formatting options would best accomplish this?

Mikhail is working in an IDE and needs to test a program one step at a time to find and fix errors. What tool should he use?

Which of the following is true of operations within a spreadsheet program’s built-in functions?

Seth, a zoologist, has a spreadsheet containing data on all the animals in a zoo. He wants to sort the column that contains the weights of all of the animals. Which sort tool could he use to reorganize the numbers so they are listed from smallest to largest?

Which best describes desktop publishing?

Research and a well-written problem statement are important because

Why are audio files compressed?

Conditional formatting allows spreadsheet users to

Libraries order items, check out items to patrons, process returned items, and organize items on shelves. What data management solution should a library use to track this information?

An effective problem statement ensures that

Which allows users to retrieve, view, edit, and manipulate information in database tables without having to work directly with a table?

Read the spreadsheet formula below, then answer the question.=SUM(C6:C9)What does the : symbol in the formula do?

What lookup function should be used to search for values in a specific row of a table and return values from adjacent rows?

A presentation has bullet points that move. The presenter wants to use these bullet points in several other places in the presentation. Which command would the presenter use to copy the feature to other places?

What part of digital video processing is practical because it saves space, reduces the expense of file storage, and reduces the amount of time required to upload and download a file?

What happens in the process represented by the flowchart?

Lucia is using the American Psychological Association (APA) style guidelines to writer her research paper. What is her most likely topic?

Normalization of tables in the Employee database could be useful in eliminating all records that

A manager does not know how to program code. What could he use to communicate his programming ideas effectively to his team?

A program runs from start to finish, producing unexpected results, though no error message is received. What most likely occurred?