CCC SPREADSHEET MCQ
CCC SPREADSHEET MCQ
Question – 1 : You accidentally erased a record in the sheet. What command can be used to restore it immediately?
Answer – (A) : Undo
Answer – (B) : Replace
Answer – (C) : Undo
Answer – (D) : Copy
View Answer
Correct Answer : (C)
Explanation :
Question – 2 : 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) : Fill Series
Answer – (C) : Fill Across Worksheet
Answer – (D) : Auto Fill Options
View Answer
Correct Answer : (A)
Explanation :
Question – 3 : 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) : Double CAL indicator on status bar
Answer – (C) : none of these
Answer – (D) : Both of these
View Answer
Correct Answer : (A)
Explanation :
Question – 4 : When the formula bar is active, you can see
Answer – (A) : All of these
Answer – (B) : The enter button
Answer – (C) : The edit formula button
Answer – (D) : All of these
View Answer
Correct Answer : (D)
Explanation :
Question – 5 : The Delete key of keyboard is assigned to which command in Excel?
Answer – (A) : Edit >> Clear >> Contents
Answer – (B) : All of these
Answer – (C) : Edit >> Delete
Answer – (D) : Edit >> Clear >> Contents
View Answer
Correct Answer : (D)
Explanation :
Question – 6 : The box on the chart that contains the name of each individual record is called the ________.
Answer – (A) : legend
Answer – (B) : cell
Answer – (C) : legend
Answer – (D) : axis
View Answer
Correct Answer : (C)
Explanation :
Question – 7 : Which of the following is not a basic step in creating a worksheet?
Answer – (A) : Copy the worksheet
Answer – (B) : Copy the worksheet
Answer – (C) : Save workbook
Answer – (D) : Enter text and data
View Answer
Correct Answer : (B)
Explanation :
Question – 8 : Each excel file is called a workbook because
Answer – (A) : It can contain many sheets including worksheets and chart sheets
Answer – (B) : You have to work hard to create it
Answer – (C) : It can contain many sheets including worksheets and chart sheets
Answer – (D) : It can be modified
View Answer
Correct Answer : (C)
Explanation :
Question – 9 : To create a formula, you first:
Answer – (A) : Select the cell you want to place the formula into
Answer – (B) : Type the equals sign (=) to tell Excel that you’re about to enter a formula
Answer – (C) : Enter the formula using any input values and the appropriate mathematical operators that make up your formula
Answer – (D) : Select the cell you want to place the formula into
View Answer
Correct Answer : (D)
Explanation :
Question – 10 : How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
Answer – (A) : F9
Answer – (B) : F11
Answer – (C) : F9
Answer – (D) : F10
View Answer
Correct Answer : (C)
Explanation :
Question – 11 : 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) : From Edit menu choose Clear and then Formats
Answer – (C) : Double click the Format Painter and then press Esc key in keyboard
Answer – (D) : From Edit menu choose Delete
View Answer
Correct Answer : (B)
Explanation :
Question – 12 : How do you tell one cell from another?
Answer – (A) : By its address
Answer – (B) : By numbers
Answer – (C) : By its address
Answer – (D) : by color
View Answer
Correct Answer : (C)
Explanation :
Question – 13 : Which is an example of a formula?
Answer – (A) : SUM(A1:A2)
Answer – (B) : =A1+A2
Answer – (C) : SUM(A1:A2)
Answer – (D) : =add(A1:A2)
View Answer
Correct Answer : (C)
Explanation :
Question – 14 : Which area in an excel window allows entering values and formulas
Answer – (A) : Formula bar
Answer – (B) : Formula bar
Answer – (C) : Standard toolbar
Answer – (D) : Title bar
View Answer
Correct Answer : (B)
Explanation :
Question – 15 : By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
Answer – (A) : Right click on Sheet Tab of third sheet and choose Delete from the context menu
Answer – (B) : Right click on Sheet Tab of third sheet and choose Delete from the context menu
Answer – (C) : Click on Sheet 3 and from Edit menu choose Delete
Answer – (D) : Both of these
View Answer
Correct Answer : (B)
Explanation :
Question – 16 : Which is an example of a function?
Answer – (A) : =SUM(A1:A2)
Answer – (B) : A1+A2
Answer – (C) : =A1+A2
Answer – (D) : =add(A1:A2)
View Answer
Correct Answer : (A)
Explanation :
Question – 17 : Which function will you use to enter current time in a woksheet cell?
Answer – (A) : =now()
Answer – (B) : =time()
Answer – (C) : =currentTime()
Answer – (D) : =today()
View Answer
Correct Answer : (A)
Explanation :
Question – 18 : Which of the following is not true about Find and Replace in Excel
Answer – (A) : You can search by rows or columns or sheets
Answer – (B) : You can search by rows or columns or sheets
Answer – (C) : You can decide whether to look for the whole word or not
Answer – (D) : You can search in formula too
View Answer
Correct Answer : (B)
Explanation :
Question – 19 : You can move a sheet from one workbook into new book by ………………… .
Answer – (A) : None of these
Answer – (B) : From Edit menu choose Move or Copy sheet, mark the Create a ccopy 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) : None of these
View Answer
Correct Answer : (D)
Explanation :
Question – 20 : Multiple calculations can be made in a single formula using
Answer – (A) : array formula
Answer – (B) : smart formula
Answer – (C) : complex formulas
Answer – (D) : array formula
View Answer
Correct Answer : (D)
Explanation :
Question – 21 : What is entered by the function =today()
Answer – (A) : The date value for the day according to system clock
Answer – (B) : The time value according to system clock
Answer – (C) : The date value for the day according to system clock
Answer – (D) : Today’s date as Text format
View Answer
Correct Answer : (C)
Explanation :
Question – 22 : The Name box on to the left of formula bar
Answer – (A) : shows the name of cell or range currently working on
Answer – (B) : shows the name of workbook currently working on
Answer – (C) : none of these
Answer – (D) : shows the name of cell or range currently working on
View Answer
Correct Answer : (D)
Explanation :
Question – 23 : Where a row and a column meet, what do you call that?
Answer – (A) : A cell
Answer – (B) : A box
Answer – (C) : A cell
Answer – (D) : None of these
View Answer
Correct Answer : (C)
Explanation :
Question – 24 : Merge cells option can be applied from
Answer – (A) : Format Cells dialog box Alignment Tab
Answer – (B) : Formatting toolbar
Answer – (C) : Both of these
Answer – (D) : None of these
View Answer
Correct Answer : (A)
Explanation :
Question – 25 : Give me an example of a cell address.
Answer – (A) : A21
Answer – (B) : 41A
Answer – (C) : A21
Answer – (D) : 911
View Answer
Correct Answer : (C)
Explanation :
Question – 26 : 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 selected cells are deleted and the cells are shifted left
Answer – (D) : The cell content of selected cells disappear from cell and stored in clipboard
View Answer
Correct Answer : (A)
Explanation :
Question – 27 : You can automatically adjust the size of text in a cell if they do not fit in width by
Answer – (A) : From Format Cells dialog box mark Shrink to fit check box
Answer – (B) : From Format choose Columns and then Auto fit Selection
Answer – (C) : All of these
Answer – (D) : Double clicking on the right border of column header
View Answer
Correct Answer : (A)
Explanation :
Question – 28 : To create a formula, you first:
Answer – (A) : Select the cell you want to place the formula into
Answer – (B) : Choose the new command from the file menu
Answer – (C) : Enter the formula using any input values and the appropriate mathematical operators that make up your formula
Answer – (D) : Select the cell you want to place the formula into
View Answer
Correct Answer : (D)
Explanation :
Question – 29 : Text formulas:
Answer – (A) : Concatenate and manipulate text
Answer – (B) : Concatenate and manipulate text
Answer – (C) : Replace cell references
Answer – (D) : Return ASCII values of characters
View Answer
Correct Answer : (B)
Explanation :
Question – 30 : If you want all of the white cats grouped together in the database, you need to sort by ________.
Answer – (A) : Pet Type, then Color
Answer – (B) : Color, then Gender
Answer – (C) : Pet Type, then Color
Answer – (D) : Pet Type, then Gender
View Answer
Correct Answer : (C)
Explanation :
CCC SPREADSHEET MCQ
CCC SPREADSHEET MCQ
CCC SPREADSHEET MCQ
CCC SPREADSHEET MCQ
CCC SPREADSHEET MCQ
CCC SPREADSHEET MCQ
CCC SPREADSHEET MCQ
CCC SPREADSHEET MCQ
CCC SPREADSHEET MCQ
CCC SPREADSHEET MCQ
CCC SPREADSHEET MCQ
CCC SPREADSHEET MCQ
CCC SPREADSHEET MCQ
CCC SPREADSHEET MCQ
v