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