If I wanted to work out the sum/total of the cell range A1:A6 how would I type it into the formula bar?
=sum(A1:A6) ENTER
=total(A1:A6) ENTER
sum(A1:A6) ENTER
total(A1:A6) ENTER
Sorting something into ascending order means you are sorting from or for example.
To apply a percentage to a number you must use the formula tab.
If the question mentions the word FORMAT you must use the format cells command on the home tab.
How do you scale the page to fit one page high and two pages wide?
Home tab, replace command.
Page layout tab, scale to fit group.
Page layout tab, size command.
File tab, print, custom scaling.
If you are asked to add cell B5 and B7, how would you type this in?
If you were asked to divide cell B8 by B10, how would you type this in?
If you were asked to calculate the smallest value in a cell range which one would you use?
=counta
=max
=min
=count
If you were asked to calculate the biggest value in a cell range which one would you use?
=sum
=if
If you were asked to calculate whether a cell is more than or less than another cell which one would you use?
=average
How would do you change the username?
Page layout, margins
File tab, options, username
Review tab, spelling and grammar
Insert tab, text box
To rename worksheets you should double click on the appropriate sheet.
Calculate the total of the following cell range B3:B11. How would this be typed in?
Calculate the average of the cell range B4:C6. How would you type this in?
When entering formulas into the work sheet, you must use the letter and number of the cell as the reference. e.g C4, B7, B2
To insert data labels, which tab needs to be clicked on?
Layout tab
Design tab
Insert tab
Home tab
Cut and paste is used when something needs to be
When editing a chart the format tab is used for...
Inserting a title and data labels
Changing the shading and size of the chart
Editing the data on the chart
Inserting a different chart type
To zoom the view tab is used?
It is possible to change the chart type even after it has been created?
Copy and paste is used when more than of something is needed.
Pictures and documents that are needed in the exam can be found in the
To add a title to a chart which tab do you need to be clicked on?
It is possible to keep specific cells visible at all times even when scrolling?
New sheets can be added using the format command
Bitte warte - es wird geladen…