Test: Excel Functions- 1

# Test: Excel Functions- 1

Test Description

## 10 Questions MCQ Test How to become an Expert of MS Excel | Test: Excel Functions- 1

Test: Excel Functions- 1 for Class 6 2022 is part of How to become an Expert of MS Excel preparation. The Test: Excel Functions- 1 questions and answers have been prepared according to the Class 6 exam syllabus.The Test: Excel Functions- 1 MCQs are made for Class 6 2022 Exam. Find important definitions, questions, notes, meanings, examples, exercises, MCQs and online tests for Test: Excel Functions- 1 below.
Solutions of Test: Excel Functions- 1 questions in English are available as part of our How to become an Expert of MS Excel for Class 6 & Test: Excel Functions- 1 solutions in Hindi for How to become an Expert of MS Excel course. Download more important topics, notes, lectures and mock test series for Class 6 Exam by signing up for free. Attempt Test: Excel Functions- 1 | 10 questions in 20 minutes | Mock test for Class 6 preparation | Free important questions MCQ to study How to become an Expert of MS Excel for Class 6 Exam | Download free PDF with solutions
 1 Crore+ students have signed up on EduRev. Have you?
Test: Excel Functions- 1 - Question 1

### Excel uniquely identifies cells within a worksheet with a cell name

Detailed Solution for Test: Excel Functions- 1 - Question 1

Column letters and row numbers in Excel uniquely identifies cells within a worksheet with a cell name.

Test: Excel Functions- 1 - Question 2

### You can use drag-and-drop to embed excel worksheet data in a word document

Detailed Solution for Test: Excel Functions- 1 - Question 2

We can use drag-and-drop to embed excel worksheet data in a word document by dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key.

Test: Excel Functions- 1 - Question 3

### A numeric value can be treated as a label value if it precedes with

Detailed Solution for Test: Excel Functions- 1 - Question 3

An apostrophe before a cell value forces Excel to interpret the value as label. This is mostly useful for values that look like a number or date.

Test: Excel Functions- 1 - Question 4

Tab scrolling button

Detailed Solution for Test: Excel Functions- 1 - Question 4

Tab scrolling button allow us to view additional sheets tabs.

Test: Excel Functions- 1 - Question 5

A worksheet range is a

Detailed Solution for Test: Excel Functions- 1 - Question 5

A worksheet range is a group of cells.

Test: Excel Functions- 1 - Question 6

The chart wizard term data series refers to

Detailed Solution for Test: Excel Functions- 1 - Question 6

The chart wizard term data series refers to a collection of chart data markers.

Test: Excel Functions- 1 - Question 7

A worksheet can have a maximum of ________ number of rows.

Detailed Solution for Test: Excel Functions- 1 - Question 7

Excel 2003 and earlier 65,536 Rows.
Excel 2007 and higher 1,048,576 Rows.

Test: Excel Functions- 1 - Question 8

A typical worksheet has ________ number of columns.

Detailed Solution for Test: Excel Functions- 1 - Question 8

Excel 2003 and earlier 256
(as label ‘IV’) columns.
Excel 2007 and higher 16,384 (as label ‘XFD’) columns.

Test: Excel Functions- 1 - Question 9

Which of the following formulas is not entered correctly?

Detailed Solution for Test: Excel Functions- 1 - Question 9

A formula always starts with an equal sign (=), which can be followed by numbers, math operators (such as a plus or minus sign), and functions, which can really expand the power of a formula.
Here in option D 10+50 there is no equal sign (=), so it is not correct.

Test: Excel Functions- 1 - Question 10

What symbol is used before a number to make it a label?

Detailed Solution for Test: Excel Functions- 1 - Question 10

An apostrophe before a cell value forces Excel to interpret the value as label. This is mostly useful for values that look like a number or date.

## How to become an Expert of MS Excel

75 videos|43 docs|8 tests
 Use Code STAYHOME200 and get INR 200 additional OFF Use Coupon Code
Information about Test: Excel Functions- 1 Page
In this test you can find the Exam questions for Test: Excel Functions- 1 solved & explained in the simplest way possible. Besides giving Questions and answers for Test: Excel Functions- 1, EduRev gives you an ample number of Online tests for practice

## How to become an Expert of MS Excel

75 videos|43 docs|8 tests