Computer Applications- Microsoft Excel: Printing Spreadsheets
Portfolio 3 Quiz 11
- 1.
How do you preview a worksheet you want to print?
- A.
View Button and select print
- B.
Data Tab and select print preview
- C.
Office Button and select print preview
- D.
All of the Above
Correct Answer
C. Office Button and select print previewExplanation
To preview a worksheet before printing, you can click on the Office Button (located in the top left corner of the screen in Microsoft Office applications) and then select "Print Preview" from the options. This will allow you to see how the worksheet will look when printed, including the page layout, formatting, and any potential issues that may need to be addressed before printing. By selecting this option, you can ensure that the worksheet appears as desired before actually printing it.Rate this question:
-
- 2.
How can you just print a selected part of a worksheet?
- A.
Highlight data you want to print and select print
- B.
Select data and hit the office button. Select print and choose selection option in the print what section
- C.
Select data you want to print, right click and choose copy
- D.
None of the Above
Correct Answer
B. Select data and hit the office button. Select print and choose selection option in the print what sectionExplanation
To print a selected part of a worksheet, you need to select the data you want to print and then click on the office button. From there, select the print option and choose the selection option in the print what section. This will ensure that only the selected data is printed and not the entire worksheet.Rate this question:
-
- 3.
How can you change the orientation of a worksheet to landscape using Print Preview?
- A.
In Print Preview Mode, select page setup and click landscape
- B.
In Print Preview Mode, select show margins and change landscape
- C.
In Print Preview Mode, select the data you want to change orientation and select print landscape
- D.
All of the Above
Correct Answer
A. In Print Preview Mode, select page setup and click landscapeExplanation
In Print Preview Mode, selecting page setup and clicking landscape allows you to change the orientation of a worksheet to landscape. This option is typically found in the page setup settings, which can be accessed in the Print Preview Mode. By selecting landscape, the worksheet will be displayed horizontally, making it wider than it is tall. This is useful when the content of the worksheet is better suited for a wider layout.Rate this question:
-
- 4.
How can you add a header in Print Preview Mode?
- A.
In Print Preview Mode, select custom footer, then rotate page 180 degrees
- B.
In Print Preview Mode, select page setup and change to landscape mode
- C.
In Print Preview Mode, double click on the worksheet at the top and start typing header
- D.
In Print Preview Mode, select page setup, click heafer/footer tab, and click custon header
Correct Answer
D. In Print Preview Mode, select page setup, click heafer/footer tab, and click custon headerExplanation
In Print Preview Mode, you can add a header by selecting page setup, clicking on the header/footer tab, and then clicking on custom header. This allows you to customize the header for your document in Print Preview Mode.Rate this question:
-
- 5.
How can you get a multipage worksheet to print on one page?
- A.
In Print Preview Mode, click on page layout and use the size bars to manipulate the data
- B.
In Print Preview Mode, click on page setup and select fit to:
- C.
In Print Preview Mode, click on page setup and set boundaries in landscape mode
- D.
You can't do this in Print Preview Mode
Correct Answer
B. In Print Preview Mode, click on page setup and select fit to:Explanation
In Print Preview Mode, clicking on page setup and selecting "fit to:" allows you to adjust the scaling of the worksheet so that it fits onto one page when printed. This option automatically adjusts the size of the content on the worksheet to fit within the specified number of pages.Rate this question:
-
- 6.
How do you get gridlines to print?
- A.
In Print Preview Mode, click page setup, select the sheet tab, and check gridlines checkbox
- B.
In Print Preview Mode, click page setup, select the sheet tab, and make sure that print gridlines box is unchecked
- C.
In Print Preview Mode, click on page setup and select fit to:
- D.
In Print Preview Mode, select page setup, click heafer/footer tab, and check gridlines box.
Correct Answer
A. In Print Preview Mode, click page setup, select the sheet tab, and check gridlines checkboxExplanation
In order to get gridlines to print, you need to be in Print Preview Mode. From there, you should click on page setup and select the sheet tab. Finally, you need to check the gridlines checkbox. This will ensure that the gridlines are included when you print the document.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Apr 18, 2023Quiz Edited by
ProProfs Editorial Team -
Jan 02, 2012Quiz Created by
Ntorok
- Binary Code Quizzes
- Computer Concept Quizzes
- Computer Essential Quizzes
- Computer Forensics Quizzes
- Computer Hardware Quizzes
- Computer Networking Quizzes
- Computer Parts Quizzes
- Computer Programming Quizzes
- Computer Science Quizzes
- Computer Security Quizzes
- Computer Shortcut Key Quizzes
- Computer Skills Quizzes
- Computer Virus Quizzes
- Cyber Security Quizzes
- Data Quizzes
- Data Security Quizzes
- Hacking Quizzes
- HCI Quizzes
- Internet Quizzes
- IT SecurITy Quizzes
- Malware Quizzes
- Microprocessor Quizzes
- Network Quizzes
- Programming Language Quizzes
- Software Quizzes
Back to top