Question 1

The portion of the spreadsheet to be printed can be specified using margins.

Accepted Answer

The portion of the spreadsheet to be printed can be specified using print area, not margins.

Question 2

The real power of Excel lies in its amazing computational capability.Explain.

Accepted Answer

The answer of The real power of Excel lies in...

Question 3

If a spreadsheet is printed sideways on a page,the orientation is said to be portrait.

Accepted Answer

If a spreadsheet is printed sideways on a page, the orientation is said to be landscape, not portrait.

Question 4

In Excel,________ refers to whether a worksheet is printed normally or sideways on a page.
A)layout
B)orientation
C)alignment
D)setup

Accepted Answer

Orientation refers to the way the page is printed, either in portrait (normal) or landscape (sideways). Layout refers to how the data is organized on the page, alignment refers to how the data is positioned within a cell, and setup typically refers to the page size, margins, and print quality settings.

Question 5

Which of the following is true of the printing option in Excel spreadsheets?
A)Gridlines can only be viewed in the print preview and cannot be printed.
B)Print Preview is present in the Review tab.
C)Landscape orientation prints a worksheet upright.
D)Print area can be used to specify the portion of the spreadsheet to be printed.

Accepted Answer

The print area option allows for specific portions of a spreadsheet to be printed. Gridlines can be printed, and landscape orientation will print a worksheet sideways to fit more columns onto a page. Print Preview is located in the File tab.

Question 6

Whenever users have a problem with a calculation in Excel,they can press F2 to highlight the cells involved in that calculation.

Accepted Answer

Pressing F2 in Excel highlights the cells involved in a calculation, making it easier for users to identify and solve any errors in their calculations.

Question 7

While copying a formula,Excel can adjust the terms of the formula to refer to the cells,in the row to which it is copied.

Accepted Answer

This is known as relative referencing in Excel. When a formula is copied, the cell references are adjusted automatically based on the relative position of the new cell. For example, if a formula refers to cell A1 and is copied to a cell in the next row, the reference will automatically change to A2.

Question 8

The tools and selections in the PAGE LAYOUT ribbon determine how a document will be arranged as a printed document.

Accepted Answer

The PAGE LAYOUT ribbon in Microsoft Word contains tools and options that enable users to customize the layout, formatting, and printing options of a document, such as margins, orientation, size, and page background. These settings help users create professional-looking documents that are optimized for reading, printing, or publishing. Therefore, the statement that the tools and selections in the PAGE LAYOUT ribbon determine how a document will be arranged as a printed document is true.

Quiz 16: Introduction to Microsoft Excel 2013