Primary 6 Exam  >  Primary 6 Tests  >  Test: Excel Tips- 2 - Primary 6 MCQ

Test: Excel Tips- 2 - Primary 6 MCQ


Test Description

20 Questions MCQ Test - Test: Excel Tips- 2

Test: Excel Tips- 2 for Primary 6 2024 is part of Primary 6 preparation. The Test: Excel Tips- 2 questions and answers have been prepared according to the Primary 6 exam syllabus.The Test: Excel Tips- 2 MCQs are made for Primary 6 2024 Exam. Find important definitions, questions, notes, meanings, examples, exercises, MCQs and online tests for Test: Excel Tips- 2 below.
Solutions of Test: Excel Tips- 2 questions in English are available as part of our course for Primary 6 & Test: Excel Tips- 2 solutions in Hindi for Primary 6 course. Download more important topics, notes, lectures and mock test series for Primary 6 Exam by signing up for free. Attempt Test: Excel Tips- 2 | 20 questions in 40 minutes | Mock test for Primary 6 preparation | Free important questions MCQ to study for Primary 6 Exam | Download free PDF with solutions
Test: Excel Tips- 2 - Question 1

Getting data from a cell located in a different sheet is called ________

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

Getting data from a cell located in a different sheet is called Cell reference.
There are Three types of Cell reference in Excel

  • Relative
  • Absolute
  • Mixed
Test: Excel Tips- 2 - Question 2

Which elements of a worksheet can be protected from accidental modification?

Detailed Solution for Test: Excel Tips- 2 - Question 2

All elements of a worksheet can be protected from accidental modification.
To protect a worksheet in Excel 2007 and higher versions, click the Review tab, click Protect Worksheet (or Protect Sheet), and click OK.
Excel 2003 and Earlier Versions click Tools > Protection, click Protect Sheet, and click OK.

1 Crore+ students have signed up on EduRev. Have you? Download the App
Test: Excel Tips- 2 - Question 3

Concatenation of text can be done using

Detailed Solution for Test: Excel Tips- 2 - Question 3

The ampersand (&) calculation operator allow us join text items without using a function. For example, =A1 & B1 will return the same value as =CONCATENATE(A1,B1). In many cases, using the ampersand operator is quicker and simpler than using CONCATENATE to create strings.

Test: Excel Tips- 2 - Question 4

Which of the following is not a valid data type in Excel?

Detailed Solution for Test: Excel Tips- 2 - Question 4

There are Three types of data in cells: labels, values, and formulas. Labels (text) are descriptive pieces of information, such as names, months, or other identifying statistics, and they usually include alphabetic characters. Values (numbers) are generally raw numbers or dates. Formulas are instructions for Excel to perform calculations.

Test: Excel Tips- 2 - Question 5

A numeric value can be treated as label value if ________ precedes it.

Detailed Solution for Test: Excel Tips- 2 - Question 5

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

Test: Excel Tips- 2 - Question 6

Which area in an Excel window allows entering values and formulas?

Detailed Solution for Test: Excel Tips- 2 - Question 6

Formula Bar area in an Excel window allows entering values and formulas. Formula Bar is a toolbar at the top of the Microsoft Excel spreadsheet window that we can use to enter or copy an existing formula in to cells or charts. It is labeled with function symbol (fx). By clicking the Formula Bar, or when you type an equal (=) symbol in a cell, the Formula Bar will activate.

Test: Excel Tips- 2 - Question 7

An Excel Workbook is a collection of ________

Detailed Solution for Test: Excel Tips- 2 - Question 7

A workbook is a collection of one or more spreadsheets and charts in a single file.

Test: Excel Tips- 2 - Question 8

MS-EXCEL is based on ________

Detailed Solution for Test: Excel Tips- 2 - Question 8

MS-Excel is based on Windows. MS-Excel is a spreadsheet developed by Microsoft for Windows and few other operating systems. It is a program that stores and retrieves numerical data in rows and columns of grid format.

Test: Excel Tips- 2 - Question 9

Multiple calculations can be made in a single formula using ________

Detailed Solution for Test: Excel Tips- 2 - Question 9

