Microsoft Excel Mcqs with Answers for Test Preparation

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

A. Decoration
B. Data appearance
C. Functions
D. Charting

What is a cell in Excel?

A. A row
B. A column
C. A unit of data
D. A unit of formatting

In excel columns are labelled as____________?

A. A, B, C, etc.
B. 1, 2, 3, etc.
C. A1, A2, A3, etc.
D. $A$1, $A$2, etc.

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

A. 10
B. 100
C. 300
D. 500

User developed instruction for excel are called__________?

A. Progrms
B. Macros
C. Procedured
D. All of these

Which function calculates the largest value in a set of numbers in Excel?

A. Average
B. Count
C. Minimum
D. Maximum

What displays the content of active cell?

A. Name box
B. Row headings
C. Formula bar
D. None of these

See also  Pakistan Movement 1857-1947 MCQs With Answers

In a computer spreadsheet, block of cells is called __________ ?

A. Workbook
B. Function
C. Column
D. Range

Microsoft Excel 2019 files have a default extension of___________?

A. .Xlsx
B. .Xls
C. .excel
D. .123

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

A. Calculations
B. Formulas
C. Functions
D. Relative addressing

In Ms Excel, which of the following special function keys allow the content in cell?

A. Shift
B. Esc
C. Tab
D. Space

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

A. Format number in comma format
B. Format number in currency format
C. Format number in date format
D. Format number in time format

Pages ( 4 of 15 ): « Previous1 ... 3 4 5 ... 15Next »

Leave a Comment