Test: Excel Basics - 1 - Primary 6 MCQ

AutoFormat option in excel is a unique way of formatting data quickly, the first step is we need to select the entire data we need to format and then the second step we need to click on auto-format from the QAT and third step we need to choose the format from the different options.

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.

SUBTRACT() is not a valid function in MS Excel
Subtract two or more numbers in a cell:

1. Click any blank cell, and then type an equal sign (=) to start the formula.
2. After the equal sign, type a few numbers that are separated by a minus sign (-).
   for example, 100-50-30.
3. Press RETURN, then the result is 20.

On the Home tab, in the Font group, click the arrow next to Borders Button, and then click No Border Button.
--OR--
Click Home > the Borders arrow > Erase Border, and then select the cells with the border you want to erase.

Microsoft Excel can wrap text so it appears on multiple lines in a cell. We can format the cell so the text wraps automatically, or enter a manual line break.
On the Home tab, in the Alignment group, click Wrap Text.

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 formatting and Drawing toolbar is a toolbar in Microsoft Office 2003 and earlier applications, that gives the user the ability to change the formatting of selected text or cell.

COUNTA function counts cells containing any type of information, including error values. COUNTA function does not count empty cells.

Key Points
1. MS Excel

• It is a spreadsheet program for data analysis and documentation.
• It contains a number of rows and columns where the intersection of a column and a row is a "cell".
• Each cell contains one point of data.
• It is developed by Microsoft.
• It features calculation, graphing tools, pivot tables, etc

2. Entering Data in MS Excel

• A cell is selected in which a particular text is to be written and then enter is pressed.
• Tab key is used to feed the same data in different cells of Excel.
• Arrow keys are used to jump from one cell to another and then feed data accordingly to a particular cell.
• Esc cancel an entry in the cell or Formula Bar.

There is no option to set page border in Excel.

Ctrl + Space Bar is the short cut key to highlight the entire column.

Concept
What-If Analysis is the process of changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet.
Three kinds of What-If Analysis tools come with Excel

• Scenarios: A Scenario can have multiple variables, but it can only accommodate up to 32 values.Scenarios and Data tables take sets of input values and determine possible results.
• Goal Seek: Goal Seek works differently from Scenarios and Data Tables in that it takes a result and determines possible input values that produce that result.
• Data Tables: A Data Table works with only one or two variables, but it can accept many different values for those variables.

A conditional format changes the appearance of cells on the basis of conditions that you specify. If the conditions are true, the cell range is formatted; if the conditions are false, the cell range is not formatted.

The absolute cell reference in excel is a cell address that contains a dollar sign ($). It can precede the column reference, the row reference or both.

Key Points

• In MS Excel, rows are numbered from 1 to onwards and columns are numbered from A to onwards.
• "Rows" run "horizontally" across the "worksheet & ranges" from "1 to 1048576".
• "Columns" run "vertically" downward across the "worksheet & ranges" from "A to XFD" - "1 to 16384".

Important Points

• Worksheet and workbook specifications and limits:
• Rows can have a maximum height of 409.
• Total number of rows and columns on a worksheet - 1,048,576 rows by 16,384 columns
• Column width - 255 characters
• Page breaks - 1,026 horizontal and vertical
• Row height - 409 points