Quiz: Excel Basics - 2 - Primary 6 MCQ

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

The Internet Assistant for Excel is an add-in wizard that allows you to create and distribute Excel documents online for viewing with any popular browser. The Internet Assistant helps you convert your spreadsheet data to HTML format. It is designed for the 1997 and earlier versions of Excel.

The contents of cells A1, A2, B1, and B2 are 0, 0, a, and 0 respectively. 
COUNT (A1: B2)= 3 because there are three numeric values in the cell.
Hence the correct answer is 3.

The statement that is not true regarding Conditional Formatting is:

      2. You can set condition to look for Bold and apply Italics on them

Conditional Formatting in most spreadsheet software does not have a built-in option to detect specific font styles like Bold and then apply another font style like Italics. Conditional Formatting typically focuses on cell values or formulas to apply formatting such as color, font, border, and patterns based on specified conditions.

A circular reference occurs when a formula directly or indirectly refers to its own cell. This causes the formula to use its result in the calculation, which can create errors.

The correct answer is Pie chart.

• Doughnut Chart:
  • Data that is arranged in columns or rows only on a worksheet can be plotted in a doughnut chart.
  • The doughnut chart is similar to a pie chart.
  • Just like a pie chart, a doughnut chart shows the relationship of parts to a whole.
• A doughnut chart can contain more than one data series.
  Example of Chart:
  What's your favorite ice cream flavor?
  

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

Goal seek, Scenario Manager and Solver are used to perform what if analysis in Excel.

When you open a new Excel workbook, there is 1 worksheet by default at the time of opening.

This default setting can be customized in Excel's options, but by default, it typically starts with a single worksheet.

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.

When we insert an excel file into a word document and keep the source file linkage when data is updated in source file update data in liked file also. The data are Linked. In Embedded objects file become part of document and does not get updated when source file is updated.

CONCATENATE:

• This function joins two or more text strings into one text string.

its syntax is:

• CONCATENATE (text1, text2,...).
• The text items can be text strings, numbers, or single-cell references.

Additional Information
Some important mathematical functions used in MS Excel are:

• SUM
• AVERAGE
• AVERAGEIF
• COUNTA
• COUNTIF
• MOD
• ROUND 

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

Solver is used to find an optimal (maximum or minimum) value for a formula in one cell — called the objective cell — subject to constraints, or limits, on the values of other formula cells on a worksheet. Solver works with a group of cells, called decision variables or simply variable cells that are used in computing the formulas in the objective and constraint cells. Versions of Solver prior to Excel 2007 referred to the objective cell as the “target cell,” and the decision variable cells as “changing cells” or “adjustable cells”.

Key Points
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.
All Excel formulas begin with an equal sign (=). After the equal symbol, you enter either a calculation or function. For example, to add up values in cells B1 through B5, you can either: Type the entire equation: =B1+B2+B3+B4+B5.
Hence the correct answer is =.