wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

MS Excel Quiz

Total questions: 80

Worksheet time: 40mins

Name
Class
Date
1.

What is the extension file for Excel 2004?

a)

.xlsm

b)

.xlsb

c)

.xlsx

d)

.xls

2.

What is the extension file for Excel 2007 and above?

a)

.xlsx

b)

.xlsm

c)

.xlsb

d)

.xls

3.

Worksheet is also called an array of ____.

a)

boxes

b)

cells

c)

formulas

d)

columns

4.

How are cells named in MS Excel?

a)

Numerically

b)

Special Characters

c)

Alphabetically

d)

Alphanumerically

5.

What is the maximum limit of rows in MS Excel 2010?

a)

1084567

b)

1048567

c)

1084576

d)

1048576

6.

What is the maximum limit of columns in MS Excel 2010?

a)

16348

b)

16843

c)

16438

d)

16384

7.

Which bar lies at the top of the window in Excel?

a)

Scroll Bar

b)

Title Bar

c)

Ruler

d)

Status Bar

8.

How are rows numbered in MS Excel?

a)

Special Characters

b)

Alphanumerically

c)

Numerically

d)

Alphabetically

9.

How are columns named in MS Excel?

a)

Alphabetically

b)

Numerically

c)

Alphanumerically

d)

Special Characters

10.

Which tab is used to include pivot tables, charts, hyperlinks to a spreadsheet?

a)

Insert

b)

Page Layout

c)

Data

d)

Review

11.

Which tab in Excel is used for importing, querying, outlining, and subtotaling data?

a)

Formula

b)

Data

c)

Review

d)

Insert

12.

Which tab in Excel is used for proofing, protecting, and marking up a spreadsheet?

a)

View

b)

Formula

c)

Review

d)

Data

13.

Which tool in MS Office is best for organizing data and making lists?

a)

Access

b)

Excel

c)

PowerPoint

d)

Word

14.

What is the file extension of Excel 2010?

a)

.xlsx

b)

.xlsm

c)

.xlsb

d)

.xls

15.

How is a single element in a worksheet known in Excel?

a)

Range

b)

Row

c)

Column

d)

Cell

16.

What do A3, B13:B20, C7 reference in Excel signify?

a)

General

b)

Formula

c)

Union

d)

Range

17.

Which type of key should combine with the Ctrl key to create a macro key in Excel?

a)

Special Characters

b)

Alphabetic

c)

Numeric

d)

Alphanumeric

18.

Which bar is used to display the sheet information and insertion point location in MS Excel?

a)

Ruler

b)

Scroll Bar

c)

Status Bar

d)

Title Bar

19.

Which tab is used to change the display of the worksheet area and the data it contains?

a)

Review

b)

Data

c)

Page Layout

d)

View

20.

Which view in Excel displays the pages exactly as they appear when printed?

a)

Custom View

b)

Page Layout View

c)

Full Screen View

d)

Page Break View

21.

Which tab is used for creating, formatting, and editing a spreadsheet?

a)

Data

b)

Home

c)

Insert

d)

Review

22.

Which function is used to count the number of cells that contain numbers in a range?

a)

Sumif()

b)

Sum()

c)

Countif()

d)

Count()

23.

Which function is used to add the values in a range?

a)

Sum()

b)

Sumif()

c)

Count()

d)

ABS()

24.

Which symbol is used to execute formulas in MS Excel?

a)

#

b)

'

c)

"

d)

=

25.

Where does the result display when a formula is entered in Excel?

a)

Current Cell

b)

Next Cell

c)

Previous Cell

d)

Formula Bar

26.

Which function in Excel is used to find the biggest value in a range?

a)

LEN

b)

MAX

c)

DMAX

d)

Ceiling

27.

Which one of the following is a text function in MS Excel?

a)

MID()

b)

NOW()

c)

COUNT()

d)

SIGN

28.

Which one of the following is a 'Date & Time' function in Excel?

a)

MID()

b)

NOW()

c)

FIND()

d)

MOD()

29.

Which function is used to find the middle number in a range?

a)

MODE()

b)

TRIM()

c)

MEDIAN()