An array formula is a formula that can perform multiple calculations on one or more of the items in an array. We can think of an array as a row of values, a column of values, or a combination of rows and columns of values. Array formulas can return either multiple results or a single result. For example, we can create an array formula in a range of cells and use the array formula to calculate a column or row of subtotals. We can also place an array formula in a single cell and calculate a single amount. An array formula that includes multiple cells is called a multi-cell formula, and an array formula in a single cell is called a single-cell formula.

Test: Excel Tips- 2 - Question 10

What do you mean by a Workspace?

Detailed Solution for Test: Excel Tips- 2 - Question 10

The term workspace refers to all the open workbooks and their exact screen position and window sizes.
A workspace contains pointers to your other Excel files that you had open during your session.
When you open an Excel workspace all the other files are opened as well
Workspaces are particularly useful if you frequently work with the same set of files and need to have them all open at once.

Test: Excel Tips- 2 - Question 11

In EXCEL, you can sum a large range of data by simply selecting a tool button called ________.

Detailed Solution for Test: Excel Tips- 2 - Question 11

AutoSum is a Microsoft Excel function that adds together a range of cells and displays the total in the cell below the selected range.

Test: Excel Tips- 2 - Question 12

To return the remainder after a number is divided by a divisor in EXCEL we use the function?

Detailed Solution for Test: Excel Tips- 2 - Question 12

The MOD function in Excel is used to find remainder after division of one number (dividend) by another (divisor). In mathematics, this operation is called the modulo operation or modulus, hence the name MOD.

Test: Excel Tips- 2 - Question 13

Which is not the function of "Edit, Clear" command?

Detailed Solution for Test: Excel Tips- 2 - Question 13

Test: Excel Tips- 2 - Question 14

To select an entire column in MS-EXCEL, press?

Detailed Solution for Test: Excel Tips- 2 - Question 14

To select an entire column in MS-EXCEL, Click the column heading letter or press CTRL + Space Bar key.

Test: Excel Tips- 2 - Question 15

Which function is not available in the Consolidate dialog box?

Detailed Solution for Test: Excel Tips- 2 - Question 15

Test: Excel Tips- 2 - Question 16

Microsoft Excel is a powerful ________

Detailed Solution for Test: Excel Tips- 2 - Question 16

Microsoft Excel is Microsoft's general-purpose spreadsheet program for Windows, used for data analysis and display. It is commonly used in a business environment since it is part of the Microsoft Office package. Microsoft Excel is an extremely powerful tool, which is used by millions of people everyday. Functions tailored to a specific task can be programmed into Excel to extend its capabilities with customised analysis tools.

Test: Excel Tips- 2 - Question 17

Which Chart can be created in Excel?

Detailed Solution for Test: Excel Tips- 2 - Question 17

Excel offers the following major chart types −

  • Column Chart
  • Line Chart
  • Pie Chart
  • Doughnut Chart
  • Bar Chart
  • Area Chart
  • XY (Scatter) Chart
  • Bubble Chart
  • Stock Chart
  • Surface Chart
  • Radar Chart
  • Combo Chart
Test: Excel Tips- 2 - Question 18

How do you display current date and time in MS Excel?

Detailed Solution for Test: Excel Tips- 2 - Question 18

DATE - returns the serial date value for a date
TODAY - returns today's date
NOW - returns the current date and time
TIME - assemble a proper time.

Test: Excel Tips- 2 - Question 19

How do you rearrange the data in ascending or descending order?

Detailed Solution for Test: Excel Tips- 2 - Question 19

Sorting data in MS Excel rearranges the rows based on the contents of a particular column. We can also sort a table to put names in alphabetical order or ascending or descending order. Or, maybe we want to sort data by Amount from smallest to largest or largest to smallest.

Test: Excel Tips- 2 - Question 20

What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ?

Detailed Solution for Test: Excel Tips- 2 - Question 20

'#,##0.00' = 5436.80

Information about Test: Excel Tips- 2 Page
In this test you can find the Exam questions for Test: Excel Tips- 2 solved & explained in the simplest way possible. Besides giving Questions and answers for Test: Excel Tips- 2, EduRev gives you an ample number of Online tests for practice

Top Courses for Primary 6

Download as PDF

Top Courses for Primary 6