Question 1

In the accompanying figure, item 2 points to the ____.

Accepted Answer

The answer of 
In the accompanying figure, item 2 points...

Question 2

The ____________________ button allows you to merge several cells into one cell and center the text in the merged cell.

Accepted Answer

The answer of The ____________________ button allows you to merge...

Question 3

Describe how to enter data in an Excel worksheet.

Accepted Answer

The answer of Describe how to enter data in an...

Question 4

Excel uses the order of precedence which is the standard order used in  ____.

Accepted Answer

Excel uses the order of precedence in math, which is a set of rules that dictate the order in which calculation operations are performed when there are multiple operators involved in a single formula.

Question 5

To preview a worksheet, click the ______ button in Backstage view.

Accepted Answer

The answer of To preview a worksheet, click the ______...

Question 6

In addition to themes, you can add ______________ to individual cells to improve their appearance.

Accepted Answer

The answer of In addition to themes, you can add...

Question 7

When you copy a formula to a new cell, the original cell references are replaced with cell references that are in the same ____ position as those in the original formula.

Accepted Answer

Relative references change based on their position relative to the new cell, whereas absolute references always refer to the same cell. Adjacent and exact do not accurately describe how the cell references are changed when copying a formula.

Question 8

Describe how to change cell alignment.

Accepted Answer

The answer of Describe how to change cell alignment....

Question 9

A(n) ____________________ is information included at the top of every page in your worksheet.

Accepted Answer

The answer of A(n) ____________________ is information included at the...

Question 10

_____ referencing is when you copy a formula to a new cell and Excel automatically replaces the original cell references with cell references that are in the same relative position as those in the original formula.

Accepted Answer

Relative referencing is a feature in Excel that allows you to copy a formula to a new cell and automatically adjust the cell references so that they refer to the correct cells relative to the new location of the formula. This is in contrast to absolute referencing, where the cell references remain fixed regardless of where the formula is copied. Formula and relational are not relevant to the concept of referencing in Excel.

Question 11

To insert a column, click the column heading to the right of where you want the new one, and then click the Insert button in the ____ group.

Accepted Answer

To insert a column, we need to go to the Cells group and click on the Insert button.

Question 12

In Excel, the asterisk is the symbol for ____.

Accepted Answer

The asterisk symbol (*) represents multiplication in Excel.

Question 13

The Enter button, which is a check mark icon, is on the ____.

Accepted Answer

The Enter button, represented by a check mark icon, is located on the formula bar in spreadsheet programs like Microsoft Excel. This button is used to confirm the entry or editing of a formula or data in a cell.

Question 14

Check the ____________________ text box in the Print Preview area to make sure your computer is set to the right printer.

Accepted Answer

The answer of Check the ____________________ text box in the...

Question 15

When you click the ____ button, a dotted border appears around the range of cells that Excel assumes you want to add together.

Accepted Answer

The AutoSum button is specifically designed to easily add up a range of cells in Excel. When you click it, Excel automatically selects what it believes to be the range of cells you want to sum, and places a dotted border around them.

Question 16

In the accompanying figure, item 3 points to the ____.

Accepted Answer

Item 3 is pointing to the active cell, which is the cell currently selected or being edited. It is not pointing to any of the other options listed.

Question 17

If a page is taller than it is wide and some columns are cut off from view, you need to adjust the _________________ in the Settings area of the Print Preview area.

Accepted Answer

The answer of If a page is taller than it...

Question 18

Describe how to change the number format in a cell.

Accepted Answer

The answer of Describe how to change the number format...

Question 19

According to the order of precedence, which operation below should be performed first?

Accepted Answer

In mathematics and computer programming, the order of operations dictates that operations within parentheses are performed first before other operations like multiplication (*), division (/), and addition (+).

Question 20

Click the ____________________ button on the PAGE LAYOUT tab to add a consistent look to all of the elements in your workbook.

Accepted Answer

The answer of Click the ____________________ button on the PAGE...

Quiz 7: Creating and Enhancing a Worksheet