Test: Excel Formulas- 1 - Class 6 MCQ

In 2003 and earlier versions - From Format Cells dialog box click on Merge Cells check box
In 2007 and subsequent versions - Merge & Center icon on the Home ribbon.

We can check the conditions against Cell value or Formula when applying conditional formatting

On the bottom left of the worksheet we find the Sheet Tab Scroll Buttons to move to the First sheet, Previous sheet, Next sheet, and Last sheet. They are followed by the tabs for the worksheets in our workbook and the Insert Worksheet button or tab, depending on the version of Excel we are using.

In Conditional Formatting we cannot set condition to look for Bold and apply Italics on them.

The 'SUMSQ' is the formula to sum the squares of the given numbers.
Here, sum of squares of (1, 2, 3, 4) is 1+4+9+16 = 30

Name Box refers to an input box directly to the left of the formula bar. The Name Box normally displays the address of the "active cell" on the worksheet. You can also use the name box to quickly create a named range.

The width of a row and be specified manually or fit automatically is invalid statement.

Key Points

• The term Worksheet used in Excel documents is a collection of cells organized in rows and columns.
• It is the working surface you interact with to enter data.
• Each worksheet contains 1048576 rows and 16384 columns and serves as a giant table that allows you to organize information.
• The collection of worksheets is known as the workbook.

Data sheet can not be a sheet in workbook.

Formula palette is used to create and edit formula.
It is also possible to type a function directly into a cell, however, as there are over 300 functions built into Microsoft Excel, some of which are quite complex, Excel provides the Formula Palette to simplify the process.

Key Points
By default, any new workbook you create in Excel will contain one worksheet, called Sheet1. To change the default number of worksheets, navigate to Backstage view, click Options, then choose the desired number of worksheets to include in each new workbook
Hence the correct answer is 1.

A cell can be edited through Press the F2 key or Click the formula bar or Double click the cell.

To go to previous cell we use Go To function Ctrl + G.

• Exam scores and bank balance are numerical data.
• Employee address consists of words, names, numbers, etc. So it is a non numerical data.