d)

MID()

30.

What is the purpose of the 'Tab' key in MS Excel?

a)

Moves cell pointer to next row

b)

Moves cell pointer to previous row

c)

Moves cell pointer to next column

d)

Moves cell pointer to previous column

31.

What is the purpose of the 'Enter Key' in MS Excel?

a)

Moves cell pointer to previous row

b)

Moves cell pointer to next column

c)

Moves cell pointer to next row

d)

Moves cell pointer to previous column

32.

Which function key is used to open the go-to dialogue box in MS Excel?

a)

F11

b)

F7

c)

F5

d)

F2

33.

Which option in MS Excel is used to display the rows that meet certain conditions?

a)

Find

b)

Filter

c)

Sort

d)

Format

34.

Which option in Excel is used to rearrange the rows based on the content of a particular column?

a)

Sort

b)

Filter

c)

Format

d)

Find

35.

Which type of addressing is used to keep rows constant and column changes while copying a formula?

a)

Mixed

b)

General

c)

Absolute

d)

Relative

36.

Which one of the following is a 'no argument' function?

a)

IF()

b)

Max()

c)

Lower()

d)

Now()

37.

Which key is used to move the insertion point to the beginning of the current sheet?

a)

Ctrl + Home

b)

Ctrl + Pageup

c)

Home

d)

Pageup

38.

Which key is used to make multiple lines in a single cell?

a)

Alt + ↵

b)

Tab + ↵

c)

Ctrl + ↵

d)

Shift + ↵

39.

Columns in MS Excel are named in the form of _____.

a)

none of them

b)

alphabets (A, B, C, D,...)

c)

numbers (1,2,3,4,...)

d)

roman numerals (I,II, III, IV,...)

40.

Rows in MS Excel are named in the form of _____.

a)

alphabets (A, B, C, D,...)

b)

numbers (1,2,3,4,...)

c)

none of them

d)

roman numerals (I,II, III, IV,...)

41.

The intersection of a row and column in MS Excel is called _____.

a)

cell

b)

document

c)

workbook

d)

spreadsheet

42.

The cell having column number 3 and row number 6 is denoted by the name _____.

a)

F3

b)

C3

c)

C6

d)

F6

43.

In MS Excel, a function is entered by typing ____ symbol first.

a)

@

b)

#

c)

=

d)

$

44.

MS Excel can ____ given data.

a)

statistically analyze

b)

draw graphs for

c)

all of them

d)

sort

45.

The latest version of MS Excel can have ____ rows.

a)

512

b)

1024

c)

16,384

d)

10,48,576

46.

The latest version of MS Excel can have ____ columns.

a)

16,384

b)

10,48,576

c)

512

d)

1024

47.

Excel supports recording of repeated actions with the help of ____.

a)

graph

b)

chart

c)

macro

d)

other applications

48.

MS Excel macros can be invoked using ____.

a)

button

b)

keystroke

c)

both a & b

d)

neither a nor b

49.

MS Excel supports a version of Visual Basic called ____ for programming.

a)

Javascript

b)

Visual Basic for Applications (VBA)

c)

ASP.NET

d)

C#.NET

50.

Each sheet in an MS Excel file is called a ____.

a)

notesheet

b)

workbook

c)

notebook

d)

worksheet

51.

By default, Excel worksheets are named ____.

a)

note1, note2, note3, ...

b)

sheet1, sheet2, sheet3,...

c)

book1, book2, book3, ...

d)

page1, page2, page3, ...

52.

Excel file without any macros has the default extension of ____.

a)

.xlsm

b)

.xlst

c)

.xls

d)

.xlsx

53.

Excel file containing macros has the default extension of ____.

a)

.xlst

b)

.xlsx

c)

.xlsm

d)

.xls

54.

MS Excel can reference data in ____.

a)

different sheet in the same workbook

b)

all of them

c)

the same sheet

d)

different sheet in a different workbook

55.

In MS Excel, the common type of data applicable to any cell is called _____ data type.

a)

Currency

b)

Number

c)

General

d)

Text

56.

In MS Excel, the data type suitable for handling numbers is called _____ data type.

a)

