To align currency symbols and decimal points in a column of numbers, you can apply the ____ number format.

• 
  

  Currency

• Accounting

• 
  

  Percentage

• General

Which of the following tabs lets you set worksheet print options?

• Page Layout

• Home

• File

Which of the following is true when you delete a cell?

• 
  

  When you delete cells using the Delete list arrow, you can choose which way to move adjacent cells.

• Row and column alignment will not be affected.

• You need to manually adjust cell references in surrounding formulas.

• You can use the Delete command on the Insert tab.

Which of the following should you select as X in the following series of clicks to change the chart type to a clustered column chart: Chart > Chart Tools > Design tab > Type group > Change Chart Type > All Charts > X > Clustered Column > OK?

• pie

• bar

• line

• column

The default worksheet text is _____-point Calibri.

where can you see a preview of how your worksheet will look when printed, included nheaders

• print tab in backstage view

• page break preview

• normal view

To apply a cell style, you would use the Cell Styles command on the _____ tab.

Steffie wants to change the margins of a worksheet to Normal to align it better on a printed page. To do this, what can she do after selecting the worksheet for this purpose?

• Click Margins in the Page Setup group on the Page Layout tab and then click on Normal.

• Set Width and Height to Automatic and Scale to 100% in the Scale to Fit group on the Page Layout tab.

• Click Orientation and then select from the drop down menu in the Page Setup group on the Page Layout tab.

• Check the boxes beside Gridlines View Point and Headings View Point in the Sheet Options group on the Page Layout tab.

When you double-click a cell's right column border, which of the following occurs?

• The column is deleted.

• AutoFit resizes the column to 8.43 characters wide.

• A column is added to the right of the column's border.

• AutoFit resizes the column to the widest cell entry.

In a complex formula, how does Excel determine which calculation to perform first?

• 
  

  It calculates the leftmost formulas first.

• it calculates operations outside parentheses first.

• It follows the order of operations.

• It calculates functions first.