TestOut 5.4 Excel Changing Properties and Printing

Grace is preparing a monthly sales report in Excel to present to her team. She wants the company logo and the column headers to appear on every page when printed. How can she achieve this?

• To calculate formulas automatically

• To repeat rows or columns that will be on each page

• To insert hyperlinks in the cells

• To change the font style of the entire worksheet

Luna is working on a financial report in Excel and needs to allow her team, Evelyn and Zoe, to edit only specific cells in the document. How can Luna achieve this?

• Unlocking cells in Excel involves hiding the cells so only Luna, Evelyn, and Zoe can see them.

• Unlocking cells in Excel involves changing the font color of the cells so they stand out to Luna, Evelyn, and Zoe.

• Unlocking cells in Excel 'Locked' option in the 'Format Cells' dialog box for the cells Evelyn and Zoe need to edit.

• Unlocking cells in Excel involves merging the cells together so Luna, Evelyn, and Zoe can edit them as one.

Evelyn is working on a financial report in Excel for her company's annual meeting. She wants to ensure the printed version looks professional. What function of margins in Excel printing should she use?

• Control the white area to the page edge

• Change the font size of the text

• Adjust the color of the cells

• Insert additional rows in the spreadsheet

Avery has created a monthly sales report in Excel and wants to print only the summary section. How can Avery set a print area for this section?

• Click on the cell -> Page Layout tab -> Set Print Area

• Highlight range -> Insert tab -> Print Area -> Set Print Area

• Right-click on the range -> Format Cells -> Set Print Area

• Select range -> Page Layout tab -> Print Area -> Set Print Area

Emma is working on a large Excel spreadsheet for her project report and wants to print it. What does selecting 'Fit to Page' do in this scenario?

• It changes the color of the content

• It changes the font size of the content

• It adds a border around the content

• It fits the content to a specific page size.

Why did Ethan decide to set print titles in his Excel report for the monthly sales meeting?

• To ensure specific rows or columns repeat on printed pages

• To add unnecessary complexity to the sales report

• To confuse Hannah and David with irrelevant information

• To waste time without any benefit

James is working on a financial report in Excel and needs to print it for a meeting. How can James adjust the margins for printing to ensure everything looks neat?

• Margins cannot be adjusted in Excel

• Adjust margins through the Page Layout tab.

• Adjust margins through the Data tab

• Use the Insert tab to adjust margins

Imagine Avery, Samuel, and Henry are collaborating on a financial report using Excel. What are the benefits of unlocking certain cells in the document?

• Protection against accidental changes.

• Increased risk of data corruption

• Limited functionality in Excel

• Higher chance of accidental changes

Liam is working on a project report in Excel and needs to print it for his presentation. What printing options should he consider?

• Selecting the printer, number of copies, page orientation

• Selecting the computer, number of copies, and print range.

• Selecting the printer, brightness, sound, and print range.

• Selecting the printer, number of pages, color brightness, and print range.

William is working on a financial report in Excel and needs to add a company logo in the footer for a professional touch. Which sequence of actions should he follow using Page layout?

• Page Layout - Print Titles - header or footer

• Insert - Page Setup - header or footer

• Page Setup - header or footer

• File - header or footer