4011018
Beschreibung
Quiz von Mollie Nichols, aktualisiert more than 1 year ago
|
Erstellt von Mollie Nichols
vor mehr als 8 Jahre
|
|
Frage 1
Frage
If I wanted to work out the sum/total of the cell range A1:A6 how would I type it into the formula bar?
Antworten
-
=sum(A1:A6) ENTER
-
=total(A1:A6) ENTER
-
sum(A1:A6) ENTER
-
total(A1:A6) ENTER
Frage 2
Frage
Sorting something into ascending order means you are sorting from [blank_start]a to z[blank_end] or [blank_start]1 to 10[blank_end] for example.
Antworten
-
a to z
-
1 to 10
Frage 3
Frage
To apply a percentage to a number you must use the formula tab.
Antworten
- True
- False
Frage 4
Frage
If the question mentions the word FORMAT you must use the format cells command on the home tab.
Antworten
- True
- False
Frage 5
Frage
How do you scale the page to fit one page high and two pages wide?
Antworten
-
Home tab, replace command.
-
Page layout tab, scale to fit group.
-
Page layout tab, size command.
-
File tab, print, custom scaling.
Frage 6
Frage
If you are asked to add cell B5 and B7, how would you type this in? [blank_start]=B5+B7[blank_end]
Antworten
-
=B5+B7
Frage 7
Frage
If you were asked to divide cell B8 by B10, how would you type this in? [blank_start]=B8/B10[blank_end]
Antworten
-
=B8/B10
Frage 8
Frage
If you were asked to calculate the smallest value in a cell range which one would you use?
Antworten
-
=counta
-
=max
-
=min
-
=count
Frage 9
Frage
If you were asked to calculate the biggest value in a cell range which one would you use?
Antworten
-
=max
-
=sum
-
=if
-
=min
Frage 10
Frage
If you were asked to calculate whether a cell is more than or less than another cell which one would you use?
Antworten
-
=average
-
=sum
-
=if
-
=count
Frage 11
Frage
How would do you change the username?
Antworten
-
Page layout, margins
-
File tab, options, username
-
Review tab, spelling and grammar
-
Insert tab, text box
Frage 12
Frage
To rename worksheets you should double click on the appropriate sheet.
Antworten
- True
- False
Frage 13
Frage
Calculate the total of the following cell range B3:B11. How would this be typed in? [blank_start]=sum(B3:B11)[blank_end]
Antworten
-
=sum(B3:B11)
Frage 14
Frage
Calculate the average of the cell range B4:C6. How would you type this in? [blank_start]=average(B4:C6)[blank_end]
Antworten
-
=average(B4:C6)
Frage 15
Frage
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
Antworten
- True
- False
Frage 16
Frage
To insert data labels, which tab needs to be clicked on?
Antworten
-
Layout tab
-
Design tab
-
Insert tab
-
Home tab
Frage 17
Frage
Cut and paste is used when something needs to be [blank_start]moved[blank_end]
Antworten
-
moved
Frage 18
Frage
When editing a chart the format tab is used for...
Antworten
-
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
Frage 19
Frage
To zoom the view tab is used?
Antworten
- True
- False
Frage 20
Frage
It is possible to change the chart type even after it has been created?
Antworten
- True
- False
Frage 21
Frage
Copy and paste is used when more than [blank_start]one[blank_end] of something is needed.
Antworten
-
one
Frage 22
Frage
Pictures and documents that are needed in the exam can be found in the [blank_start]z drive[blank_end]
Antworten
-
z drive
Frage 23
Frage
To add a title to a chart which tab do you need to be clicked on?
Antworten
-
Layout
Frage 24
Frage
It is possible to keep specific cells visible at all times even when scrolling?
Antworten
- True
- False
Frage 25
Frage
New sheets can be added using the format command
Antworten
- True
- False
Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.