Simple Excel Test - Answers

Q1: How to Display the Format Cells dialog box
Answeŕ: CTRL + 1

Q2: What is an Absolute Reference
Answeŕ: $A$1

Q3: How can I set up alternating row colors in Microsoft Excel 2010? I don't want to have to change the row colors every time I insert, delete, or move a row.
Answeŕ: Select the Home tab in the toolbar at the top of the screen. Then in the Styles group, click on the Format as Table drop-down and select one of the options.

Q4: In Microsoft Excel 2010, I have a spreadsheet with column headings. I need a way to scroll down the rows, but still see the column headings that are contained in the top row. How can I do this?
Answeŕ: If you need to see the column headings even after scrolling, you could try freezing the top row in Excel.

Q5: Apply Date number style to the cells
Answeŕ: CTRL + SHIFT + #

Q6: What is the syntax for the HLOOKUP function in Microsoft Excel

Answeŕ:HLOOKUP (Lookup_value, table_array, row_index, [range_lookup])

Q7: what is the syntax for the VLOOKUP function in Microsoft Excel

Answeŕ: VLOOKUP (lookup_value, table_array, column_index, [range_lookup])

Q8: BODMAS Rule

Answeŕ:Bracket, Order, Division, Multiplication, Addition, and Subtraction

Q9:What does the #N/A error mean

Answeŕ:Excel cannot find the value it is being asked to look for

Q10:What does the #VALUE! error mean

Answeŕ:The data type a function is given doesn’t match what it is expecting by the Excel.

Také thé Test