Olympiad Test: MS Excel - 2


20 Questions MCQ Test National Cyber Olympiad Class 8 | Olympiad Test: MS Excel - 2


Description
Attempt Olympiad Test: MS Excel - 2 | 20 questions in 40 minutes | Mock test for Class 8 preparation | Free important questions MCQ to study National Cyber Olympiad Class 8 for Class 8 Exam | Download free PDF with solutions
QUESTION: 1

Which of the following describes how to select all the cells in a single column?

Solution:
QUESTION: 2

Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?

Solution:
QUESTION: 3

Which of the following is not a basic step in creating a worksheet?

Solution:
QUESTION: 4

To insert three columns between columns D and E you would

Solution:
QUESTION: 5

Charts tips can

Solution:
QUESTION: 6

How do you change column width to fit the contents?

Solution:
QUESTION: 7

You can use the horizontal and vertical scroll bars to

Solution:
QUESTION: 8

To drag a selected range of data to another worksheet in the same workbook, use the

Solution:
QUESTION: 9

When the formula bar is activated, you can see

Solution:
QUESTION: 10

In a worksheet you can select

Solution:
QUESTION: 11

When you print preview a worksheet

Solution:
QUESTION: 12

You can copy data or formulas

Solution:
QUESTION: 13

To activate the previous cell in a pre-selected range, press

Solution:
QUESTION: 14

A function inside another function is called a ….. function.

Solution:
QUESTION: 15

The maximum no of rows in an excel sheet are:

Solution:
QUESTION: 16

Which of the cell pointer indicate that you can move the content to other cell?

Solution:
QUESTION: 17

Which of the following is not the correct method of editing the cell content?

Solution:
QUESTION: 18

Which of the following is correct?

Solution:
QUESTION: 19

Which of the following function will return a value 8?

Solution:
QUESTION: 20

Which of the following function will you use to find the highest number in a series?

Solution:
Use Code STAYHOME200 and get INR 200 additional OFF
Use Coupon Code