﻿ Excel Skills Assessment
Progress
1 2 3 4 5 Report

Current Ranking

You must answer all questions (even with a don't know) to move to the next page
1 To create a formula you start by typing
a @
b +
c -
d =
e Don't know

a Type = and click on the other sheet or spreadsheet cell
b Type the name of the sheet and the cell reference
c Type the name of the sheet, a ' and the cell reference
d Type the name of the sheet, a ! and the cell reference
e Don't know

3 If you copy the cell in B4 to C5, what will the formula look like and what will the answer be
a '=B\$1' and 0
b '=B1' and 0
c '=A\$1' and OK
d '=B\$1' and OK
e Don't know

4 In order to change the name of a excel file the best option would be to
a Change the name shown in cell A1 of Sheet 1
b In folder change name of the file while the file is closed
c Click the Save icon (or use CTRL S)
d Use the 'Save As'
e Don't know

Click Next
Progress
1 2 3 4 5 Report

Current Ranking

5 In order to change the way the printer prints (portrait to landscape) you would
a Go to Print Preview and choose page setup and choose the landscape option
b Go to Page Setup and choose the Landscape option
c Use the Print Option and then change the Printers Properties
d Choose the Print Area option and Set the print Area to be landscape
e Don't Know

6 If you've copied this cell (A1 with =1/3 in it) and you pasted as values into cell B1 (which has no formatting) what could it look like
a 0.33
b 1/3
c =1/3
d 0.333333333333
e Don't Know

7 If you insert a row at Row 1, 2 and 4 in the first picture (pic A), resulting in the second picture (pic B), what will the answer be in cell B7?
a 39
b 18
c 25
d 33
e 31

PICTURE A

PICTURE B

8 How do I make cell A1 look like cell A3
a Go to the Format Cells option and Wrap Text
b Go to the Format Cells option and Shrink to Fit
c Go to the Format Cells option and Merge Cells
d Hold ALT down and click enter at each new line point
e Don't Know