wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Class VI Excel Quiz

Total questions: 70

Worksheet time: 12mins

Name
Class
Date
1.

Which of the following represents a correct cell reference in Excel?

a)

A1

b)

1A

c)

A1B1

2.

Ishaan is working on a spreadsheet and needs to make changes to a specific cell. What is the keyboard shortcut he can use to edit the active cell?

a)

F1

b)

F2

c)

F4

3.

Which command is used to split a single cell into multiple cells?

a)

Split

b)

Divide

c)

Separate

4.

Aanya is working on a spreadsheet and needs to remove some unnecessary data. She wonders how a cell can be deleted through …………………………… group of the Home tab.

a)

Cells

b)

Row

c)

Font

5.

Aarush is working on a document and accidentally deletes a paragraph he spent a lot of time on. Which command allows him to reverse the last action?

a)

Redo

b)

AutoFill

c)

Undo

6.

Sneha is working on a spreadsheet and wants to adjust the height of certain rows to better fit the content. Which of the following list contains the option to change the row height?

a)

Format

b)

Cell Size

c)

Row Size

7.

In Excel all formulas must start with …………………….

a)

+ sign

b)

=sign

c)

$sign

8.

……….. function finds the largest value or number in the given range of cells.

a)

Min

b)

Averge

c)

Count

9.

Functions are predefined ………………

a)

Commands

b)

Operations

c)

Formulas

10.

………………….. means to arrange data in ascending or descending order.

a)

Formula

b)

Sorting

c)

Programs

11.

…… (a)   error occurs when a user attempts to reference a function that does not exist.

12.

…… (a)   ……… function returns the largest value in the selected range of cells.

13.

The … (a)   …. That you use in a formulas that perform specific tasks.

14.

The … (a)   ….. feature of MS-Excel allows you to enter a predefined series of data.

15.

Delete Sheet Rows commands lets you delete a …… (a)   ….. from you worksheet.

16.

The file extension of an Excel file is … (a)   ……

17.

By default, a workbook is named as …… (a)   …..

18.

The address of a cell is formed by the combination of letter and …… (a)   …..

19.

AI is capable of understanding human language with the help of a concept called … (a)   …

20.

Press the … (a)   …. key if you wish to exit the slide show before it ends.

21.

Press F6 function key to run slide show.

a)

True

b)

False

22.

A slide show can be very useful for teaching, sharing and learning purpose.

a)

True

b)

False

23.

In Gmail, AI is only used for scanning an email for viruses.

a)

True

b)

False

24.

The Name box shows the address of the active cell.

a)

True

b)

False

25.

There are 15,000 rows in Excel.

a)

True

b)

False

26.

The right align option aligns the text to the bottom of the cell.

a)

True

b)

False

27.

Insert option is found on Format tab.

a)

True

b)

False

28.

We can change the row height and column width in your worksheet.

a)

True

b)

False

29.

$A$5 is an example of mixed referencing.

a)

True

b)

False

30.

We can sort data in ascending order only.

a)

True

b)

False

31.
The feature to center text across several cells is called:
a)
Wrap Text
b)
Merge and Center
c)
Shrink to Fit
d)
Number Formatting
32.
Microsoft Excel is what type of software?
a)
Word Processing
b)
Spreadsheet
c)
Presentation
d)
Drawing
33.
Which of the following operators do you use to begin typing a formula?
a)
*
b)
+
c)
=
d)
/
34.
Rows are which of the following:
a)
vertical
b)
horizontal
35.
Columns are vertical.
a)
True
b)
False
36.
What does every formula or function start with?
a)
!
b)
@
c)
#
d)
=
37.
What is the formula to find the lowest number in cells C1:C4?
a)
=average(C1:C4)
b)
=max(C1:C4)
c)
=min(C1:C4)
d)
=sum(C1:C4)
38.
What instructs the software to perform a calculation?
a)
value
b)
label
c)
formula
39.
Place where you can rename each worksheet.  Located at the bottom of the worksheet window.
a)
Sheet tab
b)
Formula
c)
Name Box
d)
Chart
40.
What does this symbol do:
/
a)
Multiply
b)
Add
c)
Divide
d)
Minus
41.
What does this symbol do:
*
a)
Multiply
b)
Add
c)
Divide
d)
Minus
42.
The quickest way to find a total in Excel is by using __________.
a)
AutoTotal
b)
AutoSum
c)
AutoAdd
d)
AutoPlus
43.
_________ allows you to perform calculations on data entered into a spreadsheet?
a)
Formulas
b)
Data
c)
Cell
d)
Cell reference
44.
Excel allows you to
a)
read stories
b)
work with data
c)
invent ideas
d)
create presentations
45.
In a worksheet, the vertical spaces with letter headings.
a)
Rows
b)
Cell addresses
c)
Columns
46.
A command line above the worksheet where text, numbers, and formulas are entered into a worksheet.
a)
Insert
b)
Formula bar
c)
Tables
47.
In a worksheet, the horizontal spaces with the headings 1,2,3, and so on.
a)
Rows
b)
Columns
c)
Bold
d)
Italics
48.

