Accountancy Test - 10

Concept:

Calculation is the process of computing formulas and then displaying the results as values in the cells that contain the formulas.

Microsoft Excel automatically recalculates formulas only when the cells that the formula depends on have changed. Autocalculation automatically recalculate the whole worksheet if any change is made in a single cell

This is the default behaviour when you first open a workbook and when you are editing a workbook.

However, you can control when and how Excel recalculates formulas.

The correct answer is Left

Explanation:

By default, Excel aligns numbers to the right and text to the left.

Additional Information To align the text  

• Select the cells that have the text you want aligned.
• On the Home tab choose one of the following alignment options:
• To vertically align text, pick Top Align, Middle Align, or Bottom Align.
• To horizontally align text, pick Align Text Left, Center, or Align Text Right.
• When you have a long line of text, part of the text might not be visible. To fix this without changing the column width, click Wrap Text.
• To center text spanning several columns or rows, click Merge & Center.

The correct answer is Datasheet.

Key Points

• Datasheet
  • Each table that appears as a spreadsheet grid is called a datasheet. Hence, Option 2 is correct.
  • A datasheet is a useful way of viewing data in Access.
  • A database is a collection of tables.
  • Most importantly, datasheet view allows a user to view many table records at the same time.
  • In datasheet view, information is displayed in rows and columns—similar to a spreadsheet.
  • Records are displayed as rows, so each row is an individual record.
  • Within each row, columns represent fields within the record.
  • At the top of the datasheet, a window is the title bar, the Quick Access toolbar, and the Ribbon.
  • The bottom of the window has a status bar and on the right side of the window is a scroll bar as you would expect.
  • Many of the features that are common to spreadsheets are present in Access datasheet windows.
  • A user can modify row height, column width, font size to change the amount of data that fits without scrolling.
  • A user can also change the order of the rows or columns displayed in the window.
  • Datasheet views are a common display tool for tables, queries, and forms in Access.
  • There are some irregularities in the functionality of the datasheet windows for these depending on the underlying data sources.

Image of Datasheet View:

 Additional Information

• Query
  • A query is like a saved filter. It enables us to combine data into a single datasheet from multiple tables.
• Record
  • A record is a row in a table that consists of information about something.
• Table
  • A spreadsheet table, in OpenGL Tablets, is an analog of the Excel table with rows, columns, formulas, and calculations as contents.
  • Spreadsheets can also call decision tables or other executable tables to make decisions on values, and based on those, make calculations.

Key Points

A cell reference, or cell address, is an alphanumeric value used to identify a specific cell in a spreadsheet. Each cell address contains 'one or more letters followed by a number. The letter or letters identify the column and the number represents the row. In row-major order, the consecutive elements of a row reside next to each other.

Address of the second cell in an MS-Excel worksheet=?

The letter represents the column, So the second cell in the first row = B

The number represents the row, So the second cell in the first row = 1

Address of the second cell in an MS-Excel worksheet= B1

Hence the correct answer is B1.

Key Points

 COUNT function in Excel:

The COUNT function counts the number of cells that contain numbers and counts numbers within the list of arguments. Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers.

Syntax:

COUNT(value1, [value2], ...)

Explanation:

 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 correct answer is Cells.

Key Points

• In a spreadsheet, everything is stored in little boxes called cells.
  • In Microsoft Excel, a cell is a rectangular box that occurs at the intersection of a vertical column and a horizontal row in a worksheet.

Additional Information

• Vertical columns are numbered with alphabetic values such as A, B, C.
  • Horizontal rows are numbered with numeric values such as 1, 2, 3.
  • Cells are identified by the Cell Name (or Reference, which is found by combining the Column Letter with the Row Number.
  • Each cell has its own set of coordinates or positions in the worksheet such as A1, A2, or M16.
  • A cell can only store 1 piece of data at a time.
  • You can store data in a cell such as a formula, text value, numeric value, or date value.
  • The active cell is the cell in the spreadsheet that is currently selected for data entry.
  • Columns run vertically on the spreadsheet screen.
    • An Excel spreadsheet contains 256 columns that are labelled with the letters of the alphabet.
  • Rows run horizontally on the spreadsheet screen.
    • An Excel spreadsheet contains 16,384 rows which are labelled numerically.

The correct answer is option 4.

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 =.

Key Points

 Excel FLOOR function:

The FLOOR function in Excel is used to round a given number down, to the nearest multiple of a specified significance.

Syntax: FLOOR(number, significance)

Number- the number you want to round.

Significance - the multiple to which you wish to round the number.

FLOOR(14, 4) = 12 Here 4 rounds down the nearest multiple of  4 (4 × 3 = 12 is nearer)

Hence the correct answer is 12.

The correct answer "8".

Key Points

• The Cell value of A1 is 6.
• The Cell value of A2 is 4.
• A3 contains the formula: =$A$1+A2 then the value of A3 will be 10.
• The Cell value of B1 is 3.
• The Cell value of B2 is 2.
• The formula in cell A3 is copied to cell B3.
• So, the value in cell B3 is "8".​

Additional InformationRelative Reference:

If you copy the data from place to place, the formula will move with it. So if you type =A1+A2 into cell A3, then copy and paste that formula into cell B3, it will automatically change the formula to =B1+B2.

Absolute Reference:

If you type =$A$1+$A$2 into cell A3, then copy and paste that formula into cell B3, it will stay =$A$1+$A$2. 

Absolute Columns:

If you type =$A1+$A2 into cell A3, then copy and paste that formula into cell B3, it will stay =$A1+$A2.

But if you copy and paste that formula into A4, then it becomes =$A2+$A3. That’s because the column references are absolute, but the row references aren’t. 

Absolute Rows:

If you type =A$1+A$2 into cell A3, then copy and paste that formula into cell B3, you will get =B$1+B$2.

However, if you copy and paste that formula into A4, it stays =A$1+A$2 because its row references are absolute.

Important PointsDifference Between Relative and Absolute References in Excel:

The key difference between relative and absolute cells is that relative cell references move when you copy them, but absolute references do not.

Absolute references are noted by a dollar sign in front of the cell reference. So a relative cell reference might look like =A1+A2 but an absolute reference might look like =$A$1+$A$2. (Actually, the formula can also look like =$A1+$A2 or =A$1+A$2, but let’s not get ahead of ourselves.)

The correct answer is Spreadsheet program.

Key Points

• A spreadsheet is a computer programme that allows you to organise, analyse, and save data in a tabular format. Spreadsheets were created as electronic versions of accounting worksheets on paper.
• The application works with data entered into table cells.
• A spreadsheet can also refer to an electronic document of this type.
• Conditional expressions, text-to-number conversion methods, and text-to-string conversion functions are all available in spreadsheet systems.
• A spreadsheet programme is a standard feature of an office productivity suite, and since the introduction of online apps, office suites are now available as web apps as well.
• A spreadsheet programme is frequently included with an office productivity suite, which also includes a word processor, a presentation programme, and a database management system.