|Total of questions: 286|
|Total of questions: 286|
|First steps (21 questions)|
|Basic Settings (14 questions)|
|Cells 1 (25 questions)|
|Cells 2 (24 questions)|
|WorkSheets (10 questions)|
|Formulas and Functions (41 questions)|
|Formatting (29 questions)|
|Charts (23 questions)|
|Output: Setup and Print (22 questions)|
|Functions (14 questions)|
|Images (3 questions)|
|MS Excel 2016, 2013, 2010, 2007, 2003 (BENCHMARK) (30 questions)|
|MS Excel 2016, 2013, 2010, 2007, 2003 (ASSESSMENT) (30 questions)|
Enter the text Computer Sales in the left section of the header of the SALES worksheet.
Format the 2ndhour2 worksheet so that the second row is automatically printed at the top of each page.
Change the print settings of the 2ndhour2 worksheet, so that the worksheet is printed to one (1) page in width and three (3) pages in height.
Apply the appropriate print settings on the 2ndhour2 worksheet so that the gridlines and the row and column headings are printed.
Set the margins of the active worksheet as follows:
Top: 1,5", bottom: 1,5"
Left: 0,5", right: 0,5"
Header: 0,75", footer: 0,75"
Apply landscape orientation and Letter paper size on the active worksheet.
Set the header of the active worksheet in the following order: file name, slash ( / ), sheet name (e.g. myxls.xls/sheet1), and place it in the center of the header. Set the page numbering to appear in the center of the footer, in the Page 1 of ? form.
Set as a workbook view of the active window the Page Break Preview.
Print the entire active worksheet to the default printer.
Select and print the cell range A9:B12 only.
Print the entire active workbook to the default printer.
Print the selected chart only.
Set the print scale of the SALES worksheet to 150% and the print scale of the 2ndhour2 worksheet to 135%.
Modify the footer of the SALES worksheet so that the current date is printed on the left section. Also modify the footer of the 2ndhour2 worksheet so that the current time is printed on the right section.
Print the entire active worksheet to the c:\test4u_printer\myprint2.prn file using the default printer.
Change the orientation of the active worksheet to Landscape.
Change the paper size to Letter.
Apply the appropriate printer settings on the 2ndhour2 worksheet so that the row and column headings are displayed while printing.
Apply the appropriate printer settings on the 2ndhour2 worksheet so that the grid lines are displayed while printing.
Print the active worksheet in two copies.
Which of the following icons corresponds to the print preview icon?
Click on the appropriate point of the photo to display the print preview of the worksheet already opened.