How is the COLUMN in a MS Excel Spreadsheet named?

a)

Numbers

b)

Letters

c)

Cells

d)

Columns

49.

How are ROWS in MS EXCEL spreadsheet named?

a)

numbers

b)

letters

c)

cells

d)

columns

50.

What is a rectangular box in a MS EXCEL Spreadsheet called?

a)

row

b)

column

c)

cell

51.

What is the name of the cell that is colored blue?

a)

A

b)

B

c)

2B

d)

B2

52.

Which is a formula using MS Excel using addition.

a)

2 + 3 =

b)

= A + B

c)

=A2+B3

d)

A2+B3

53.

What function do you press to center a title in 5 cells in one row?

a)

Title YES

b)

Merge and Center

c)

A1+B1+C1+D1+E1

d)

Center

54.

What is an example of a RANGE in MS Excel.

a)

B2-F5

b)

F5:B2

c)

B2:5F

d)

(B2:F5)

55.

Which Formula is written correctly for multiplying cell A1 and A7?

a)

=A1+A7

b)

=A1*A7

c)

A1+A7

d)

A1*A7

56.

___ is considered to be a single row

a)

record

b)

cell

57.

A ________ is used for easy manipulation of data in Excel

a)

tool bar

b)

data form

58.

Press ____ to move the next field in the row

a)

tab

b)

Shift + Tab

59.

Press _____ to move the previous field

a)

tab

b)

shift + tab

60.

The _____ command is used to change or customize the order of the spreadsheet data

a)

filter

b)

sort

61.

The ____ command is used to view only the required data while the rest of the data is temporarily hidden,

a)

Filter

b)

Data validation

62.

_____ is used to specify the type of data that can be entered in a celll

a)

input message

b)

data validation

63.

This alerts users by displaying an error message if invalid data is typed in a cell

a)

Error Alert

b)

Filter

64.

The _____ command is used to outline the worksheet in numerous ways

a)

Data form

b)

Subtotal

65.

____ tool is used to summarize extensive data to make it easily manageable.

a)

Pivot table

b)

Custom filter

66.

This icon represent

a)

data form

b)

Filter

c)

Sort

d)

excel

67.

This icon represents

a)

Auto sum

b)

Sort and Filter

68.

this icon represents

a)

Subtotal

b)

Average

c)

Count

d)

Total

69.

This icon stands for

a)

Filter

b)

Data Validation

70.

You cannot specify multiple conditions using Customer filter

a)

True

b)

False

Similar Resources on Wayground

Christmas Spreadsheets Quiz

70 questions

Christmas Spreadsheets Quiz

quiz

Worksheet

•

9th Grade

BCS Level 3 Award in Mobile and Operating Systems - Test 1

71 questions

BCS Level 3 Award in Mobile and Operating Systems - Test 1

quiz

Worksheet

•

9th Grade

latihan soal TIK (office)

70 questions

latihan soal TIK (office)

quiz

Worksheet

•

1st Grade - Professio...

Mr I's CS (OCR) Paper 1

66 questions

Mr I's CS (OCR) Paper 1

quiz

Worksheet

•

7th - 10th Grade

Tugas TIK 9 Genap

68 questions

Tugas TIK 9 Genap

quiz

Worksheet

•

9th Grade

TEST: Google & Internet Test

65 questions

TEST: Google & Internet Test

quiz

Worksheet

•

9th - 12th Grade

ITF+ Practice Exam 5

73 questions

ITF+ Practice Exam 5

quiz

Worksheet

•

9th Grade

Grade7 All

66 questions

Grade7 All

quiz

Worksheet

•

7th Grade - University