CCC SPREADSHEET
CCC SPREADSHEET
Question – 1 : Where can you set the shedding color for a range of cells in Excel?
Answer – (A) : All of these
Answer – (B) : Choose required color on Fill Color tool in Drawing toolbar
Answer – (C) : Choose required color form Patterns tab of Format Cells dialog box
Answer – (D) : Choose required color on Fill Color tool in Formatting toolbar
View Answer
Correct Answer : (A)
Explanation :
Question – 2 : Text formulas:
Answer – (A) : Concatenate and manipulate text
Answer – (B) : Concatenate and manipulate text
Answer – (C) : Show formula error value
Answer – (D) : Replace cell references
View Answer
Correct Answer : (B)
Explanation :
Question – 3 : Multiple calculations can be made in a single formula using
Answer – (A) : array formula
Answer – (B) : Complex formulas
Answer – (C) : standard formulas
Answer – (D) : array formula
View Answer
Correct Answer : (D)
Explanation :
Question – 4 : If you need a text to show vertically in a cell. How will you achieve this?
Answer – (A) : Choose 90 Degrees in Orientation of Format Cells dialog box
Answer – (B) : Choose 90 Degrees in Orientation of Format Cells dialog box
Answer – (C) : Choose Center Across Selection from Horizontal combo box in Format Cells dialog box
Answer – (D) : Choose Vertical on Text alignment in Format Cells dialog box
View Answer
Correct Answer : (B)
Explanation :
Question – 5 : Which is used to perform what if analysis?
Answer – (A) : All of these
Answer – (B) : Scenario Manager
Answer – (C) : All of these
Answer – (D) : Goal seek
View Answer
Correct Answer : (C)
Explanation :
Question – 6 : You can auto fit the width of column by
Answer – (A) : Double clicking on column right border on column header
Answer – (B) : Double clicking on the column left border of column header
Answer – (C) : double clicking on the column name on column header
Answer – (D) : Double clicking on column right border on column header
View Answer
Correct Answer : (D)
Explanation :
Question – 7 : What happens when you press Ctrl + X after selecting some cells in Excel?
Answer – (A) : The cells selected are marked for cutting
Answer – (B) : The selected cells are deleted and cells are shifted up
Answer – (C) : The cell content of selected cells disappear from cell and stored in clipboard
Answer – (D) : The cells selected are marked for cutting
View Answer
Correct Answer : (D)
Explanation :
Question – 8 : Can you set 0.5 inch left indentation for a cell in Excel?
Answer – (A) : Indentation can be set from Format Cells dialog box
Answer – (B) : The indentation can be specified only when printing
Answer – (C) : Excel does not have indentation feature
Answer – (D) : Indentation can be set from Format Cells dialog box
View Answer
Correct Answer : (D)
Explanation :
Question – 9 : How can you print three copies of a workbook?
Answer – (A) : Select File >Print from the menu and type 3 in the Number of copies text box.
Answer – (B) : Select File >Print from the menu and type 3 in the Number of copies text box.
Answer – (C) : Select File>Properties form the menu and type 3 in the Copies to print text box.
Answer – (D) : Click the Print button on the standard toolbar to print the document then take it to Kinko’s and have 2 more copies made
View Answer
Correct Answer : (B)
Explanation :
Question – 10 : How can you find specific information in a list?
Answer – (A) : Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button
Answer – (B) : Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button
Answer – (C) : Select Insert > Find from the menu
Answer – (D) : Select Tools > Finder from the menu
View Answer
Correct Answer : (B)
Explanation :
Question – 11 : The name box
Answer – (A) : Appears to the left of the formula bar
Answer – (B) : Appears below the status bar
Answer – (C) : Appears to the left of the formula bar
Answer – (D) : Appears below the menu bar
View Answer
Correct Answer : (C)
Explanation :
Question – 12 : It is acceptable to let long text flow into adjacent cells on a worksheet when
Answer – (A) : no data will be entered in the adjacent cells
Answer – (B) : there is no suitable abbreviation for the text
Answer – (C) : no data will be entered in the adjacent cells
Answer – (D) : data will be entered in the adjecent cells
View Answer
Correct Answer : (C)
Explanation :
Question – 13 : When a label is too long to fit within a worksheet cell, you typically must
Answer – (A) : Increase the column width
Answer – (B) : Adjust the row height
Answer – (C) : Shorten the label
Answer – (D) : Increase the column width
View Answer
Correct Answer : (D)
Explanation :
Question – 14 : Edit >> Delete command
Answer – (A) : Deletes selected cells
Answer – (B) : Deletes selected cells
Answer – (C) : Deletes the content of a cell
Answer – (D) : Deletes the comment of cell
View Answer
Correct Answer : (B)
Explanation :
Question – 15 : How do you insert a row?
Answer – (A) : Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
Answer – (B) : Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
Answer – (C) : Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
Answer – (D) : Select the row heading where you want to insert the new row and select Edit >Row from the menu
View Answer
Correct Answer : (B)
Explanation :
Question – 16 : To remove the content of selected cells you must issue ______ command.
Answer – (A) : Edit >> Clear >> Contents
Answer – (B) : Edit >> Delete
Answer – (C) : Edit >> Clear >> All
Answer – (D) : Edit >> Clear >> Contents
View Answer
Correct Answer : (D)
Explanation :
Question – 17 : What is the short cut key to replace a data with another in sheet?
Answer – (A) : Ctrl + H
Answer – (B) : Ctrl + F
Answer – (C) : Ctrl + R
Answer – (D) : Ctrl + H
View Answer
Correct Answer : (D)
Explanation :
Question – 18 : You can activate a cell by
Answer – (A) : All of these
Answer – (B) : All of these
Answer – (C) : Clicking the cell
Answer – (D) : Pressing the Tab key
View Answer
Correct Answer : (B)
Explanation :
Question – 19 : Which of the following methods can not be used to enter data in a cell
Answer – (A) : Pressing the Esc key
Answer – (B) : Clicking on the formula bar
Answer – (C) : Pressing the Tab key
Answer – (D) : Pressing an arrow key
View Answer
Correct Answer : (A)
Explanation :
Question – 20 : Which of the following is not the correct method of editing the cell content?
Answer – (A) : Press the Alt key
Answer – (B) : Double click the cell
Answer – (C) : Click the formula bar
Answer – (D) : Press the Alt key
View Answer
Correct Answer : (D)
Explanation :
Question – 21 : Which tool you will use to join some cells and place the content at the middle of joined cell?
Answer – (A) : Click on Merge and Center tool on formatting toolbar
Answer – (B) : Click on Merge and Center tool on formatting toolbar
Answer – (C) : From Format Cells dialog box select the Centered alignment
Answer – (D) : From Format Cells dialog box choose Merge and Center check box
View Answer
Correct Answer : (B)
Explanation :
Question – 22 : How do you select an entire column?
Answer – (A) : Click the column heading letter
Answer – (B) : Hold down the shift key as you click anywhere in the column.
Answer – (C) : Hold down the Ctrl key as you click anywhere in the column
Answer – (D) : Click the column heading letter
View Answer
Correct Answer : (D)
Explanation :
Question – 23 : Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?
Answer – (A) : Divide
Answer – (B) : Divide
Answer – (C) : Square
Answer – (D) : Goal Seek
View Answer
Correct Answer : (B)
Explanation :
Question – 24 : Which of the following will not cut information?
Answer – (A) : Pressing Ctrl + C
Answer – (B) : Selecting Edit>Cut from the menu
Answer – (C) : Clicking the Cut button on the standard
Answer – (D) : Pressing Ctrl + C
View Answer
Correct Answer : (D)
Explanation :
Question – 25 : To center worksheet titles across a range of cells, you must
Answer – (A) : Select the cells containing the title text plus the range over which the title text is to be centered
Answer – (B) : Select the cells containing the title text plus the range over which the title text is to be centered
Answer – (C) : Format the cells with the comma style
Answer – (D) : Widen the columns
View Answer
Correct Answer : (B)
Explanation :
Question – 26 : How do you delete a column?
Answer – (A) : Right click the column heading you want to delet and select delete from the shortcut menu
Answer – (B) : Right click the column heading you want to delet and select delete from the shortcut menu
Answer – (C) : Select the row heading you want to delete and select Edit>Delete from the menu
Answer – (D) : Select the column heading you want to delete and select the Delete Row button on the standard toolbar
View Answer
Correct Answer : (B)
Explanation :
Question – 27 : Comments put in cells are called
Answer – (A) : Cell tip
Answer – (B) : Web tip
Answer – (C) : Cell tip
Answer – (D) : Smart tip
View Answer
Correct Answer : (C)
Explanation :
Question – 28 : You can use the horizontal and vertical scroll bars to
Answer – (A) : View different rows and columns edit the contents of a cell
Answer – (B) : Split a worksheet into two panes
Answer – (C) : View different rows and columns edit the contents of a cell
Answer – (D) : Edit the contents of a cell
View Answer
Correct Answer : (C)
Explanation :
Question – 29 : If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must
Answer – (A) : From Edit menu choose Clear and then Formats
Answer – (B) : Double click the Format Painter and then press Esc key in keyboard
Answer – (C) : From Edit menu choose Delete
Answer – (D) : From Edit menu choose Clear and then Formats
View Answer
Correct Answer : (D)
Explanation :
Question – 30 : Which of the following is not a way to complete a cell entry?
Answer – (A) : Pressing spacebar
Answer – (B) : Clicking the Enter button on the Formula bar
Answer – (C) : Pressing enter
Answer – (D) : Pressing spacebar
View Answer
Correct Answer : (D)
Explanation :
CCC SPREADSHEET
CCC SPREADSHEET
CCC SPREADSHEET
CCC SPREADSHEET
CCC SPREADSHEET
CCC SPREADSHEET
CCC SPREADSHEET
CCC SPREADSHEET
CCC SPREADSHEET
CCC SPREADSHEET
CCC SPREADSHEET
CCC SPREADSHEET
CCC SPREADSHEET
CCC SPREADSHEET
CCC SPREADSHEET
CCC SPREADSHEET
CCC SPREADSHEET
CCC SPREADSHEET
CCC SPREADSHEET