CCC SPREADSHEET MCQ QUESTIONS AND ANSWERS
CCC SPREADSHEET MCQ QUESTIONS AND ANSWERS
Question – 1 : You can merge the main document with data source in Excel. In mail merge operation, Word is usually
Answer – (A) : client
Answer – (B) : none
Answer – (C) : source
Answer – (D) : server
View Answer
Correct Answer : (A)
Explanation :
Question – 2 : When a row of data is to be converted into columns
Answer – (A) : Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK.
Answer – (B) : Copy the cells in row, select the same number of cells in row and paste
Answer – (C) : Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK
Answer – (D) : Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK.
View Answer
Correct Answer : (D)
Explanation :
Question – 3 : MS Excel provides the default value for step in Fill Series dialog box
Answer – (A) : 1
Answer – (B) : 0
Answer – (C) : 10
Answer – (D) : 1
View Answer
Correct Answer : (D)
Explanation :
Question – 4 : Excel probably considers the cell entry January 1, 2000 to be a
Answer – (A) : Value
Answer – (B) : Value
Answer – (C) : Text string
Answer – (D) : Label
View Answer
Correct Answer : (B)
Explanation :
Question – 5 : You can use the formula palette to
Answer – (A) : Create and edit formulas containing functions
Answer – (B) : Format cells containing numbers
Answer – (C) : Create and edit formulas containing functions
Answer – (D) : Copy a range of cells
View Answer
Correct Answer : (C)
Explanation :
Question – 6 : Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
Answer – (A) : Press Ctrl +Home
Answer – (B) : Press Home
Answer – (C) : Press Ctrl +Home
Answer – (D) : Press Shift + Home
View Answer
Correct Answer : (C)
Explanation :
Question – 7 : Which of the following is a correct order of precedence in formula calculation?
Answer – (A) : All of these
Answer – (B) : All of these
Answer – (C) : Multiplication and division, positive and negative values, addition and subtraction
Answer – (D) : Addition and subtraction, positive and negative values, exponentiation
View Answer
Correct Answer : (B)
Explanation :
Question – 8 : The command Edit >> Fill Across Worksheet is active only when
Answer – (A) : When many sheets are selected
Answer – (B) : When many sheets are selected
Answer – (C) : None of these
Answer – (D) : When no sheet is selected
View Answer
Correct Answer : (B)
Explanation :
Question – 9 : If you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you:
Answer – (A) : Press Esc
Answer – (B) : Press Esc
Answer – (C) : Press the Edit Formula button
Answer – (D) : Press the Enter button
View Answer
Correct Answer : (B)
Explanation :
Question – 10 : You can merge the main document with data source in Excel. In mail merge operation, Word is usually
Answer – (A) : client
Answer – (B) : client
Answer – (C) : none
Answer – (D) : source
View Answer
Correct Answer : (B)
Explanation :
Question – 11 : 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 click on the cell pointer in worksheet
Answer – (D) : Double clicking on column right border on column header
View Answer
Correct Answer : (D)
Explanation :
Question – 12 : The Paste Special command lets you copy and paste:
Answer – (A) : The resulting values of a formula instead of the actual formula
Answer – (B) : Multiply the selection by a copied value
Answer – (C) : Formatting options
Answer – (D) : The resulting values of a formula instead of the actual formula
View Answer
Correct Answer : (D)
Explanation :
Question – 13 : A circular reference is
Answer – (A) : A formula that either directly or indirectly depends on itself
Answer – (B) : A cell that points to a drawing object
Answer – (C) : Geometric modeling tool
Answer – (D) : Always erroneous
View Answer
Correct Answer : (A)
Explanation :
Question – 14 : You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
Answer – (A) : Line chart
Answer – (B) : Line chart
Answer – (C) : Column chart
Answer – (D) : Pie chart
View Answer
Correct Answer : (B)
Explanation :
Question – 15 : You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that?
Answer – (A) : Custom List
Answer – (B) : Auto Fill Options
Answer – (C) : Custom List
Answer – (D) : Fill Series
View Answer
Correct Answer : (C)
Explanation :
Question – 16 : Excel worksheet cells work very similarly to what common element of the windows graphical user interface
Answer – (A) : Text boxes
Answer – (B) : Option buttons
Answer – (C) : List boxes
Answer – (D) : Text boxes
View Answer
Correct Answer : (D)
Explanation :
Question – 17 : How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
Answer – (A) : F9
Answer – (B) : F8
Answer – (C) : F11
Answer – (D) : F9
View Answer
Correct Answer : (D)
Explanation :
Question – 18 : Which of the following methods can not be used to edit the contents of a cell?
Answer – (A) : Press the Alt key
Answer – (B) : Press the Alt key
Answer – (C) : Clicking the formula bar
Answer – (D) : Pressing the F2 key
View Answer
Correct Answer : (B)
Explanation :
Question – 19 : Which of the following option is not available in Paste Special dialog box?
Answer – (A) : SQRT
Answer – (B) : Add
Answer – (C) : Divide
Answer – (D) : SQRT
View Answer
Correct Answer : (D)
Explanation :
Question – 20 : Which of the following action removes a sheet from workbook?
Answer – (A) : Select the sheet, then choose Edit >> Delete Sheet
Answer – (B) : none of these
Answer – (C) : Both of these
Answer – (D) : Select the sheet, then choose Edit >> Delete Sheet
View Answer
Correct Answer : (D)
Explanation :
Question – 21 : 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 F2 key
View Answer
Correct Answer : (A)
Explanation :
Question – 22 : You can convert existing excel worksheet data an charts to an HTML document by using
Answer – (A) : Internet assistant wizard
Answer – (B) : FTP wizard
Answer – (C) : Internet assistant wizard
Answer – (D) : Import wizard
View Answer
Correct Answer : (C)
Explanation :
Question – 23 : Which of the following is not a valid data type in excel
Answer – (A) : Character
Answer – (B) : Label
Answer – (C) : Number
Answer – (D) : Date/time
View Answer
Correct Answer : (A)
Explanation :
Question – 24 : You can enter which types of data into worksheet cells?
Answer – (A) : Labels, values, and formulas
Answer – (B) : Labe3ls and values but not formulas
Answer – (C) : Labels, values, and formulas
Answer – (D) : Formulas only
View Answer
Correct Answer : (C)
Explanation :
Question – 25 : The Name box on to the left of formula bar
Answer – (A) : shows the name of cell or range currently working on
Answer – (B) : None of these
Answer – (C) : shows the name of workbook currently working on
Answer – (D) : shows the name of worksheet currently working on
View Answer
Correct Answer : (A)
Explanation :
Question – 26 : Which of the following Excel screen components can NOT be turned on or off?
Answer – (A) : None of these
Answer – (B) : Tool Bar
Answer – (C) : None of these
Answer – (D) : Status Bar
View Answer
Correct Answer : (C)
Explanation :
Question – 27 : You can use the formula pallette to
Answer – (A) : create and edit formula containing functions
Answer – (B) : enter assumptions data
Answer – (C) : create and edit formula containing functions
Answer – (D) : format cells containing numbers
View Answer
Correct Answer : (C)
Explanation :
Question – 28 : Where can you change automatic or manual calculation mode in Excel?
Answer – (A) : Go to Tools >> Options >> Calculation and mark the corresponding radio button
Answer – (B) : Go to Tools >> Options >> Calculation and mark the corresponding radio button
Answer – (C) : None of these
Answer – (D) : Double CAL indicator on status bar
View Answer
Correct Answer : (B)
Explanation :
Question – 29 : You can move a sheet from one workbook into new book by
Answer – (A) : From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
Answer – (B) : From Edit menu choose Move or Copy sheet, mark the Create a copy and Click OK
Answer – (C) : From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
Answer – (D) : From Edit menu choose Move of Copy then choose (Move to end) and click OK
View Answer
Correct Answer : (C)
Explanation :
Question – 30 : Which of the cell pointer indicate that you can move the content to other cell?
Answer – (A) : Mouse Pointer with anchor at the tip
Answer – (B) : None of these
Answer – (C) : Mouse Pointer with anchor at the tip
Answer – (D) : Doctor’s symbol (Big Plus)
View Answer
Correct Answer : (C)
Explanation :
CCC SPREADSHEET MCQ QUESTIONS AND ANSWERS
CCC SPREADSHEET MCQ QUESTIONS AND ANSWERS
CCC SPREADSHEET MCQ QUESTIONS AND ANSWERS
CCC SPREADSHEET MCQ QUESTIONS AND ANSWERS
CCC SPREADSHEET MCQ QUESTIONS AND ANSWERS
CCC SPREADSHEET MCQ QUESTIONS AND ANSWERS
CCC SPREADSHEET MCQ QUESTIONS AND ANSWERS
CCC SPREADSHEET MCQ QUESTIONS AND ANSWERS
CCC SPREADSHEET MCQ QUESTIONS AND ANSWERS
CCC SPREADSHEET MCQ QUESTIONS AND ANSWERS
CCC SPREADSHEET MCQ QUESTIONS AND ANSWERS
CCC SPREADSHEET MCQ QUESTIONS AND ANSWERS
CCC SPREADSHEET MCQ QUESTIONS AND ANSWERS
CCC SPREADSHEET MCQ QUESTIONS AND ANSWERS
CCC SPREADSHEET MCQ QUESTIONS AND ANSWERS
CCC SPREADSHEET MCQ QUESTIONS AND ANSWERS
CCC SPREADSHEET MCQ QUESTIONS AND ANSWERS