Exam 13: Creating a Workbook

A pixel is a single point, or the smallest colorable area, on a computer monitor or printout.

Mike is working on a project that requires him to calculate the scaled up values of parts from an engineering plan to a working model. In order to do this, items in column B need to be raised to the tenth power to meet the values in column C and the final value should appear in columnD)Which of the following formulas should Mike enter in the first row of column D?

In the following snippet of Microsoft Excel 2016 document, when the selected range is inserted into a worksheet, the rest of the cells shift down because:

Microsoft Excel is software used to create _____ that can be used to enter, analyze, and present quantitative data.

Every Excel formula:

A formula is written using _________ that combine different values to return a single value. A)references B)operators C)commas D)colons

Case 13-2 Megan has created a workbook using Microsoft Excel 2016 and wants to print it. There are many worksheets in her file, and so Megan selects the Print command from the Backstage view. The preview of her work is shown in a page that is taller than it is wide. Which of the following orientations will make sure her work is printing on a sheet that is wider than it is tall?

Elsa has collated information for a meeting using Excel. Due to certain developments, some of the data in her worksheet is now redundant. She deletes three rows from her worksheet to reflect the developments. Which of the following will happen to the rest of the rows in the worksheet when Elsa deletes three rows?

By default, Microsoft Excel 2016 displays pages ready to print in the landscape orientation.

Once you have _________ a formula, a moving, dashed border surrounds the cell you copied it from. A)pasted B)selected C)copied D)changed

While dragging a range of cells, if the new location is not visible, drag the selected range to the edge of the worksheet in the direction you want to scroll.

Boris has created a workbook that consists of data related to the organization he works with. The last sheet in the workbook is the documentation sheet that allows people who share the file to know the purpose of the file. The documentation sheet appears last when the workbook is opened. Which of the following should Boris do if he wants people to see this sheet first when they open the file?

Column widths are expressed in terms of either the number of characters the column can contain or the size of the column in _____.

In Microsoft Excel 2016, which of the following date data format displays dates in mm/dd/yyyy format?

You can enter a(n) _________ in the Name box to select a range in the worksheet. A)range formula B)range data C)range reference D)range function

You can drag and copy a range to another location in the worksheet by double-clicking the cell.

Which of the following is the default number format that Microsoft Excel uses to enter numerical values?

Which of the following happens if you choose to wrap text within a cell?

In the following snippet of a Microsoft Excel 2016 worksheet, the information in cell B5 extends beyond the cell's border because:

To select adjacent columns you can click the first column header, press and hold the _________, and click the last header. A)Alt key B)Shift key C)Ctrl key D)Tab key