CCC MCQ - English

Spreadsheets MCQ Questions and Answers

Home | CCC | Spreadsheets

CCC Online Test MS Excel MCQ Questions and Answers [with Pdf Download] : We provide mcqs questions on excel, you can learn and test excel objective questions and answers and if you want to download excel mcq pdf or notes click given link below.

Download CCC PDF Click Here. 

MS Excel MCQ in Hindi Click Here. 

Page: 1/24

1) Which of the following methods cannot be used to enter data in a cell

    Pressing an arrow key
    Pressing the Tab key
    Pressing the Esc key
    Clicking on the formula bar

Answer : C Discuss

2) Which of the following will not cut information?

    Pressing Ctrl + C
    Selecting Edit>Cut from the menu
    Clicking the Cut button on the standard
    Pressing Ctrl+X

Answer : A Discuss

3) Which of the following is not a way to complete a cell entry?

    Pressing enter
    Pressing any arrow key on the keyboard
    Clicking the Enter button on the Formula bar
    Pressing spacebar

Answer : D Discuss

4) You can activate a cell by

    Pressing the Tab key
    Clicking the cell
    Pressing an arrow key
    All of the above

Answer : D Discuss

Free Online Test

MS Excel Online Test in English
25 Questions | 10 Minutes

Start Now



5) Text formulas:

    Replace cell references
    Return ASCII values of characters
    Concatenate and manipulate text
    Show formula error value

Answer : C Discuss

6) How do you insert a row?

    Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
    Select the row heading where you want to insert the new row and select Edit >Row from the menu
    Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
    All of the above

Answer : A Discuss

7) Which of the following is not a basic step in creating a worksheet?

    Save workbook
    Modifiy the worksheet
    Enter text and data
    Copy the worksheet

Answer : D Discuss

8) How do you select an entire column?

    Select Edit > Select > Column from the menu
    Click the column heading letter
    Hold down the shift key as you click anywhere in the column.
    Hold down the Ctrl key as you click anywhere in the column

Answer : B Discuss

9) How can you print three copies of a workbook?

    Select File>Properties form the menu and type 3 in the Copies to print text box.
    Select File >Print from the menu and type 3 in the Number of copies text box.
    Click the Print button on the standard toolbar to print the document then take it to Kinko’s and have 2 more copies made
    Press Ctrl+P+3

Answer : B Discuss

10) To create a formula, you first:

    Select the cell you want to place the formula into
    Type the equals sign (=) to tell Excel that you’re about to enter a formula
    Enter the formula using any input values and the appropriate mathematical operators that make up your formula
    Choose the new command from the file menu

Answer : A Discuss

Jump to Pages:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

Free Online Test

MS Excel Online Test in English
25 Questions | 10 Minutes

Start Now



MCQ Category