computer applications exam study guide latest 2022 with complete solution

computer applications exam study guide latest 2022 with complete solution Which scenario would best benefit from a page break? a paragraph with four lines on one page and one line on another Rico is working on a document titled 'Document1'. Which is most likely the case for Rico's document? He has not saved the document yet Which best describes the Quick Access Toolbar and the Ribbon tabs? The Quick Access Toolbar is customizable, and the Ribbon tabs are collapsible. Rose has a list of two columns of information separated by tabs. She wants to input this information into a table. What is the fastest way for Rose to do this? clicking Convert Text to Table Amitha writes up a one-page summary of a novel during her summer internship at a publishing company. When she reads over the page, she realizes she used the word "foreshadow" seven times, and she would like to reduce the repetition. Thesaurus Kyle has created a table but realizes that he wants to add one more row to the bottom. How can he do this? by right-clicking the bottom row, clicking Insert, then clicking Insert Row Below Lee wants to format a paragraph that he just wrote. What are some of the options that Lee can do to his paragraph? Check all that apply. aligning text adding borders applying bullets applying numbering Which correctly shows the configuration of boxes in the View tab that allow the indents to be changed? ruler Which best compares portrait and landscape orientations? Portrait is taller than it is wide, and landscape is wider than it is tall. What formatting has been applied to this document? bullets, left alignment, and font color Which segment is most likely set at 1.0 spacing? b Azzam is reviewing a paper he just wrote about kinetic friction for his physics class. On the third page, he realizes that every time he wrote "coefficient of friction," he should have written "coefficient of kinetic friction." He uses the Find and Replace tool and clicks on "Replace All" to fix the issue, but then when prints out the paper, he sees "coefficient of friction" in the first paragraph. What is most likely the reason why the phrase was not fixed? Azzam used the tool while he was on the third page. Which tasks can be completed within the File tab? saving a file, opening a file, and viewing the author of a document Which steps will create a new blank Word document? Click File, click New, then double-click Blank document. How do you change a Word document to an .html file? Save it as a Web page The AutoRecovery feature would be useful for which situations? Check all that apply. You closed a file without saving it then realized that you do need the file. You were working on a file when Word quit unexpectedly. Which steps will open the Help system so that you can enter a question and do a search for help? Click the File tab, click Help, then click Microsoft Office Help. Lee only wants to print columns A-D of a spreadsheet he is working on. What sequence should he use to accomplish this? select A-D with his mouse, File, Print, Print Active sheets, Print Selection, Print Haan creates this table to track his income. Which would give him the total income for the year? =SUM(B2:B13) Stacey wants to change her document to landscape view instead of portrait. Jesse wants to change the scale of his document. Which best describes all of the options that Stacey and Jesse each have? Stacey and Jesse can both look under Page Layout or under File and select Print. This spreadsheet shows an invoice for hours worked. If a user copies the formula from D15 into D16, what would the formula read in D16? =B16*C16 Garrett has a column of data. What can he do at the bottom of that column of data using an Auto function? Check all that apply. SUM AVERAGE MIN MAX COUNT Wendy wants to format the cells of a spreadsheet but not the text. Which formatting tools should Wendy use? Check all that apply. row height row width border Uri would like to change the font color in a group of cells. In which part of the Excel window should he look for font color controls? the ribbon Fran is changing the font, background color, and size of some text in a cell. She also makes it bold and italicized. She then leaves a comment in a cell. Which are all examples of Fran using text formatting? font, size, bold, italicize Anandi has been working with Excel to record data from an extensive physics experiment at her university. She has hundreds of columns representing different trials, and many rows showing different pieces of data from each trial. A handful of cells have data that stand out, so she needs to show them to her professor, even though these cells are hundreds of columns apart. If Anandi has written down the names of those cells, what is the fastest way to get to these cells while in Excel? pressing Control + G and typing in the address of each needed cell This table lists family members and their ages. What must have been selected to yield this new table? shift cells up