MICROSOFT EXCEL

The Chart wizard term data categories refers to:

• (A) A chart plot area
• (B) A horizontal axis
• (C) The organization of individual values with a chart’s data series
• (D) The data range that supply chart data

A worksheet range is a:

• (A) A command used for data modeling
• (B) A range of values such as from 23 to 234
• (C) A group of cells
• (D) A group of worksheets

Getting data from a cell located in a different sheet is called:

• (A) Accessing
• (B) Referencing
• (C) Updating
• (D) Functioning

Tab scrolling button:

• (A) Allow you to view a different worksheet
• (B) Allow you to view additional worksheet rows down
• (C) Allow you to view additional worksheet columns to the right
• (D) Allow you to view additional sheets tabs

A numeric value can be treated as a label value if it precedes with:

• (A) Apostrophe (&lsquo
• (B) Exclamation (!)
• (C) Hash (#)
• (D) Ampersand (&

Concatenation of text can be done using:

• (A) Apostrophe (&lsquo
• (B) Exclamation (!)
• (C) Hash (#)
• (D) Ampersand (&

Data can be arranged in a worksheet in a easy to understand manner using:

• (A) auto formatting
• (B) applying styles
• (C) changing fonts
• (D) all of above

You can use drag-and-drop to embed excel worksheet data in a word document:

• (A) By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
• (B) By dragging a range of excel data to the word button on the taskbar while pressing Shift key
• (C) By dragging a range of excel data to the word button on the taskbar while pressing Alt key
• (D) None of above

The auto calculate feature:

• (A) Can only add values in a range of cells
• (B) Provides a quick way to view the result of an arithmetic operation on a range of cells
• (C) Automatically creates formulas and adds them to a worksheet
• (D) A and c

Excel uniquely identifies cells within a worksheet with a cell name:

• (A) Cell names
• (B) Column numbers and row letters
• (C) Column letters and row numbers
• (D) Cell locator coordinates