Olympiad Test: MS Excel - 1 | 10 Questions MCQ Test National Cyber Olympiad Class 8 Class 8

QUESTION: 1

What function displays row data in a column or column data in a row?

A.
Hyperlink
B.
Index
C.
Transpose
D.
Rows

Solution:

QUESTION: 2

Except for the ______ function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result

A.
IF
B.
AND
C.
OR
D.
NOT

Solution:

QUESTION: 3

Each excel file is called a workbook because

A.
It can contain text and data
B.
It can be modified
C.
It can contain many sheets including worksheets and chart sheets
D.
You have to work hard to create it

Solution:

QUESTION: 4

Which types of charts can excel produce out of the given options?

A.
Line graphs and pie charts only
B.
Line graphs only
C.
Bar charts, line graphs and pie charts
D.
Bar charts and line graphs only

Solution:

A chart is a powerful tool that allows you to visually display data in a variety of different chart formats. MS Excel can produce different chart formats such as Bar, Pie, Line, Column, Area, Scatter, Surface, or Radar charts.

QUESTION: 5

How are data organized in a spreadsheet?

A.
Lines and spaces
B.
Layers and planes
C.
Rows and columns
D.
Height and width

Solution:

QUESTION: 6

Which of the following is a correct order of precedence in a formula calculation?

A.
Multiplication and division, exponential positive and negative value
B.
Multiplication and division, positive and negative values, addition and subtraction
C.
Addition and subtraction, positive and negative values, exponentiation
D.
None of the above

Solution:

QUESTION: 7

How should you print a selected area of a worksheet, if you want to print a different area next time?

A.
On the file menu, point to print area, and then click set print area.
B.
On the file menu, click print, and then click selection under print what
C.
On the view menu, click custom views, then click add
D.
All of the above

Solution:

QUESTION: 8

Which of the following methods can not be used to enter data in a cell?

A.
Pressing an arrow key
B.
Pressing the tab key
C.
Pressing the Esc key
D.
Clicking the enter button to the formula bar

Solution:

QUESTION: 9

Which of the following methods cannot be used to edit the content of cell?

A.
Pressing the Alt key
B.
Clicking the formula bar
C.
Pressing F2
D.
Double clicking the cell

Solution:

QUESTION: 10

You can activate a cell by

A.
Pressing the Tab key
B.
Clicking the cell
C.
Pressing an arrow key
D.
All of the above

Solution:

Olympiad Test: MS Excel - 1

10 Questions MCQ Test National Cyber Olympiad Class 8 | Olympiad Test: MS Excel - 1

What function displays row data in a column or column data in a row?

Except for the ______ function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result

Each excel file is called a workbook because

Recommended Content

NCERT Textbook: Resources

NCERT Solutions: Comparing Quantities- 1

NCERT Solutions: Data Handling- 1

Chapter Notes (Part - 2) - Resources

What is Soil Preparation?

Recommended Tests

Olympiad Test: Integers

Test: Nutrition in Animals

Test: Globe Latitudes And Longitudes

Test: Environment

Test: Nutrition in Plants- 1

Download free EduRev App

Similar Content

MS Excel: Logical Test

MS Excel: Text Functions

MS Excel: Text to Columns

MS Excel

Related tests

Olympiad Test: MS Excel - 1

Olympiad Test : MS Excel 2010 - 1

Test: MS Excel- 1

Olympiad Test: MS Excel - 2

Test: MS Excel- 1

Schools

Competitive Examinations

Quick Access Links

Technical Exams