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