Question 1

You are using Microsoft Excel to create a budget for your team at work. The budget includes numbers, formulas, and text that spans several columns. 
 You made a mistake in one of the formulas, how do you correct the error?

Accepted Answer

The answer of You are using Microsoft Excel to create...

Question 2

You are working on a very large spreadsheet that you know will print on several pages. 
 Describe how to include the page number on the bottom left of every page of your document.

Accepted Answer

The answer of You are working on a very large...

Question 3

You are using Microsoft Excel to create a budget for your team at work. The budget includes numbers, formulas, and text that spans several columns. 
 Describe how to center a title over all of the columns that make up your budget.

Accepted Answer

The answer of You are using Microsoft Excel to create...

Question 4

You are using Microsoft Excel to create a budget for your team at work. The budget includes numbers, formulas, and text that spans several columns. 
 You just added a new row of information, but all of the text in the left-most column is not showing, how do you fix the problem?

Accepted Answer

The answer of You are using Microsoft Excel to create...

Question 5

You are working on a very large spreadsheet that you know will print on several pages. 
 Describe how you can visualize the entire document before you print it.

Accepted Answer

The answer of You are working on a very large...

Question 6

Match between columns
                        Premises: Accounting Number Format button
Order of precedence
Merge & Center button
Argument
AutoComplete

Accepted Answer

The Answer of Used to align text within a cell is...

Quiz 7: Creating and Enhancing a Worksheet

You are using Microsoft Excel to create a budget for your team at work. The budget includes numbers, formulas, and text that spans several columns. You made a mistake in one of the formulas, how do you correct the error?

You are working on a very large spreadsheet that you know will print on several pages. Describe how to include the page number on the bottom left of every page of your document.

You are using Microsoft Excel to create a budget for your team at work. The budget includes numbers, formulas, and text that spans several columns. Describe how to center a title over all of the columns that make up your budget.

You are using Microsoft Excel to create a budget for your team at work. The budget includes numbers, formulas, and text that spans several columns. You just added a new row of information, but all of the text in the left-most column is not showing, how do you fix the problem?

You are working on a very large spreadsheet that you know will print on several pages. Describe how you can visualize the entire document before you print it.

Match each item with the correct description.