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 9 MCQ Questions With Answers
1.
What is one way to ADD a Range of rows and columns in MS EXCEL other than using the + symbol.
SUMMING
SUM
ALL
None at all
2.
To insert a new row, select the row heading _______ where you want the new row to appear.
Above
Below
3.
By default, any new workbook you create in Excel will contain one ________, called __________.
workbook, workbook
worksheet, sheet1
4.
To change the font, font size, color, or style: Select the ________ you want to modify.
Column Headings
Cells
5.
_____________ will automatically modify a cell's row height.
Wrapping Text
Adjusting Column Height
6.
To copy a worksheet: Right-click the worksheet you want to copy, then select _______ or _________ from the worksheet menu.
Copy, Move
Copy, Select
7.
The bar that displays the data being entered in the active cell:
status bar
entry bar
Windows Task Bar
none of the above
8.
How is the COLUMN in a MS Excel Spreadsheet named?
Numbers
Letters
Cells
Columns
9.
________ formats also allow you to work with a powerful set of ________ functions that use time and ________ information to calculate an answer.
Date
Number
10.
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
11.
To insert a new column, select the column heading to the _______ of where you want the new column to appear.
Left
Right
12.
__________ merges the selected cells into larger cells while keeping each row separate
Merge and Center
Merge Across
13.
What is an example of a RANGE in MS Excel.
B2-F5
F5:B2
B2:5F
(B2:F5)
14.
You can select the desired cells and press ________ on your keyboard to access more number-formatting options.
Ctrl+1
Ctrl+F
15.
How are ROWS in MS EXCEL spreadsheet named?
numbers
letters
cells
columns
16.
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
17.
_________ format is especially helpful when calculating things like the cost of sales tax or a tip.
Date
Percentage
Sum
Difference
18.
Unique address of a cell that is the coordinate of the intersection of a row and a column:
entry bar
cell reference
name box
none of the above
19.
Allows you to create clear and defined boundaries for different sections of your worksheet.
Cell Borders and Fill Colors
Headings
Font Size
Font Color
20.
When is a MS Excel Spreadsheet used?
Making a Drawing
When Reading
For Collecting Information
For Baking a Cake
21.
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
22.
In Microsoft Excel, the file you create and edit is called:
A form
A ledger
A table
A workbook
A record
23.
To rename a worksheet: Right-click the worksheet you want to rename, then select __________ from the worksheet menu.
Rename
Open
24.
The cell in a spreadsheet application in which data may be entered:
cell reference
name box
active cell
none of the above
25.
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
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