Which of the following statement is false?
- (A) You can set different header footer for even and odd pages
- (B) You can set different page number formats for different sections
- (C) You can set different header footer for first page of a section
- (D) You can set different header and footer for last page of a section
- (D) You can set different header and footer for last page of a section
Where can you change the vertical alignment?
- (A) Formatting toolbar
- (B) Paragraph dialog box
- (C) Page Setup dialog box
- (D) Standard toolbar
- (C) Page Setup dialog box
To autoFit the width of column:
- (A) Double click the right border of column
- (B) Double click the left border of column
- (C) Double click the column header
- (D) All of above
- (A) Double click the right border of column
What feature enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula?
- (A) Goal Seek
- (B) Scenario Summary report
- (C) Forecasting
- (D) Trend line
- (A) Goal Seek
What term describes a background that appears as a grainy, non smooth surface:
- (A) gradient
- (B) pattern
- (C) solid
- (D) texture
- (D) texture
Excel is a:
- (A) Graphic program
- (B) Word processor
- (C) A spreadsheet
- (D) None of these
- (C) A spreadsheet
To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called:
- (A) HTML
- (B) Pivot Table Field List
- (C) Pivot Table List
- (D) Pivot Table Report
- (D) Pivot Table Report
What function displays row data in a column or column data in a row?
- (A) Hyperlink
- (B) Index
- (C) Transpose
- (D) Rows
- (C) Transpose
When you insert an Excel file into a Word document, the data are:
- (A) Hyperlinked
- (B) Placed in a word table
- (C) Linked
- (D) Embedded
- (C) Linked
Except for the function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result:
- (A) IF
- (B) AND
- (C) OR
- (D) NOT
- (A) IF