Question 1

Excel has many Page Setup options.Please briefly describe each of the following: Portrait orientation, Landscape orientation, Gridlines, and Worksheet headings.

Accepted Answer

The answer of Excel has many Page Setup options.Please briefly...

Question 2

When using the spell checker, if no suggested spellings are displayed, click the Not in Dictionary text box, then type the correct word._________________________

Accepted Answer

This is true. If no suggested spellings are displayed, the user can manually enter the correct word by clicking on the "Not in Dictionary" text box and typing the correct spelling.

Question 3

When using the spell checker, if the correct spelling appears in the Recommendations list, click to select it, then click the Change button to correct the misspelled word._________________________

Accepted Answer

Suggestions

Question 4

Data sorted in ascending order will be arranged in reverse alphabetical order-labels that start with Z will be positioned above those that start with Y._________________________

Accepted Answer

descending

Question 5

It's a good idea to use the Save option to rename and save an extra copy of your worksheet before testing your worksheet for errors._________________________

Accepted Answer

Save As

Question 6

Vector drawings can be created using Excel's drawing tools._________________________

Accepted Answer

Excel does have drawing tools that allow users to create vector drawings.

Question 7

Case 14-1
Juliet wants to save a worksheet as a Web page. Please answer the questions below.
-Part of Juliet's worksheet contains formatting that isn't available in HTML.She is notified of the problem areas and is given the option of ____.

Accepted Answer

When saving a worksheet as a Web page, if there are formatting issues that aren't compatible with HTML, the user is typically given the option to either cancel the save process to address the issues or continue with the save despite the potential formatting problems. This ensures that the user has control over how to proceed with the save operation, acknowledging the limitations or making necessary adjustments.

Question 8

You can use the Charts group on the Page Layout tab to chart or graph data in your worksheet._________________________

Accepted Answer

Insert

Question 9

Case 14-1
Juliet wants to save a worksheet as a Web page. Please answer the questions below.
-To make sure that her worksheet will convert successfully to a Web page, Juliet previews her worksheet in ____ prior to posting the file.

Accepted Answer

Previewing the worksheet in a Web browser will give Juliet the most accurate representation of how the worksheet will appear as a Web page. Previewing it in Windows Explorer or Windows Excel would not provide the same level of accuracy.

Question 10

Excel creates a chart based on the data and labels you select from a worksheet._________________________

Accepted Answer

Excel uses the selected data and labels to create a chart.

Question 11

Worksheet headings are the column letters and row numbers._________________________

Accepted Answer

This statement is true. Worksheet headings in Microsoft Excel, for example, are the column letters (A, B, C, etc.) and row numbers (1, 2, 3, etc.) that are used to identify cells within the worksheet.

Question 12

To draw an arrow, click the Insert tab, then click Shapes in the Pictures group._________________________

Accepted Answer

Illustrations

Question 13

You can add graphics to your Excel worksheet.Please describe the Shapes tools and how you would go about drawing an arrow.Please also describe the Smart Art button and how you would insert SmartArt into your worksheet.

Accepted Answer

The answer of You can add graphics to your Excel...

Question 14

When a chart is selected, you can move it or resize it by dragging the sizing handles._________________________

Accepted Answer

When a chart is selected, you can move and resize it using the sizing handles which are located on its corners and sides.

Question 15

Case 14-1
Juliet wants to save a worksheet as a Web page. Please answer the questions below.
-To save her worksheet as a Web page, Juliet first access the Save As dialog box, clicks a Selection option, chooses an ____ file type, names her file, and clicks Save.

Accepted Answer

HTML is the standard file type for saving a worksheet as a Web page. HTTP is a protocol used for communication between web servers and clients, XML is a markup language used for structuring and storing data, and JavaScript is a scripting language used for creating interactive effects on Web pages.

Quiz 14: Finalizing a Worksheet