General

b)

Number

c)

Currency

d)

Text

57.

In MS Excel, number data type can control the _____.

a)

both a & b

b)

number of decimal places

c)

neither a nor b

d)

digit grouping

58.

In MS Excel, numbers can be grouped and prefixed with a currency symbol using _____ data type.

a)

Accounting

b)

both a & b

c)

Currency

d)

neither a nor b

59.

In MS Excel, _____ data type is suitable for handling dates.

a)

Fraction

b)

Percentage

c)

Time

d)

Date

60.

In MS Excel, _____ data type is suitable for handling time values.

a)

Time

b)

Percentage

c)

Fraction

d)

Date

61.

In MS Excel, _____ data type takes values between 0 and 1 and displays them in percentage format.

a)

Date

b)

Time

c)

Fraction

d)

Percentage

62.

In MS Excel, _____ data type displays decimal fractions as vulgar or mixed fractions.

a)

Date

b)

Time

c)

Percentage

d)

Fraction

63.

In MS Excel, _____ data type displays numbers in scientific notation.

a)

Custom

b)

Scientific

c)

Date

d)

Text

64.

In MS Excel, _____ data type is suitable for names and other character sequences.

a)

Date

b)

Custom

c)

Text

d)

Scientific

65.

In MS Excel, _____ data type supports formatting of numbers with suitable customization.

a)

Scientific

b)

Text

c)

Date

d)

Custom

66.

In MS Excel, for the number 45453453 to be displayed as 4,54,53,453.0, the custom format could be ________.

a)

########0.0

b)

##,##,##,###.#

c)

###,###,##0.0

d)

##,##,##,##0.0

67.

In custom formatting of numbers, an optional digit is denoted by ________ symbol.

a)

0

b)

^

c)

#

d)

$

68.

In custom formatting of numbers, a compulsory/ mandatory digit is denoted by _____ symbol.

a)

0

b)

#

c)

$

d)

^

69.

When copying and pasting an Excel formula, the method which permits formula to progressively update cell references is called ______ referencing system.

a)

relative

b)

none of them

c)

semi-relative

d)

static

70.

When copying and pasting an Excel formula, the method which permits formula to progressively update either column reference or row reference (but not both) is called ________ referencing system.

a)

static

b)

semi-relative

c)

relative

d)

none of them

71.

When copying and pasting an Excel formula, the method which keeps references to a particular cell address is called ______ referencing system.

a)

none of them

b)

relative

c)

semi-relative

d)

static

72.

The formula = A5 * 5 is written in ______ system.

a)

static

b)

semi-relative

c)

none of them

d)

relative

73.

The formula = A5 * 5, when copied to the next row of the same column, will become _______ system.

a)

= A4 * 5

b)

= B5 * 5

c)

= A7 * 5

d)

= A6 * 5

74.

In MS Excel, _______ functions help to access databases stored in spreadsheets.

a)

Cube/ Database

b)

Date/ Time

c)

Engineering

d)

Financial

75.

______ functions help to access date and time functions in MS Excel.

a)

Financial

b)

Engineering

c)

Date/ Time

d)

Cube/ Database

76.

_______ functions help to access base conversion, logarithmic and other Engineering features in MS Excel.

a)

Cube/ Database

b)

Date/ Time

c)

Engineering

d)

Financial

77.

In MS Excel, ______ functions help to access interest calculation, accounting and currency related calculations.

a)

Cube/ Database

b)

Date/ Time

c)

Financial

d)

Engineering

78.

Which function in Excel is used to calculate the average of a range of numbers?

a)

AVG

b)

MEAN

c)

SUM

d)

AVERAGE

79.

What is the shortcut key to save a workbook in MS Excel?

a)

Ctrl + N

b)

Ctrl + P

c)

Ctrl + O

d)

Ctrl + S

80.

Which feature in Excel allows you to visually represent data trends over time?

a)

Data Validation

b)

Conditional Formatting

c)

Tables

d)

Charts

Similar Resources on Wayground

examen de explotacion minera -operacion noche

80 questions

examen de explotacion minera -operacion noche

quiz

Worksheet

•

Professional Development