MCQ Mojo
access_time
menu
Quiz
Web Stories
CBSE
arrow_drop_down
MCQ Questions for CBSE Class 12 with Answers
MCQ Questions for CBSE Class 11 with Answers
MCQ Questions for CBSE Class 10 with Answers
MCQ Questions for CBSE Class 9 with Answers
MCQ Questions for CBSE Class 8 with Answers
MCQ Questions for CBSE Class 7 with Answers
MCQ Questions for CBSE Class 6 with Answers
MCQ Questions for CBSE Class 5 with Answers
MCQ Questions for CBSE Class 4 with Answers
MCQ Questions for CBSE Class 3 with Answers
MCQ Questions for CBSE Class 2 with Answers
MCQ Questions for CBSE Class 1 with Answers
CBSE
arrow_drop_down
MCQ Questions for CBSE Class 12 with Answers
MCQ Questions for CBSE Class 11 with Answers
MCQ Questions for CBSE Class 10 with Answers
MCQ Questions for CBSE Class 9 with Answers
MCQ Questions for CBSE Class 8 with Answers
MCQ Questions for CBSE Class 7 with Answers
MCQ Questions for CBSE Class 6 with Answers
MCQ Questions for CBSE Class 5 with Answers
MCQ Questions for CBSE Class 4 with Answers
MCQ Questions for CBSE Class 3 with Answers
MCQ Questions for CBSE Class 2 with Answers
MCQ Questions for CBSE Class 1 with Answers
Quiz
Quiz
/
MS Excel Class 12 MCQ Questions With Answers
1.
To insert a new row, select the row heading _______ where you want the new row to appear.
Above
Below
2.
By default, any new workbook you create in Excel will contain one ________, called __________.
workbook, workbook
worksheet, sheet1
3.
To change the font, font size, color, or style: Select the ________ you want to modify.
Column Headings
Cells
4.
_____________ will automatically modify a cell's row height.
Wrapping Text
Adjusting Column Height
5.
To copy a worksheet: Right-click the worksheet you want to copy, then select _______ or _________ from the worksheet menu.
Copy, Move
Copy, Select
6.
________ formats also allow you to work with a powerful set of ________ functions that use time and ________ information to calculate an answer.
Date
Number
7.
Excel will usually apply the _______ number format by default if the entered data such as the number 12 is entered.
Percentage
General
Date
Long Date
8.
To insert a new column, select the column heading to the _______ of where you want the new column to appear.
Left
Right
9.
__________ merges the selected cells into larger cells while keeping each row separate
Merge and Center
Merge Across
10.
You can select the desired cells and press ________ on your keyboard to access more number-formatting options.
Ctrl+1
Ctrl+F
11.
To change the row height and column width for all cells in a worksheet, locate and click the _______ _____ button just below the name box to select every cell in the worksheet.
Select All
Fill Handle
Auto Fit
Auto Fill
12.
_________ format is especially helpful when calculating things like the cost of sales tax or a tip.
Date
Percentage
Sum
Difference
13.
Allows you to create clear and defined boundaries for different sections of your worksheet.
Cell Borders and Fill Colors
Headings
Font Size
Font Color
14.
A quick way to include professional formatting for different parts of your workbook, such as titles and headers.
Font Color
Cell Style
Borders
Fill Color
15.
To rename a worksheet: Right-click the worksheet you want to rename, then select __________ from the worksheet menu.
Rename
Open
16.
At times, you may want to compare certain rows or columns without changing the organization of your worksheet. To do this you can __________ columns and rows.
Cut
Organize
View side by side
Hide
17.
Excel 2016 will treat "October" as a
Date
Text string
18.
To group worksheets: Select the first worksheet you want to include in the worksheet group. Press and hold the _______ ______ on your keyboard.
Ctrl Key
Group Key
19.
The drop-down menu in the Number group is called the __________ drop-down.
Number Format
General
20.
If you want to remove the content from a row or column without causing others to shift, right-click a heading, then select ________ Contents from the drop-down menu
Clear
Delete
21.
If you select any cells with number formatting, you can see the actual value of the cell in the _______ _____.
formula bar
adjacent cell
22.
To insert a new ________: Locate and select the New _____ button near the bottom-right corner of the Excel window.
Worksheet
Workbook
23.
Excel allows you to insert new columns or rows, delete certain rows or columns, move them to a different location in the worksheet, or even ______ rows or columns.
Hide
Copy
24.
_______ allows you to set a column's width to fit its content automatically.
Auto Fill
Resize
Fill Handle
Auto Fit
25.
To access other date formatting options, select the Number Format drop-down menu and choose _______ Number Formats.
More
Date
Report Question
Previous
Next
warning
Submit
access_time
Time
Report Question
A bunch of text
Support mcqmojo.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page