Excel Basic

If you see a series of "######" in a cell, that means the following:

• You keyed in an incorrect number
• The row height is too high
• The text is incorrectly spelled
• The column width is not wide enough

Which of the following operators do you use to begin typing a formula?

• -

• +
• =
• (

What number format is used for to get this kind of cell [$ 1.234,00]?

• General

• Accounting/Currency

• Number

• Text

Where can we find quick analysis on selected cells (sum,average,min/max etc.)?

• Status bar

• Formula bar

• Name box

• Ribbon

When we want to look two sheets from the same workbook in separate windows, what options do we use?

• Open another instance of the same workbook (double click)

• Use Split option on View tab

• Page Break View

• Use New Window + Arrange options in View tab

How do we freeze all cells above Row 4 and left of Column D (with Row 4 and Column D NOT freezed)?

• Select Cell "E5" and click Freeze Panes

• Click Freeze Top Row and Freeze Top Column

• Select Cell "D4" and click Freeze Panes

• Hide Rows 1-4 and A-C

How should we type Custom Number format to create a number with meter unit next to it. I.E. [ 1,000.00 cm ]

• #,##0.00 "cm"

• 0 "cm"

• #,##0.00 cm

• 0 cm

What option do we use to remove all text and colors from selected cells at the same time?

• Clear Formats

• Delete on keyboard

• Clear All

• Clear Contents

To format cells like this, which Conditional formatting should we use?

• Color Scales

• Highlight Cells Rules:

  Greater Than

  Less Than

  Between

• Top/bottom Rules

• Data bars

To format 25 cells with the biggest value in some range, what Conditional formatting should we use?

• Top/bottom Rules

  - Above Average

• Highlight Cells Rules

  - Greater than

• Top/Bottom Rules

  - Top 10 items

• Top/Bottom Rules

  • - Top 10%