Test: Excel Tips- 2 - Primary 6 MCQ

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

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.

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.

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.

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.

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.

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

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.

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.

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.

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

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.

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

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.

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

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.

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.

'#,##0.00' = 5436.80