Download CCC Old Paper

Question : 1 To return the remainder after a number is divided by a divisor in EXCEL we use the function

  1. ROUND ( )
  2. FACT ( )
  3. MOD ( )
  4. DIV ( )

Answer : 3

Question : 2 MS-EXCEL can be used to automate

  1. Financial statements, Business forecasting
  2. Transaction registers, inventory control
  3. Accounts receivable, accounts payable
  4. Any of the above

Answer : 4

Question : 3 What function displays row data in a column or column data in a row?

  1. Hyperlink
  2. Index
  3. Transpose
  4. Rows

Answer : 3

Question : 4 Which types of charts can excel produce?

  1. Line graphs and pie charts only
  2. Only line graphs
  3. Bar charts, line graphs and pie charts
  4. Bar charts and line graphs only

Answer : 3

Question : 5 How are data organized in a spreadsheet?

  1. Lines and spaces
  2. Layers and planes
  3. Rows and columns
  4. Height and width

Answer : 3

Question : 6 What does the VLOOKUP function do?

  1. Looks up text that contain ‘v’
  2. Checks whether text is the same in one cell as in the next
  3. Finds related records
  4. All of above

Answer : 3

Question : 7 A function inside another function is called a function.

  1. Nested
  2. Round
  3. Sum
  4. Text

Answer : 1

Question : 8 How should you print a selected area of a worksheet, if you’ll want to print a different area next time?

  1. On the file menu, point to print area, and then click set print area.
  2. On the file menu, click print, and then click selection under print what
  3. On the view menu, click custom views, then click add
  4. All of above

Answer : 2

Question : 9 Which of the following methods can not be used to enter data in a cell?

  1. Pressing an arrow key
  2. Pressing the tab key
  3. Pressing the Esc key
  4. Clicking the enter button to the formula bar

Answer : 3

Question : 10 Which of the following methods cannot be used to edit the content of cell?

  1. Pressing the Alt key
  2. Clicking the formula bar
  3. Pressing F2
  4. Double clicking the cell

Answer : 1

Question : 11 You can activate a cell by

  1. Pressing the Tab key
  2. Clicking the cell
  3. Pressing an arrow key
  4. All of above

Answer : 4

Question : 12 Which of the following setup options can not be set in the page setup dialog box?

  1. Printer selection
  2. Vertical or horizontal placement
  3. Orientation
  4. Row and column titles

Answer : 1

Question : 13 What term refers to a specific set of values saved with the workbook?

  1. Range
  2. Scenario
  3. rend line
  4. What-if analysis

Answer : 2

Question : 14 Which of the following describes how to select all the cells in a single column?

  1. Right click on column and select Pick from list
  2. Use data – text to columns menu item
  3. Left click on the gray column title button
  4. Pressing Ctrl + A on the keyboard

Answer : 3

Question : 15 To insert three columns between columns D and E you would

  1. Select column D
  2. Select column E
  3. Select columns E, F and G
  4. Select columns D, E, and F.

Answer : 2

Question : 16 To center worksheet titles across a range of cell, you must

  1. Select the cells containing the title text and use the fill handle to center
  2. Widen the columns
  3. column width
  4. Row height

Answer : 1

Question : 17 How do you change column width to fit the contents?

  1. Single-click the boundary to the left to the column heading
  2. Double click the boundary to the right of the column heading
  3. Press Alt and single click anywhere in the column
  4. All of above

Answer : 2

Question : 18 You can use the horizontal and vertical scroll bars to

  1. Split a worksheet into two panes
  2. View different rows and columns
  3. Edit the contents of a cell
  4. View different worksheets

Answer : 2

Question : 19 Which of the following is an absolute cell reference?

  1. !A!1
  2. $A$1
  3. #a#1
  4. A1

Answer : 2

Question : 20 Which symbol must all formula begin with?

  1. =
  2. +
  3. (
  4. @

Answer : 1