Computer science study desk with a laptop, circuit board and network diagrams

Focused topic practice

microsoft excel MCQs

Practise focused microsoft excel questions with marked answers for exam preparation and subject revision.

microsoft excel Mcqs

1. How we can view a cell comment ?
0

A. click the comment command on the view menu

B. click the edit comment commands on the Insert menu

C. click the Display comment command on the window menu

D. position the mouse pointer over the cell

2. Which among following is not associated with spelling dialogue box?
0

A. Change

B. Edit

C. Ignore All

D. Ignore

3. To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called?
0

A. Pivot Table List

B. HTML

C. Pivot Table Report

D. Pivot Table Field List

4. Which of these key are used in ms excel to insert current time In workbook.
0

A. Ctrl+!

B. Ctrl + Shift + ;

C. None of these

D. Ctrl+*

5. Excel displays the current cells address in the __________?
0

A. Formula bar

B. Title bar

C. Status bar

D. Name box

6. In a computer spreadsheet, cell range A3 through G3 should be keyed in as _________ ?
0

A. A3:G3

B. A3 to G3

C. A3?.G3

D. A3-G3

7. Move to Next Sheet in Ms Excel:
0

A. None of these

B. Ctrl + Page Down

C. Page Down

D. Shift + Page Down

8. With which of the following all formulas in excel starts ?
0

A. /

B. *

C. =

D. $

9. In a computer spreadsheet, SUM, AVERAGE, MIN and MAX are examples of __________ ?
0

A. Calculations

B. Formulas

C. Functions

D. Relative addressing

10. Basic unit of a computer worksheet in which you enter text and numbers is known as __________ ?
0

A. workbook

B. row

C. column

D. cell

11. Which Excel function counts the cells containing numbers in a selected range?
0

A. COUNTA

B. COUNTIF

C. SUM

D. COUNT

12. Main window in a computer spreadsheet is called ___________ ?
0

A. Work

B. Work book

C. Work sheet

D. Account book

13. What is the maximum number of columns in a modern Microsoft Excel worksheet?
0

A. 16,384

B. 256

C. 65,536

D. 1,048,576

14. Computer spreadsheet capability to allow a pie chart to be generated from data in spreadsheet cells is termed as __________ ?
0

A. Decoration

B. Data appearance

C. Charting

D. Functions

15. Ctrl+Shift+1 shortcut Keys in excel are used to __________?
0

A. Format number in currency format

B. Format number in time format

C. Formatnumber in dateformat

D. Formatnumber in commaformat

16. In Excel's default A1 reference style, how are worksheet rows identified?
0

A. Symbols

B. Letters

C. Numbers

D. Cell references

17. What is the default file extension for a standard Microsoft Excel 2019 workbook?
0

A. .xls

B. .xlsx

C. .excel

D. .xlsm

18. which of the following is not a valid Zoom percentage in Excel?
0

A. 300

B. 500

C. 100

D. 10

19. You can set page border in excel from: __________?
0

A. From Border tab in Format Cells dialog box

B. From Line Style tool in Drawing toolbar

C. You can not set page border in Excel

D. From Border tool in Formatting toolbar

20. Which Operation cant be performed by Queue?
0

A. Traversing

B. Deletion

C. Insertion

D. Retrieving

Showing 1 to 20 of 65 mcqs