Edexel Excel test

A _____ is a collection of data that is stored electronically as a series of records in a table.

• spreadsheet

• cell

• database

• pivot table

Which of the following formulas will Excel Not be able to calculate?

• =SUM(Sales)-A3

• =SUM(A1:A5)*.5

• =SUM(A1:A5)/(10-10)

• =SUM(A1:A5)-10

Expecting cell A1 is showing the number "14000.7489". What function ought to be utilized to round this number to the nearest integer?

• =ROUND(A1,0)

• =MROUND(A1,100)

• =MROUND(A1,10)

• =ROUND(A1,1)

Assume an organization expected that its income should be $180,000 for 2014-2018. What function ought to be entered in cell E6 so it shows income in 2016 if it was above budget, else it'll display 0?

• =IF(E2<B6,E2,0)

• = IF(E2<B6,0,E2)

• =IF(E2>B6,0,E2)

• =IF(E2>B6,E2,0)

You entered below formula in cell E3 =VLOOKUP(2000,A2:C9,2,TRUE). What will be the outcome?

• Alameda

• #N/A

• Phoenix

• Antioch

Company A is looking at 4 possible activities and will accept them if the IRR is 10% or above, as appeared in cell E2. What is the formula utilized in cell C2, which can also be copied down to cell C3 through C5, to produce the required results?

• =IF(B$2>=E$2,"Accept","Reject")

• =IF(B1>=E2,"Accept","Reject")

• =IF(B2>=E1,"Accept","Reject")

• =IF(B2>=E2,"Accept""Reject")

_____ cells involves creating a single cell by combining two or more selected cells.

• Formatting

• Merging

• Embedding

• Splitting

What kind of chart would be useful to show the percentages of share owned by different parties?

What is the shortcut key to insert a new sheet in Excel?

• Ctrl+C

• Ctrl+V

• Ctrl+N

• Ctrl+T

Which of this feature can we make a Drop down list