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 One easy way to tell if a cell contains a formula instead of data is to click on the cell and look at the formula bar to see if it begins with an equal sign. Mr. Prasad is a high school English teacher. He weighs different essays and assignments differently while calculating final grades. Therefore, he has made an Excel worksheet showing how different classwork weighs into a final grade. He would like to distribute an electronic file to his students, but he wants everyone to be able to read it regardless of whether or not they have Microsoft Office Suite. What can Mr. Prasad do to best distribute the file? use "Save As" to save it as an Adobe PDF file Even though there are aspects of a PowerPoint presentation that are not printable, usually basic art, text, and images are printable. The Print command in PowerPoint is found in the File tab. Fryshta is using the Help window in PowerPoint to learn about inserting Smart Shapes into a presentation. She currently has a Help page open that shows all of the steps she needs to take. Which button on the Help window would be most useful for keeping the window open and visible while Fryshta completes the steps? Pin The director of a California grocery store chain is preparing a PowerPoint presentation about new product lines to send to each store's manager. The director would like for each manager to share the presentation with the whole staff and say a few interesting facts about the new products as the staff sees images of them. What would be the most efficient way for the chain's director to make sure the store managers read these facts and know when to say them during the presentation? by typing the facts about a product into the PowerPoint notes pane under the slide showing the specific product A user wants to preview half of a presentation by viewing a slide show that begins on Slide 15. Which is the fastest way for the user to do this? scrolling to Slide 15 and clicking on From Current Slide under the Slide Show tab What are three print output options available in PowerPoint? Outline, Kiosk, Overheads A user wants to add speaker notes to a slide. The user has displayed the slide to which the speaker notes will be added and has clicked the View tab. Which steps will complete this task? clicking the Notes Page button, clicking the notes placeholder, then entering text Complete the steps for adding a footer to all notes pages in a presentation. 1. Click the tab 2. Click Header & Footer. 3. Select the tab. 4. Check Footer, then enter footer text. 5. Click , then click OK What are two methods for playing a slide show from the first slide? clicking the From Beginning button or pressing the F5 key Which tab should you use to access the thesaurus? Review Which set of steps shows the correct order for saving a PowerPoint presentation for the first time? Click the Save button, choose a location in the Save As dialog box, type a meaningful file name in the File Name field, then click Save. What are three controls that can be found on the File tab of Microsoft PowerPoint? Help, Open, Print What are the presentation views available in PowerPoint? Normal View Slide Sorter View Slide Show View Reading View To add a slide using the default layout, what should you do before clicking the New Slide button? Click the Home tab. Julia would like to print her calendar for June 20th through June 26th. Part of her computer screen is shown. Which steps will print the calendar accordingly? going to Print in the File tab, choosing Weekly Calendar Style, and clicking Print Abdul would like to propose a new time for a meeting request that was originally supposed to take place on Monday at 2:00 p.m. When Abdul opens the original meeting request, he sees that the status for Carla, one of the attendees, is "No Information." What does this mean? Carla is not connected to the Outlook exchange system. Which best describes a benefit of compressing an inserted image before sending it in an e-mail? The message will move faster through the Internet. Which is an advantage of using the Response Manager window for viewing responses to a meeting request instead of viewing the requests in the Inbox? The Response Manager window shows all responses in a single, well-organized display Michael scheduled an event for a group of people. Some people live in the eastern time zone, which is where the event is set, and some live in the Pacific time zone. Which shows the correct order of steps for adding the Pacific time zone to the event? go to the File tab, go to Options, click Calendar, add the time zone, click OK Elizabeth wants to send a status report for a task to her manager. She double-clicks on the task and clicks "Send Status Report" in the Manage Task group of the Ribbon. What information must Elizabeth enter before sending the report? her manager's e-mail address What feature of the Outlook 2010 window provides users with information about which folder is currently being worked on? the Title bar Kerry wants to find Oliver Burke, who is one of her contacts in Outlook. A portion of Kerry's computer screen is shown. Which steps should Kerry follow? clicking Contacts in the Navigation Pane and typing "Burke" in the Search field Mai is sending an e-mail to four of her colleagues: Pam, Tyler, Shanti, and Carl. She would like all responses to be sent to Tyler. Which message option should Mai use? Reply-To Address Valerie wants to restore a deleted appointment in Outlook. A portion of her computer screen is shown. Which shows the correct steps to complete the task? clicking on Mail in the Navigation Pane, clicking on Deleted Items, and left-clicking on the appointment and dragging it to Calendar in the Navigation Pane Abraham wants to add two new contacts to his contact group. Both of the new contacts work at Abraham's company. What new information will he have to add for each contact? Check all that apply. the person's name the person's job title Sasha is viewing a primary component of her Inbox in Outlook. She sees that the subject is "Meeting Time," the message is from her co-worker Trevon, and the message was received on Monday, January 10th. Sasha can also see the contents of the message. Which part of the Inbox is Sasha viewing? the Reading Pane Which piece of information for a task should be manually entered in the Reading Pane because it cannot be entered using a drop-down menu in a text field? the location for a first meeting Sonya wants to add a hyperlink to her new e-mail message. Her computer screen is shown. Which tab should Sonya click in order to find the Hyperlink option? Insert Where should Nolan go to change the font size of his message before printing it? the Format tab in the Page Setup dialog box When using the AutoFill feature, where should you put the mouse pointer in the cell to get the AutoFill handle? bottom-right corner Which key can you press to access the Excel Help window? F1 Complete each sentence to describe different elements of an Excel worksheet. The intersection of a column and a row is called a A vertical group of data is called a Text in a cell is referred to as a cell column label Complete each sentence to describe the Excel interface. Tabs, groups, and commands are found in the . Active cell name and contents are found in the bar. The file name can be found in the bar. ribbon formula status Which keyboard command would you use to navigate to the left adjacent cell in a worksheet? Shift + Tab What are two ways to accept data typed into a cell? pressing the Tab key or pressing the Enter key Marissa is working in Outlook 2010. Part of her computer screen is shown. How can Marissa view her calendar appointments for the entire month of October? by clicking Calendar in the Navigation Pane and clicking on Month in the Arrange group of the Ribbon Alicia wants to change the display of the Outlook Today window on her computer. After clicking on Customize Outlook Today, which steps should she follow to change the display from three columns to one column? In the Styles area, click Standard (one column) from the drop-down menu.