Prev 1 2 3 4 5 Next
1. Excel is a ____ program developed by Microsoft.
A. Spreadsheet
B. Document
C. Data management
D. All of the above
ANSWER:A
SOLUTION : Excel is a spreadsheet program developed by Microsoft.
2. What is the extension of a Microsoft Excel file?
A. msxcl
B. xcl
C. xlsx
D. xlsm
ANSWER:C
SOLUTION: “.xlsx” is the extension of a Microsoft Excel file.
3. What is the default file name of Microsoft Excel file?
A. Workbook.xlsx
B. Workbook1.xlsx
C. Worksheet.xlsx
D. Worksheet1.xlsx
ANSWER:B
SOLUTION: The default file name of Microsoft Excel file is “Workbook1.xlsx”.
4. Shortcut key CTRL + D is used to ____.
A. Open font dialog box
B. Open format cells dialog box
C. Shift current cell’s value in the right cell
D. Fill down in the selection
ANSWER:D
SOLUTION: Shortcut key CTRL + D is used to Fill down in the selection.
5. Microsoft Excel is used for?
A. Analysis
B. Data Entry
C. Data Management
D. All of the above
ANSWER:D
SOLUTION: All of the above
6. What is the collection of worksheets called?
A. Ledger
B. Book
C. Testbook
D. Workbook
ANSWER:D
SOLUTION :The collection of worksheets is called a workbook.
7. The total number of rows in a worksheet?
A. Unlimited
B. 65,535
C. 1,048,576
D. 1,068,576
ANSWER: C
SOLUTION:The total number of rows in a worksheet is 1,048,576.
8. The total number of columns in a worksheet?
A. 26
B. 256
C. 12,834
D. 16,384
ANSWER:D
SOLUTION: The total number of columns in a worksheet is 16,384.
9. What is the column width in a worksheet?
A. 26 characters
B. 128 characters
C. 255 characters
D. 256 characters
ANSWER:C
SOLUTION: The column width in a worksheet is 255 characters.
10. The total number of characters that a cell contains is?
A. 32,767 characters
B. 32,768 characters
C. 65,535 characters
D. 1,32,767 characters
ANSWER:A
SOLUTION: The total number of characters that a cell contain are 32,767 characters.